RDCCheckReportHelperNSS


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_ResultOfReferral int 4 null
ERR_FinalDiagnosisStatus int 4 null
ERR_CancerFasterDiagnosisPathwayEndDate int 4 null
Birthdate varchar 10 √ null
CancerSite varchar 20 √ null
ERR_PerformanceStatus int 4 null
ERR_DateOnwardReferralOrDischarge int 4 null
ERR_NHSNumberLen int 4 null
ERR_DateofReferralRDC int 4 null
Invalid int 4 null
Incomplete int 4 null
ERR_Comorbidities int 4 null
ERR_SmokingStatus int 4 null
ERR_AlcoholConsumption int 4 null
ERR_SymptomsAtPresentation int 4 null
ERR_DateFirstPresentSymptoms int 4 null
ERR_NumberConsBeforeRef int 4 null
ERR_FilterFunctionTests int 4 null
ERR_DateOfTriage int 4 null
ERR_Tests1ConductedAtRDC int 4 null
ERR_Tests1ConductedDate int 4 null
OrgFirstSeen varchar 2147483647 √ null
ERR_OtherSymptomsAtPresentation int 4 null
ERR_Tests1ConductedOther int 4 null

Indexes

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

Diagram producer might be missing

No diagrams were produced please see application output for any errors