Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| CARE_ID | int | 4 | null |
|
|
|||
| NHSNumber | varchar | 10 | null |
|
|
|||
| DateOfBirth | date | 20 | √ | null |
|
|
||
| Postcode | varchar | 10 | √ | null |
|
|
||
| Surname | varchar | 60 | √ | null |
|
|
||
| Forename | varchar | 50 | √ | null |
|
|
||
| Address1 | varchar | 35 | √ | null |
|
|
||
| Address2 | varchar | 35 | √ | null |
|
|
||
| Address3 | varchar | 35 | √ | null |
|
|
||
| Address4 | varchar | 35 | √ | null |
|
|
||
| Address5 | varchar | 35 | √ | null |
|
|
||
| MDTDate | smalldatetime | 16 | √ | null |
|
|
||
| ConsultantFirstSeen | varchar | 8 | √ | null |
|
|
||
| DiagnosisDate | smalldatetime | 16 | √ | null |
|
|
||
| SymptomsNone | bit | 1 | √ | null |
|
|
||
| SymptomsLUTS | bit | 1 | √ | null |
|
|
||
| SymptomsMets | bit | 1 | √ | null |
|
|
||
| SymptomsGeneral | bit | 1 | √ | null |
|
|
||
| SymptomsWeightLoss | bit | 1 | √ | null |
|
|
||
| SymptomsNotKnown | bit | 1 | √ | null |
|
|
||
| PerformanceStatus | int | 4 | √ | null |
|
|
||
| ASAScore | int | 4 | √ | null |
|
|
||
| ReferralSource | varchar | 2 | √ | null |
|
|
||
| PSA | varchar | 50 | √ | null |
|
|
||
| GleasonPrimary | int | 4 | √ | null |
|
|
||
| GleasonSecondary | int | 4 | √ | null |
|
|
||
| GleasonTertiary | int | 4 | √ | null |
|
|
||
| MultiparametricMRIPerf | int | 4 | √ | null |
|
|
||
| PreTreatTStage | varchar | 5 | √ | null |
|
|
||
| PreTreatTLetter | varchar | 5 | √ | null |
|
|
||
| PreTreatNStage | varchar | 5 | √ | null |
|
|
||
| PreTreatNLetter | varchar | 5 | √ | null |
|
|
||
| PreTreatMStage | varchar | 5 | √ | null |
|
|
||
| PreTreatMLetter | varchar | 5 | √ | null |
|
|
||
| PerineuralInvasion | varchar | 1 | √ | null |
|
|
||
| PositiveCores | int | 4 | √ | null |
|
|
||
| TotalCores | varchar | 50 | √ | null |
|
|
||
| GreatestPercentCancer | int | 4 | √ | null |
|
|
||
| SpecialistRefAppts | int | 4 | √ | null |
|
|
||
| PlannedTreat1 | varchar | 3 | √ | null |
|
|
||
| PlannedTreat2 | varchar | 3 | √ | null |
|
|
||
| PlannedTreat3 | varchar | 3 | √ | null |
|
|
||
| PlannedTreat4 | varchar | 3 | √ | null |
|
|
||
| PlannedTreat5 | varchar | 3 | √ | null |
|
|
||
| PlannedTreat6 | varchar | 3 | √ | null |
|
|
||
| SurgeryOrgCode | varchar | 5 | √ | null |
|
|
||
| SurgeryConsultant | varchar | 8 | √ | null |
|
|
||
| RadicalProstType | int | 4 | √ | null |
|
|
||
| SurgeryDate | smalldatetime | 16 | √ | null |
|
|
||
| NerveSparing | varchar | 50 | √ | null |
|
|
||
| LymphadenectomyPerformed | int | 4 | √ | null |
|
|
||
| PostTreatTStage | varchar | 5 | √ | null |
|
|
||
| PostTreatTLetter | varchar | 3 | √ | null |
|
|
||
| PostTreatNStage | varchar | 5 | √ | null |
|
|
||
| PostTreatNLetter | varchar | 6 | √ | null |
|
|
||
| OrganConfined | varchar | 1 | √ | null |
|
|
||
| SeminalVesiclesInvasion | varchar | 3 | √ | null |
|
|
||
| ProstateExcMargin | int | 4 | √ | null |
|
|
||
| StandardExcMargin | varchar | 2 | √ | null |
|
|
||
| PlannedRadioIntent | int | 4 | √ | null |
|
|
||
| PlannedRadioType | int | 4 | √ | null |
|
|
||
| PlannedImageGuidance | int | 4 | √ | null |
|
|
||
| PlannedRadioField | int | 4 | √ | null |
|
|
||
| PlannedBrachyType | int | 4 | √ | null |
|
|
||
| PlannedBrachyTotalDose | int | 4 | √ | null |
|
|
||
| PlannedBrachyTotalFractions | int | 4 | √ | null |
|
|
||
| PlannedNADTDuration | int | 4 | √ | null |
|
|
||
| PlannedNADTTotal | int | 4 | √ | null |
|
|
||
| HasFirstCarePlan | int | 4 | null |
|
|
|||
| HasBiopsyPathology | int | 4 | null |
|
|
|||
| HasProstatectomy | int | 4 | null |
|
|
|||
| HasPostTreatPathology | int | 4 | null |
|
|