Key | Name | Data Type | Max Length (Bytes) | Nullability | Identity | Description |
---|
 | ID | [dbo].[dict_id] | 5 | NOT NULL | 1 - 1 | Key to the RegistryHeader table |
| RegistryType | varchar(30) | 30 | NULL allowed | | Registry type |
 ![Foreign Keys FK_RegistryHeader_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientID Foreign Keys FK_RegistryHeader_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientID](../../../../Images/fk.png) | PatientID | [dbo].[uniqueid] | 9 | NOT NULL | | Patient. Link to Person.ID. |
| EncounterID | [dbo].[uniqueid] | 9 | NULL allowed | | Encounter. Link to Encounter.ID |
| SubmittingFor | [dbo].[uniqueid] | 9 | NULL allowed | | Submitting For - loads cancer problem |
| CreatedBy | [dbo].[uniqueid] | 9 | NULL allowed | | Created by. Link to IDX_User.ID |
| LastUpdatedBy | [dbo].[uniqueid] | 9 | NULL allowed | | Last updated by. Link to IDX_User.ID |
| CreatedDate | datetime | 8 | NULL allowed | | Created Date |
| UpdatedDate | datetime | 8 | NULL allowed | | Updated Date |
| Status | varchar(20) | 20 | NULL allowed | | Status |
| ReportConfidentiality | varchar(50) | 50 | NULL allowed | | Confidentiality. Used across Cancer and Case registry |