aurora_standard.chmescmr

Field Type Null Default Key Extra Comment
patient_id char(20) YES
date_of_service date YES
site_id char(3) YES
provider_id smallint(6) YES
dx1 char(15) YES
dx2 char(15) YES
dx3 char(15) YES
dx4 char(15) YES
dx_seq smallint(6) YES
visit_no char(15) YES

References

Local Column References
provider_id
TableColumn
HSPI_Bastrop.payersub04_provider_id
HSPI_CURES2015_B1.payersub04_provider_id
HSPI_Central_Hospital.payersub04_provider_id
HSPI_Dewitt.payersub04_provider_id
HSPI_Fulton.payersub04_provider_id
HSPI_Inferno.payersub04_provider_id
HSPI_MU2015_E1.payersub04_provider_id
HSPI_MU2015_G2.payersub04_provider_id
HSPI_MU2015_G9.payersub04_provider_id
HSPI_Sandbox.payersub04_provider_id
HSPI_Summit_General.payersub04_provider_id
HSPI_United_Physicians.payersub04_provider_id
MPI.payersub04_provider_id
patient_id
TableColumn
HSPI_CURES2015_B1.document_referencesauthor_patient_id
HSPI_Central_Hospital.document_referencesauthor_patient_id
HSPI_Dewitt.document_referencesauthor_patient_id
HSPI_Fulton.document_referencesauthor_patient_id
HSPI_Inferno.document_referencesauthor_patient_id
HSPI_MU2015_E1.document_referencesauthor_patient_id
HSPI_MU2015_G2.document_referencesauthor_patient_id
HSPI_MU2015_G9.document_referencesauthor_patient_id
HSPI_Sandbox.document_referencesauthor_patient_id
HSPI_Summit_General.document_referencesauthor_patient_id
HSPI_United_Physicians.document_referencesauthor_patient_id
MPI.document_referencesauthor_patient_id
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
dx1
TableColumn
_1.encounters_cpt_codesecp_dx1
_1.precerts_cpt_codespcp_dx1
_1188.encounters_cpt_codesecp_dx1
_1188.precerts_cpt_codespcp_dx1
_1218.encounters_cpt_codesecp_dx1
_1218.precerts_cpt_codespcp_dx1
_1548.encounters_cpt_codesecp_dx1
_1548.precerts_cpt_codespcp_dx1
_435.encounters_cpt_codesecp_dx1
_435.precerts_cpt_codespcp_dx1
_436.encounters_cpt_codesecp_dx1
_436.precerts_cpt_codespcp_dx1
_436_archive_testing.encounters_cpt_codesecp_dx1
_436_archive_testing.precerts_cpt_codespcp_dx1
_437.encounters_cpt_codesecp_dx1
_437.precerts_cpt_codespcp_dx1
_8.encounters_cpt_codesecp_dx1
_8.precerts_cpt_codespcp_dx1
_81.encounters_cpt_codesecp_dx1
_81.precerts_cpt_codespcp_dx1
_999.encounters_cpt_codesecp_dx1
_999.precerts_cpt_codespcp_dx1
aurora_standard.chmadmpradmit_dx1
aurora_standard.chmcostrcreason_dx1
aurora_standard.chmhid4creason_dx1
aurora_standard.chmmhastother_dx1
aurora_standard.chmmhastpoa_dx1
dx2
TableColumn
_1.encounters_cpt_codesecp_dx2
_1.precerts_cpt_codespcp_dx2
_1188.encounters_cpt_codesecp_dx2
_1188.precerts_cpt_codespcp_dx2
_1218.encounters_cpt_codesecp_dx2
_1218.precerts_cpt_codespcp_dx2
_1548.encounters_cpt_codesecp_dx2
_1548.precerts_cpt_codespcp_dx2
_435.encounters_cpt_codesecp_dx2
_435.precerts_cpt_codespcp_dx2
_436.encounters_cpt_codesecp_dx2
_436.precerts_cpt_codespcp_dx2
_436_archive_testing.encounters_cpt_codesecp_dx2
_436_archive_testing.precerts_cpt_codespcp_dx2
_437.encounters_cpt_codesecp_dx2
_437.precerts_cpt_codespcp_dx2
_8.encounters_cpt_codesecp_dx2
_8.precerts_cpt_codespcp_dx2
_81.encounters_cpt_codesecp_dx2
_81.precerts_cpt_codespcp_dx2
_999.encounters_cpt_codesecp_dx2
_999.precerts_cpt_codespcp_dx2
aurora_standard.chmadmpradmit_dx2
aurora_standard.chmcostrcreason_dx2
aurora_standard.chmhid4creason_dx2
aurora_standard.chmmhastother_dx2
aurora_standard.chmmhastpoa_dx2
dx3
TableColumn
_1.encounters_cpt_codesecp_dx3
_1.precerts_cpt_codespcp_dx3
_1188.encounters_cpt_codesecp_dx3
_1188.precerts_cpt_codespcp_dx3
_1218.encounters_cpt_codesecp_dx3
_1218.precerts_cpt_codespcp_dx3
_1548.encounters_cpt_codesecp_dx3
_1548.precerts_cpt_codespcp_dx3
_435.encounters_cpt_codesecp_dx3
_435.precerts_cpt_codespcp_dx3
_436.encounters_cpt_codesecp_dx3
_436.precerts_cpt_codespcp_dx3
_436_archive_testing.encounters_cpt_codesecp_dx3
_436_archive_testing.precerts_cpt_codespcp_dx3
_437.encounters_cpt_codesecp_dx3
_437.precerts_cpt_codespcp_dx3
_8.encounters_cpt_codesecp_dx3
_8.precerts_cpt_codespcp_dx3
_81.encounters_cpt_codesecp_dx3
_81.precerts_cpt_codespcp_dx3
_999.encounters_cpt_codesecp_dx3
_999.precerts_cpt_codespcp_dx3
aurora_standard.chmadmpradmit_dx3
aurora_standard.chmcostrcreason_dx3
aurora_standard.chmhid4creason_dx3
aurora_standard.chmmhastother_dx3
aurora_standard.chmmhastpoa_dx3
dx4
TableColumn
_1.encounters_cpt_codesecp_dx4
_1.precerts_cpt_codespcp_dx4
_1188.encounters_cpt_codesecp_dx4
_1188.precerts_cpt_codespcp_dx4
_1218.encounters_cpt_codesecp_dx4
_1218.precerts_cpt_codespcp_dx4
_1548.encounters_cpt_codesecp_dx4
_1548.precerts_cpt_codespcp_dx4
_435.encounters_cpt_codesecp_dx4
_435.precerts_cpt_codespcp_dx4
_436.encounters_cpt_codesecp_dx4
_436.precerts_cpt_codespcp_dx4
_436_archive_testing.encounters_cpt_codesecp_dx4
_436_archive_testing.precerts_cpt_codespcp_dx4
_437.encounters_cpt_codesecp_dx4
_437.precerts_cpt_codespcp_dx4
_8.encounters_cpt_codesecp_dx4
_8.precerts_cpt_codespcp_dx4
_81.encounters_cpt_codesecp_dx4
_81.precerts_cpt_codespcp_dx4
_999.encounters_cpt_codesecp_dx4
_999.precerts_cpt_codespcp_dx4
aurora_standard.chmmhastother_dx4
aurora_standard.chmmhastpoa_dx4
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
site_id
TableColumn
aurora_standard.chhcntrcneic_site_id
aurora_standard.chmcntrcneic_site_id
common.lab_interfaces_performing_siteslips_performing_site_id