RDCCheckReportHelperSS


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
PatientSurname varchar 100 √ null
PatientForename varchar 100 √ null
CancerType varchar 2 √ null
Username varchar 50 null
ERR_CancerAlliance int 4 null
ERR_ProviderCode int 4 null
ERR_NHSNumber int 4 null
ERR_DateOfBirth int 4 null
ERR_CancerFasterDiagnosisPathwayEndDate int 4 null
Birthdate varchar 10 √ null
CancerSite varchar 20 √ null
ERR_NHSNumberLen int 4 null
ERR_DateofReferralRDC int 4 null
Invalid int 4 null
Incomplete int 4 null
ERR_SiteSpecificReferralPathway int 4 null
OrgFirstSeen varchar 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_RDCCheckReportHelperSS Primary key Asc/Asc CareID + Username

Diagram producer might be missing

No diagrams were produced please see application output for any errors