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 |
|
|
||
| DateReferred | date | 20 | √ | null |
|
|
||
| DateCancerReferralReceived | smalldatetime | 16 | √ | null |
|
|
||
| DateSeen | date | 20 | √ | null |
|
|
||
| DateHNACompleted | date | 20 | √ | null |
|
|
||
| DateOfDiagnosis | smalldatetime | 16 | √ | null |
|
|
||
| OrgCodeDiagnosis | nvarchar | 500 | √ | null |
|
|
||
| DaysBetweenDiagHNA | int | 4 | √ | null |
|
|
||
| CarePlanCreated | bit | 1 | √ | null |
|
|
||
| HNACreated | bit | 1 | √ | null |
|
|
||
| CNSInterventionLevel1 | bit | 1 | null |
|
|
|||
| CNSInterventionLevel2 | bit | 1 | null |
|
|
|||
| CNSInterventionLevel3 | bit | 1 | null |
|
|
|||
| CNSInterventionLevel4 | bit | 1 | null |
|
|
|||
| CancerSiteID | int | 4 | √ | null |
|
|
||
| CancerSiteDesc | varchar | 50 | √ | null |
|
|
||
| PointOfPathwayID | int | 4 | √ | null |
|
|
||
| PointOfPathwayDesc | varchar | 50 | √ | null |
|
|
||
| PointOfPathwayOther | varchar | 500 | √ | null |
|
|