ROX_Care_Clinical_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
CareType 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
IsDischarged varchar 1 null
Disch_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
TrackDuration 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
DateOfBirth date 6 √ null
Age_At_Eval int 4 √ null
age_group_sort smallint 2 √ null
age_range nvarchar 50 √ null
Gender varchar 10 null
Physician varchar 8000 √ null
Admittedfrom varchar 100 √ null
DiscargeTo varchar 100 √ null
discharge_destination_default varchar 1 √ null
TheraphyEndReason varchar 100 √ null
PriorLivingLocation varchar 300 √ null
ResponsibleTherapist varchar 41 √ null
PrimaryTherapist varchar 41 √ null
Discipline char 2 null
Disch_AlphaValue varchar 50 √ null
Eval_AlphaValue varchar 50 √ null
Disch_Measurement_Value decimal 14,4 √ null
Eval_Measurement_Value decimal 14,4 √ null
OutCome decimal 18,2 √ null
Disch_Score varchar 2147483647 √ null
Disch_Normalized_Score decimal 18,2 null
Eval_Score varchar 2147483647 √ null
Eval_Normalized_Score decimal 18,2 null
Length_Of_Stay_Sort int 4 √ null
Length_of_Stay_Group varchar 10 √ null
VisitCount int 4 √ 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