Key | Name | Data Type | Max Length (Bytes) | Nullability | Identity | Default | Description |
---|
 | ID | [dbo].[uniqueid] | 9 | NOT NULL | 1 - 1 | | Key to the Patient_Case table |
(2)![Foreign Keys FK_Patient_Case_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientID Foreign Keys FK_Patient_Case_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientID](../../../../Images/fk.png) | PatientID | [dbo].[uniqueid] | 9 | NOT NULL | | | Patient.Link to Person.ID |
![Foreign Keys FK_Patient_Case_CaseStatusDE: [dbo].[Case_Status_DE].CaseStatusDE Foreign Keys FK_Patient_Case_CaseStatusDE: [dbo].[Case_Status_DE].CaseStatusDE](../../../../Images/fk.png) | CaseStatusDE | [dbo].[dict_id] | 5 | NOT NULL | | | Status. Link to Case_Status_DE.ID |
![Foreign Keys FK_Patient_Case_EncounterEmployerID: [dbo].[Encounter_Employer].EncounterEmployerId Foreign Keys FK_Patient_Case_EncounterEmployerID: [dbo].[Encounter_Employer].EncounterEmployerId](../../../../Images/fk.png) | EncounterEmployerId | [dbo].[uniqueid] | 9 | NOT NULL | | ((0)) | Key to the Encounter_Employer table |
 | CaseNumberEXT | varchar(255) | 255 | NOT NULL | | ('') | External identifier for Case Number |
| InjuryDTTM | datetime | 8 | NOT NULL | | ('01/01/1900') | Date of injury |
| OrgID | [dbo].[dict_id] | 5 | NOT NULL | | ((0)) | Organization. Link to Organization.ID |
| DateOpened | datetime | 8 | NOT NULL | | ('01/01/1900') | Date the case was opened |
| InterfaceSourceID | varchar(255) | 255 | NOT NULL | | ('') | Interface source |
| WhoDidItID | [dbo].[uniqueid] | 9 | NOT NULL | | ((0)) | Who entered this case. Link to IDX_User.ID |
| LastUpdatedDTTM | datetime | 8 | NOT NULL | | ('01/01/1900') | Last date of update |
| FirstDateOfService | datetime | 8 | NOT NULL | | ('01/01/1900') | First date patient was seen for this accident for workers comp |
| AccidentState | char(2) | 2 | NOT NULL | | ('') | US state abbreviation where the accident occurred for workers comp |