aurora_standard.chxflocd

Field Type Null Default Key Extra Comment
visit_no int(11) YES MUL
order_no smallint(6) YES
cur_flag varchar(1) YES
service_code varchar(10) YES
date_in date YES
time_in time YES
loc_code varchar(10) YES
input_by smallint(6) YES
due_date date YES
comment varchar(40) YES
film_type varchar(6) YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
time_in
TableColumn
Azalea.timesheetsts_time_in
aurora_standard.chtclokdtrans_time_in
aurora_standard.chtclokdactual_time_in
aurora_standard.hhtclokdtrans_time_in
aurora_standard.hhtclokdactual_time_in
aurora_standard.timetabltrans_time_in
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
due_date
TableColumn
_1.patients_reminderspr_due_date
_1.patients_statementspst_due_date
_1188.patients_reminderspr_due_date
_1188.patients_statementspst_due_date
_1218.patients_reminderspr_due_date
_1218.patients_statementspst_due_date
_1548.patients_reminderspr_due_date
_1548.patients_statementspst_due_date
_435.patients_reminderspr_due_date
_435.patients_statementspst_due_date
_436.patients_reminderspr_due_date
_436.patients_statementspst_due_date
_436_archive_testing.patients_reminderspr_due_date
_436_archive_testing.patients_statementspst_due_date
_437.patients_reminderspr_due_date
_437.patients_statementspst_due_date
_8.patients_reminderspr_due_date
_8.patients_statementspst_due_date
_81.patients_reminderspr_due_date
_81.patients_statementspst_due_date
_999.patients_reminderspr_due_date
_999.patients_statementspst_due_date
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
order_no
TableColumn
aurora_standard.chmpintrrx_order_no
date_in
TableColumn
aurora_standard.chtclokdtrans_date_in
aurora_standard.hhtclokdtrans_date_in
aurora_standard.timetabltrans_date_in