aurora_standard.chmmbc40

Field Type Null Default Key Extra Comment
visit_no int(11) YES
seq_no smallint(6) YES
date_of_service date YES
place_of_service varchar(1) YES
type_of_service varchar(2) YES
procedure_code varchar(5) YES
quantity varchar(3) YES
original_charge decimal(7,2) YES
diagnosis_code varchar(5) YES
modifier_1 varchar(2) YES
modifier_2 varchar(2) YES
modifier_3 varchar(2) YES
misc_dte_amt_paid varchar(6) YES
rend_phys varchar(10) YES
ic_indicator varchar(1) YES
opc_level_of_educ varchar(1) YES
opc_no_of_people varchar(2) YES
provider_code varchar(11) YES
duration_of_need smallint(6) YES
purch_serv_supp decimal(7,2) YES
dme_rx_note varchar(25) YES
waiver_of_liab varchar(1) YES
pos_medicare varchar(2) YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

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
date_of_service
TableColumn
_1.chartschrt_date_of_service
_1.charts_cpt_codeschcp_date_of_service
_1.configured_encounters_templates_cpt_codescetcc_date_of_service
_1.encountersenc_date_of_service
_1.encounters_cpt_codesecp_date_of_service
_1.encounters_payments_edi_logs_cpt_codesepelcc_date_of_service
_1.precertspre_date_of_service
_1.precerts_cpt_codespcp_date_of_service
_1188.chartschrt_date_of_service
_1188.charts_cpt_codeschcp_date_of_service
_1188.configured_encounters_templates_cpt_codescetcc_date_of_service
_1188.encountersenc_date_of_service
_1188.encounters_cpt_codesecp_date_of_service
_1188.encounters_payments_edi_logs_cpt_codesepelcc_date_of_service
_1188.precertspre_date_of_service
_1188.precerts_cpt_codespcp_date_of_service
_1218.chartschrt_date_of_service
_1218.charts_cpt_codeschcp_date_of_service
_1218.configured_encounters_templates_cpt_codescetcc_date_of_service
_1218.encountersenc_date_of_service
_1218.encounters_cpt_codesecp_date_of_service
_1218.encounters_payments_edi_logs_cpt_codesepelcc_date_of_service
_1218.precertspre_date_of_service
_1218.precerts_cpt_codespcp_date_of_service
_1548.chartschrt_date_of_service
_1548.charts_cpt_codeschcp_date_of_service
_1548.configured_encounters_templates_cpt_codescetcc_date_of_service
_1548.encountersenc_date_of_service
_1548.encounters_cpt_codesecp_date_of_service
_1548.encounters_payments_edi_logs_cpt_codesepelcc_date_of_service
_1548.precertspre_date_of_service
_1548.precerts_cpt_codespcp_date_of_service
_435.chartschrt_date_of_service
_435.charts_cpt_codeschcp_date_of_service
_435.configured_encounters_templates_cpt_codescetcc_date_of_service
_435.encountersenc_date_of_service
_435.encounters_cpt_codesecp_date_of_service
_435.encounters_payments_edi_logs_cpt_codesepelcc_date_of_service
_435.precertspre_date_of_service
_435.precerts_cpt_codespcp_date_of_service
_436.chartschrt_date_of_service
_436.charts_cpt_codeschcp_date_of_service
_436.configured_encounters_templates_cpt_codescetcc_date_of_service
_436.encountersenc_date_of_service
_436.encounters_cpt_codesecp_date_of_service
_436.encounters_payments_edi_logs_cpt_codesepelcc_date_of_service
_436.precertspre_date_of_service
_436.precerts_cpt_codespcp_date_of_service
_436_archive_testing.chartschrt_date_of_service
_436_archive_testing.charts_cpt_codeschcp_date_of_service
_436_archive_testing.configured_encounters_templates_cpt_codescetcc_date_of_service
_436_archive_testing.encountersenc_date_of_service
_436_archive_testing.encounters_cpt_codesecp_date_of_service
_436_archive_testing.encounters_payments_edi_logs_cpt_codesepelcc_date_of_service
_436_archive_testing.precertspre_date_of_service
_436_archive_testing.precerts_cpt_codespcp_date_of_service
_437.chartschrt_date_of_service
_437.charts_cpt_codeschcp_date_of_service
_437.configured_encounters_templates_cpt_codescetcc_date_of_service
_437.encountersenc_date_of_service
_437.encounters_cpt_codesecp_date_of_service
_437.encounters_payments_edi_logs_cpt_codesepelcc_date_of_service
_437.precertspre_date_of_service
_437.precerts_cpt_codespcp_date_of_service
_8.chartschrt_date_of_service
_8.charts_cpt_codeschcp_date_of_service
_8.configured_encounters_templates_cpt_codescetcc_date_of_service
_8.daily_close_calculationsdcc_enc_date_of_service
_8.daily_close_calculationsdcc_ecp_date_of_service
_8.encountersenc_date_of_service
_8.encounters_cpt_codesecp_date_of_service
_8.encounters_payments_edi_logs_cpt_codesepelcc_date_of_service
_8.precertspre_date_of_service
_8.precerts_cpt_codespcp_date_of_service
_81.chartschrt_date_of_service
_81.charts_cpt_codeschcp_date_of_service
_81.configured_encounters_templates_cpt_codescetcc_date_of_service
_81.encountersenc_date_of_service
_81.encounters_cpt_codesecp_date_of_service
_81.encounters_payments_edi_logs_cpt_codesepelcc_date_of_service
_81.precertspre_date_of_service
_81.precerts_cpt_codespcp_date_of_service
_999.chartschrt_date_of_service
_999.charts_cpt_codeschcp_date_of_service
_999.configured_encounters_templates_cpt_codescetcc_date_of_service
_999.encountersenc_date_of_service
_999.encounters_cpt_codesecp_date_of_service
_999.encounters_payments_edi_logs_cpt_codesepelcc_date_of_service
_999.precertspre_date_of_service
_999.precerts_cpt_codespcp_date_of_service
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
seq_no
TableColumn
aurora_standard.chmarstarec_seq_no
aurora_standard.chmarstacrec_seq_no
aurora_standard.chmarstairec_seq_no
aurora_standard.chmarstdrec_seq_no
aurora_standard.chmarstdirec_seq_no
aurora_standard.chmarsterec_seq_no
aurora_standard.chmarsthrec_seq_no
aurora_standard.chmarsthirec_seq_no
aurora_standard.chmarstphrec_seq_no
aurora_standard.chmarstpirec_seq_no
aurora_standard.chmarstporec_seq_no
aurora_standard.chmarstpqrec_seq_no
aurora_standard.chmarstprrec_seq_no
aurora_standard.chmarstpsrec_seq_no
aurora_standard.chmarstptrec_seq_no
aurora_standard.chmarstpyrec_seq_no
aurora_standard.chmcostarec_seq_no
aurora_standard.chmcostbrec_seq_no
aurora_standard.chmcostdrec_seq_no
aurora_standard.chmcostrcrec_seq_no
aurora_standard.chmgltcda_seq_no
aurora_standard.chmgltcdb_seq_no
aurora_standard.chmhid4arec_seq_no
aurora_standard.chmhid4brec_seq_no
aurora_standard.chmhid4crec_seq_no
aurora_standard.chmhid4drec_seq_no
aurora_standard.chmhid4grec_seq_no
aurora_standard.chrhhdcclisting_seq_no
aurora_standard.chrhhmprlisting_seq_no
aurora_standard.chrhhndclisting_seq_no
aurora_standard.chrhhndcfirm_seq_no
aurora_standard.chrhhroclisting_seq_no
aurora_standard.chrmndclisting_seq_no
aurora_standard.chrmndcfirm_seq_no
aurora_standard.chxhistdh_seq_no
aurora_standard.chyhistdh_seq_no
aurora_standard.drugclaslisting_seq_no
aurora_standard.formulatlisting_seq_no
aurora_standard.listingslisting_seq_no
aurora_standard.listingsfirm_seq_no
aurora_standard.packagelisting_seq_no
aurora_standard.routeslisting_seq_no
diagnosis_code
TableColumn
common.mednecmed_diagnosis_code