aurora_standard.chmrevec

Field Type Null Default Key Extra Comment
reve_code varchar(10) YES UNI
descrip varchar(30) YES
bill_type varchar(1) YES
cpt_code varchar(10) YES
hcpcs_code varchar(10) YES
log_heading varchar(10) YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
cpt_code
TableColumn
Loinc.loinc_codeslc_cpt_code
_1.clients_fee_schedules_mapcfsm_cpt_code
_1.clinical_interventions_test_codes_mapcitcm_cpt_code
_1.immunizations_cpt_mapicm_cpt_code
_1.insurances_allowables_cpt_mapiacm_cpt_code
_1.insurances_contracted_pricingicp_cpt_code
_1.insurances_contracted_pricing_logicpl_cpt_code
_1.patients_responsibility_estimates_servicesprests_cpt_code
_1188.clients_fee_schedules_mapcfsm_cpt_code
_1188.clinical_interventions_test_codes_mapcitcm_cpt_code
_1188.immunizations_cpt_mapicm_cpt_code
_1188.insurances_allowables_cpt_mapiacm_cpt_code
_1188.insurances_contracted_pricingicp_cpt_code
_1188.insurances_contracted_pricing_logicpl_cpt_code
_1188.patients_responsibility_estimates_servicesprests_cpt_code
_1218.clients_fee_schedules_mapcfsm_cpt_code
_1218.clinical_interventions_test_codes_mapcitcm_cpt_code
_1218.immunizations_cpt_mapicm_cpt_code
_1218.insurances_allowables_cpt_mapiacm_cpt_code
_1218.insurances_contracted_pricingicp_cpt_code
_1218.insurances_contracted_pricing_logicpl_cpt_code
_1218.patients_responsibility_estimates_servicesprests_cpt_code
_1548.clients_fee_schedules_mapcfsm_cpt_code
_1548.clinical_interventions_test_codes_mapcitcm_cpt_code
_1548.immunizations_cpt_mapicm_cpt_code
_1548.insurances_allowables_cpt_mapiacm_cpt_code
_1548.insurances_contracted_pricingicp_cpt_code
_1548.insurances_contracted_pricing_logicpl_cpt_code
_1548.patients_responsibility_estimates_servicesprests_cpt_code
_435.clients_fee_schedules_mapcfsm_cpt_code
_435.clinical_interventions_test_codes_mapcitcm_cpt_code
_435.immunizations_cpt_mapicm_cpt_code
_435.insurances_allowables_cpt_mapiacm_cpt_code
_435.insurances_contracted_pricingicp_cpt_code
_435.insurances_contracted_pricing_logicpl_cpt_code
_435.patients_responsibility_estimates_servicesprests_cpt_code
_436.clients_fee_schedules_mapcfsm_cpt_code
_436.clinical_interventions_test_codes_mapcitcm_cpt_code
_436.immunizations_cpt_mapicm_cpt_code
_436.insurances_allowables_cpt_mapiacm_cpt_code
_436.insurances_contracted_pricingicp_cpt_code
_436.insurances_contracted_pricing_logicpl_cpt_code
_436.patients_responsibility_estimates_servicesprests_cpt_code
_436_archive_testing.clients_fee_schedules_mapcfsm_cpt_code
_436_archive_testing.clinical_interventions_test_codes_mapcitcm_cpt_code
_436_archive_testing.immunizations_cpt_mapicm_cpt_code
_436_archive_testing.insurances_allowables_cpt_mapiacm_cpt_code
_436_archive_testing.insurances_contracted_pricingicp_cpt_code
_436_archive_testing.insurances_contracted_pricing_logicpl_cpt_code
_436_archive_testing.patients_responsibility_estimates_servicesprests_cpt_code
_437.clients_fee_schedules_mapcfsm_cpt_code
_437.clinical_interventions_test_codes_mapcitcm_cpt_code
_437.immunizations_cpt_mapicm_cpt_code
_437.insurances_allowables_cpt_mapiacm_cpt_code
_437.insurances_contracted_pricingicp_cpt_code
_437.insurances_contracted_pricing_logicpl_cpt_code
_437.patients_responsibility_estimates_servicesprests_cpt_code
_8.clients_fee_schedules_mapcfsm_cpt_code
_8.clinical_interventions_test_codes_mapcitcm_cpt_code
_8.immunizations_cpt_mapicm_cpt_code
_8.insurances_allowables_cpt_mapiacm_cpt_code
_8.insurances_contracted_pricingicp_cpt_code
_8.insurances_contracted_pricing_logicpl_cpt_code
_8.patients_responsibility_estimates_servicesprests_cpt_code
_81.clients_fee_schedules_mapcfsm_cpt_code
_81.clinical_interventions_test_codes_mapcitcm_cpt_code
_81.immunizations_cpt_mapicm_cpt_code
_81.insurances_allowables_cpt_mapiacm_cpt_code
_81.insurances_contracted_pricingicp_cpt_code
_81.insurances_contracted_pricing_logicpl_cpt_code
_81.patients_responsibility_estimates_servicesprests_cpt_code
_999.clients_fee_schedules_mapcfsm_cpt_code
_999.clinical_interventions_test_codes_mapcitcm_cpt_code
_999.immunizations_cpt_mapicm_cpt_code
_999.insurances_allowables_cpt_mapiacm_cpt_code
_999.insurances_contracted_pricingicp_cpt_code
_999.insurances_contracted_pricing_logicpl_cpt_code
_999.patients_responsibility_estimates_servicesprests_cpt_code
aurora_standard.axlscdmmd_cpt_code
aurora_standard.axlscdmci_cpt_code
aurora_standard.c5cdmoth_cpt_code
aurora_standard.c5cdmwc_cpt_code
aurora_standard.c5cdmcomm_cpt_code
aurora_standard.c5cdmdroth_cpt_code
aurora_standard.c5cdmdrwc_cpt_code
aurora_standard.c5cdmdrcomm_cpt_code
aurora_standard.c7cdmcomm_cpt_code
aurora_standard.c8cdmcomm_cpt_code
aurora_standard.chmpricaprev_cpt_code
aurora_standard.chmpricacur_cpt_code
aurora_standard.chmpricccomm_cpt_code
aurora_standard.glspricecomm_cpt_code
common.loinc_codeslc_cpt_code
common.mednecmed_cpt_code
common.test_codes_cpttcc_cpt_code
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
descrip
TableColumn
aurora_standard.addcdmbill_descrip
aurora_standard.afcdmdept_descrip
aurora_standard.afcdmbill_descrip
aurora_standard.apscdmbill_descrip
aurora_standard.apscdm2bill_descrip
aurora_standard.apscdmabill_descrip
aurora_standard.aseycmcbill_descrip
aurora_standard.aseycmhbill_descrip
aurora_standard.aswcdmbill_descrip
aurora_standard.axlscdmbill_descrip
aurora_standard.bdcdmdept_descrip
aurora_standard.bdcdmbill_descrip
aurora_standard.becdmbill_descrip
aurora_standard.bfcdmdept_descrip
aurora_standard.bfcdmbill_descrip
aurora_standard.bfcdminvbill_descrip
aurora_standard.bfcdmprobill_descrip
aurora_standard.bfcdmrhcbill_descrip
aurora_standard.bfrhccdmdept_descrip
aurora_standard.bfrhccdmbill_descrip
aurora_standard.bgcdmbill_descrip
aurora_standard.bmcdmbill_descrip
aurora_standard.bokcdmbill_descrip
aurora_standard.bpcdmhosbill_descrip
aurora_standard.bpcdmrhcbill_descrip
aurora_standard.bvcdmbill_descrip
aurora_standard.bvclncdmbill_descrip
aurora_standard.c5cdmbill_descrip
aurora_standard.c5cdmdrbill_descrip
aurora_standard.c7cdmprimary_descrip
aurora_standard.c7cdmother_descrip
aurora_standard.c7cdm720bill_descrip
aurora_standard.c7cdmoldbill_descrip
aurora_standard.c7cdmrxbill_descrip
aurora_standard.c7cdmsphbill_descrip
aurora_standard.c7cdmsupbill_descrip
aurora_standard.c7cdmxlsbill_descrip
aurora_standard.c7dmebill_descrip
aurora_standard.c8cdmprimary_descrip
aurora_standard.c8cdmother_descrip
aurora_standard.chmapcdcd_descrip
aurora_standard.chmapcjcj_descrip
aurora_standard.chmapckck_descrip
aurora_standard.chmapcpcp_descrip
aurora_standard.chmclocdloc_descrip
aurora_standard.chmerapcera_descrip
aurora_standard.chmmnecbpolicy_descrip
aurora_standard.chmoceeco_descrip
aurora_standard.chmprchdprev_descrip
aurora_standard.chmprchdcur_descrip
aurora_standard.chmpriccprimary_descrip
aurora_standard.chmpriccother_descrip
aurora_standard.chmradexps_descrip
aurora_standard.chplocaclocation_descrip
aurora_standard.chractpcactn_descrip
aurora_standard.chractscactns_descrip
aurora_standard.chrintpcpi_descrip
aurora_standard.chrintscpis_descrip
aurora_standard.drg_workw_descrip
aurora_standard.glspriceprimary_descrip
aurora_standard.glspriceother_descrip
aurora_standard.hl7ft1trans_descrip
aurora_standard.samcdmcbill_descrip
aurora_standard.stonwallbill_descrip
aurora_standard.sturaterrate_descrip
aurora_standard.workdescw_descrip
reve_code
TableColumn
aurora_standard.chmaccocub_reve_code
aurora_standard.chmaccocother_reve_code
aurora_standard.vault_accommodation_codesub_reve_code
aurora_standard.vault_accommodation_codesother_reve_code