Tables [dbo].[Encounter_Employer]
Occupational Medicine Employer information for the encounter
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Primary Key PK_Encounter_Employer: IDID[dbo].[uniqueid]9NOT NULL1 - 1Key to the Encounter_Employer table
Cluster Key CIX_Encounter_Employer_EncounterID: OriginalEncounterIdForeign Keys FK_Encounter_Employer_OriginalEncounterID: [dbo].[Encounter].OriginalEncounterIdOriginalEncounterId[dbo].[uniqueid]9NOT NULLEncounter. Link to Encounter.ID
EmployerNamevarchar(40)40NOT NULLPatient employer
EmployerLocationNamevarchar(40)40NOT NULL('')Employer Location
EmployerNumberExtvarchar(40)40NOT NULLEmployer external identifier
Foreign Keys FK_Encounter_Employer_OccMedEmployerDE: [dbo].[OccMed_Employer_DE].OccMedEmployerDEOccMedEmployerDE[dbo].[dict_id]5NOT NULL((0))Employer. Link to OccMed_Employer_DE.ID
LocationAddressvarchar(35)35NOT NULL('')Employer Location address line 1
LocationAddress2varchar(35)35NOT NULL('')Employer Location address line 2
LocationCityvarchar(35)35NOT NULL('')Employer Location City
LocationStatevarchar(35)35NOT NULL('')Employer Location State
LocationZipchar(10)10NOT NULL('')Employer Location Zip Code
SpecialtyNetworkvarchar(60)60NOT NULL('')Specialty or referral network associated with the Employer.  This corresponds to the 'Network' field of the ZCS segment of the HL7 message.  This value is displayed on the Encounter Summary for encounters that have employer data associated with them