Tables [dbo].[Patient_Case]
workers comp case information
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Cluster Primary Key PK_Patient_Case_ID: IDID[dbo].[uniqueid]9NOT NULL1 - 1Key to the Patient_Case table
Indexes NIX_Patient_Case_CaseNumberEXT_PatientID, NIX_Patient_Case_PatientID(2)Foreign Keys FK_Patient_Case_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientIDPatientID[dbo].[uniqueid]9NOT NULLPatient.Link to Person.ID
Foreign Keys FK_Patient_Case_CaseStatusDE: [dbo].[Case_Status_DE].CaseStatusDECaseStatusDE[dbo].[dict_id]5NOT NULLStatus. Link to Case_Status_DE.ID
Foreign Keys FK_Patient_Case_EncounterEmployerID: [dbo].[Encounter_Employer].EncounterEmployerIdEncounterEmployerId[dbo].[uniqueid]9NOT NULL((0))Key to the Encounter_Employer table
Indexes NIX_Patient_Case_CaseNumberEXT_PatientIDCaseNumberEXTvarchar(255)255NOT NULL('')External identifier for Case Number
InjuryDTTMdatetime8NOT NULL('01/01/1900')Date of injury
OrgID[dbo].[dict_id]5NOT NULL((0))Organization. Link to Organization.ID
DateOpeneddatetime8NOT NULL('01/01/1900')Date the case was opened
InterfaceSourceIDvarchar(255)255NOT NULL('')Interface source
WhoDidItID[dbo].[uniqueid]9NOT NULL((0))Who entered this case. Link to IDX_User.ID
LastUpdatedDTTMdatetime8NOT NULL('01/01/1900')Last date of update
FirstDateOfServicedatetime8NOT NULL('01/01/1900')First date patient was seen for this accident for workers comp
AccidentStatechar(2)2NOT NULL('')US state abbreviation where the accident occurred for workers comp