Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ssn | varchar | 12 | √ | null |
|
|
||
| resident_id | int | 4 | null |
|
|
|||
| first_name | varchar | 15 | √ | null |
|
|
||
| middle_initial | char | 1 | √ | null |
|
|
||
| last_name | varchar | 25 | √ | null |
|
|
||
| facility_id | varchar | 3 | √ | null |
|
|
||
| facility | varchar | 50 | null |
|
|
|||
| facility_city | varchar | 25 | √ | null |
|
|
||
| facility_state | varchar | 2 | √ | null |
|
|
||
| region_area | varchar | 50 | null |
|
|
|||
| library_name | varchar | 50 | null |
|
|
|||
| metric_name | varchar | 50 | null |
|
|
|||
| care_type | varchar | 50 | null |
|
|
|||
| track_id | int | 4 | null |
|
|
|||
| case_id | int | 4 | null |
|
|
|||
| stay_id | int | 4 | null |
|
|
|||
| zip_code | varchar | 10 | √ | null |
|
|
||
| document_type | varchar | 10 | null |
|
|
|||
| document_order | bigint | 8 | √ | null |
|
|
||
| isactive | int | 4 | null |
|
|
|||
| is_discharged | varchar | 1 | null |
|
|
|||
| discharge_date | datetime | 16,3 | √ | null |
|
|
||
| doc_completed_date | datetime | 16,3 | √ | null |
|
|
||
| facility_length_of_stay | int | 4 | √ | null |
|
|
||
| case_start_date | datetime | 16,3 | null |
|
|
|||
| case_end_date | datetime | 16,3 | √ | null |
|
|
||
| track_start_date | datetime | 16,3 | null |
|
|
|||
| track_end_date | datetime | 16,3 | √ | null |
|
|
||
| case_length_of_stay | int | 4 | √ | null |
|
|
||
| track_duration | int | 4 | √ | null |
|
|
||
| case_duration | int | 4 | √ | null |
|
|
||
| ot_minutes | int | 4 | √ | null |
|
|
||
| pt_minutes | int | 4 | √ | null |
|
|
||
| st_minutes | int | 4 | √ | null |
|
|
||
| payer_name | nvarchar | 2147483647 | √ | null |
|
|
||
| payer_type | nvarchar | 2147483647 | √ | null |
|
|
||
| payer_type_code | nvarchar | 2147483647 | √ | null |
|
|
||
| skilled_payer | nvarchar | 2147483647 | √ | null |
|
|
||
| rug_category | nvarchar | 2147483647 | √ | null |
|
|
||
| dob | date | 6 | √ | null |
|
|
||
| gender | varchar | 10 | null |
|
|
|||
| age_at_encounter | int | 4 | √ | null |
|
|
||
| physician | varchar | 8000 | √ | null |
|
|
||
| admitted_from | varchar | 100 | √ | null |
|
|
||
| discharge_to | varchar | 100 | √ | null |
|
|
||
| discharge_destination_default | varchar | 1 | √ | null |
|
|
||
| therapy_end_reason | varchar | 100 | √ | null |
|
|
||
| prior_living_location | varchar | 300 | √ | null |
|
|
||
| responsible_therapist | varchar | 41 | √ | null |
|
|
||
| primary_therapist | varchar | 41 | √ | null |
|
|
||
| discipline | char | 2 | null |
|
|
|||
| current_alphavalue | varchar | 50 | √ | null |
|
|
||
| previous_alphavalue | varchar | 50 | √ | null |
|
|
||
| current_measurement_value | decimal | 14,4 | √ | null |
|
|
||
| previous_measurement_value | decimal | 14,4 | √ | null |
|
|
||
| change_value | decimal | 15,4 | √ | null |
|
|
||
| change_value_wrt_eval | decimal | 15,4 | √ | null |
|
|
||
| current_score | varchar | 2147483647 | √ | null |
|
|
||
| previous_score | varchar | 2147483647 | √ | null |
|
|
||
| current_from_date | datetime | 16,3 | √ | null |
|
|
||
| current_thru_date | datetime | 16,3 | √ | null |
|
|
||
| length_of_stay_sort | int | 4 | √ | null |
|
|
||
| length_of_stay_group | varchar | 10 | √ | null |
|
|
||
| eval_date | datetime | 16,3 | √ | null |
|
|
||
| visit_count | int | 4 | √ | null |
|
|
||
| therapist_count | int | 4 | √ | null |
|
|
||
| outcome_count | int | 4 | null |
|
|
|||
| education_level | varchar | 30 | √ | null |
|
|