aurora_standard.chptermd

Field Type Null Default Key Extra Comment
empl_code varchar(6) YES
comments varchar(60) YES
seq_num smallint(6) YES
termination_no int(11) YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
comments
TableColumn
Loinc.loinc_codeslc_comments
_1.patient_amendmentspa_comments
_1.patients_allergiespalg_comments
_1.patients_medicationspms_erx_comments
_1.patients_reminderspr_comments
_1188.patient_amendmentspa_comments
_1188.patients_allergiespalg_comments
_1188.patients_medicationspms_erx_comments
_1188.patients_reminderspr_comments
_1218.patient_amendmentspa_comments
_1218.patients_allergiespalg_comments
_1218.patients_medicationspms_erx_comments
_1218.patients_reminderspr_comments
_1548.patient_amendmentspa_comments
_1548.patients_allergiespalg_comments
_1548.patients_medicationspms_erx_comments
_1548.patients_reminderspr_comments
_435.patient_amendmentspa_comments
_435.patients_allergiespalg_comments
_435.patients_medicationspms_erx_comments
_435.patients_reminderspr_comments
_436.patient_amendmentspa_comments
_436.patients_allergiespalg_comments
_436.patients_medicationspms_erx_comments
_436.patients_reminderspr_comments
_436_archive_testing.patient_amendmentspa_comments
_436_archive_testing.patients_allergiespalg_comments
_436_archive_testing.patients_medicationspms_erx_comments
_436_archive_testing.patients_reminderspr_comments
_437.patient_amendmentspa_comments
_437.patients_allergiespalg_comments
_437.patients_medicationspms_erx_comments
_437.patients_reminderspr_comments
_8.patient_amendmentspa_comments
_8.patients_allergiespalg_comments
_8.patients_medicationspms_erx_comments
_8.patients_reminderspr_comments
_81.patient_amendmentspa_comments
_81.patients_allergiespalg_comments
_81.patients_medicationspms_erx_comments
_81.patients_reminderspr_comments
_999.patient_amendmentspa_comments
_999.patients_allergiespalg_comments
_999.patients_medicationspms_erx_comments
_999.patients_reminderspr_comments
aurora_standard.cgsiflddf_comments
aurora_standard.chlrescdres_comments
aurora_standard.chpinsrdclass_comments
common.applicantsapp_comments
common.data_import_clients_meta_datadicmd_comments
common.data_import_field_typesdift_comments
common.data_import_fieldsdif_comments
common.leadslea_comments
common.loinc_codeslc_comments
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
empl_code
TableColumn
aurora_standard.chtsupvcsupv_empl_code
aurora_standard.stypddrdadj_empl_code