Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| facilityid | int | 4 | √ | null |
|
|
||||
| facilitycode | varchar | 5 | √ | null |
|
|
||||
| facilityname | varchar | 75 | √ | null |
|
|
||||
| facilityaddress | varchar | 35 | √ | null |
|
|
||||
| facilitycity | varchar | 50 | √ | null |
|
|
||||
| facilitycountry | varchar | 254 | √ | null |
|
|
||||
| facilityphone | varchar | 35 | √ | null |
|
|
||||
| facilityfax | varchar | 35 | √ | null |
|
|
||||
| facilitypc | varchar | 15 | √ | null |
|
|
||||
| facilitystate | varchar | 3 | √ | null |
|
|
||||
| arstartdate | datetime | 16,3 | √ | null |
|
|
||||
| currentopenmonth | int | 4 | √ | null |
|
|
||||
| currentopenyear | int | 4 | √ | null |
|
|
||||
| lineofbusiness | varchar | 10 | √ | null |
|
|
||||
| medicaididentifierid | int | 4 | √ | null |
|
|
||||
| medicaididentifiername | varchar | 30 | √ | null |
|
|
||||
| medicareidentifierid | int | 4 | √ | null |
|
|
||||
| medicareidentifiername | varchar | 30 | √ | null |
|
|
||||
| ssnidentifierid | int | 4 | √ | null |
|
|
||||
| ssnidentifiername | varchar | 30 | √ | null |
|
|
||||
| mrnidentifier | varchar | 32 | √ | null |
|
|
||||
| createddate | datetime | 16,3 | √ | null |
|
|
||||
| revisiondate | datetime | 16,3 | √ | null |
|
|
||||
| deleted | varchar | 1 | √ | null |
|
|
||||
| timezone | int | 4 | √ | null |
|
|
||||
| providertype | varchar | 20 | √ | null |
|
|
||||
| npi | varchar | 10 | √ | null |
|
|
||||
| ccn | varchar | 1000 | √ | null |
|
|
||||
| stateprovider | varchar | 1000 | √ | null |
|
|
||||
| stateid | varchar | 1000 | √ | null |
|
|
||||
| medicarerug | varchar | 5 | √ | null |
|
|
||||
| statemedicaidindex | varchar | 5 | √ | null |
|
|
||||
| altstatemedicaidindex | varchar | 5 | √ | null |
|
|
||||
| statemedicaidgrouper | varchar | 100 | √ | null |
|
|
||||
| altstatemedicaidgrouper | varchar | 100 | √ | null |
|
|
||||
| collectionsagencyclientnumber | varchar | 20 | √ | null |
|
|
Relationships
Close relationships within degrees of separation
