aurora_standard.chmraded

Field Type Null Default Key Extra Comment
bill_date char(10) YES
pat_visit_no char(10) YES
pat_mr_no char(20) YES
charge_code char(10) YES
charge_desc char(30) YES
charge_dt char(10) YES
cpt char(10) YES
mod_1 char(2) YES
mod_2 char(2) YES
units char(6) YES
phy_no char(6) YES
phy_nm char(30) YES
phy_npi char(10) YES

References

Local Column References
units
TableColumn
Loinc.loinc_codeslc_ipcc_units
Loinc.loinc_codeslc_submitted_units
Loinc.loinc_codeslc_example_units
Loinc.loinc_codeslc_curated_range_and_units
Loinc.loinc_codeslc_example_ucum_units
Loinc.loinc_codeslc_example_si_ucum_units
Loinc.loinc_codes_example_unitslceu_example_units
_1.charts_cpt_codeschcp_num_units
_1.charts_medicationscm_quantity_units
_1.charts_procedurescp_num_units
_1.clients_fee_schedules_mapcfsm_num_units
_1.clinical_interventions_coded_attributescica_units
_1.clinical_interventions_lab_results_mapcilrm_units
_1.configured_encounters_templates_cpt_codescetcc_num_units
_1.encounters_cpt_codesecp_num_units
_1.encounters_cpt_codes_templatesecpt_num_units
_1.hl7_resultsres_observ_units
_1.labs_resultslr_observ_units
_1.patients_immunizationspim_administered_units
_1.patients_immunizations_templatespimt_administered_units
_1.patients_inventorypinv_administered_units
_1.patients_medicationspms_quantity_units
_1.patients_prescriptionsprx_quantity_units
_1.patients_responsibility_estimates_servicesprests_ndc_num_units
_1.patients_responsibility_estimates_servicesprests_num_units
_1.patients_responsibility_estimates_servicesprests_allowed_units
_1.precerts_cpt_codespcp_num_units
_1188.charts_cpt_codeschcp_num_units
_1188.charts_medicationscm_quantity_units
_1188.charts_procedurescp_num_units
_1188.clients_fee_schedules_mapcfsm_num_units
_1188.clinical_interventions_lab_results_mapcilrm_units
_1188.configured_encounters_templates_cpt_codescetcc_num_units
_1188.encounters_cpt_codesecp_num_units
_1188.encounters_cpt_codes_templatesecpt_num_units
_1188.hl7_resultsres_observ_units
_1188.labs_resultslr_observ_units
_1188.patients_immunizationspim_administered_units
_1188.patients_immunizations_templatespimt_administered_units
_1188.patients_inventorypinv_administered_units
_1188.patients_medicationspms_quantity_units
_1188.patients_prescriptionsprx_quantity_units
_1188.patients_responsibility_estimates_servicesprests_ndc_num_units
_1188.patients_responsibility_estimates_servicesprests_num_units
_1188.patients_responsibility_estimates_servicesprests_allowed_units
_1188.precerts_cpt_codespcp_num_units
_1218.charts_cpt_codeschcp_num_units
_1218.charts_medicationscm_quantity_units
_1218.charts_procedurescp_num_units
_1218.clients_fee_schedules_mapcfsm_num_units
_1218.clinical_interventions_lab_results_mapcilrm_units
_1218.configured_encounters_templates_cpt_codescetcc_num_units
_1218.encounters_cpt_codesecp_num_units
_1218.encounters_cpt_codes_templatesecpt_num_units
_1218.hl7_resultsres_observ_units
_1218.labs_resultslr_observ_units
_1218.patients_immunizationspim_administered_units
_1218.patients_immunizations_templatespimt_administered_units
_1218.patients_inventorypinv_administered_units
_1218.patients_medicationspms_quantity_units
_1218.patients_prescriptionsprx_quantity_units
_1218.patients_responsibility_estimates_servicesprests_ndc_num_units
_1218.patients_responsibility_estimates_servicesprests_num_units
_1218.patients_responsibility_estimates_servicesprests_allowed_units
_1218.precerts_cpt_codespcp_num_units
_1548.charts_cpt_codeschcp_num_units
_1548.charts_medicationscm_quantity_units
_1548.charts_procedurescp_num_units
_1548.clients_fee_schedules_mapcfsm_num_units
_1548.clinical_interventions_coded_attributescica_units
_1548.clinical_interventions_lab_results_mapcilrm_units
_1548.configured_encounters_templates_cpt_codescetcc_num_units
_1548.encounters_cpt_codesecp_num_units
_1548.encounters_cpt_codes_templatesecpt_num_units
_1548.hl7_resultsres_observ_units
_1548.labs_resultslr_observ_units
_1548.patients_immunizationspim_administered_units
_1548.patients_immunizations_templatespimt_administered_units
_1548.patients_inventorypinv_administered_units
_1548.patients_medicationspms_quantity_units
_1548.patients_prescriptionsprx_quantity_units
_1548.patients_responsibility_estimates_servicesprests_ndc_num_units
_1548.patients_responsibility_estimates_servicesprests_num_units
_1548.patients_responsibility_estimates_servicesprests_allowed_units
_1548.precerts_cpt_codespcp_num_units
_435.charts_cpt_codeschcp_num_units
_435.charts_medicationscm_quantity_units
_435.charts_procedurescp_num_units
_435.clients_fee_schedules_mapcfsm_num_units
_435.clinical_interventions_coded_attributescica_units
_435.clinical_interventions_lab_results_mapcilrm_units
_435.configured_encounters_templates_cpt_codescetcc_num_units
_435.encounters_cpt_codesecp_num_units
_435.encounters_cpt_codes_templatesecpt_num_units
_435.hl7_resultsres_observ_units
_435.labs_resultslr_observ_units
_435.patients_immunizationspim_administered_units
_435.patients_immunizations_templatespimt_administered_units
_435.patients_inventorypinv_administered_units
_435.patients_medicationspms_quantity_units
_435.patients_prescriptionsprx_quantity_units
_435.patients_responsibility_estimates_servicesprests_ndc_num_units
_435.patients_responsibility_estimates_servicesprests_num_units
_435.precerts_cpt_codespcp_num_units
_436.charts_cpt_codeschcp_num_units
_436.charts_medicationscm_quantity_units
_436.charts_procedurescp_num_units
_436.clients_fee_schedules_mapcfsm_num_units
_436.clinical_interventions_coded_attributescica_units
_436.clinical_interventions_lab_results_mapcilrm_units
_436.configured_encounters_templates_cpt_codescetcc_num_units
_436.encounters_cpt_codesecp_num_units
_436.encounters_cpt_codes_templatesecpt_num_units
_436.hl7_resultsres_observ_units
_436.labs_resultslr_observ_units
_436.patients_immunizationspim_administered_units
_436.patients_immunizations_templatespimt_administered_units
_436.patients_inventorypinv_administered_units
_436.patients_medicationspms_quantity_units
_436.patients_prescriptionsprx_quantity_units
_436.patients_responsibility_estimates_servicesprests_ndc_num_units
_436.patients_responsibility_estimates_servicesprests_num_units
_436.precerts_cpt_codespcp_num_units
_436_archive_testing.charts_cpt_codeschcp_num_units
_436_archive_testing.charts_medicationscm_quantity_units
_436_archive_testing.charts_procedurescp_num_units
_436_archive_testing.clients_fee_schedules_mapcfsm_num_units
_436_archive_testing.clinical_interventions_coded_attributescica_units
_436_archive_testing.clinical_interventions_lab_results_mapcilrm_units
_436_archive_testing.configured_encounters_templates_cpt_codescetcc_num_units
_436_archive_testing.encounters_cpt_codesecp_num_units
_436_archive_testing.encounters_cpt_codes_templatesecpt_num_units
_436_archive_testing.hl7_resultsres_observ_units
_436_archive_testing.labs_resultslr_observ_units
_436_archive_testing.patients_immunizationspim_administered_units
_436_archive_testing.patients_immunizations_templatespimt_administered_units
_436_archive_testing.patients_inventorypinv_administered_units
_436_archive_testing.patients_medicationspms_quantity_units
_436_archive_testing.patients_prescriptionsprx_quantity_units
_436_archive_testing.patients_responsibility_estimates_servicesprests_ndc_num_units
_436_archive_testing.patients_responsibility_estimates_servicesprests_num_units
_436_archive_testing.precerts_cpt_codespcp_num_units
_437.charts_cpt_codeschcp_num_units
_437.charts_medicationscm_quantity_units
_437.charts_procedurescp_num_units
_437.clients_fee_schedules_mapcfsm_num_units
_437.clinical_interventions_coded_attributescica_units
_437.clinical_interventions_lab_results_mapcilrm_units
_437.configured_encounters_templates_cpt_codescetcc_num_units
_437.encounters_cpt_codesecp_num_units
_437.encounters_cpt_codes_templatesecpt_num_units
_437.hl7_resultsres_observ_units
_437.labs_resultslr_observ_units
_437.patients_immunizationspim_administered_units
_437.patients_immunizations_templatespimt_administered_units
_437.patients_inventorypinv_administered_units
_437.patients_medicationspms_quantity_units
_437.patients_prescriptionsprx_quantity_units
_437.patients_responsibility_estimates_servicesprests_ndc_num_units
_437.patients_responsibility_estimates_servicesprests_num_units
_437.precerts_cpt_codespcp_num_units
_8.charts_cpt_codeschcp_num_units
_8.charts_medicationscm_quantity_units
_8.charts_procedurescp_num_units
_8.clients_fee_schedules_mapcfsm_num_units
_8.clinical_interventions_coded_attributescica_units
_8.clinical_interventions_lab_results_mapcilrm_units
_8.configured_encounters_templates_cpt_codescetcc_num_units
_8.daily_close_calculationsdcc_ecp_num_units
_8.encounters_cpt_codesecp_num_units
_8.encounters_cpt_codes_templatesecpt_num_units
_8.hl7_resultsres_observ_units
_8.labs_resultslr_observ_units
_8.patients_immunizationspim_administered_units
_8.patients_immunizations_templatespimt_administered_units
_8.patients_inventorypinv_administered_units
_8.patients_medicationspms_quantity_units
_8.patients_prescriptionsprx_quantity_units
_8.patients_responsibility_estimates_servicesprests_ndc_num_units
_8.patients_responsibility_estimates_servicesprests_num_units
_8.patients_responsibility_estimates_servicesprests_allowed_units
_8.precerts_cpt_codespcp_num_units
_81.charts_cpt_codeschcp_num_units
_81.charts_medicationscm_quantity_units
_81.charts_procedurescp_num_units
_81.clients_fee_schedules_mapcfsm_num_units
_81.clinical_interventions_lab_results_mapcilrm_units
_81.configured_encounters_templates_cpt_codescetcc_num_units
_81.encounters_cpt_codesecp_num_units
_81.encounters_cpt_codes_templatesecpt_num_units
_81.hl7_resultsres_observ_units
_81.labs_resultslr_observ_units
_81.patients_immunizationspim_administered_units
_81.patients_immunizations_templatespimt_administered_units
_81.patients_inventorypinv_administered_units
_81.patients_medicationspms_quantity_units
_81.patients_prescriptionsprx_quantity_units
_81.patients_responsibility_estimates_servicesprests_ndc_num_units
_81.patients_responsibility_estimates_servicesprests_num_units
_81.patients_responsibility_estimates_servicesprests_allowed_units
_81.precerts_cpt_codespcp_num_units
_999.charts_cpt_codeschcp_num_units
_999.charts_medicationscm_quantity_units
_999.charts_procedurescp_num_units
_999.clients_fee_schedules_mapcfsm_num_units
_999.clinical_interventions_coded_attributescica_units
_999.clinical_interventions_lab_results_mapcilrm_units
_999.configured_encounters_templates_cpt_codescetcc_num_units
_999.encounters_cpt_codesecp_num_units
_999.encounters_cpt_codes_templatesecpt_num_units
_999.hl7_resultsres_observ_units
_999.labs_resultslr_observ_units
_999.patients_immunizationspim_administered_units
_999.patients_immunizations_templatespimt_administered_units
_999.patients_inventorypinv_administered_units
_999.patients_medicationspms_quantity_units
_999.patients_prescriptionsprx_quantity_units
_999.patients_responsibility_estimates_servicesprests_ndc_num_units
_999.patients_responsibility_estimates_servicesprests_num_units
_999.patients_responsibility_estimates_servicesprests_allowed_units
_999.precerts_cpt_codespcp_num_units
aurora_standard.c7cdmrxbill_units
aurora_standard.cachrgchg_units
aurora_standard.cachrg2chg_units
aurora_standard.cachrgcachg_units
aurora_standard.cachrgevochg_units
aurora_standard.canullchrgchg_units
aurora_standard.caroomchg_units
aurora_standard.chmabstrblood_units
aurora_standard.chmapcbrcpt_units
aurora_standard.chmapcircpt_units
aurora_standard.choordmdorder_units
aurora_standard.choordrcdefault_units
aurora_standard.chrordrrdispense_units
aurora_standard.oeorderorder_units
common.loinc_codeslc_ipcc_units
common.loinc_codeslc_submitted_units
common.loinc_codeslc_example_units
common.loinc_codeslc_curated_range_and_units
common.loinc_codeslc_example_ucum_units
common.loinc_codeslc_example_si_ucum_units
common.test_codes_cpttcc_units
template_library.encounters_cpt_codes_templatesecpt_num_units
template_library.patients_immunizations_templatespimt_administered_units
charge_code
TableColumn
_1.hl7_resultsres_charge_code
_1.radiology_results_test_codes_resultsrrtcres_charge_code
_1188.hl7_resultsres_charge_code
_1188.radiology_results_test_codes_resultsrrtcres_charge_code
_1218.hl7_resultsres_charge_code
_1218.radiology_results_test_codes_resultsrrtcres_charge_code
_1548.hl7_resultsres_charge_code
_1548.radiology_results_test_codes_resultsrrtcres_charge_code
_435.hl7_resultsres_charge_code
_435.radiology_results_test_codes_resultsrrtcres_charge_code
_436.hl7_resultsres_charge_code
_436.radiology_results_test_codes_resultsrrtcres_charge_code
_436_archive_testing.hl7_resultsres_charge_code
_436_archive_testing.radiology_results_test_codes_resultsrrtcres_charge_code
_437.hl7_resultsres_charge_code
_437.radiology_results_test_codes_resultsrrtcres_charge_code
_8.hl7_resultsres_charge_code
_8.radiology_results_test_codes_resultsrrtcres_charge_code
_81.hl7_resultsres_charge_code
_81.radiology_results_test_codes_resultsrrtcres_charge_code
_999.hl7_resultsres_charge_code
_999.radiology_results_test_codes_resultsrrtcres_charge_code
cpt
TableColumn
_1.orders_test_codes_mapotcm_cpt
_1188.orders_test_codes_mapotcm_cpt
_1218.orders_test_codes_mapotcm_cpt
_1548.orders_test_codes_mapotcm_cpt
_435.orders_test_codes_mapotcm_cpt
_436.orders_test_codes_mapotcm_cpt
_436_archive_testing.orders_test_codes_mapotcm_cpt
_437.orders_test_codes_mapotcm_cpt
_8.orders_test_codes_mapotcm_cpt
_81.orders_test_codes_mapotcm_cpt
_999.orders_test_codes_mapotcm_cpt
aurora_standard.apscdmmc_cpt
aurora_standard.apscdmmd_cpt
aurora_standard.apscdmci_cpt
aurora_standard.apscdmwc_cpt
aurora_standard.apscdmamc_cpt
aurora_standard.apscdmamd_cpt
aurora_standard.apscdmaci_cpt
aurora_standard.apscdmawc_cpt
aurora_standard.bfcdmmd_cpt
aurora_standard.bfrhccdmmd_cpt
aurora_standard.chmokopdprin_cpt
aurora_standard.chmsubccstart_cpt
aurora_standard.chmsubccend_cpt
aurora_standard.samcdmcmc_cpt
aurora_standard.samcdmcmd_cpt
aurora_standard.workcptwk_cpt
common.test_codestco_cpt
mod_1
TableColumn
aurora_standard.axlscdmmd_mod_1
aurora_standard.axlscdmci_mod_1
aurora_standard.chmpricaprev_mod_1
aurora_standard.chmpricacur_mod_1
mod_2
TableColumn
aurora_standard.axlscdmmd_mod_2
aurora_standard.axlscdmci_mod_2
aurora_standard.chmpricaprev_mod_2
aurora_standard.chmpricacur_mod_2
phy_nm
TableColumn
aurora_standard.b2mrdradm_phy_nm
aurora_standard.b2mrdratt_phy_nm
aurora_standard.bhmrdradm_phy_nm
aurora_standard.bhmrdratt_phy_nm
aurora_standard.bhtmrdradm_phy_nm
aurora_standard.bhtmrdratt_phy_nm
aurora_standard.c7mpipri_phy_nm
aurora_standard.c9mpipri_phy_nm
aurora_standard.chmarsifam_phy_nm
aurora_standard.chmarsiattend_phy_nm
aurora_standard.chmarsiadmit_phy_nm
aurora_standard.chmazstdatt_phy_nm
aurora_standard.chmazstdoth_phy_nm
aurora_standard.chmazstiatt_phy_nm
aurora_standard.chmazstioth_phy_nm
aurora_standard.chmazstoatt_phy_nm
aurora_standard.chmazstooth_phy_nm
aurora_standard.chmcampifam_phy_nm
aurora_standard.chmcampiattend_phy_nm
aurora_standard.chmcampiadmit_phy_nm
aurora_standard.chmexmpifam_phy_nm
aurora_standard.chmexmpiattend_phy_nm
aurora_standard.chmexmpiadmit_phy_nm
aurora_standard.chmexvisattend_phy_nm
aurora_standard.chmexvisadmit_phy_nm
aurora_standard.chmradexfam_phy_nm
aurora_standard.chmradexattend_phy_nm
aurora_standard.chmradexadmit_phy_nm
aurora_standard.kcvisfam_phy_nm
aurora_standard.kcvisitfam_phy_nm
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
phy_npi
TableColumn
aurora_standard.chmarsifam_phy_npi
aurora_standard.chmarsiattend_phy_npi
aurora_standard.chmarsiadmit_phy_npi
aurora_standard.chmazstdatt_phy_npi
aurora_standard.chmazstdproc_phy_npi
aurora_standard.chmazstdoth_phy_npi
aurora_standard.chmazstiatt_phy_npi
aurora_standard.chmazstiproc_phy_npi
aurora_standard.chmazstioth_phy_npi
aurora_standard.chmazstoatt_phy_npi
aurora_standard.chmazstoproc_phy_npi
aurora_standard.chmazstooth_phy_npi
aurora_standard.chmcampifam_phy_npi
aurora_standard.chmcampiattend_phy_npi
aurora_standard.chmcampiadmit_phy_npi
aurora_standard.chmexmpifam_phy_npi
aurora_standard.chmexmpiattend_phy_npi
aurora_standard.chmexmpiadmit_phy_npi
aurora_standard.chmexvisattend_phy_npi
aurora_standard.chmexvisadmit_phy_npi
aurora_standard.chmlastratt_phy_npi
aurora_standard.chmlastrop_phy_npi
aurora_standard.chmlastroth_phy_npi
aurora_standard.chmlastrrnd_phy_npi
aurora_standard.chmlastradm_phy_npi
aurora_standard.chmlastrref_phy_npi
aurora_standard.chmmhastatt_phy_npi
aurora_standard.chmpdemofam_phy_npi
aurora_standard.chmpdemoattend_phy_npi
aurora_standard.chmpdemoadmit_phy_npi
aurora_standard.chmradexfam_phy_npi
aurora_standard.chmradexattend_phy_npi
aurora_standard.chmradexadmit_phy_npi