aurora_standard.c7vis
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| pat_ssn | varchar(11) | YES | MUL | |||
| vis_no | int(11) | YES | MUL | |||
| mr_no | varchar(20) | YES | MUL | |||
| pat_type | varchar(6) | YES | MUL | |||
| pat_class | varchar(5) | YES | ||||
| adm_dt | char(10) | YES | MUL | |||
| 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 | int(6) | YES | ||||
| att_phy | int(6) | YES | ||||
| bill_dt | char(10) | YES | ||||
| pri_fc | varchar(6) | YES | ||||
| cur_fc | varchar(6) | YES | MUL | |||
| accom_cd | varchar(10) | YES | ||||
| maj_compl | varchar(30) | 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(10) | YES | ||||
| adm_typ | varchar(10) | YES | ||||
| guar_no | int(11) | YES | MUL | |||
| 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 | ||||
| bdbal | decimal(16,2) | YES | ||||
| bd_dt | char(10) | YES | ||||
| bd_agency | varchar(20) | YES | ||||
| opp_ini | varchar(20) | YES | ||||
| fam_phy | varchar(20) | YES | ||||
| rev_cycle | varchar(20) | YES | ||||
| stmt_dt | char(10) | YES | ||||
| visit_no | bigint(11) | YES |