aurora_standard.cavis
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| pat_ssn | varchar(11) | YES | MUL | |||
| evo_no | varchar(20) | YES | ||||
| vis_no | int(11) | YES | MUL | |||
| stupid_no | varchar(20) | NO | ||||
| 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 | smallint(6) | YES | ||||
| att_phy | smallint(6) | YES | ||||
| bill_dt | char(10) | YES | ||||
| pri_fc | varchar(6) | YES | ||||
| cur_fc | varchar(6) | YES | MUL | |||
| cur_fc_desc | varchar(30) | YES | ||||
| accom_cd | varchar(10) | YES | ||||
| dx_desc | varchar(30) | YES | ||||
| prim_dx | varchar(10) | YES | ||||
| maj_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(30) | YES | ||||
| adm_typ | varchar(30) | 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 | ||||
| totchrgs | 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 | ||||
| hos_service | varchar(20) | YES | ||||
| end_fill | varchar(1) | YES | ||||
| comments | varchar(100) | YES |