aurora_standard.chmdiagd

Field Type Null Default Key Extra Comment
visit_no int(11) YES MUL
dx_type varchar(1) YES
icd_code varchar(10) YES MUL
dx_date date YES MUL
dx_time time YES
seq_no smallint(6) YES
comment varchar(30) YES
location varchar(20) YES
input_by int(11) YES
drg_no smallint(6) YES
pat_no varchar(20) YES
poa varchar(1) YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
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
poa
TableColumn
_1.encounters_ub04enc_ub04_72_a_poa
_1.encounters_ub04enc_ub04_72_b_poa
_1.encounters_ub04enc_ub04_72_c_poa
_1188.encounters_ub04enc_ub04_72_a_poa
_1188.encounters_ub04enc_ub04_72_b_poa
_1188.encounters_ub04enc_ub04_72_c_poa
_1218.encounters_ub04enc_ub04_72_a_poa
_1218.encounters_ub04enc_ub04_72_b_poa
_1218.encounters_ub04enc_ub04_72_c_poa
_1548.encounters_ub04enc_ub04_72_a_poa
_1548.encounters_ub04enc_ub04_72_b_poa
_1548.encounters_ub04enc_ub04_72_c_poa
_435.encounters_ub04enc_ub04_72_a_poa
_435.encounters_ub04enc_ub04_72_b_poa
_435.encounters_ub04enc_ub04_72_c_poa
_436.encounters_ub04enc_ub04_72_a_poa
_436.encounters_ub04enc_ub04_72_b_poa
_436.encounters_ub04enc_ub04_72_c_poa
_436_archive_testing.encounters_ub04enc_ub04_72_a_poa
_436_archive_testing.encounters_ub04enc_ub04_72_b_poa
_436_archive_testing.encounters_ub04enc_ub04_72_c_poa
_437.encounters_ub04enc_ub04_72_a_poa
_437.encounters_ub04enc_ub04_72_b_poa
_437.encounters_ub04enc_ub04_72_c_poa
_8.encounters_ub04enc_ub04_72_a_poa
_8.encounters_ub04enc_ub04_72_b_poa
_8.encounters_ub04enc_ub04_72_c_poa
_81.encounters_ub04enc_ub04_72_a_poa
_81.encounters_ub04enc_ub04_72_b_poa
_81.encounters_ub04enc_ub04_72_c_poa
_999.encounters_ub04enc_ub04_72_a_poa
_999.encounters_ub04enc_ub04_72_b_poa
_999.encounters_ub04enc_ub04_72_c_poa
aurora_standard.abshl7di9_poa
aurora_standard.chmazstdprin_poa
aurora_standard.chmazstiprin_poa
aurora_standard.chmazstoprin_poa
aurora_standard.chmlastrpri_poa
aurora_standard.chmmhastadm_poa
aurora_standard.chmokipdprin_poa
aurora_standard.chmtxstrpri_poa
icd_code
TableColumn
_1.immunizations_icd_mapiim_icd_code
_1.patients_icd9_problemspip_icd_code
_1188.immunizations_icd_mapiim_icd_code
_1188.patients_icd9_problemspip_icd_code
_1218.immunizations_icd_mapiim_icd_code
_1218.patients_icd9_problemspip_icd_code
_1548.immunizations_icd_mapiim_icd_code
_1548.patients_icd9_problemspip_icd_code
_435.immunizations_icd_mapiim_icd_code
_435.patients_icd9_problemspip_icd_code
_436.immunizations_icd_mapiim_icd_code
_436.patients_icd9_problemspip_icd_code
_436_archive_testing.immunizations_icd_mapiim_icd_code
_436_archive_testing.patients_icd9_problemspip_icd_code
_437.immunizations_icd_mapiim_icd_code
_437.patients_icd9_problemspip_icd_code
_8.immunizations_icd_mapiim_icd_code
_8.patients_icd9_problemspip_icd_code
_81.immunizations_icd_mapiim_icd_code
_81.patients_icd9_problemspip_icd_code
_999.immunizations_icd_mapiim_icd_code
_999.patients_icd9_problemspip_icd_code
comment
TableColumn
_1.orders_commentsorc_comment
_1.orders_comments_templatesorct_comment
_1.precerts_commentsprc_comment
_1.radiology_order_notesradnot_comment
_1188.orders_commentsorc_comment
_1188.orders_comments_templatesorct_comment
_1188.precerts_commentsprc_comment
_1188.radiology_order_notesradnot_comment
_1218.orders_commentsorc_comment
_1218.orders_comments_templatesorct_comment
_1218.precerts_commentsprc_comment
_1218.radiology_order_notesradnot_comment
_1548.orders_commentsorc_comment
_1548.orders_comments_templatesorct_comment
_1548.precerts_commentsprc_comment
_1548.radiology_order_notesradnot_comment
_435.orders_commentsorc_comment
_435.orders_comments_templatesorct_comment
_435.precerts_commentsprc_comment
_435.radiology_order_notesradnot_comment
_436.orders_commentsorc_comment
_436.orders_comments_templatesorct_comment
_436.precerts_commentsprc_comment
_436.radiology_order_notesradnot_comment
_436_archive_testing.orders_commentsorc_comment
_436_archive_testing.orders_comments_templatesorct_comment
_436_archive_testing.precerts_commentsprc_comment
_436_archive_testing.radiology_order_notesradnot_comment
_437.orders_commentsorc_comment
_437.orders_comments_templatesorct_comment
_437.precerts_commentsprc_comment
_437.radiology_order_notesradnot_comment
_8.orders_commentsorc_comment
_8.orders_comments_templatesorct_comment
_8.precerts_commentsprc_comment
_8.radiology_order_notesradnot_comment
_81.orders_commentsorc_comment
_81.orders_comments_templatesorct_comment
_81.precerts_commentsprc_comment
_81.radiology_order_notesradnot_comment
_999.orders_commentsorc_comment
_999.orders_comments_templatesorct_comment
_999.precerts_commentsprc_comment
_999.radiology_order_notesradnot_comment
ahiWiki.archivear_comment
ahiWiki.logginglog_comment
ahiWiki.recentchangesrc_comment
ahiWiki.revisionrev_comment
aurora_standard.audppayddenial_comment
aurora_standard.chmabstrstatus_comment
aurora_standard.chmblogddenial_comment
aurora_standard.chmbremddenial_comment
aurora_standard.chmmcqudemp_comment
aurora_standard.chmmcqudsp_emp_comment
aurora_standard.chmozpcdacct_comment
aurora_standard.chmppayddenial_comment
aurora_standard.chpevaldreviewer_comment
aurora_standard.hl7ntesrc_comment
aurora_standard.hl7nteadsrc_comment
common.service_tickets_commentsstcp_comment
template_library.orders_comments_templatesorct_comment
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