Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
SSN | varchar | 12 | √ | null |
|
|
||
OptimaResidentID | int | 4 | null |
|
|
|||
FirstName | varchar | 15 | √ | null |
|
|
||
MiddleInitial | char | 1 | √ | null |
|
|
||
LastName | varchar | 25 | √ | null |
|
|
||
SiteID | 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 |
|
|
|||
TxTrack_ID | int | 4 | null |
|
|
|||
PatientCase_ID | int | 4 | null |
|
|
|||
Stay_ID | int | 4 | null |
|
|
|||
FacilityState | varchar | 2 | √ | null |
|
|
||
ZipCode | varchar | 10 | √ | null |
|
|
||
documentType | varchar | 10 | null |
|
|
|||
document_order | bigint | 8 | √ | null |
|
|
||
IsActive | int | 4 | null |
|
|
|||
IsDischarged | varchar | 1 | null |
|
|
|||
DischargeDate | datetime | 16,3 | √ | null |
|
|
||
Doc_Completed_Date | datetime | 16,3 | √ | null |
|
|
||
FacilityLengthOfStay | int | 4 | √ | null |
|
|
||
CaseStartDate | datetime | 16,3 | null |
|
|
|||
CaseEndDate | datetime | 16,3 | √ | null |
|
|
||
TrackStartDate | datetime | 16,3 | null |
|
|
|||
TrackEndDate | datetime | 16,3 | √ | null |
|
|
||
CaseLengthOfStay | int | 4 | √ | null |
|
|
||
TrackTotalDuration | int | 4 | √ | null |
|
|
||
CaseDuration | int | 4 | √ | null |
|
|
||
ot_minutes | int | 4 | √ | null |
|
|
||
pt_minutes | int | 4 | √ | null |
|
|
||
st_minutes | int | 4 | √ | null |
|
|
||
PayerName | nvarchar | 2147483647 | √ | null |
|
|
||
PayerType | nvarchar | 2147483647 | √ | null |
|
|
||
PayerTypeCode | nvarchar | 2147483647 | √ | null |
|
|
||
Skilled_Payer_Type | nvarchar | 2147483647 | √ | null |
|
|
||
RUGCategory | nvarchar | 2147483647 | √ | null |
|
|
||
DOB | date | 6 | √ | null |
|
|
||
Age_At_Doc | int | 4 | √ | null |
|
|
||
Gender | varchar | 10 | null |
|
|
|||
Age_Group | 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 |
|
|
||
Admittedfrom | varchar | 100 | √ | null |
|
|
||
DiscargeTo | varchar | 100 | √ | null |
|
|
||
discharge_destination_default | varchar | 1 | √ | null |
|
|
||
PriorLivingLocation | varchar | 300 | √ | null |
|
|
||
TheraphyEndReason | varchar | 100 | √ | null |
|
|
||
ResponsibleTherapist | varchar | 41 | √ | null |
|
|
||
PrimaryTherapist | varchar | 41 | √ | null |
|
|
||
Discipline | char | 2 | null |
|
|
|||
Current_Measurement_Value | decimal | 14,4 | √ | null |
|
|
||
Previous_Measurement_Value | decimal | 14,4 | √ | null |
|
|
||
OutCome | decimal | 13,4 | √ | null |
|
|
||
OutCome_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 |
|
|
||
Length_Of_Stay_Sort | int | 4 | √ | null |
|
|
||
Length_of_Stay_Group | varchar | 10 | √ | null |
|
|
||
Eval_Date | datetime | 16,3 | √ | null |
|
|
||
VisitCount | int | 4 | √ | null |
|
|
||
Exclude_Outcome_Indicator | varchar | 1 | null |
|
|
|||
TherapistCount | int | 4 | √ | null |
|
|
||
outcome_count | int | 4 | null |
|
|
|||
Education_level | varchar | 30 | √ | null |
|
|
Diagram producer might be missing
No diagrams were produced please see application output for any errors