aurora_standard.chmarst
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| rec_type | char(2) | YES | MUL | |||
| filler | char(5) | YES | ||||
| federal_id | char(10) | YES | ||||
| federal_sub_id | char(4) | YES | ||||
| facility_npi | char(13) | YES | ||||
| medicaid_npi | char(13) | YES | ||||
| filler1 | char(39) | YES | ||||
| fac_phone | char(10) | YES | ||||
| fac_name | char(25) | YES | ||||
| fac_id | char(4) | YES | ||||
| fac_add | char(25) | YES | ||||
| fac_city | char(14) | YES | ||||
| fac_state | char(2) | YES | ||||
| fac_zip | char(9) | YES | ||||
| filler2 | char(45) | YES |
References
| Local Column | References | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| filler |
| ||||||||||||||||||
| fac_name |
|