Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ReferralID | int | 4 | null |
|
|
|||
| PatientName | varchar | 100 | √ | null |
|
|
||
| Gender | varchar | 100 | √ | null |
|
|
||
| NHSNumber | varchar | 10 | √ | null |
|
|
||
| HospitalNumber | varchar | 50 | √ | null |
|
|
||
| OrgFirstSeen | varchar | 50 | √ | null |
|
|
||
| ReferredTo | varchar | 50 | √ | null |
|
|
||
| DateReferral | date | 20 | √ | null |
|
|
||
| TimeReferral | time | 32 | √ | null |
|
|
||
| ReferralRoute | varchar | 50 | √ | null |
|
|
||
| ReferrerName | varchar | 2147483647 | √ | null |
|
|
||
| ReferralReason | varchar | 50 | √ | null |
|
|
||
| ReferralMethod | varchar | 50 | √ | null |
|
|
||
| EmergencyAdmission | varchar | 10 | √ | null |
|
|
||
| PatientType | varchar | 50 | √ | null |
|
|
||
| ComplicationsCancer | varchar | 2147483647 | √ | null |
|
|
||
| ComplicationsCancerOther | varchar | 2147483647 | √ | null |
|
|
||
| ComplicationsTreatment | varchar | 2147483647 | √ | null |
|
|
||
| ComplicationsTreatmentOther | varchar | 2147483647 | √ | null |
|
|
||
| PrimaryTumourSite | varchar | 50 | √ | null |
|
|
||
| TumourSubSite | varchar | 50 | √ | null |
|
|
||
| ReasonReferralAOS | varchar | 2147483647 | √ | null |
|
|
||
| CancerComplicationsAdditionalComplications | varchar | 2147483647 | √ | null |
|
|
||
| TreatmentComplicationsAdditionalComplications | varchar | 2147483647 | √ | null |
|
|
||
| CurrentTreatment | varchar | 2147483647 | √ | null |
|
|
||
| CurrentTreatmentIntent | varchar | 50 | √ | null |
|
|
||
| TreatmentRegimen | varchar | 50 | √ | null |
|
|
||
| ConsultantHaematologist | varchar | 50 | √ | null |
|
|
||
| PrimaryTreatmentCentre | varchar | 50 | √ | null |
|
|
||
| DateAssessment | date | 20 | √ | null |
|
|
||
| TimeAssessment | time | 32 | √ | null |
|
|
||
| AssessmentType | varchar | 2147483647 | √ | null |
|
|
||
| AssessmentLocation | varchar | 50 | √ | null |
|
|
||
| AssessedByCNS | varchar | 2147483647 | √ | null |
|
|
||
| AssessedByConsultant | varchar | 2147483647 | √ | null |
|
|
||
| ContactWith | varchar | 50 | √ | null |
|
|
||
| FrailtySuspected | varchar | 5 | √ | null |
|
|
||
| CGARequired | varchar | 10 | √ | null |
|
|
||
| PerformanceStatus | int | 4 | √ | null |
|
|
||
| UkonsScore | int | 4 | √ | null |
|
|
||
| SignificantMedicalHistory | varchar | 2147483647 | √ | null |
|
|
||
| DiscussedWith | varchar | 2147483647 | √ | null |
|
|
||
| AdditionalNotes | varchar | 2147483647 | √ | null |
|
|
||
| AdviceGiven | varchar | 2147483647 | √ | null |
|
|
||
| NameOfHCP | varchar | 2147483647 | √ | null |
|
|
||
| AdditionalAdviceGiven | varchar | 2147483647 | √ | null |
|
|
||
| Actions | varchar | 2147483647 | √ | null |
|
|
||
| AdditionalActionTaken | varchar | 2147483647 | √ | null |
|
|
||
| NameOfOtherService | varchar | 2147483647 | √ | null |
|
|
||
| TestsCancelled | varchar | 100 | √ | null |
|
|
||
| TestsCancelledOther | varchar | 2147483647 | √ | null |
|
|
||
| DateDischargedAOS | date | 20 | √ | null |
|
|
||
| DateDischargedHospital | date | 20 | √ | null |
|
|
||
| LengthOfStay | int | 4 | √ | null |
|
|
||
| DischargeDestination | varchar | 2147483647 | √ | null |
|
|
||
| EarlyDischargeRecommended | varchar | 10 | √ | null |
|
|
||
| AdmissionAvoided | varchar | 10 | √ | null |
|
|
||
| Outcome | varchar | 2147483647 | √ | null |
|
|
||
| OtherOutcome | varchar | 2147483647 | √ | null |
|
|
||
| DischargeOutcomeComments | varchar | 2147483647 | √ | null |
|
|
||
| DateNeutropenicSepsisSuspected | date | 20 | √ | null |
|
|
||
| TimeNeutropenicSepsisSuspected | time | 32 | √ | null |
|
|
||
| DateAssessmentNeutropenicSepsis | date | 20 | √ | null |
|
|
||
| TimeAssessmentNeutropenicSepsis | time | 32 | √ | null |
|
|
||
| DateArrivalNeutropenicSepsis | date | 20 | √ | null |
|
|
||
| TimeArrivalNeutropenicSepsis | time | 32 | √ | null |
|
|
||
| DateAntibioticsPrescribedNeutropenicSepsis | date | 20 | √ | null |
|
|
||
| TimeAntibioticsPrescribedNeutropenicSepsis | time | 32 | √ | null |
|
|
||
| DateAntibioticsAdministeredNeutropenicSepsis | date | 20 | √ | null |
|
|
||
| TimeAntibioticsAdministeredNeutropenicSepsis | time | 32 | √ | null |
|
|
||
| NeutropenicSepsisConfirmed | varchar | 5 | √ | null |
|
|
||
| DateNeutropenicSepsisConfirmed | date | 20 | √ | null |
|
|
||
| AdministrationService | varchar | 2147483647 | √ | null |
|
|
||
| CorrectMedicationGiven | varchar | 5 | √ | null |
|
|
||
| CorrectMedicationGivenComments | varchar | 2147483647 | √ | null |
|
|
||
| AntibioticGivenName | varchar | 2147483647 | √ | null |
|
|
||
| AntibioticGivenDose | varchar | 2147483647 | √ | null |
|
|
||
| ContributingFactors | varchar | 2147483647 | √ | null |
|
|
||
| AssessedByCNSNeutropenicSepsis | varchar | 2147483647 | √ | null |
|
|
||
| AssessedByConsultantNeutropenicSepsis | varchar | 2147483647 | √ | null |
|
|
||
| DateMASCCRiskIndexCompleted | date | 20 | √ | null |
|
|
||
| TimeMASCCRiskIndexCompleted | time | 32 | √ | null |
|
|
||
| TotalMASCCScore | int | 4 | √ | null |
|
|
||
| DateAssessmentMSCC | date | 20 | √ | null |
|
|
||
| TimeAssessmentMSCC | time | 32 | √ | null |
|
|
||
| AssessedByCNSMSCC | varchar | 2147483647 | √ | null |
|
|
||
| AssessedByConsultantMSCC | varchar | 2147483647 | √ | null |
|
|
||
| OncologistHaematologistMSCC | varchar | 100 | √ | null |
|
|
||
| TreatmentTeamsDiscussions | varchar | 2147483647 | √ | null |
|
|
||
| SteroidsStarted | varchar | 5 | √ | null |
|
|
||
| SteroidsStartedDate | date | 20 | √ | null |
|
|
||
| SteroidsType | varchar | 2147483647 | √ | null |
|
|
||
| NursedFlat | varchar | 5 | √ | null |
|
|
||
| ImagingTypeRequested | varchar | 20 | √ | null |
|
|
||
| ImagingTypeOther | varchar | 2147483647 | √ | null |
|
|
||
| DateImagingRequested | date | 20 | √ | null |
|
|
||
| TimeImagingRequested | time | 32 | √ | null |
|
|
||
| DateImagingPerformed | date | 20 | √ | null |
|
|
||
| TimeImagingPerformed | time | 32 | √ | null |
|
|
||
| DateImagingReported | date | 20 | √ | null |
|
|
||
| TimeImagingReported | time | 32 | √ | null |
|
|
||
| ReportingOrganisation | varchar | 100 | √ | null |
|
|
||
| MSCCConfirmed | varchar | 5 | √ | null |
|
|
||
| MSCCConfirmedDate | date | 20 | √ | null |
|
|
||
| SpinalSurgeonsInformedDate | date | 20 | √ | null |
|
|
||
| RadiotherapyInformedDate | date | 20 | √ | null |
|
|
||
| DiagnosisDelayReasons | varchar | 2147483647 | √ | null |
|
|
||
| DefinitiveTreatmentType | varchar | 100 | √ | null |
|
|
||
| DefinitiveTreatmentTypeOther | varchar | 2147483647 | √ | null |
|
|
||
| DateDefinitiveTreatmentStarted | date | 20 | √ | null |
|
|
||
| TimeDefinitiveTreatmentStarted | time | 32 | √ | null |
|
|
||
| PrimaryTreatmentOrganisation | varchar | 100 | √ | null |
|
|
||
| TreatmentDelayReasons | varchar | 2147483647 | √ | null |
|
|
||
| 3MonthFollowUpComplete | varchar | 5 | √ | null |
|
|
||
| FunctionOutcome3MonthsPain | varchar | 10 | √ | null |
|
|
||
| FunctionOutcome3MonthsMobility | varchar | 10 | √ | null |
|
|
||
| FunctionOutcome3MonthsContinent | varchar | 10 | √ | null |
|
|
||
| 12MonthFollowUpComplete | varchar | 5 | √ | null |
|
|
||
| FunctionOutcome12MonthsPain | varchar | 10 | √ | null |
|
|
||
| FunctionOutcome12MonthsMobility | varchar | 10 | √ | null |
|
|
||
| FunctionOutcome12MonthsContinent | varchar | 10 | √ | null |
|
|
||
| 24MonthFollowUpComplete | varchar | 5 | √ | null |
|
|
||
| FunctionOutcome24MonthsPain | varchar | 10 | √ | null |
|
|
||
| FunctionOutcome24MonthsMobility | varchar | 10 | √ | null |
|
|
||
| FunctionOutcome24MonthsContinent | varchar | 10 | √ | null |
|
|
||
| DateOfDeath | date | 20 | √ | null |
|
|
||
| Username | varchar | 50 | √ | null |
|
|
||
| RecordOfAssessment | varchar | 2147483647 | √ | null |
|
|
Diagram producer might be missing
No diagrams were produced please see application output for any errors