Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| CareID | int | 4 | null |
|
|
|||||
| DateCancerReferralReceived | smalldatetime | 16 | √ | null |
|
|
||||
| PatientSurname | varchar | 60 | √ | null |
|
|
||||
| PatientForename | varchar | 50 | √ | null |
|
|
||||
| NHSNumber | varchar | 10 | √ | null |
|
|
||||
| DateOfBirth | date | 20 | √ | null |
|
|
||||
| HospitalNumber | varchar | 20 | √ | null |
|
|
||||
| TriageContactWith | varchar | 8000 | √ | null |
|
|
||||
| CancerSiteID | int | 4 | √ | null |
|
|
||||
| CancerSiteDesc | varchar | 50 | √ | null |
|
|
||||
| TriagedByID | int | 4 | √ | null |
|
|
||||
| TriagedByDesc | varchar | 50 | √ | null |
|
|
||||
| TriagedByOther | varchar | 30 | √ | null |
|
|
||||
| TriageDate | date | 20 | √ | null |
|
|
||||
| OutcomeID | int | 4 | √ | null |
|
|
||||
| OutcomeDesc | varchar | 50 | √ | null |
|
|
||||
| OutcomeOther | varchar | 50 | √ | null |
|
|
||||
| TriageContactType | nvarchar | 1073741823 | null |
|
|
|||||
| HasBeenTriaged | int | 4 | null |
|
|
|||||
| TotalTimeSpent | int | 4 | √ | null |
|
|
||||
| DiagnosisCode | varchar | 50 | √ | null |
|
|
||||
| DiagnosisDescription | varchar | 150 | √ | null |
|
|