aurora_standard.chmtkl8d

Field Type Null Default Key Extra Comment
tklr_id smallint(6) YES MUL
visit_no int(11) YES
coll_stat varchar(1) YES
tklr_days smallint(6) YES
disp_seq int(11) YES
pat_name varchar(30) YES
pat_status varchar(3) YES
pri_fc varchar(2) YES
fin_class varchar(5) YES
spec_hand varchar(2) YES
action_code varchar(10) YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
action_code
TableColumn
_1.hl7_ordersord_action_code
_1188.hl7_ordersord_action_code
_1218.hl7_ordersord_action_code
_1548.hl7_ordersord_action_code
_435.hl7_ordersord_action_code
_436.hl7_ordersord_action_code
_436_archive_testing.hl7_ordersord_action_code
_437.hl7_ordersord_action_code
_8.hl7_ordersord_action_code
_81.hl7_ordersord_action_code
_999.hl7_ordersord_action_code
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
fin_class
TableColumn
aurora_standard.chmarsicur_fin_class
aurora_standard.chmcampicur_fin_class
aurora_standard.chmerafcnew_fin_class
aurora_standard.chmexmpicur_fin_class
aurora_standard.hl7gt1guar_fin_class
spec_hand
TableColumn
aurora_standard.chmcolaccur_spec_hand
aurora_standard.chmcolacnew_spec_hand
aurora_standard.chmstatcdef_spec_hand
pat_status
TableColumn
aurora_standard.chmgltcda_pat_status
aurora_standard.chmgltcdb_pat_status
aurora_standard.chmpricaprev_pat_status
aurora_standard.chmpricacur_pat_status