ActiveLatestPSATrackerData


Columns

Column Type Size Nulls Auto Default Children Parents Comments
NHSNumber varchar 10 null
HotspitalNumber varchar 20 √ null
PatientStatus varchar 100 √ null
PatName varchar 112 √ null
DateofBirth date 20 √ null
PostCode varchar 10 √ null
TrackingStatus varchar 10 √ null
DateDiagnosis smalldatetime 16 √ null
Diagnosis varchar 158 √ null
OrganisationFollowUp nvarchar 500 √ null
LatestFollowupDate smalldatetime 16 √ null
LatestTum smalldatetime 16 √ null
LatestPSA varchar 255 √ null
Outcome varchar 30 √ null
LastTreatment nvarchar 1073741823 √ null
TumourMarkerDate date 20 √ null
AlertLevel real 4 √ null
LatestTrackingComment text 2147483647 √ null
GPName varchar 100 √ null
GPAddress1 varchar 250 √ null
GPAddress2 varchar 250 √ null
GPAddress3 varchar 250 √ null
GPAddress4 varchar 250 √ null
GPPostCode varchar 20 √ null
Consultant varchar 50 √ null
PSAAtDiagnosis varchar 50 √ null
GleasonScoreAtDiagnosis int 4 √ null
ClinicalStage varchar 8000 √ null
IsDead int 4 null
CareID int 4 null
ReasonSuspended varchar 50 √ null

View Definition

Possibly Referenced Tables/Views