Tables [dbo].[Medication_MedOffer]
This table links a specific Medication record to a Medication Offer from dbo.MedOffer
KeyNameData TypeMax Length (Bytes)NullabilityDescription
Indexes nix_Medication_MedOffer_ItemIDForeign Keys FK_Medication_MedOffer_ItemID_Item_Medication_ID: [dbo].[Item_Medication].ItemIDItemID[dbo].[uniqueid]9NOT NULLThe Medication object ID. Link to Item_Medication.ID.
Cluster Primary Key PK_Medication_MedOffer: MedicationID\MedOfferIDForeign Keys FK_Medication_MedOffer_MedicationID_Medication_ID: [dbo].[Medication].MedicationIDMedicationID[dbo].[uniqueid]9NOT NULLThe Medication object CurrentID. Used for audit. Link to Medication.ID.
CreatedDTTMdatetime8NULL allowedDate/time the Medication_MedOffer record was created
MedOfferOutputMethodDE[dbo].[dict_id]5NULL allowedOutput Method. Link to MedOffer_Output_method_DE.ID. Indicates if the coupon is ‘attached’ the med. Values contained in that dictionary are: ‘Print coupon to give to patient’, ‘Send coupon to Pharmacy electronically’, ‘Decline coupon for this patient’
Cluster Primary Key PK_Medication_MedOffer: MedicationID\MedOfferIDForeign Keys FK_Medication_MedOffer_MedOfferID_MedOffer_ID: [dbo].[MedOffer].MedOfferIDMedOfferID[dbo].[uniqueid]9NOT NULLMedication Offer. Link to MedOffer.ID.
IsInactiveFlag[dbo].[BOOL]1NOT NULLIndicates if the offer is inactive or not.