ROX_Core_Clinical_Progress_Outcome

0 rows


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 20,4 null
Previous_Score decimal 20,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