aurora_standard.hl7msh

Field Type Null Default Key Extra Comment
hl7joinno smallint(6) YES
seg_msh varchar(3) YES
enc_char varchar(4) YES
send_appl varchar(180) YES
send_fac varchar(180) YES
rec_appl varchar(180) YES
rec_fac varchar(180) YES
date_time_mess varchar(26) YES
security varchar(40) YES
mess_type varchar(7) YES
mess_cntrl_id varchar(20) YES
proc_id varchar(3) YES
vers_id varchar(8) YES
seq_num varchar(15) YES
field1 varchar(2) YES
field2 varchar(2) YES
field3 varchar(2) YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
seq_num
TableColumn
_1.hl7_lab_locationshll_seq_num
_1.hl7_notesnot_seq_num
_1.hl7_ordersord_seq_num
_1.hl7_resultsres_seq_num
_1.radiology_results_notesrrnot_seq_num
_1.radiology_results_test_codes_maprrtcm_seq_num
_1.radiology_results_test_codes_resultsrrtcres_seq_num
_1188.hl7_lab_locationshll_seq_num
_1188.hl7_notesnot_seq_num
_1188.hl7_ordersord_seq_num
_1188.hl7_resultsres_seq_num
_1188.radiology_results_notesrrnot_seq_num
_1188.radiology_results_test_codes_maprrtcm_seq_num
_1188.radiology_results_test_codes_resultsrrtcres_seq_num
_1218.hl7_lab_locationshll_seq_num
_1218.hl7_notesnot_seq_num
_1218.hl7_ordersord_seq_num
_1218.hl7_resultsres_seq_num
_1218.radiology_results_notesrrnot_seq_num
_1218.radiology_results_test_codes_maprrtcm_seq_num
_1218.radiology_results_test_codes_resultsrrtcres_seq_num
_1548.hl7_lab_locationshll_seq_num
_1548.hl7_notesnot_seq_num
_1548.hl7_ordersord_seq_num
_1548.hl7_resultsres_seq_num
_1548.radiology_results_notesrrnot_seq_num
_1548.radiology_results_test_codes_maprrtcm_seq_num
_1548.radiology_results_test_codes_resultsrrtcres_seq_num
_435.hl7_lab_locationshll_seq_num
_435.hl7_notesnot_seq_num
_435.hl7_ordersord_seq_num
_435.hl7_resultsres_seq_num
_435.radiology_results_notesrrnot_seq_num
_435.radiology_results_test_codes_maprrtcm_seq_num
_435.radiology_results_test_codes_resultsrrtcres_seq_num
_436.hl7_lab_locationshll_seq_num
_436.hl7_notesnot_seq_num
_436.hl7_ordersord_seq_num
_436.hl7_resultsres_seq_num
_436.radiology_results_notesrrnot_seq_num
_436.radiology_results_test_codes_maprrtcm_seq_num
_436.radiology_results_test_codes_resultsrrtcres_seq_num
_436_archive_testing.hl7_lab_locationshll_seq_num
_436_archive_testing.hl7_notesnot_seq_num
_436_archive_testing.hl7_ordersord_seq_num
_436_archive_testing.hl7_resultsres_seq_num
_436_archive_testing.radiology_results_notesrrnot_seq_num
_436_archive_testing.radiology_results_test_codes_maprrtcm_seq_num
_436_archive_testing.radiology_results_test_codes_resultsrrtcres_seq_num
_437.hl7_lab_locationshll_seq_num
_437.hl7_notesnot_seq_num
_437.hl7_ordersord_seq_num
_437.hl7_resultsres_seq_num
_437.radiology_results_notesrrnot_seq_num
_437.radiology_results_test_codes_maprrtcm_seq_num
_437.radiology_results_test_codes_resultsrrtcres_seq_num
_8.hl7_lab_locationshll_seq_num
_8.hl7_notesnot_seq_num
_8.hl7_ordersord_seq_num
_8.hl7_resultsres_seq_num
_8.radiology_results_notesrrnot_seq_num
_8.radiology_results_test_codes_maprrtcm_seq_num
_8.radiology_results_test_codes_resultsrrtcres_seq_num
_81.hl7_lab_locationshll_seq_num
_81.hl7_notesnot_seq_num
_81.hl7_ordersord_seq_num
_81.hl7_resultsres_seq_num
_81.radiology_results_notesrrnot_seq_num
_81.radiology_results_test_codes_maprrtcm_seq_num
_81.radiology_results_test_codes_resultsrrtcres_seq_num
_999.hl7_lab_locationshll_seq_num
_999.hl7_notesnot_seq_num
_999.hl7_ordersord_seq_num
_999.hl7_resultsres_seq_num
_999.radiology_results_notesrrnot_seq_num
_999.radiology_results_test_codes_maprrtcm_seq_num
_999.radiology_results_test_codes_resultsrrtcres_seq_num
aurora_standard.hl7msaexp_seq_num