Tables [dbo].[Encounter_Service_Package]
Occupational Medicine Service Package  linked to an encounter
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Primary Key PK_Encounter_Service_Package: IDID[dbo].[uniqueid]9NOT NULL1 - 1Key to the Encounter_Service_Package table
Cluster Key cix_Encounter_Service_Package_EncounterID: EncounterIDForeign Keys FK_Encounter_Service_Package_Encounter: [dbo].[Encounter].EncounterIDEncounterID[dbo].[uniqueid]9NOT NULLEncounter. Link to Encounter.ID
ServicePackageNumberExtvarchar(20)20NOT NULLService Package external identifier
Foreign Keys FK_Encounter_Service_Package_Problem: [dbo].[Problem_DE].ProblemDEProblemDE[dbo].[dict_id]5NOT NULL((0))Problem. Link to Problem_DE.ID
Descriptionvarchar(40)40NOT NULL('')Service Package description
Foreign Keys FK_Encounter_Service_Package_EncounterEmployerID: [dbo].[Encounter_Employer].EncounterEmployerIdEncounterEmployerId[dbo].[uniqueid]9NOT NULL((0))Employer. Link to Encounter_Employer.ID
ProblemID[dbo].[uniqueid]9NOT NULL((0))Problem. Link to Problem_Header.ID