Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| PatientId | int | 4 | null |
|
|
|||
| Patient_Id_Number | varchar | 35 | √ | null |
|
|
||
| Facility_Name | varchar | 375 | √ | null |
|
|
||
| Facility_Type | varchar | 254 | √ | null |
|
|
||
| region | varchar | 254 | √ | null |
|
|
||
| regionalmanager | varchar | 254 | √ | null |
|
|
||
| action_type | varchar | 20 | √ | null |
|
|
||
| Stay_Status | varchar | 50 | √ | null |
|
|
||
| AdmissionDate | datetime | 16,3 | null |
|
|
|||
| DischargeDate | datetime | 16,3 | √ | null |
|
|
||
| facility_length_of_stay_days | int | 4 | √ | null |
|
|
||
| facility_stay_census_bucket | varchar | 15 | null |
|
|
|||
| AdmitLocationID | int | 4 | √ | null |
|
|
||
| AdmitLocation | varchar | 254 | √ | null |
|
|
||
| AdmitLocationType | varchar | 254 | √ | null |
|
|
||
| dischargeLocationID | int | 4 | √ | null |
|
|
||
| dischargeLocation | varchar | 254 | √ | null |
|
|
||
| dischargeLocationType | varchar | 254 | √ | null |
|
|
||
| age_at_admission | int | 4 | √ | null |
|
|
||
| hospital_stay_from | datetime | 16,3 | √ | null |
|
|
||
| hospital_stay_to | datetime | 16,3 | √ | null |
|
|
||
| hospital_stay_days | int | 4 | √ | null |
|
|
||
| stay_hospital_bucket | varchar | 15 | null |
|
|
|||
| initial_payercode | nvarchar | 2147483647 | √ | null |
|
|
||
| initial_payername | nvarchar | 2147483647 | √ | null |
|
|
||
| initial_payertype | nvarchar | 2147483647 | √ | null |
|
|
||
| skilled_flag | varchar | 1 | √ | null |
|
|
||
| DiagnosisCode | nvarchar | 2147483647 | √ | null |
|
|
||
| DiagnosisDesc | nvarchar | 2147483647 | √ | null |
|
|
||
| insurance | nvarchar | 2147483647 | √ | null |
|
|
Diagram producer might be missing
No diagrams were produced please see application output for any errors