aurora_standard.chmcost2

Field Type Null Default Key Extra Comment
mr_no int(11) YES
visit_no varchar(20) YES
charge_code varchar(1) YES
units decimal(10,4) YES
tot_charge decimal(16,2) YES
date_serv date YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

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
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
mr_no
TableColumn
aurora_standard.bsinsursnf_mr_no
aurora_standard.bsinsurprev_mr_no
aurora_standard.chhcntrcauto_snf_mr_no
aurora_standard.chhcntrcauto_mr_no
aurora_standard.chmarbexpat_mr_no
aurora_standard.chmarsipat_mr_no
aurora_standard.chmbatexpat_mr_no
aurora_standard.chmcampipat_mr_no
aurora_standard.chmcntrcauto_snf_mr_no
aurora_standard.chmcntrcauto_mr_no
aurora_standard.chmexmpipat_mr_no
aurora_standard.chmhstmrpat_mr_no
aurora_standard.chmhstrmpat_mr_no
aurora_standard.chmlastrmother_mr_no
aurora_standard.chmmhastco_mr_no
aurora_standard.chmmrhdrupd_mr_no
aurora_standard.chmnrcexpat_mr_no
aurora_standard.chmokipdpat_mr_no
aurora_standard.chmokopdpat_mr_no
aurora_standard.chmpatmrsnf_mr_no
aurora_standard.chmpatmrprev_mr_no
aurora_standard.chmradedpat_mr_no
aurora_standard.chmradexpat_mr_no
aurora_standard.chmreqsrofc_mr_no
aurora_standard.ncexmpipat_mr_no