Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| ReferralID | int | 4 | null |
|
|
|||||
| DateDischargedAOS | date | 20 | √ | null |
|
|
||||
| DateDischargedHospital | date | 20 | √ | null |
|
|
||||
| EarlyDischargeRecommended | int | 4 | √ | null |
|
|
||||
| AdmissionAvoided | int | 4 | √ | null |
|
|
||||
| DischargeDestinationID | int | 4 | √ | null |
|
|
||||
| DischargeDestinationOther | varchar | 250 | √ | null |
|
|
||||
| RemainsInpatient | bit | 1 | null |
|
|
|||||
| ActiveOncologyTreatment | bit | 1 | null |
|
|
|||||
| GPFollowUp | bit | 1 | null |
|
|
|||||
| PalliativeCareReferral | bit | 1 | null |
|
|
|||||
| NoFurtherAOInput | bit | 1 | null |
|
|
|||||
| AttendingOPA | bit | 1 | null |
|
|
|||||
| TakenOverByConsultant | bit | 1 | null |
|
|
|||||
| AddReferralToSCR | bit | 1 | null |
|
|
|||||
| EndOfLifeCare | bit | 1 | null |
|
|
|||||
| TakenOverByTeam | bit | 1 | null |
|
|
|||||
| SupportPalliativeCare | bit | 1 | null |
|
|
|||||
| InappropriateReferral | bit | 1 | null |
|
|
|||||
| PalliativeCareReferralDate | date | 20 | √ | null |
|
|
||||
| OtherOutcome | varchar | 250 | √ | null |
|
|
||||
| FunctionOutcome3MonthsPain | int | 4 | √ | null |
|
|
||||
| FunctionOutcome3MonthsMobility | int | 4 | √ | null |
|
|
||||
| FunctionOutcome3MonthsContinent | int | 4 | √ | null |
|
|
||||
| FunctionOutcome24MonthsPain | int | 4 | √ | null |
|
|
||||
| FunctionOutcome24MonthsMobility | int | 4 | √ | null |
|
|
||||
| FunctionOutcome24MonthsContinent | int | 4 | √ | null |
|
|
||||
| DischargeOutcomeComments | varchar | 2147483647 | √ | null |
|
|
||||
| MajorNewCancer | bit | 1 | null |
|
|
|||||
| MajorChemoRTComplication | bit | 1 | null |
|
|
|||||
| MajorRecommendDiagnosticTests | bit | 1 | null |
|
|
|||||
| MajorCancellingUnnecessaryTests | bit | 1 | null |
|
|
|||||
| MajorPreventingAdmission | bit | 1 | null |
|
|
|||||
| MajorSymptomManagement | bit | 1 | null |
|
|
|||||
| MajorCNSPresentSignificantNews | bit | 1 | null |
|
|
|||||
| MajorOther | bit | 1 | null |
|
|
|||||
| MajorOtherIntervention | varchar | 250 | √ | null |
|
|
||||
| IntermediatePsychologicalSupport | bit | 1 | null |
|
|
|||||
| IntermediateInformation | bit | 1 | null |
|
|
|||||
| IntermediateAdvisedReferralAnotherTeam | bit | 1 | null |
|
|
|||||
| IntermediateAdvisedReferralOtherHospital | bit | 1 | null |
|
|
|||||
| IntermediateOther | bit | 1 | null |
|
|
|||||
| IntermediateOtherIntervention | varchar | 250 | √ | null |
|
|
||||
| MinorOrganisingFUAppointment | bit | 1 | null |
|
|
|||||
| MinorCheckPatientProgress | bit | 1 | null |
|
|
|||||
| MinorInpatientFU | bit | 1 | null |
|
|
|||||
| MinorOther | bit | 1 | null |
|
|
|||||
| MinorOtherIntervention | varchar | 250 | √ | null |
|
|
||||
| AuditID | int | 4 | √ | null |
|
|
||||
| MajorCNSPresentBadNews | bit | 1 | ((0)) |
|
|
|||||
| MajorCNSGaveDiagnosis | bit | 1 | ((0)) |
|
|
|||||
| FunctionOutcome12MonthsPain | int | 4 | √ | null |
|
|
||||
| FunctionOutcome12MonthsMobility | int | 4 | √ | null |
|
|
||||
| FunctionOutcome12MonthsContinent | int | 4 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_tblAO_OUTCOME | Primary key | Asc | ReferralID |