rptPTL_TEMP_FD


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
PTLgroup varchar 10 √ null
HospitalNumber varchar 20 √ null
NHSNumber varchar 10 √ null
Forename varchar 50 √ null
Surname varchar 60 √ null
DateBirth datetime 16,3 √ null
DateDeath datetime 16,3 √ null
PatientPathwayID varchar 30 √ null
CancerSite varchar 50 √ null
DateReceipt datetime 16,3 √ null
DateFirstSeen datetime 16,3 √ null
OrgCodeFirstSeen varchar 5 √ null
CancerStatus varchar 100 √ null
ReferralType varchar 100 √ null
PriotiryType varchar 2 √ null
ReferralRoute varchar 100 √ null
RapidDiagnostic varchar 3 √ null
FirstSeenAdjTime int 4 √ null
FirstSeenAdjReason varchar 50 √ null
DateDiagnosis datetime 16,3 √ null
DiagnosisCode varchar 5 √ null
Diagnosis varchar 150 √ null
DateDecisionTreat datetime 16,3 √ null
DateTreatment datetime 16,3 √ null
TrackingNotes varchar 8000 √ null
DateReferredToTertiary datetime 16,3 √ null
OrgCodeTertiaryCentre varchar 5 √ null
WaitingTimeReftoPathwayEndDate int 4 √ null
TargetDateReftoPathwayEndDate datetime 16,3 √ null
DaysReftoPathwayEndDate int 4 √ null
DaystoReftoPathwayEndDateBreach int 4 √ null
PathwayEndDate datetime 16,3 √ null
TumourStatus varchar 50 √ null
FasterDiagnosisOrganisation varchar 250 √ null
FasterDiagnosisDelayReason varchar 160 √ null
DiagnosisUncertainty bit 1 null
FasterDiagnoisEndReason varchar 25 √ null
PaedSubSite varchar 50 √ null
Subtype varchar 50 √ null
Username varchar 50 √ null
WeekEndingDate datetime 16,3 √ null
ClockStopDate datetime 16,3 √ null
ClockStopCause varchar 50 √ null

Indexes

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

Diagram producer might be missing

No diagrams were produced please see application output for any errors