aurora_standard.chmmbc55
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| visit_no | int(11) | YES | ||||
| injury_code | varchar(1) | YES | ||||
| patient_had_similr | varchar(1) | YES | ||||
| emergency_ind | varchar(1) | YES | ||||
| date_patient_retrn | date | YES | ||||
| disability_from | date | YES | ||||
| disability_thru | date | YES | ||||
| partial_from | date | YES | ||||
| partial_thru | date | YES | ||||
| epsdt_ind | varchar(1) | YES | ||||
| family_planning | varchar(1) | YES | ||||
| co_ins_amt | decimal(7,2) | YES | ||||
| deductible_amt | decimal(7,2) | YES | ||||
| paid_amt | decimal(7,2) | YES | ||||
| adjustment_code | varchar(1) | YES | ||||
| number_18 | smallint(6) | YES | ||||
| provider_id | varchar(8) | YES | ||||
| provider_type | varchar(2) | YES | ||||
| location_code | varchar(2) | YES | ||||
| medicare_status | varchar(2) | YES | ||||
| accident_state | varchar(2) | YES | ||||
| accident_hour | varchar(2) | YES | ||||
| chs_rowID | bigint(20) unsigned | NO | PRI | auto_increment |