tblCNSContact


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CNSContactID int identity 4 √ null
MacmillanCNSReferences.CNSContactId FK_MacmillanCNSReferences_CNSContactIdR
MacmillanRecordUpload.CNSRecordId FK_MacmillanRecordUpload_CNSRecordIdR
tblCNSCarePlan.CNSContactID FK_tblCNSCarePlan_tblCNSContactC
tblCNSClinicalActivity.CNSContactID FK_tblCNSClinicalActivity_tblCNSContactR
tblCNSContactType.CNSContactID FK_tblCNSContactType_tblCNSContactR
tblCNSInfoAdvice.CNSContactID FK_tblCNSInfoAdvice_tblCNSContactR
tblHolisticAssessment.CNSContactID FK_tblHolisticAssessment_tblCNSContactC
WellbeingEvents.CNSContactID FK_WellbeingEvents_tblCNSContactC
CareID int 4 null
tblMAIN_REFERRALS.CARE_ID FK_tblCNSContact_tblMAIN_REFERRALSC
L_SEEN_DATE date 20 √ null
L_CONTACT_PLACE int 4 √ null
ltblCNS_LOCATION.PLACE_ID FK_tblCNSContact_L_CONTACT_PLACEC
L_CNS int 4 √ null
ltblCNS_NAME.ID FK_tblCNSContact_L_CNSC
L_NURSE varchar 50 √ null
L_CONTACT_PAT bit 1 ((0))
L_CONTACT_REL bit 1 ((0))
L_CONTACT_CARER bit 1 ((0))
L_CONTACT_PROF bit 1 ((0))
L_CONTACT_OTHER bit 1 ((0))
L_PROF_WHO varchar 255 √ null
L_REFERRAL_1 int 4 √ null
ltblCNS_PRIME_REF.REF_ID FK_tblCNSContact_L_REFERRAL_1R
L_REFERRAL_2 int 4 √ null
ltblCNS_PRIME_REF.REF_ID FK_tblCNSContact_L_REFERRAL_2R
L_REFERRAL_3 int 4 √ null
ltblCNS_SECOND_REF.REF_ID FK_tblCNSContact_L_REFERRAL_3R
L_REFERRAL_OTHER varchar 500 √ null
L_REFERRAL_OTHER_SECONDARY varchar 500 √ null
L_PRIVACY int 4 √ null
ltblYNNA.YNNA_ID FK_tblCNSContact_L_PRIVACYR
L_PT_STATUS int 4 √ null
ltblCNS_PT_STATUS.STATUS_ID FK_tblCNSContact_L_PT_STATUSR
L_ORGANISATION int 4 √ null
OrganisationSites.ID FK_tblCNSContact_L_ORGANISATION_OrganisationSitesR
L_NOTES text 2147483647 √ null
LEVEL_INTERVENTION_1 bit 1 ((0))
LEVEL_INTERVENTION_2 bit 1 ((0))
LEVEL_INTERVENTION_3 bit 1 ((0))
LEVEL_INTERVENTION_4 bit 1 ((0))
PERFORMANCE_STATUS int 4 √ null
POINT_OF_PATHWAY int 4 √ null
ltblPOINT_OF_PATHWAY.ID FK_tblCNSContact_POINT_OF_PATHWAYR
POINT_OF_PATHWAY_OTHER varchar 500 √ null
HNATypeOffered int 4 √ null
ltblHNATypeOffered.ID FK_tblCNSContact_HNATypeOfferedR
MSCCLeafletGiven int 4 √ null
PatientRegistrationLeafletGiven int 4 √ null
HNACompletedBy int 4 √ null
DateHNACompleted date 20 √ null
DEPRECATED_20_02_WellbeingEvent int 4 √ null
DEPRECATED_20_02_WellbeingEventName varchar 100 √ null
DEPRECATED_20_02_WellbeingDateAttended date 20 √ null
DEPRECATED_20_02_ReasonWellbeingEventNotOffered nvarchar 100 √ null
ACTION_ID int 4 √ null
OtherInformationAdvice varchar 2147483647 √ null
OtherClinicalActivity varchar 2147483647 √ null
CarePlanDate datetime 16,3 √ null
TreatmentSummaryCompleted int 4 √ null
ltblYNBool.YN_ID FK_TreatmentSummaryCompletedR
TreatmentSummarySharedWith tinyint 1 √ null
TreatmentSummarySharedWith.ID FK_TreatmentSummarySharedWithR
WhenTreatmentSummaryCompleted tinyint 1 √ null
WhenTreatmentSummaryCompleted.ID FK_WhenTreatmentSummaryCompletedR
DateTreatmentSummaryCompleted datetime 16,3 √ null
HNAStatus tinyint 1 √ null
ReasonHNADeclined nvarchar 100 √ null
HNACompletedByOther nvarchar 100 √ null
ReasonHNANotOffered nvarchar 100 √ null
ReasonUnableToComplete nvarchar 100 √ null
CarePlanStatus int 4 √ null
CarePlanStatus.ID FK_tblCNSContact_CarePlanStatusR
ReasonCPDeclined nvarchar 100 √ null
ReasonCPNotOffered nvarchar 100 √ null
ReasonCPUnableToComplete nvarchar 100 √ null
CarePlanCompletedBy int 4 √ null
CarePlanCompletedBy.ID FK_tblCNSContact_CarePlanCompletedByR
CarePlanCompletedByOther nvarchar 100 √ null
CarePlanPointOfPathway int 4 √ null
ltblPOINT_OF_PATHWAY.ID FK_tblCNSContact_ltblPOINT_OF_PATHWAYR
CarePlanPointOfPathwayOther nvarchar 100 √ null
ColorectalCNSContactType int 4 √ null
ColorectalCNSContactType.ID FK_HNAStatusR
OtherColorectalCNSContactType varchar 255 √ null
DateHNAOffered date 20 √ null
DateHNADeclined date 20 √ null
PermissionToTalkTo varchar 150 √ null
PlannedContact int 4 √ null
ltblYN.YN_ID FK_tblCNSContact_ltblYNR
OtherContactLocation varchar 150 √ null
CNSNotesActionID int 4 √ null
PAM_Score int 4 √ null
PAM_Level tinyint 1 √ null
PAM_DateRecorded date 20 √ null
ReferralOtherThirdParty varchar 500 √ null
DateCPOffered date 20 √ null
DateCPDeclined date 20 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_tblCNSContact Primary key Asc CNSContactID
IX_SeenDate_Referral1 Performance Asc/Asc L_SEEN_DATE + L_REFERRAL_1
IX_SeenDate_Referral3 Performance Asc/Asc L_SEEN_DATE + L_REFERRAL_3
IX_tblCNSContact_CareID Performance Asc/Asc CareID + L_SEEN_DATE
NonClusteredIndex-20190121-113729 Performance Asc L_SEEN_DATE

Check Constraints

Constraint Name Constraint
CK__tblCNSCon__PAM_S__3AC90222 ([PAM_Score]>=(0) AND [PAM_Score]<=(999))
CK__tblCNSCon__PAM_L__3BBD265B ([PAM_Level]=(4) OR [PAM_Level]=(3) OR [PAM_Level]=(2) OR [PAM_Level]=(1))

Relationships

Close relationships within degrees of separation