Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| Federal Provider Number | varchar | 2147483647 | √ | null |
|
|
||
| Provider Name | varchar | 2147483647 | √ | null |
|
|
||
| Provider Address | varchar | 2147483647 | √ | null |
|
|
||
| Provider City | varchar | 2147483647 | √ | null |
|
|
||
| Provider State | varchar | 2147483647 | √ | null |
|
|
||
| Provider Zip Code | varchar | 2147483647 | √ | null |
|
|
||
| Survey Date | varchar | 2147483647 | √ | null |
|
|
||
| Survey Type | varchar | 2147483647 | √ | null |
|
|
||
| Deficiency Prefix | varchar | 2147483647 | √ | null |
|
|
||
| Deficiency Category | varchar | 2147483647 | √ | null |
|
|
||
| Deficiency Tag Number | varchar | 2147483647 | √ | null |
|
|
||
| Deficiency Description | varchar | 2147483647 | √ | null |
|
|
||
| Scope Severity Code | varchar | 2147483647 | √ | null |
|
|
||
| Deficiency Corrected | varchar | 2147483647 | √ | null |
|
|
||
| Correction Date | varchar | 2147483647 | √ | null |
|
|
||
| Inspection Cycle | varchar | 2147483647 | √ | null |
|
|
||
| Standard Deficiency | varchar | 2147483647 | √ | null |
|
|
||
| Complaint Deficiency | varchar | 2147483647 | √ | null |
|
|
||
| Infection Control Inspection Deficiency | varchar | 2147483647 | √ | null |
|
|
||
| Location | varchar | 2147483647 | √ | null |
|
|
||
| Processing Date | varchar | 2147483647 | √ | null |
|
|
Diagram producer might be missing
No diagrams were produced please see application output for any errors