aurora_standard.chmhid4g
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| rec_type | varchar(1) | YES | ||||
| facility_npi | varchar(15) | YES | ||||
| visit_no | varchar(24) | YES | MUL | |||
| rec_seq_no | varchar(2) | YES | ||||
| medicaid_no | varchar(12) | YES | ||||
| valu_cd54 | varchar(2) | YES | ||||
| birth_wt | varchar(4) | YES | ||||
| apgar | varchar(2) | YES | ||||
| cond_cd17 | varchar(2) | YES | ||||
| cond_cd25 | varchar(2) | YES | ||||
| marital | varchar(1) | YES | ||||
| observ_start_dt | varchar(8) | YES | ||||
| prim_lang | varchar(3) | YES | ||||
| filler_322 | varchar(322) | YES | ||||
| chs_rowID | int(11) | NO | PRI | auto_increment |