aurora_standard.chmvtotd

Field Type Null Default Key Extra Comment
fac_no char(3) NO
attend_phy smallint(6) YES
visit_flag char(1) YES
visit_no int(11) YES
pat_status char(3) YES
est_drg smallint(6) YES
ins_co smallint(6) YES
network_no char(6) YES
los smallint(6) YES
dischg_service char(4) YES
pri_fc char(2) YES
fin_class char(2) YES
spec_hand char(2) YES
admit_date date YES
dischg_date date YES
charges decimal(12,2) YES
pmts decimal(12,2) YES
adjs decimal(12,2) YES
cur_bal decimal(12,2) YES
network_paid_1 char(6) YES
network_paid_2 char(6) YES
fam_phy smallint(6) YES

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
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
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
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
cur_bal
TableColumn
aurora_standard.avtotstot_cur_bal
aurora_standard.catotstot_cur_bal
los
TableColumn
aurora_standard.chmabstrmean_los
aurora_standard.chmdrgccmean_los
aurora_standard.chmmhastoutlier_los
aurora_standard.workdrgmean_los
admit_date
TableColumn
aurora_standard.chmadmtrlast_admit_date
aurora_standard.hhmadmtrlast_admit_date
aurora_standard.hl7pv2expect_admit_date
fin_class
TableColumn
aurora_standard.chmarsicur_fin_class
aurora_standard.chmcampicur_fin_class
aurora_standard.chmerafcnew_fin_class
aurora_standard.chmexmpicur_fin_class
aurora_standard.hl7gt1guar_fin_class
dischg_date
TableColumn
aurora_standard.chmchdddold_dischg_date
aurora_standard.chmchdddnew_dischg_date
aurora_standard.chmchpsdchg_dischg_date
aurora_standard.hl7pv2exp_dischg_date
aurora_standard.tmpmrrptedit_dischg_date
spec_hand
TableColumn
aurora_standard.chmcolaccur_spec_hand
aurora_standard.chmcolacnew_spec_hand
aurora_standard.chmstatcdef_spec_hand
ins_co
TableColumn
aurora_standard.chmemplrwc_ins_co
aurora_standard.chmpricaprev_ins_co
aurora_standard.chmpricacur_ins_co
aurora_standard.chmquesrwork_comp_ins_co
aurora_standard.chqliabdliab_ins_co
pat_status
TableColumn
aurora_standard.chmgltcda_pat_status
aurora_standard.chmgltcdb_pat_status
aurora_standard.chmpricaprev_pat_status
aurora_standard.chmpricacur_pat_status
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