Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| CancerAlliance | varchar | 9 | √ | null |
|
|
||
| ProviderCode | varchar | 5 | √ | null |
|
|
||
| NHSNumber | varchar | 10 | √ | null |
|
|
||
| HospitalNumber | varchar | 50 | √ | null |
|
|
||
| PatientSurname | varchar | 100 | √ | null |
|
|
||
| PatientForename | varchar | 100 | √ | null |
|
|
||
| Birthdate | varchar | 10 | √ | null |
|
|
||
| DateOfReferralToRDCSS | varchar | 10 | √ | null |
|
|
||
| SiteSpecificReferralPathway | varchar | 2 | √ | null |
|
|
||
| FDSEndDateSS | varchar | 10 | √ | null |
|
|
||
| CoMorbsAngina | bit | 1 | null |
|
|
|||
| CoMorbsAspirin | bit | 1 | null |
|
|
|||
| CoMorbsSteroids | bit | 1 | null |
|
|
|||
| CoMorbsWarfarin | bit | 1 | null |
|
|
|||
| CoMorbsDipyridamole | bit | 1 | null |
|
|
|||
| CoMorbsClopidogrel | bit | 1 | null |
|
|
|||
| CoMorbsPacemaker | bit | 1 | null |
|
|
|||
| CoMorbsClotting | bit | 1 | null |
|
|
|||
| CoMorbsAcutePancreatitis | bit | 1 | null |
|
|
|||
| CoMorbsAlcoholInducedPancreatitis | bit | 1 | null |
|
|
|||
| CoMorbsAnaemia | bit | 1 | null |
|
|
|||
| CoMorbsArthritis | bit | 1 | null |
|
|
|||
| CoMorbsBarrettsOesophagus | bit | 1 | null |
|
|
|||
| CoMorbsCardiovascular | bit | 1 | null |
|
|
|||
| CoMorbsCerebrovascular | bit | 1 | null |
|
|
|||
| CoMorbsChronicPancreatitis | bit | 1 | null |
|
|
|||
| CoMorbsCirrhosisLiver | bit | 1 | null |
|
|
|||
| CoMorbsCOPDOtherChronic | bit | 1 | null |
|
|
|||
| CoMorbsHistoryCardiacFailure | bit | 1 | null |
|
|
|||
| CoMorbsHistoryCVA | bit | 1 | null |
|
|
|||
| CoMorbsIschaemicHeart | bit | 1 | null |
|
|
|||
| CoMorbsInflammatoryBowel | bit | 1 | null |
|
|
|||
| CoMorbsLiver | bit | 1 | null |
|
|
|||
| CoMorbsMental | bit | 1 | null |
|
|
|||
| CoMorbsNeurological | bit | 1 | null |
|
|
|||
| CoMorbsPeripheralVascular | bit | 1 | null |
|
|
|||
| CoMorbsRenal | bit | 1 | null |
|
|
|||
| CoMorbsRespiratory | bit | 1 | null |
|
|
|||
| CoMorbsCreatinine | bit | 1 | null |
|
|
|||
| CoMorbsDiabetesI | bit | 1 | null |
|
|
|||
| CoMorbsDiabetesII | bit | 1 | null |
|
|
|||
| CoMorbsOtherVascular | bit | 1 | null |
|
|
|||
| CoMorbsCOPD | bit | 1 | null |
|
|
|||
| CoMorbsCognitiveImpairment | bit | 1 | null |
|
|
|||
| CoMorbsDepression | bit | 1 | null |
|
|
|||
| CoMorbsHypertension | bit | 1 | null |
|
|
|||
| CoMorbsLongstandingPhysicalDisability | bit | 1 | null |
|
|
|||
| CoMorbsObesity | bit | 1 | null |
|
|
|||
| CoMorbsPreviousCancer | bit | 1 | null |
|
|
|||
| CoMorbsSevereLongstandingMentalIllness | bit | 1 | null |
|
|
|||
| CoMorbsNotKnown | bit | 1 | null |
|
|
|||
| CoMorbsMorbiditiesNone | bit | 1 | null |
|
|
|||
| CoMorbsOtherCoMorbidity | bit | 1 | null |
|
|
|||
| CoMorbidities | varchar | 2147483647 | √ | null |
|
|
||
| PerformanceStatus | varchar | 3 | √ | null |
|
|
||
| SmokingStatus | varchar | 3 | √ | null |
|
|
||
| AlcoholConsumption | varchar | 3 | √ | null |
|
|
||
| SymptomsUnexpWeightLoss | bit | 1 | null |
|
|
|||
| SymptomsLossOfAppetite | bit | 1 | null |
|
|
|||
| SymptomsFatigue | bit | 1 | null |
|
|
|||
| SymptomsNauseaVomiting | bit | 1 | null |
|
|
|||
| SymptomsMalaise | bit | 1 | null |
|
|
|||
| SymptomsBloating | bit | 1 | null |
|
|
|||
| SymptomsVagueAbdoPain | bit | 1 | null |
|
|
|||
| SymptomsProgPain | bit | 1 | null |
|
|
|||
| SymptomsGPGutFeeling | bit | 1 | null |
|
|
|||
| SymptomsUnexpBreathlessness | bit | 1 | null |
|
|
|||
| SymptomsUnexpThrombo | bit | 1 | null |
|
|
|||
| SymptomsAbnormalLabFinding | bit | 1 | null |
|
|
|||
| SymptomsAbnormalRadSugCan | bit | 1 | null |
|
|
|||
| SymptomsAnaemia | bit | 1 | null |
|
|
|||
| SymptomsJaundice | bit | 1 | null |
|
|
|||
| SymptomsOther | bit | 1 | null |
|
|
|||
| SymptomsUnknown | bit | 1 | null |
|
|
|||
| SymptomsAtPresentation | varchar | 100 | √ | null |
|
|
||
| OtherSymptomsAtPresentation | varchar | 500 | √ | null |
|
|
||
| DateFirstPresentSymptoms | varchar | 10 | √ | null |
|
|
||
| NumberConsBeforeRef | int | 4 | √ | null |
|
|
||
| FFTestsNone | bit | 1 | null |
|
|
|||
| FFTestsCXR | bit | 1 | null |
|
|
|||
| FFTestsURINE | bit | 1 | null |
|
|
|||
| FFTestsFIT | bit | 1 | null |
|
|
|||
| FFTestsFBC | bit | 1 | null |
|
|
|||
| FFTestsESR_CRP | bit | 1 | null |
|
|
|||
| FFTestsLFTSInclGlobs | bit | 1 | null |
|
|
|||
| FFTestsTFTS | bit | 1 | null |
|
|
|||
| FFTestsHBA1c | bit | 1 | null |
|
|
|||
| FFTestsBone | bit | 1 | null |
|
|
|||
| FFTestsCA_125 | bit | 1 | null |
|
|
|||
| FFTestsPSA | bit | 1 | null |
|
|
|||
| FFTestsUltrasound | bit | 1 | null |
|
|
|||
| FFTestsFerritinFolate | bit | 1 | null |
|
|
|||
| FFTestsTTG_AB | bit | 1 | null |
|
|
|||
| FFTestsGGT | bit | 1 | null |
|
|
|||
| FFTestsProtEP | bit | 1 | null |
|
|
|||
| FFTestsHIV | bit | 1 | null |
|
|
|||
| FFTestsClotting | bit | 1 | null |
|
|
|||
| FFTestsGlucose | bit | 1 | null |
|
|
|||
| FFTestsLDH | bit | 1 | null |
|
|
|||
| FFTestsOther | bit | 1 | null |
|
|
|||
| FilterFunctionTests | varchar | 100 | √ | null |
|
|
||
| DateOfReferralToRDCNSS | varchar | 10 | √ | null |
|
|
||
| ResultOfReferral | varchar | 3 | √ | null |
|
|
||
| DateOfTriage | varchar | 10 | √ | null |
|
|
||
| Tests1ConductedAtRDC | varchar | 500 | √ | null |
|
|
||
| Tests1ConductedDate | varchar | 10 | √ | null |
|
|
||
| Tests2ConductedAtRDC | varchar | 500 | √ | null |
|
|
||
| Tests2ConductedDate | varchar | 10 | √ | null |
|
|
||
| Tests3ConductedAtRDC | varchar | 500 | √ | null |
|
|
||
| Tests3ConductedDate | varchar | 10 | √ | null |
|
|
||
| Tests4ConductedAtRDC | varchar | 500 | √ | null |
|
|
||
| Tests4ConductedDate | varchar | 10 | √ | null |
|
|
||
| Tests5ConductedAtRDC | varchar | 500 | √ | null |
|
|
||
| Tests5ConductedDate | varchar | 10 | √ | null |
|
|
||
| OtherTests | varchar | 50 | √ | null |
|
|
||
| OtherTestDate | varchar | 10 | √ | null |
|
|
||
| FinalDiagnosisStatus | int | 4 | √ | null |
|
|
||
| DateOnwardReferralOrDischarge | varchar | 10 | √ | null |
|
|
||
| FDSEndDateNSS | varchar | 10 | √ | null |
|
|
||
| CareID | int | 4 | null |
|
|
|||
| PatientID | int | 4 | null |
|
|
|||
| CancerType | varchar | 2 | √ | null |
|
|
||
| Gender | varchar | 2 | √ | null |
|
|
||
| Ethnicity | varchar | 50 | √ | null |
|
|
||
| Postcode | varchar | 10 | √ | null |
|
|
||
| CancerSite | varchar | 50 | √ | null |
|
|
||
| Username | varchar | 100 | null |
|
|
|||
| OrgFirstSeen | varchar | 2147483647 | √ | null |
|
|
||
| PathwayEndReason | varchar | 22 | √ | null |
|
|
||
| isNSS | bit | 1 | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_RDCHelper | Primary key | Asc/Asc | CareID + Username |
Diagram producer might be missing
No diagrams were produced please see application output for any errors