rptPTL_TEMP_JPHILLIPS


Columns

Column Type Size Nulls Auto Default Children Parents Comments
PTL_ID int identity 4 √ null
CARE_ID int 4 √ null
PATIENT_ID int 4 √ null
HospitalNumber varchar 10 √ null
NHSNumber varchar 10 √ null
Forename varchar 50 √ null
Surname varchar 60 √ null
DateBirth datetime 16,3 √ null
DateDeath datetime 16,3 √ null
PCTCode varchar 5 √ null
PCT varchar 50 √ null
CancerSite varchar 50 √ null
UrgentCancerType varchar 2 √ null
PriorityTypeCode varchar 2 √ null
PriorityType varchar 100 √ null
ReferralTypeCode varchar 2 √ null
ReferralType varchar 100 √ null
DateReceipt datetime 16,3 √ null
DateFirstSeen datetime 16,3 √ null
OrgCodeFirstSeen varchar 5 √ null
CancerStatusCode varchar 2 √ null
CancerStatus varchar 100 √ null
TumourStatusCode int 4 √ null
TumourStatus varchar 50 √ null
DateCancelledAppt datetime 16,3 √ null
FirstSeenAdjTime int 4 √ null
FirstSeenAdjReasonCode int 4 √ null
FirstSeenAdjReason varchar 50 √ null
DateConsultantUpgrade datetime 16,3 √ null
OrgCodeUpgrade varchar 5 √ null
ConsultantCode varchar 8 √ null
Consultant varchar 50 √ null
DateDiagnosis datetime 16,3 √ null
AgeAtDiagnosis int 4 √ null
DiagnosisCode varchar 5 √ null
Diagnosis varchar 150 √ null
Histology varchar 10 √ null
TreatmentID int 4 √ null
TreatmentCode varchar 2 √ null
Treatment varchar 60 √ null
TreatmentSettingCode varchar 2 √ null
TreatmentSetting varchar 50 √ null
DateDecisionTreat datetime 16,3 √ null
DateTreatment datetime 16,3 √ null
OrgCodeTreatment varchar 5 √ null
FirstSeenDTTAdjTime int 4 √ null
FirstSeenDTTAdjReasonCode int 4 √ null
FirstSeenDTTAdjReason varchar 150 √ null
DTTTreatmentAdjTime int 4 √ null
DTTTreatmentAdjReasonCode int 4 √ null
DTTTreatmentAdjReason varchar 150 √ null
TargetDate62Days datetime 16,3 √ null
DaysTo62DayBreach int 4 √ null
WaitingTimeRefTreatment int 4 √ null
DaysTo62DayBreachNoDTT int 4 √ null
Treated7Days int 4 √ null
Treated62Days int 4 √ null
Treated7Days62Days int 4 √ null
Breach62Days int 4 √ null
Treated7DaysBreach62Days int 4 √ null
FutureAchieve62Days int 4 √ null
FutureFail62Days int 4 √ null
TargetDate31Days datetime 16,3 √ null
DaysTo31DayBreach int 4 √ null
WaitingTimeDTTTreatment int 4 √ null
ActualWaitDTTTreatment int 4 √ null
DTTTreated7Days int 4 √ null
Treated31Days int 4 √ null
Treated7Days31Days int 4 √ null
Breach31Days int 4 √ null
Treated7DaysBreach31Days int 4 √ null
FutureAchieve31Days int 4 √ null
FutureFail31Days int 4 √ null
FutureDTT int 4 √ null
NoDTTDate int 4 √ null
ReportDate datetime 16,3 √ null
TreatNo int 4 √ null
TrackingNotes text 2147483647 √ null
DateReferredToTertiary datetime 16,3 √ null
OrgCodeTertiaryCentre varchar 5 √ null
Username varchar 50 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_rptPTL_TEMP_JPHILLIPS Primary key Asc PTL_ID

Diagram producer might be missing

No diagrams were produced please see application output for any errors