Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
CareID | int | 4 | null |
|
|
|||
PatientID | int | 4 | null |
|
|
|||
NHSNumber | varchar | 10 | √ | null |
|
|
||
HospitalNumber | varchar | 50 | √ | null |
|
|
||
Surname | varchar | 60 | √ | null |
|
|
||
Forename | varchar | 50 | √ | null |
|
|
||
Gender | char | 1 | √ | null |
|
|
||
CancerSite | varchar | 50 | √ | null |
|
|
||
DateOfBirth | date | 20 | √ | null |
|
|
||
DateOfDeath | date | 20 | √ | null |
|
|
||
PPI | varchar | 20 | √ | null |
|
|
||
SourceOfReferralForOutpatients | varchar | 2 | √ | null |
|
|
||
CancerType | varchar | 2 | √ | null |
|
|
||
PriorityType | varchar | 2 | √ | null |
|
|
||
DateDecisionToRefer | smalldatetime | 16 | √ | null |
|
|
||
DateReceipt | smalldatetime | 16 | √ | null |
|
|
||
DateFirstSeen | smalldatetime | 16 | √ | null |
|
|
||
DateUpgrade | smalldatetime | 16 | √ | null |
|
|
||
CancerStatus | varchar | 2 | √ | null |
|
|
||
Diagnosis1 | varchar | 5 | √ | null |
|
|
||
Diagnosis2 | varchar | 5 | √ | null |
|
|
||
DateDiagnosis | smalldatetime | 16 | √ | null |
|
|
||
TumourStatus | int | 4 | √ | null |
|
|
||
DateDTT | smalldatetime | 16 | √ | null |
|
|
||
DateTreatmentStart | smalldatetime | 16 | √ | null |
|
|
||
TreatmentEvent | varchar | 2 | √ | null |
|
|
||
TreatmentSetting | varchar | 2 | √ | null |
|
|
||
TreatNo | int | 4 | √ | null |
|
|
||
AdjustmentReason | int | 4 | √ | null |
|
|
||
DateCancelled | smalldatetime | 16 | √ | null |
|
|
||
AdjustmentDays | int | 4 | √ | null |
|
|
||
AdjustmentCode | int | 4 | √ | null |
|
|
||
FirstApptOffered | int | 4 | √ | null |
|
|
||
DatePatientInformed | smalldatetime | 16 | √ | null |
|
|
||
FasterDiagnosisExclusionDate | datetime | 16,3 | √ | null |
|
|
||
OrgFirstSeen | varchar | 5 | √ | null |
|
|
||
OrgUpgrade | varchar | 5 | √ | null |
|
|
||
OrgTreatment | varchar | 5 | √ | null |
|
|
||
Morphology | varchar | 10 | √ | null |
|
|
||
MorphologySNOMED | int | 4 | √ | null |
|
|
||
DiagnosisSNOMED | int | 4 | √ | null |
|
|
||
TreatmentID | int | 4 | √ | null |
|
|
||
TreatmentType | char | 2 | √ | null |
|
|
||
FasterDiagnosisOrganisation | int | 4 | √ | null |
|
|
||
IsTransfer | bit | 1 | null |
|
|
|||
IsOtherSite | bit | 1 | null |
|
|
|||
IsNoCancerStatus | bit | 1 | null |
|
|
|||
IsNoTreatment | bit | 1 | null |
|
|
|||
IsBCC | bit | 1 | null |
|
|
|||
IsNonCancerDiagnosis | bit | 1 | null |
|
|
|||
AgeRefRcvd | int | 4 | √ | null |
|
|
||
AgeAtDiagnosis | int | 4 | √ | null |
|
|
||
IsRecurrenceOrMets | bit | 1 | null |
|
|
|||
IsSuspectedRecurrence | bit | 1 | null |
|
|
|||
IsFirstTreatment | bit | 1 | null |
|
|
|||
IsUrgent | bit | 1 | null |
|
|
|||
Is2WW | bit | 1 | null |
|
|
|||
IsScreening | bit | 1 | null |
|
|
|||
IsBreastSymptomatic | bit | 1 | null |
|
|
|||
IsSuspectedLeukaemia | bit | 1 | null |
|
|
|||
IsSuspectedTesticular | bit | 1 | null |
|
|
|||
IsLeukaemia | bit | 1 | null |
|
|
|||
IsAdmission | bit | 1 | null |
|
|
|||
IsNoSubsequentTreatmentPlanned | bit | 1 | null |
|
|
|||
IsPrimaryToTransformationProgressionExclusion | bit | 1 | null |
|
|
|||
IsTransformationProgression | bit | 1 | null |
|
|
|||
IsPrimaryReferral | bit | 1 | null |
|
|
|||
InappropriateReferral | int | 4 | √ | null |
|
|
||
Subtype | varchar | 50 | √ | null |
|
|
||
IsSuspectedChildrens | bit | 1 | null |
|
|
|||
PCTCode | varchar | 5 | √ | null |
|
|
||
PCTDesc | varchar | 100 | √ | null |
|
|
||
TargetDate62Days | date | 20 | √ | null |
|
|
||
RTTRow | int | 4 | √ | null |
|
|
||
MinRow | int | 4 | √ | null |
|
|
||
MinDecisionDate | smalldatetime | 16 | √ | null |
|
|
||
MinTreatNo | int | 4 | √ | null |
|
|
||
Username | varchar | 50 | √ | null |
|
|
||
IsCWT2WW | bit | 1 | null |
|
|
|||
IsCWTScreening | bit | 1 | null |
|
|
|||
IsCWTUpgrade | bit | 1 | null |
|
|
|||
ALTCWTDTTorECAD | int | 4 | null |
|
|
|||
CWTDTTorECAD | int | 4 | null |
|
|
|||
Special | varchar | 2 | √ | null |
|
|
||
IsCWTFDP | bit | 1 | null |
|
|
|||
FirstSeenAdjTime | int | 4 | null |
|
|
|||
FirstSeenAdjReason | int | 4 | √ | null |
|
|
||
DTTTreatmentADJTime | int | 4 | null |
|
|
|||
DTTTreatmentADJReason | int | 4 | √ | null |
|
|
||
CWT2WWRTT | int | 4 | null |
|
|
|||
FirstSeenAdjTimeUpgrade | int | 4 | null |
|
|
|||
FDPPathwayEndDate | smalldatetime | 16 | √ | null |
|
|
||
minFDPPathwayEndDate | smalldatetime | 16 | √ | null |
|
|
||
TWWTargetDate | smalldatetime | 16 | √ | null |
|
|
||
TWWWait | int | 4 | √ | null |
|
|
||
RTTTargetDate | smalldatetime | 16 | √ | null |
|
|
||
RTTWait | int | 4 | √ | null |
|
|
||
DTTECADTargetDate | smalldatetime | 16 | √ | null |
|
|
||
DTTECADWait | int | 4 | √ | null |
|
|
||
RTTScreeningTargetDate | smalldatetime | 16 | √ | null |
|
|
||
RTTScreeningWait | int | 4 | √ | null |
|
|
||
RTTUpgradeTargetDate | smalldatetime | 16 | √ | null |
|
|
||
RTTUpgradeWait | int | 4 | √ | null |
|
|
||
FDPTargetDate | smalldatetime | 16 | √ | null |
|
|
||
FDPWait | int | 4 | √ | null |
|
|
||
TabNon_Pathway | int | 4 | √ | null |
|
|
||
OrgCodeFDP | varchar | 5 | √ | null |
|
|
Diagram producer might be missing
No diagrams were produced please see application output for any errors