aurora_standard.chmaget6

Field Type Null Default Key Extra Comment
fac_no varchar(3) YES
ps varchar(3) YES
fc varchar(5) YES
phy_no smallint(6) YES
charges decimal(16,2) YES
pmts decimal(16,2) YES
adjs decimal(16,2) YES
amt_1 decimal(16,2) YES
amt_2 decimal(16,2) YES
amt_3 decimal(16,2) YES
amt_4 decimal(16,2) YES
amt_5 decimal(16,2) YES
amt_6 decimal(16,2) YES
amt_7 decimal(16,2) YES
cnt_1 smallint(6) YES
cnt_2 smallint(6) YES
cnt_3 smallint(6) YES
cnt_4 smallint(6) YES
cnt_5 smallint(6) YES
cnt_6 smallint(6) YES
cnt_7 smallint(6) YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
charges
TableColumn
_1.closed_periods_dailyclpd_charges
_1.encountersenc_outside_lab_charges
_1.patient_finance_recordspfr_resp_charges
_1.precertspre_outside_lab_charges
_1188.closed_periods_dailyclpd_charges
_1188.encountersenc_outside_lab_charges
_1188.patient_finance_recordspfr_resp_charges
_1188.precertspre_outside_lab_charges
_1218.closed_periods_dailyclpd_charges
_1218.encountersenc_outside_lab_charges
_1218.patient_finance_recordspfr_resp_charges
_1218.precertspre_outside_lab_charges
_1548.closed_periods_dailyclpd_charges
_1548.encountersenc_outside_lab_charges
_1548.patient_finance_recordspfr_resp_charges
_1548.precertspre_outside_lab_charges
_435.closed_periods_dailyclpd_charges
_435.encountersenc_outside_lab_charges
_435.patient_finance_recordspfr_resp_charges
_435.precertspre_outside_lab_charges
_436.closed_periods_dailyclpd_charges
_436.encountersenc_outside_lab_charges
_436.patient_finance_recordspfr_resp_charges
_436.precertspre_outside_lab_charges
_436_archive_testing.closed_periods_dailyclpd_charges
_436_archive_testing.encountersenc_outside_lab_charges
_436_archive_testing.patient_finance_recordspfr_resp_charges
_436_archive_testing.precertspre_outside_lab_charges
_437.closed_periods_dailyclpd_charges
_437.encountersenc_outside_lab_charges
_437.patient_finance_recordspfr_resp_charges
_437.precertspre_outside_lab_charges
_8.closed_periods_dailyclpd_charges
_8.encountersenc_outside_lab_charges
_8.patient_finance_recordspfr_resp_charges
_8.precertspre_outside_lab_charges
_81.closed_periods_dailyclpd_charges
_81.encountersenc_outside_lab_charges
_81.patient_finance_recordspfr_resp_charges
_81.precertspre_outside_lab_charges
_999.closed_periods_dailyclpd_charges
_999.encountersenc_outside_lab_charges
_999.patient_finance_recordspfr_resp_charges
_999.precertspre_outside_lab_charges
aurora_standard.chmabstrtot_charges
aurora_standard.chmadmtrtot_charges
aurora_standard.chmapcgrub_charges
aurora_standard.chmarsitot_charges
aurora_standard.chmazstdtot_charges
aurora_standard.chmazstitot_charges
aurora_standard.chmazstotot_charges
aurora_standard.chmcampitot_charges
aurora_standard.chmcostalab_charges
aurora_standard.chmcostarad_charges
aurora_standard.chmcostarx_charges
aurora_standard.chmcostaroutine_charges
aurora_standard.chmcostaother_charges
aurora_standard.chmcostatot_charges
aurora_standard.chmcostrtot_charges
aurora_standard.chmexmpitot_charges
aurora_standard.chmexvistot_charges
aurora_standard.chmhidiatot_charges
aurora_standard.chmhistdtot_charges
aurora_standard.chmlastrtot_charges
aurora_standard.chmmbc50total_charges
aurora_standard.chmmhasttot_charges
aurora_standard.chmmhastoutlier_charges
aurora_standard.chmokipdtot_charges
aurora_standard.chmokopdtot_charges
aurora_standard.chmpdemotot_charges
aurora_standard.chmplogdadd_charges
aurora_standard.chmprebclow_charges
aurora_standard.chmprebchigh_charges
aurora_standard.chmtxstrtot_charges
aurora_standard.chmutah7tot_charges
aurora_standard.chmutahatot_charges
aurora_standard.chxcntrcrad_charges
aurora_standard.hl7pv1tot_charges
aurora_standard.hl7pv1adtot_charges
aurora_standard.logdetldadd_charges
aurora_standard.tmpmrrpttotal_charges
aurora_standard.tmpmrrptanc_charges
fc
TableColumn
aurora_standard.abmmpii1_fc
aurora_standard.abmmpii2_fc
aurora_standard.abmmpii3_fc
aurora_standard.abmviscur_fc
aurora_standard.abmvispri_fc
aurora_standard.abmvisi2_fc
aurora_standard.abmvisi3_fc
aurora_standard.adshmdpri_fc
aurora_standard.adshrevpri_fc
aurora_standard.afcsum2pri_fc
aurora_standard.agingwkpri_fc
aurora_standard.agingwk2pri_fc
aurora_standard.ainsrvwpri_fc
aurora_standard.amcbdpri_fc
aurora_standard.anarccur_fc
aurora_standard.anarcpri_fc
aurora_standard.apsagingcur_fc
aurora_standard.apsarcur_fc
aurora_standard.apsarpri_fc
aurora_standard.apsar0cur_fc
aurora_standard.apsar0pri_fc
aurora_standard.apsarbdcur_fc
aurora_standard.apsarbdpri_fc
aurora_standard.apsarhistcur_fc
aurora_standard.apsarhistpri_fc
aurora_standard.apsunbcur_fc
aurora_standard.apsviscur_fc
aurora_standard.apsvispri_fc
aurora_standard.avtotspri_fc
aurora_standard.bdallvispri_fc
aurora_standard.bdallviscur_fc
aurora_standard.bdvispri_fc
aurora_standard.bdviscur_fc
aurora_standard.beviscur_fc
aurora_standard.bevisbdcur_fc
aurora_standard.bevisbd2cur_fc
aurora_standard.bevisbd2prev_fc
aurora_standard.bharcur_fc
aurora_standard.bharco1_fc
aurora_standard.bharco2_fc
aurora_standard.bharco3_fc
aurora_standard.bharco4_fc
aurora_standard.bharco5_fc
aurora_standard.bharco6_fc
aurora_standard.bmvispri_fc
aurora_standard.bmviscur_fc
aurora_standard.bparcur_fc
aurora_standard.bparco1_fc
aurora_standard.bparco2_fc
aurora_standard.bparco3_fc
aurora_standard.bparco4_fc
aurora_standard.bparco5_fc
aurora_standard.bparco6_fc
aurora_standard.bpar2cur_fc
aurora_standard.bpar2co1_fc
aurora_standard.bpar2co2_fc
aurora_standard.bpar2co3_fc
aurora_standard.bpar2co4_fc
aurora_standard.bpar2co5_fc
aurora_standard.bpar2co6_fc
aurora_standard.bsvispri_fc
aurora_standard.bsviscur_fc
aurora_standard.bsvisbdpri_fc
aurora_standard.bsvisbdcur_fc
aurora_standard.c7vispri_fc
aurora_standard.c7viscur_fc
aurora_standard.c9viscur_fc
aurora_standard.c9visbd_fc
aurora_standard.cafccur_fc
aurora_standard.catotspri_fc
aurora_standard.cavispri_fc
aurora_standard.caviscur_fc
aurora_standard.cavishpri_fc
aurora_standard.cavishcur_fc
aurora_standard.chmadmtrpri_fc
aurora_standard.chmarbexpri_fc
aurora_standard.chmardydage_fc
aurora_standard.chmarsipri_fc
aurora_standard.chmbadjdnew_fc
aurora_standard.chmblogdnew_fc
aurora_standard.chmbpaydnew_fc
aurora_standard.chmbremdnew_fc
aurora_standard.chmcampipri_fc
aurora_standard.chmchfcdold_fc
aurora_standard.chmchfcdnew_fc
aurora_standard.chmchpsdcur_fc
aurora_standard.chmcntrcroll_fc
aurora_standard.chmcntrcno_insur_fc
aurora_standard.chmcolacbd_fc
aurora_standard.chmexmpipri_fc
aurora_standard.chmexvispri_fc
aurora_standard.chmfcglcbd_fc
aurora_standard.chmhcaphpri_fc
aurora_standard.chmhcapspri_fc
aurora_standard.chminsrcinpatient_fc
aurora_standard.chminsrcoutpatient_fc
aurora_standard.chmpdemopri_fc
aurora_standard.chmpsvcdcur_fc
aurora_standard.chmradexpri_fc
aurora_standard.chmstatcdef_sp_fc
aurora_standard.chmtkl1dpri_fc
aurora_standard.chmtkl2dpri_fc
aurora_standard.chmtkl3dpri_fc
aurora_standard.chmtkl4dpri_fc
aurora_standard.chmtkl5dpri_fc
aurora_standard.chmtkl6dpri_fc
aurora_standard.chmtkl7dpri_fc
aurora_standard.chmtkl8dpri_fc
aurora_standard.chmtkl9dpri_fc
aurora_standard.chmvisivpri_fc
aurora_standard.chmvtotdpri_fc
aurora_standard.financial_class_changesold_fc
aurora_standard.financial_class_changesnew_fc
aurora_standard.kcvispri_fc
aurora_standard.kcviscur_fc
aurora_standard.kcvisitpri_fc
aurora_standard.kcvisitcur_fc
aurora_standard.strcntrcmtax_fc
aurora_standard.strcustrmtax_fc
pmts
TableColumn
aurora_standard.adshmdmc_pmts
aurora_standard.adshmdmc_hmo_pmts
aurora_standard.adshmdmd_pmts
aurora_standard.adshmdinsur_pmts
aurora_standard.adshrevinsur_pmts
aurora_standard.amcbdbd_pmts
aurora_standard.amcbdsp_pmts
aurora_standard.avtotstot_pmts
aurora_standard.bhartot_pmts
aurora_standard.bhparrtot_pmts
aurora_standard.bhtparrtot_pmts
aurora_standard.bmvistot_pmts
aurora_standard.bpartot_pmts
aurora_standard.bpar2tot_pmts
aurora_standard.catotstot_pmts
aurora_standard.chmarsitot_pmts
aurora_standard.chmcampitot_pmts
aurora_standard.chmexmpitot_pmts
aurora_standard.chmexvistot_pmts
aurora_standard.chmhistptot_pmts
aurora_standard.chmpdemotot_pmts
adjs
TableColumn
aurora_standard.avtotstot_adjs
aurora_standard.bhartot_adjs
aurora_standard.bhparrtot_adjs
aurora_standard.bhtparrtot_adjs
aurora_standard.bmvistot_adjs
aurora_standard.bpartot_adjs
aurora_standard.bpar2tot_adjs
aurora_standard.catotstot_adjs
aurora_standard.chmarsitot_adjs
aurora_standard.chmcampitot_adjs
aurora_standard.chmexmpitot_adjs
aurora_standard.chmexvistot_adjs
aurora_standard.chmhistptot_adjs
aurora_standard.chmpdemotot_adjs
phy_no
TableColumn
aurora_standard.bsinsurfam_phy_no
aurora_standard.c7mpipri_phy_no
aurora_standard.campifam_phy_no
aurora_standard.chmabstradmit_phy_no
aurora_standard.chmabstrattend_phy_no
aurora_standard.chmarsifam_phy_no
aurora_standard.chmcampifam_phy_no
aurora_standard.chmexmpifam_phy_no
aurora_standard.chmpatmrfam_phy_no
aurora_standard.chmpdemofam_phy_no
aurora_standard.chmradexfam_phy_no
aurora_standard.chpwkmnrrefer_phy_no
amt_1
TableColumn
aurora_standard.chm835pssvc_amt_1
amt_2
TableColumn
aurora_standard.chm835pssvc_amt_2
amt_3
TableColumn
aurora_standard.chm835pssvc_amt_3
amt_4
TableColumn
aurora_standard.chm835pssvc_amt_4
ps
TableColumn
aurora_standard.chmabstrprimary_ps
aurora_standard.chmabstrsecondary_ps
aurora_standard.chmabstrtertiary_ps
aurora_standard.chmadmtrarrival_ps
aurora_standard.chmadmtrnew_pat_this_ps
aurora_standard.chmchfcdnew_ps
aurora_standard.chmchfcdold_ps
aurora_standard.chmchpsdold_ps
aurora_standard.chmchpsdnew_ps
aurora_standard.chmcostaprimary_ps
aurora_standard.chmcostasecondary_ps
aurora_standard.chmcostatertiary_ps
aurora_standard.chmhid4aprimary_ps
aurora_standard.chmhid4asecondary_ps
aurora_standard.chmhid4atertiary_ps
aurora_standard.chmhidiaprimary_ps
aurora_standard.chmhidicprimary_ps
aurora_standard.chmhidicsecondary_ps
aurora_standard.chmhidictertiary_ps
aurora_standard.chmradexarrival_ps
aurora_standard.financial_class_changesnew_ps
aurora_standard.financial_class_changesold_ps
aurora_standard.stxautodchg_inc_ps
aurora_standard.stxautodchg_exc_ps
aurora_standard.stxautodvis_inc_ps
aurora_standard.stxautodvis_exc_ps
aurora_standard.stxautodadj_inc_ps
aurora_standard.stxautodadj_exc_ps
aurora_standard.tmpmrrptprimary_ps
aurora_standard.tmpmrrptsecondary_ps
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