Tables [dbo].[Service_Package_Component]
Occupational Medicine Service Package Component (Orderable Item).
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Primary Key PK_Service_Package_Component: IDID[dbo].[uniqueid]9NOT NULL1 - 1Key to the Service_Package_Component table
Cluster Key CIX_Service_Package_Component_EncounterServicePackageID: EncounterServicePackageIDForeign Keys FK_Service_Package_Component_EncounterServicePackageID: [dbo].[Encounter_Service_Package].EncounterServicePackageIDEncounterServicePackageID[dbo].[uniqueid]9NOT NULLService Package. Link to Encounter_Service_Package.ID
Check Constraints CK_Service_Package_Component_OIDType_MOI : ([OIDType]='M' OR [OIDType]='O' OR [OIDType]='I')OIDTYPEchar(1)1NOT NULLType of Orderable Item (OIDID); valid values: 'I', 'M', 'O'
OIDID[dbo].[dict_id]5NOT NULL((0))Orderable Item; Links to either Medication_DE.ID or QO_Classification_DE.ID (depends on OIDTYPE)
ItemID[dbo].[uniqueid]9NOT NULL((0))Created Item. Links to the created order (Item_plam.ID, Item_Medication.ID, or Item_Immunization.ID)