aurora_standard.chmplogd

Field Type Null Default Key Extra Comment
visit_no int(11) YES MUL
which_log varchar(2) YES MUL
pay_type varchar(10) YES MUL
remit_id varchar(10) YES MUL
remit_date date YES MUL
deductible decimal(16,2) YES
co_insurance decimal(16,2) YES
non_covered decimal(16,2) YES
drg_no smallint(6) YES
drg_amt decimal(16,2) YES
reimburs_amt decimal(16,2) YES
contract_adjust decimal(16,2) YES
outlier_amt decimal(16,2) YES
lab_payment decimal(16,2) YES
lab_non_allow decimal(16,2) YES
lab_not_hcpc decimal(16,2) YES
other_payor_paid decimal(16,2) YES
other_payor_name varchar(20) YES
pat_resp_room decimal(16,2) YES
other_amt decimal(16,2) YES
pat_no varchar(20) YES
input_by int(11) YES
non_cov_days smallint(6) YES
bill_id varchar(3) YES
proc_date date YES
remit_type varchar(4) YES
covered_days smallint(6) YES
fac_no varchar(3) YES
add_charges varchar(1) YES
log_time time YES
seq_no smallint(6) YES
bill_status varchar(3) YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
deductible
TableColumn
_1.patients_responsibility_estimatesprest_deductible
_1.patients_responsibility_estimates_servicesprests_deductible
_1188.patients_responsibility_estimatesprest_deductible
_1188.patients_responsibility_estimates_servicesprests_deductible
_1218.patients_responsibility_estimatesprest_deductible
_1218.patients_responsibility_estimates_servicesprests_deductible
_1548.patients_responsibility_estimatesprest_deductible
_1548.patients_responsibility_estimates_servicesprests_deductible
_435.patients_responsibility_estimatesprest_deductible
_435.patients_responsibility_estimates_servicesprests_deductible
_436.patients_responsibility_estimatesprest_deductible
_436.patients_responsibility_estimates_servicesprests_deductible
_436_archive_testing.patients_responsibility_estimatesprest_deductible
_436_archive_testing.patients_responsibility_estimates_servicesprests_deductible
_437.patients_responsibility_estimatesprest_deductible
_437.patients_responsibility_estimates_servicesprests_deductible
_8.patients_responsibility_estimatesprest_deductible
_8.patients_responsibility_estimates_servicesprests_deductible
_81.patients_responsibility_estimatesprest_deductible
_81.patients_responsibility_estimates_servicesprests_deductible
_999.patients_responsibility_estimatesprest_deductible
_999.patients_responsibility_estimates_servicesprests_deductible
aurora_standard.chminsrddef_deductible
aurora_standard.chpinsucdep_deductible
aurora_standard.hl7in2daily_deductible
visit_no
TableColumn
aurora_standard.anotesdan_visit_no
aurora_standard.bdfiledbd_visit_no
aurora_standard.chmarsipat_visit_no
aurora_standard.chmcampipat_visit_no
aurora_standard.chmcombrto_visit_no
aurora_standard.chmexmpipat_visit_no
aurora_standard.chmokipdpat_visit_no
aurora_standard.chmokopdpat_visit_no
aurora_standard.chmradedpat_visit_no
aurora_standard.chmradexpat_visit_no
aurora_standard.chrcombrto_visit_no
aurora_standard.ncexmpipat_visit_no
pay_type
TableColumn
aurora_standard.audppaydgl_pay_type
aurora_standard.chmadmidmr_pay_type
aurora_standard.chmfcglcremit_pay_type
aurora_standard.chminsrcmr_pay_type
aurora_standard.chmppaydgl_pay_type
aurora_standard.chpinsucmr_pay_type
aurora_standard.visit_insurancesmr_pay_type
outlier_amt
TableColumn
aurora_standard.chm835pdpps_outlier_amt
seq_no
TableColumn
aurora_standard.chmarstarec_seq_no
aurora_standard.chmarstacrec_seq_no
aurora_standard.chmarstairec_seq_no
aurora_standard.chmarstdrec_seq_no
aurora_standard.chmarstdirec_seq_no
aurora_standard.chmarsterec_seq_no
aurora_standard.chmarsthrec_seq_no
aurora_standard.chmarsthirec_seq_no
aurora_standard.chmarstphrec_seq_no
aurora_standard.chmarstpirec_seq_no
aurora_standard.chmarstporec_seq_no
aurora_standard.chmarstpqrec_seq_no
aurora_standard.chmarstprrec_seq_no
aurora_standard.chmarstpsrec_seq_no
aurora_standard.chmarstptrec_seq_no
aurora_standard.chmarstpyrec_seq_no
aurora_standard.chmcostarec_seq_no
aurora_standard.chmcostbrec_seq_no
aurora_standard.chmcostdrec_seq_no
aurora_standard.chmcostrcrec_seq_no
aurora_standard.chmgltcda_seq_no
aurora_standard.chmgltcdb_seq_no
aurora_standard.chmhid4arec_seq_no
aurora_standard.chmhid4brec_seq_no
aurora_standard.chmhid4crec_seq_no
aurora_standard.chmhid4drec_seq_no
aurora_standard.chmhid4grec_seq_no
aurora_standard.chrhhdcclisting_seq_no
aurora_standard.chrhhmprlisting_seq_no
aurora_standard.chrhhndclisting_seq_no
aurora_standard.chrhhndcfirm_seq_no
aurora_standard.chrhhroclisting_seq_no
aurora_standard.chrmndclisting_seq_no
aurora_standard.chrmndcfirm_seq_no
aurora_standard.chxhistdh_seq_no
aurora_standard.chyhistdh_seq_no
aurora_standard.drugclaslisting_seq_no
aurora_standard.formulatlisting_seq_no
aurora_standard.listingslisting_seq_no
aurora_standard.listingsfirm_seq_no
aurora_standard.packagelisting_seq_no
aurora_standard.routeslisting_seq_no
fac_no
TableColumn
aurora_standard.chmpricaprev_fac_no
aurora_standard.chmpricacur_fac_no
aurora_standard.chpcashrcash_fac_no
aurora_standard.chpcobpdcash_fac_no
aurora_standard.chpcobpdbal_fac_no
aurora_standard.chscustddept_fac_no
aurora_standard.chshotlrdept_fac_no
aurora_standard.chtemplrdflt_fac_no
aurora_standard.curs_tempcash_fac_no
aurora_standard.curs_tempap_fac_no
aurora_standard.stgrowpdrod_beg_fac_no
aurora_standard.stgrowpdrod_end_fac_no
aurora_standard.stpcashddist_fac_no
aurora_standard.stpcashddisc_fac_no
aurora_standard.stpcashecash_fac_no
aurora_standard.stpcntrccash_fac_no
aurora_standard.stpcntrcdisc_fac_no
aurora_standard.stpinvcecash_fac_no
aurora_standard.stpopendap_fac_no
aurora_standard.stpopendcash_fac_no
aurora_standard.stucntrccash_fac_no
aurora_standard.stuinvcecash_fac_no
aurora_standard.stxfinsdfin_fac_no
aurora_standard.styaccrrliab_fac_no
aurora_standard.styaccrrexpense_fac_no
aurora_standard.styemplrcash_fac_no
aurora_standard.stypayfdcash_fac_no
aurora_standard.stypayodbal_fac_no
aurora_standard.stypayrecash_fac_no
aurora_standard.styrevsdcash_fac_no
aurora_standard.stytypercash_fac_no
proc_date
TableColumn
aurora_standard.chmutah7cpt_proc_date
aurora_standard.chmutahacpt_proc_date