expROOT_HELPER_1


Columns

Column Type Size Nulls Auto Default Children Parents Comments
N1_6_FORENAME varchar 100 √ null
N1_5_SURNAME varchar 100 √ null
N1_1_NHS_NUMBER varchar 10 √ null
N1_2_HOSPITAL_NUMBER varchar 100 √ null
N1_10_DATE_BIRTH datetime 16,3 √ null
Gender varchar 20 √ null
CARE_ID int 4 √ null
N_UPGRADE_DATE datetime 16,3 √ null
SeenOrg varchar 100 √ null
N16_2_ADJ_DAYS int 4 √ null
N16_4_ADJ_TREAT_CODE int 4 √ null
ltblSYMPTOMS_HEAD_NECK_HANA_VALUES.Code Implied ConstraintR
N16_5_DECISION_REASON_CODE int 4 √ null
N16_7_DECISION_REASON varchar 2147483647 √ null
N2_10_FIRST_SEEN_DELAY varchar 2 √ null
N2_11_FIRST_SEEN_REASON varchar 2147483647 √ null
N2_14_ADJ_TIME int 4 √ null
AdjustmentReason varchar 50 √ null
N2_6_RECEIPT_DATE datetime 16,3 √ null
CancerSite varchar 20 √ null
TreatOrg varchar 100 √ null
DECISION_DATE datetime 16,3 √ null
START_DATE datetime 16,3 √ null
ADJ_DAYS int 4 √ null
ADJ_CODE int 4 √ null
ltblSYMPTOMS_HEAD_NECK_HANA_VALUES.Code Implied ConstraintR
PathwayStartDate datetime 16,3 √ null
TimeRefToTreat int 4 √ null
TimeDecToTreat int 4 √ null
DelayReasonDesc varchar 200 √ null
TargetDate datetime 16,3 √ null
TREATMENT_SETTING varchar 2 √ null
Username varchar 50 √ null
N2_5_DECISION_DATE datetime 16,3 √ null
Title varchar 20 √ null
PatientStatus varchar 100 √ null
SubtypeDescription nvarchar 100 √ null
SharedBreach decimal 4,1 √ null
PredictedBreachStatus varchar 25 √ null
PredictedBreachMonth varchar 3 √ null
PredictedBreachYear int 4 √ null

Indexes

Constraint Name Type Sort Column(s)
IX_GetRootCauseHelperValues_Foo1 Performance Asc Username
IX_GetRootCauseHelperValues_Subqueries Performance Asc/Asc CARE_ID + Username
IX_Root_HELPER_1_Wide Performance Asc/Asc Username + CARE_ID

Relationships

Close relationships within degrees of separation