Tables [dbo].[MedOfferDistribution]
This table logs individual distribution events for dbo.Medication_MedOffer records
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Cluster Primary Key PK_MedOfferDistribution: IDID[dbo].[uniqueid]9NOT NULL1 - 1Key to the MedOfferDistribution table
Indexes NIX_MedOfferDistribution_MedOfferIDForeign Keys FK_MedOfferDistribution_MedOfferID_MedOffer_ID: [dbo].[MedOffer].MedOfferIDMedOfferID[dbo].[uniqueid]9NOT NULLMedication Offer. Link to MedOffer.ID.
Foreign Keys FK_MedOfferDistribution_DistributionTypeDE_MedOffer_Distribution_Type_DE_ID: [dbo].[MedOffer_Distribution_Type_DE].DistributionTypeDEDistributionTypeDE[dbo].[dict_id]5NOT NULLDistribution Type. Link to MedOffer_Distribution_type_DE.ID
DistributionDTTMdatetime8NULL allowedDate/Time the coupon was distributed to a patient
DistributedByID[dbo].[uniqueid]9NOT NULLID of provider who distributed the coupon
ScriptDestinationvarchar(35)35NOT NULLIndicates how the prescription was distributed e.g. 'fax', 'script', 'print', 'dispense'
IsDistributedbit1NOT NULL((0))Was the offer distributed.