Tables [dbo].[CancerRegistryData]
Cancer Registry data
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDescription
Cluster Primary Key PK_CancerRegistryData_ID: IDID[dbo].[dict_id]5NOT NULL1 - 1Key to the CancerRegistryData table
Indexes NIX_CancerRegistryData_RegistryHeaderIDForeign Keys FK_CancerRegistryData_RegistryHeaderID: [dbo].[RegistryHeader].RegistryHeaderIDRegistryHeaderID[dbo].[dict_id]5NOT NULLHeader. Link to RegistryHeader.ID
OnsetDatedatetime8NULL allowedOnset date
Histologyint4NULL allowedHistology
PrimarySiteint4NULL allowedPrimary site
ResolvedDatedatetime8NULL allowedResolved date
Behaviorint4NULL allowedBehavior
Lateralityint4NULL allowedLaterality
DiagnosticConfirmint4NULL allowedDiagnostic confirmation
Gradeint4NULL allowedGrade
Indexes NIX_CancerRegistryData_RegistryHeaderIDSubmittingProvider[dbo].[uniqueid]9NOT NULLSubmitting provider. Link to Person.ID
ClinicalStageGrpint4NULL allowedClinical stage group
ClinicalStageDescint4NULL allowedClinical stage description
ClinicalEditionint4NULL allowedClinical Stage Edition
ClinicalStagedByint4NULL allowedClinical Staged by
ClinicalTint4NULL allowedClinical stage T
ClinicalNint4NULL allowedClinical stage N
ClinicalMint4NULL allowedClinical stage M
PathologicStageGrpint4NULL allowedPathologic stage group
PathologicStageDescint4NULL allowedPathologic Stage description
PathologicEditionint4NULL allowedPathologic Edition
PathologicStagedByint4NULL allowedPathologic Staged by
PathologicTint4NULL allowedPathologic Stage T
PathologicNint4NULL allowedPathologic Stage N
PathologicMint4NULL allowedPathologic Stage M
CancerNotesvarchar(7000)7000NULL allowedCancer Notes
RadiationNotesvarchar(7000)7000NULL allowedRadiation notes
LastUpdatedClinicalDTTMdatetime8NULL allowedClinical Stage updated date time
LastUpdatedPathologicDTTMdatetime8NULL allowedPathologic stage updated date time