Tables [dbo].[RegistryHeader]
Header table for Registry value sets for Cancer Registry and Health Care Survey
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDescription
Primary Key PK_RegistryHeader_ID: IDID[dbo].[dict_id]5NOT NULL1 - 1Key to the RegistryHeader table
RegistryTypevarchar(30)30NULL allowedRegistry type
Cluster Key RegistryHeader_PatientID: PatientIDForeign Keys FK_RegistryHeader_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientIDPatientID[dbo].[uniqueid]9NOT NULLPatient. Link to Person.ID.
EncounterID[dbo].[uniqueid]9NULL allowedEncounter. Link to Encounter.ID
SubmittingFor[dbo].[uniqueid]9NULL allowedSubmitting For - loads cancer problem
CreatedBy[dbo].[uniqueid]9NULL allowedCreated by. Link to IDX_User.ID
LastUpdatedBy[dbo].[uniqueid]9NULL allowedLast updated by. Link to IDX_User.ID
CreatedDatedatetime8NULL allowedCreated Date
UpdatedDatedatetime8NULL allowedUpdated Date
Statusvarchar(20)20NULL allowedStatus
ReportConfidentialityvarchar(50)50NULL allowedConfidentiality. Used across Cancer and Case registry