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 |
|
|
||
region_area | varchar | 50 | null |
|
|
|||
library_name | varchar | 50 | null |
|
|
|||
metric_name | varchar | 50 | null |
|
|
|||
track_id | int | 4 | null |
|
|
|||
case_id | int | 4 | null |
|
|
|||
stay_id | int | 4 | null |
|
|
|||
facility_state | varchar | 2 | √ | 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 |
|
|
|||
doc_completed_date | datetime | 16,3 | √ | null |
|
|
||
case_start_date | datetime | 16,3 | null |
|
|
|||
track_start_date | datetime | 16,3 | null |
|
|
|||
track_total_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 |
|
|
||
age_at_doc | int | 4 | √ | null |
|
|
||
gender | varchar | 10 | null |
|
|
|||
age_range | nvarchar | 50 | √ | null |
|
|
||
age_group_sort | smallint | 2 | √ | null |
|
|
||
grip_norm_key | nvarchar | 50 | √ | null |
|
|
||
grip_age_group | nvarchar | 100 | √ | null |
|
|
||
grip_norm | numeric | 7,2 | √ | null |
|
|
||
fifty_percent_grip_norm | numeric | 7,2 | √ | null |
|
|
||
grip_age_group_sort | smallint | 2 | √ | null |
|
|
||
six_mwt_norm_key | nvarchar | 50 | √ | null |
|
|
||
six_mwt_age_group | nvarchar | 50 | √ | null |
|
|
||
six_mwt_norm | int | 4 | √ | null |
|
|
||
six_mwt_sort | smallint | 2 | √ | null |
|
|
||
physician | varchar | 8000 | √ | null |
|
|
||
admitted_from | varchar | 100 | √ | null |
|
|
||
prior_living_location | varchar | 300 | √ | null |
|
|
||
responsible_therapist | varchar | 41 | √ | null |
|
|
||
primary_therapist | varchar | 41 | √ | null |
|
|
||
discipline | char | 2 | null |
|
|
|||
current_measurement_value | decimal | 14,4 | √ | null |
|
|
||
previous_measurement_value | decimal | 14,4 | √ | null |
|
|
||
change_value | decimal | 13,4 | √ | null |
|
|
||
change_value_wrt_eval | decimal | 13,4 | √ | null |
|
|
||
current_score | decimal | 12,4 | null |
|
|
|||
previous_score | decimal | 12,4 | null |
|
|
|||
current_from_date | datetime | 16,3 | √ | null |
|
|
||
current_thru_date | datetime | 16,3 | √ | null |
|
|
||
eval_date | datetime | 16,3 | √ | null |
|
|
||
visit_count | int | 4 | √ | null |
|
|
||
exclude_outcome_indicator | varchar | 1 | null |
|
|
|||
therapist_count | int | 4 | √ | null |
|
|
||
outcome_count | int | 4 | null |
|
|
|||
education_level | varchar | 30 | √ | null |
|
|