Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ReferralID | int | 4 | null |
|
|
|||||||||
| OncologistHaematologist | int | 4 | √ | null |
|
|
||||||||
| RecordOfAssessment | varchar | 2147483647 | √ | null |
|
|
||||||||
| SteroidsStartedYN | int | 4 | √ | null |
|
|
||||||||
| SteroidsStartedDate | datetime | 16,3 | √ | null |
|
|
||||||||
| SteroidsType | varchar | 250 | √ | null |
|
|
||||||||
| NursedFlat | int | 4 | √ | null |
|
|
||||||||
| TreatmentTeamsDiscussions | varchar | 2147483647 | √ | null |
|
|
||||||||
| ImagingCT | bit | 1 | null |
|
|
|||||||||
| ImagingMRI | bit | 1 | null |
|
|
|||||||||
| ImagingPET | bit | 1 | null |
|
|
|||||||||
| ImagingOther | bit | 1 | null |
|
|
|||||||||
| ImagingOtherText | varchar | 250 | √ | null |
|
|
||||||||
| ImagingRequestedDate | date | 20 | √ | null |
|
|
||||||||
| ImagingPerformedDate | date | 20 | √ | null |
|
|
||||||||
| ImagingReportedDate | date | 20 | √ | null |
|
|
||||||||
| ImagingReportingOrganisation | int | 4 | √ | null |
|
|
||||||||
| ImagingMSCCConfirmedYN | int | 4 | √ | null |
|
|
||||||||
| ImagingMSCCConfirmedDate | datetime | 16,3 | √ | null |
|
|
||||||||
| ImagingSpinalSurgeonsInformedDate | datetime | 16,3 | √ | null |
|
|
||||||||
| ImagingRadiotherapyInformedDate | datetime | 16,3 | √ | null |
|
|
||||||||
| ImagingDiagnosisDelayReasons | varchar | 2147483647 | √ | null |
|
|
||||||||
| PTSurgery | bit | 1 | null |
|
|
|||||||||
| PTRadiotherapy | bit | 1 | null |
|
|
|||||||||
| PTChemotherapy | bit | 1 | null |
|
|
|||||||||
| PTBestSupportiveCare | bit | 1 | null |
|
|
|||||||||
| PTOther | bit | 1 | null |
|
|
|||||||||
| PTOtherPrimary | varchar | 250 | √ | null |
|
|
||||||||
| PTStartDate | date | 20 | √ | null |
|
|
||||||||
| PTOrganisation | int | 4 | √ | null |
|
|
||||||||
| PTDelayReasons | varchar | 2147483647 | √ | null |
|
|
||||||||
| AuditID | int | 4 | √ | null |
|
|
||||||||
| AssessmentDate | date | 20 | √ | null |
|
|
||||||||
| AssessmentTime | time | 32 | √ | null |
|
|
||||||||
| ReferredDate | date | 20 | √ | null |
|
|
||||||||
| ReferredTime | time | 32 | √ | null |
|
|
||||||||
| ImagingRequestedTime | time | 32 | √ | null |
|
|
||||||||
| ImagingPerformedTime | time | 32 | √ | null |
|
|
||||||||
| ImagingReportedTime | time | 32 | √ | null |
|
|
||||||||
| PTStartTime | time | 32 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_tblAO_MSCC | Primary key | Asc | ReferralID |