aurora_standard.chmapcgr

Field Type Null Default Key Extra Comment
visit_no int(11) YES UNI
bill_status varchar(3) YES
bill_type varchar(3) YES
cond1 varchar(2) YES
cond2 varchar(2) YES
overall varchar(1) YES
input_by int(11) YES
est_reimb decimal(10,2) YES
tot_hcfa decimal(10,2) YES
tot_copay decimal(10,2) YES
tot_linchg decimal(10,2) YES
tot_wt decimal(6,2) YES
act_reimb decimal(10,2) YES
ub_charges decimal(16,2) YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
bill_type
TableColumn
_1.chartschrt_bill_type
_1.encountersenc_bill_type
_1.encounters_cpt_codesecp_next_payer_bill_type
_1.encounters_paymentsepay_bill_type
_1.insurancesins_ub04_bill_type
_1.locationsloc_ub04_bill_type
_1.ordersord_bill_type
_1.patientspat_bill_type
_1.patients_demographics_snapshotspds_bill_type
_1.physiciansphy_ub04_bill_type
_1.precertspre_bill_type
_1.radiology_ordersrad_bill_type
_1188.chartschrt_bill_type
_1188.encountersenc_bill_type
_1188.encounters_cpt_codesecp_next_payer_bill_type
_1188.encounters_paymentsepay_bill_type
_1188.insurancesins_ub04_bill_type
_1188.locationsloc_ub04_bill_type
_1188.ordersord_bill_type
_1188.patientspat_bill_type
_1188.patients_demographics_snapshotspds_bill_type
_1188.physiciansphy_ub04_bill_type
_1188.precertspre_bill_type
_1188.radiology_ordersrad_bill_type
_1218.chartschrt_bill_type
_1218.encountersenc_bill_type
_1218.encounters_cpt_codesecp_next_payer_bill_type
_1218.encounters_paymentsepay_bill_type
_1218.insurancesins_ub04_bill_type
_1218.locationsloc_ub04_bill_type
_1218.ordersord_bill_type
_1218.patientspat_bill_type
_1218.patients_demographics_snapshotspds_bill_type
_1218.physiciansphy_ub04_bill_type
_1218.precertspre_bill_type
_1218.radiology_ordersrad_bill_type
_1548.chartschrt_bill_type
_1548.encountersenc_bill_type
_1548.encounters_cpt_codesecp_next_payer_bill_type
_1548.encounters_paymentsepay_bill_type
_1548.insurancesins_ub04_bill_type
_1548.locationsloc_ub04_bill_type
_1548.ordersord_bill_type
_1548.patientspat_bill_type
_1548.patients_demographics_snapshotspds_bill_type
_1548.physiciansphy_ub04_bill_type
_1548.precertspre_bill_type
_1548.radiology_ordersrad_bill_type
_435.chartschrt_bill_type
_435.encountersenc_bill_type
_435.encounters_cpt_codesecp_next_payer_bill_type
_435.encounters_paymentsepay_bill_type
_435.insurancesins_ub04_bill_type
_435.ledger_running_balancelrb_next_payer_bill_type
_435.locationsloc_ub04_bill_type
_435.ordersord_bill_type
_435.patientspat_bill_type
_435.patients_demographics_snapshotspds_bill_type
_435.physiciansphy_ub04_bill_type
_435.precertspre_bill_type
_435.radiology_ordersrad_bill_type
_436.chartschrt_bill_type
_436.encountersenc_bill_type
_436.encounters_cpt_codesecp_next_payer_bill_type
_436.encounters_paymentsepay_bill_type
_436.insurancesins_ub04_bill_type
_436.ledger_running_balancelrb_next_payer_bill_type
_436.locationsloc_ub04_bill_type
_436.ordersord_bill_type
_436.patientspat_bill_type
_436.patients_demographics_snapshotspds_bill_type
_436.physiciansphy_ub04_bill_type
_436.precertspre_bill_type
_436.radiology_ordersrad_bill_type
_436_archive_testing.chartschrt_bill_type
_436_archive_testing.encountersenc_bill_type
_436_archive_testing.encounters_cpt_codesecp_next_payer_bill_type
_436_archive_testing.encounters_paymentsepay_bill_type
_436_archive_testing.insurancesins_ub04_bill_type
_436_archive_testing.ledger_running_balancelrb_next_payer_bill_type
_436_archive_testing.locationsloc_ub04_bill_type
_436_archive_testing.ordersord_bill_type
_436_archive_testing.patientspat_bill_type
_436_archive_testing.patients_demographics_snapshotspds_bill_type
_436_archive_testing.physiciansphy_ub04_bill_type
_436_archive_testing.precertspre_bill_type
_436_archive_testing.radiology_ordersrad_bill_type
_437.chartschrt_bill_type
_437.encountersenc_bill_type
_437.encounters_cpt_codesecp_next_payer_bill_type
_437.encounters_paymentsepay_bill_type
_437.insurancesins_ub04_bill_type
_437.ledger_running_balancelrb_next_payer_bill_type
_437.locationsloc_ub04_bill_type
_437.ordersord_bill_type
_437.patientspat_bill_type
_437.patients_demographics_snapshotspds_bill_type
_437.physiciansphy_ub04_bill_type
_437.precertspre_bill_type
_437.radiology_ordersrad_bill_type
_8.chartschrt_bill_type
_8.daily_close_calculationsdcc_next_payer_bill_type
_8.daily_close_calculationsdcc_enc_bill_type
_8.encountersenc_bill_type
_8.encounters_cpt_codesecp_next_payer_bill_type
_8.encounters_paymentsepay_bill_type
_8.insurancesins_ub04_bill_type
_8.locationsloc_ub04_bill_type
_8.ordersord_bill_type
_8.patientspat_bill_type
_8.patients_demographics_snapshotspds_bill_type
_8.physiciansphy_ub04_bill_type
_8.precertspre_bill_type
_8.radiology_ordersrad_bill_type
_81.chartschrt_bill_type
_81.encountersenc_bill_type
_81.encounters_cpt_codesecp_next_payer_bill_type
_81.encounters_paymentsepay_bill_type
_81.insurancesins_ub04_bill_type
_81.locationsloc_ub04_bill_type
_81.ordersord_bill_type
_81.patientspat_bill_type
_81.patients_demographics_snapshotspds_bill_type
_81.physiciansphy_ub04_bill_type
_81.precertspre_bill_type
_81.radiology_ordersrad_bill_type
_999.chartschrt_bill_type
_999.encountersenc_bill_type
_999.encounters_cpt_codesecp_next_payer_bill_type
_999.encounters_paymentsepay_bill_type
_999.insurancesins_ub04_bill_type
_999.locationsloc_ub04_bill_type
_999.ordersord_bill_type
_999.patientspat_bill_type
_999.patients_demographics_snapshotspds_bill_type
_999.physiciansphy_ub04_bill_type
_999.precertspre_bill_type
_999.radiology_ordersrad_bill_type
common.clientscli_ub04_bill_type
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