aurora_standard.chm340bd

Field Type Null Default Key Extra Comment
charge_date date YES
charge_time time YES
mr_no char(20) YES
visit_no char(20) YES
pat_type char(20) YES
location char(20) YES
chg_code char(10) YES
chg_desc char(30) YES
quantity char(5) YES
hcpcs_code char(10) YES
gross_charge char(20) YES
primary_payor char(20) YES
sec_payor char(20) YES
tertiary_payor char(20) YES

References

Local Column References
quantity
TableColumn
HSPI_CURES2015_B1.cbos_inventory_logcurrent_quantity
HSPI_Central_Hospital.cbos_inventory_logcurrent_quantity
HSPI_Dewitt.cbos_inventory_logcurrent_quantity
HSPI_Fulton.cbos_inventory_logcurrent_quantity
HSPI_Inferno.cbos_inventory_logcurrent_quantity
HSPI_MU2015_E1.cbos_inventory_logcurrent_quantity
HSPI_MU2015_G2.cbos_inventory_logcurrent_quantity
HSPI_MU2015_G9.cbos_inventory_logcurrent_quantity
HSPI_Sandbox.cbos_inventory_logcurrent_quantity
HSPI_Summit_General.cbos_inventory_logcurrent_quantity
HSPI_United_Physicians.cbos_inventory_logcurrent_quantity
MPI.cbos_inventory_logcurrent_quantity
_1.charts_medicationscm_quantity
_1.encounters_payments_edi_logs_cpt_codesepelcc_quantity
_1.patients_medicationspms_quantity
_1.patients_prescriptionsprx_quantity
_1188.charts_medicationscm_quantity
_1188.encounters_payments_edi_logs_cpt_codesepelcc_quantity
_1188.patients_medicationspms_quantity
_1188.patients_prescriptionsprx_quantity
_1218.charts_medicationscm_quantity
_1218.encounters_payments_edi_logs_cpt_codesepelcc_quantity
_1218.patients_medicationspms_quantity
_1218.patients_prescriptionsprx_quantity
_1548.charts_medicationscm_quantity
_1548.encounters_payments_edi_logs_cpt_codesepelcc_quantity
_1548.patients_medicationspms_quantity
_1548.patients_prescriptionsprx_quantity
_435.charts_medicationscm_quantity
_435.encounters_payments_edi_logs_cpt_codesepelcc_quantity
_435.patients_medicationspms_quantity
_435.patients_prescriptionsprx_quantity
_436.charts_medicationscm_quantity
_436.encounters_payments_edi_logs_cpt_codesepelcc_quantity
_436.patients_medicationspms_quantity
_436.patients_prescriptionsprx_quantity
_436_archive_testing.charts_medicationscm_quantity
_436_archive_testing.encounters_payments_edi_logs_cpt_codesepelcc_quantity
_436_archive_testing.patients_medicationspms_quantity
_436_archive_testing.patients_prescriptionsprx_quantity
_437.charts_medicationscm_quantity
_437.encounters_payments_edi_logs_cpt_codesepelcc_quantity
_437.patients_medicationspms_quantity
_437.patients_prescriptionsprx_quantity
_8.charts_medicationscm_quantity
_8.encounters_payments_edi_logs_cpt_codesepelcc_quantity
_8.patients_medicationspms_quantity
_8.patients_prescriptionsprx_quantity
_81.charts_medicationscm_quantity
_81.encounters_payments_edi_logs_cpt_codesepelcc_quantity
_81.patients_medicationspms_quantity
_81.patients_prescriptionsprx_quantity
_999.charts_medicationscm_quantity
_999.encounters_payments_edi_logs_cpt_codesepelcc_quantity
_999.patients_medicationspms_quantity
_999.patients_prescriptionsprx_quantity
aurora_standard.hl7ft1trans_quantity
common.test_codes_results_cptstcrc_quantity
location
TableColumn
_1.cpoe_responsescpoe_res_location
_1.encounters_soap_vitalsespv_location
_1.hl7_accessionsacc_location
_1.patients_immunizationspim_location
_1.precertspre_scheduled_location
_1.precerts_mapprem_location
_1.radiology_resultsrad_res_location
_1188.cpoe_responsescpoe_res_location
_1188.encounters_soap_vitalsespv_location
_1188.hl7_accessionsacc_location
_1188.patients_immunizationspim_location
_1188.precertspre_scheduled_location
_1188.precerts_mapprem_location
_1188.radiology_resultsrad_res_location
_1218.cpoe_responsescpoe_res_location
_1218.encounters_soap_vitalsespv_location
_1218.hl7_accessionsacc_location
_1218.patients_immunizationspim_location
_1218.precertspre_scheduled_location
_1218.precerts_mapprem_location
_1218.radiology_resultsrad_res_location
_1548.cpoe_responsescpoe_res_location
_1548.encounters_soap_vitalsespv_location
_1548.hl7_accessionsacc_location
_1548.patients_immunizationspim_location
_1548.precertspre_scheduled_location
_1548.precerts_mapprem_location
_1548.radiology_resultsrad_res_location
_435.cpoe_responsescpoe_res_location
_435.encounters_soap_vitalsespv_location
_435.hl7_accessionsacc_location
_435.patients_immunizationspim_location
_435.precertspre_scheduled_location
_435.precerts_mapprem_location
_435.radiology_resultsrad_res_location
_436.cpoe_responsescpoe_res_location
_436.encounters_soap_vitalsespv_location
_436.hl7_accessionsacc_location
_436.patients_immunizationspim_location
_436.precertspre_scheduled_location
_436.precerts_mapprem_location
_436.radiology_resultsrad_res_location
_436_archive_testing.cpoe_responsescpoe_res_location
_436_archive_testing.encounters_soap_vitalsespv_location
_436_archive_testing.hl7_accessionsacc_location
_436_archive_testing.patients_immunizationspim_location
_436_archive_testing.precertspre_scheduled_location
_436_archive_testing.precerts_mapprem_location
_436_archive_testing.radiology_resultsrad_res_location
_437.cpoe_responsescpoe_res_location
_437.encounters_soap_vitalsespv_location
_437.hl7_accessionsacc_location
_437.patients_immunizationspim_location
_437.precertspre_scheduled_location
_437.precerts_mapprem_location
_437.radiology_resultsrad_res_location
_8.cpoe_responsescpoe_res_location
_8.encounters_soap_vitalsespv_location
_8.hl7_accessionsacc_location
_8.patients_immunizationspim_location
_8.precertspre_scheduled_location
_8.precerts_mapprem_location
_8.radiology_resultsrad_res_location
_81.cpoe_responsescpoe_res_location
_81.encounters_soap_vitalsespv_location
_81.hl7_accessionsacc_location
_81.patients_immunizationspim_location
_81.precertspre_scheduled_location
_81.precerts_mapprem_location
_81.radiology_resultsrad_res_location
_999.cpoe_responsescpoe_res_location
_999.encounters_soap_vitalsespv_location
_999.hl7_accessionsacc_location
_999.patients_immunizationspim_location
_999.precertspre_scheduled_location
_999.precerts_mapprem_location
_999.radiology_resultsrad_res_location
aurora_standard.bhguaremp_location
aurora_standard.bhtguaremp_location
aurora_standard.chpinsrdclass_location
aurora_standard.chplocacclass_location
aurora_standard.chqcmeudcme_location
aurora_standard.chqletrdletter_location
aurora_standard.chrcntrcrx_location
aurora_standard.mergdocsfile_location
aurora_standard.mergsigsfile_location
aurora_standard.sthcadjdstock_location
aurora_standard.sticadjdstock_location
aurora_standard.stilocarstock_location
aurora_standard.stipyxlcrev_location
aurora_standard.stipyxlcexp_location
aurora_standard.stistkldstock_location
aurora_standard.stock2stock_location
aurora_standard.stoshipdstock_location
aurora_standard.tmplocarstock_location
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