aurora_standard.kcvisit
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| pat_ssn | varchar(11) | YES | ||||
| vis_no | varchar(20) | YES | ||||
| visit_no | varchar(20) | YES | ||||
| mrno | varchar(20) | YES | ||||
| pat_type | varchar(6) | YES | ||||
| adm_dt | char(10) | YES | ||||
| adm_tm | time | YES | ||||
| dis_dt | char(10) | YES | ||||
| dis_tm | time | YES | ||||
| dis_reason | varchar(6) | NO | ||||
| hand_cd | varchar(6) | YES | ||||
| adm_phy | varchar(20) | YES | ||||
| att_phy | varchar(20) | YES | ||||
| bill_dt | char(10) | YES | ||||
| pri_fc | varchar(6) | YES | ||||
| cur_fc | varchar(6) | YES | ||||
| accom_cd | varchar(10) | YES | ||||
| chief_compl | varchar(10) | YES | ||||
| adm_dx_cd | varchar(10) | YES | ||||
| cur_nurs | varchar(10) | YES | ||||
| cur_rm | varchar(10) | YES | ||||
| cur_bed | varchar(10) | YES | ||||
| pub_info | varchar(10) | YES | ||||
| adm_src | varchar(2) | YES | ||||
| adm_typ | varchar(2) | YES | ||||
| guanum | varchar(20) | YES | ||||
| acc_typ | varchar(2) | YES | ||||
| acc_dt | char(10) | YES | ||||
| acc_tm | time | YES | ||||
| acc_st | varchar(2) | YES | ||||
| arch_flag | varchar(2) | YES | ||||
| curbal | decimal(16,2) | YES | ||||
| totchrgs | decimal(16,2) | YES | ||||
| bdbal | decimal(16,2) | YES | ||||
| coll_dt | char(10) | YES | ||||
| coll_agency | varchar(20) | YES | ||||
| opp_ini | varchar(20) | YES | ||||
| fam_phy_nm | varchar(20) | YES | ||||
| rev_cycle | varchar(20) | YES | ||||
| stmt_dt | char(10) | YES | ||||
| guar_no | int(11) | YES |