aurora_standard.c7abs
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| vis_no | int(11) | YES | MUL | |||
| mr_no | varchar(20) | YES | MUL | |||
| abs_status | varchar(6) | YES | ||||
| compl_dt | varchar(10) | YES | ||||
| last_nm | varchar(20) | YES | ||||
| first_nm | varchar(20) | YES | ||||
| mid_nm | varchar(20) | YES | ||||
| age | varchar(10) | YES | ||||
| marital | varchar(10) | YES | ||||
| zip_1 | varchar(10) | YES | ||||
| county_cd | varchar(20) | YES | ||||
| mdc | varchar(3) | YES | ||||
| drg | varchar(3) | YES | ||||
| drg_reimb | decimal(16,2) | YES |