Key | Name | Data Type | Max Length (Bytes) | Nullability | Identity | Default | Description |
---|
 | ID | [dbo].[uniqueid] | 9 | NOT NULL | 1 - 1 | | Key to the Encounter_Case table |
![Foreign Keys FK_Encounter_Case_PatientCaseID: [dbo].[Patient_Case].PatientCaseID Foreign Keys FK_Encounter_Case_PatientCaseID: [dbo].[Patient_Case].PatientCaseID](../../../../Images/fk.png) | PatientCaseID | [dbo].[uniqueid] | 9 | NOT NULL | | ((0)) | Case. Link to Patient_Case.ID |
 ![Foreign Keys FK_Encounter_Case_EncounterID_Encounter_ID: [dbo].[Encounter].EncounterID Foreign Keys FK_Encounter_Case_EncounterID_Encounter_ID: [dbo].[Encounter].EncounterID](../../../../Images/fk.png) | EncounterID | [dbo].[uniqueid] | 9 | NOT NULL | | ((0)) | Encounter. Link to Encounter.ID |
| CaseStatusDE | [dbo].[dict_id] | 5 | NOT NULL | | ((0)) | Case Status. Link to Case_Status_DE.ID |
| RecordedDTTM | datetime | 8 | NOT NULL | | ('01/01/1900') | When recorded |
| WhoDidItID | [dbo].[uniqueid] | 9 | NOT NULL | | ((0)) | User who entered. Link to IDX_User.ID |
| PrevVersionID | [dbo].[uniqueid] | 9 | NOT NULL | | ((0)) | Previous version. Link to Encounter_Case.ID |
| NextVersionID | [dbo].[uniqueid] | 9 | NOT NULL | | ((0)) | Next version. Link to Encounter_Case.ID |