newNBOCAP_CHECK_TABLE


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CARE_ID int 4 √ null
PATIENT_ID int 4 √ null
NHSNumber varchar 10 √ null
HospitalNumber varchar 50 √ null
Name varchar 100 √ null
Username varchar 50 √ null
ERR_NHSNumber int 4 √ null
ERR_DateOfBirth int 4 √ null
ERR_Postcode int 4 √ null
ERR_Gender int 4 √ null
ERR_CarePlanIntent int 4 √ null
ERR_DateOfDiagnosis int 4 √ null
ERR_ICD10MajorSite int 4 √ null
ERR_MCategory int 4 √ null
ERR_NCategory int 4 √ null
ERR_NoCancerTreatmentReason int 4 √ null
ERR_OrganisationFirstSeen int 4 √ null
ERR_PerformanceStatus int 4 √ null
ERR_PlannedCancerTreatmentType int 4 √ null
ERR_SourceOfReferral int 4 √ null
ERR_TCategory int 4 √ null
ERR_ASAGrade int 4 √ null
ERR_CancerTreatmentCurability int 4 √ null
ERR_Consultant int 4 √ null
ERR_DateOfSurgery int 4 √ null
ERR_PrimaryProcedure int 4 √ null
ERR_ProviderOrganisation int 4 √ null
ERR_SurgicalAccess int 4 √ null
ERR_SurgicalUrgencyModeOfOperation int 4 √ null
ERR_FinalPathologyNCategory int 4 √ null
ERR_FinalPathologyRadiologyMCategory int 4 √ null
ERR_FinalPathologyTCategory int 4 √ null
ERR_NumberOfNodesExamined int 4 √ null
ERR_NumberOfNodesPositive int 4 √ null
ERR_StatusOfCircumferentialExcisionMargin int 4 √ null
ERR_PreOpInitialProviderOrganisation int 4 √ null
ERR_PreOpInitialCancerTreatmentModality int 4 √ null
ERR_PostOpProviderOrganisation int 4 √ null
ERR_PostOpCancerTreatmentModality int 4 √ null
ERR_CNSIndCode int 4 √ null
ERR_TumourHeightAboveAnalVerge int 4 √ null
ERR_RecurranceorMets int 4 √ null

Diagram producer might be missing

No diagrams were produced please see application output for any errors