Tables [dbo].[Encounter_Workers_Comp]
Workers Comp information for the encounter
KeyNameData TypeMax Length (Bytes)NullabilityDescription
Cluster Primary Key PK_EncounterWorkersComp_1: EncounterIDForeign Keys FK_EncounterWorkersComp_1: [dbo].[Encounter].EncounterIDEncounterID[dbo].[uniqueid]9NOT NULLEncounter. Link to Encounter.ID
Employeervarchar(255)255NULL allowedEmpolyer
ContactPerson1varchar(255)255NULL allowedContact Person
ContactPersonPhone1varchar(25)25NULL allowedContact Person Phone
ContactPersonFax1varchar(25)25NULL allowedContact Person Fax
DateOfInjurydatetime8NULL allowedInjury Date
Foreign Keys FK_EncounterWorkersComp_2: [dbo].[Insurance_Class_DE].InsuranceClassDEInsuranceClassDE[dbo].[dict_id]5NOT NULLInsurance. Link to Insurance_Class_DE.ID
ContactPerson2varchar(255)255NULL allowedContact Person 2
ContactPersonPhone2varchar(25)25NULL allowedContact Person 2 Phone
ContactPersonFax2varchar(25)25NULL allowedContact Person 2 Fax
CaseManagervarchar(255)255NULL allowedCase Manger Name
CaseManagerPhonevarchar(25)25NULL allowedCase Manager Phone Number
CaseManagerFaxvarchar(25)25NULL allowedCase Manager Fax