CNSDetail


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CNSContactID int 4 null
CareID int 4 √ null
PatientSurname varchar 60 √ null
PatientForename varchar 50 √ null
NHSNumber varchar 10 √ null
DateOfBirth date 20 √ null
HospitalNumber varchar 20 √ null
CNSID int 4 √ null
CNSName varchar 50 √ null
CNSNameOther varchar 50 √ null
CNSRoleID tinyint 1 √ null
CNSRole nvarchar 30 √ null
DateReferred date 20 √ null
DateCancerReferralReceived smalldatetime 16 √ null
DateSeen date 20 √ null
HNAStatus varchar 75 √ null
Reasondeclined nvarchar 100 √ null
Completedbyother nvarchar 100 √ null
OtherPointinPathway varchar 500 √ null
HNATypeOff varchar 50 √ null
HNACompletedBy varchar 50 √ null
DateHNACompleted date 20 √ null
DateFirstAppt smalldatetime 16 √ null
DateOfDiagnosis smalldatetime 16 √ null
OrgCodeDiagnosis nvarchar 500 √ null
OrgFirstContact nvarchar 500 √ null
DaysBetweenDiagHNA int 4 √ null
CarePlanCreated bit 1 √ null
HNACreated bit 1 √ null
ContactType nvarchar 1073741823 null
ContactWith varchar 8000 √ null
Referrals varchar 8000 √ null
CNSInterventionLevel1 bit 1 null
CNSInterventionLevel2 bit 1 null
CNSInterventionLevel3 bit 1 null
CNSInterventionLevel4 bit 1 null
CNSInterventionLevel varchar 8000 √ null
CancerSiteID int 4 √ null
CancerSiteDesc varchar 50 √ null
PointOfPathwayID int 4 √ null
PointOfPathwayDesc varchar 50 √ null
PointOfPathwayOther varchar 500 √ null
DiagnosisCode varchar 50 √ null
DiagnosisDescription varchar 150 √ null
CarePlanDate datetime 16,3 √ null
ContactOrganisation nvarchar 500 √ null
ReasonHNANotOffered nvarchar 100 √ null
HasHNABeenCreatedOnSCR int 4 null
ReasonHNAUnableToComplete nvarchar 100 √ null
CarePlanStatus varchar 100 √ null
ReasonCPDeclined nvarchar 100 √ null
ReasonCPNotOffered nvarchar 100 √ null
ReasonCPUnableToComplete nvarchar 100 √ null
CarePlanCompletedBy varchar 50 √ null
CarePlanCompletedByOther nvarchar 100 √ null
CarePlanPointOfPathway varchar 50 √ null
CarePlanPointOfPathwayOther nvarchar 100 √ null

View Definition

Possibly Referenced Tables/Views