aurora_standard.chmadmdd

Field Type Null Default Key Extra Comment
visit_no int(11) YES MUL
daily_date date YES MUL
pat_status varchar(3) YES
fin_class varchar(5) YES
nurs_station varchar(10) YES
acc_code varchar(3) YES
clin_class varchar(10) YES
level_care varchar(3) YES
which_log varchar(2) YES
input_by smallint(6) YES
room varchar(5) YES
bed varchar(5) YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
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
bed
TableColumn
aurora_standard.bdallviscur_bed
aurora_standard.bdviscur_bed
aurora_standard.c7viscur_bed
aurora_standard.caviscur_bed
aurora_standard.cavishcur_bed
aurora_standard.chhl7adtcurr_bed
aurora_standard.chmadmtrcurr_bed
aurora_standard.chmmashrroom_bed
aurora_standard.chmrtrndf_bed
aurora_standard.chmrtrndt_bed
aurora_standard.hhmadmtrcurr_bed
aurora_standard.kcviscur_bed
aurora_standard.kcvisitcur_bed
room
TableColumn
aurora_standard.chhl7adtcurr_room
aurora_standard.chmadmtrcurr_room
aurora_standard.chmblogdpat_resp_room
aurora_standard.chmplogdpat_resp_room
aurora_standard.chmrtrndf_room
aurora_standard.chmrtrndt_room
aurora_standard.chmstatcreq_room
aurora_standard.hhmadmtrcurr_room
aurora_standard.logchrgddeliv_room
aurora_standard.logchrgdrec_room
aurora_standard.logchrgdob_room
aurora_standard.logdetldpat_resp_room
aurora_standard.schmultiorsurgery_room
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
pat_status
TableColumn
aurora_standard.chmgltcda_pat_status
aurora_standard.chmgltcdb_pat_status
aurora_standard.chmpricaprev_pat_status
aurora_standard.chmpricacur_pat_status
clin_class
TableColumn
aurora_standard.chmstatcdef_clin_class
level_care
TableColumn
aurora_standard.chmstatcdef_level_care