Tables [dbo].[MedOffer]
Medication Offer information received from the DXC service
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Cluster Primary Key PK_MedOffer: IDID[dbo].[uniqueid]9NOT NULL1 - 1Key to the MedOffer table
OfferUrlvarchar(max)maxNULL allowedGenerated coupon/voucher URL used to view and print in PDF format.
OfferImageUrlvarchar(max)maxNULL allowedGenerated coupon/voucher URL used to view and print in JPG format
PharmacyNotesvarchar(512)512NULL allowedDxc-generated notes to be sent to pharmacy for electronically submitted prescriptions.
CreatedDTTMdatetime8NULL allowedDate/time the coupon was created (ie, retrieved from DXC)
Indexes NIX_MedOffer_OfferExternalID_MedOfferTypeDEOfferExternalIDvarchar(255)255NULL allowedExternal ID from vendor representing a coupon offer.
SerializedOfferRequestvarchar(max)maxNULL allowedSerialized MedOffer object from DXC service
Indexes NIX_MedOffer_OriginatingIDForeign Keys FK_MedOffer_OriginatingID_Medication_ID: [dbo].[Medication].OriginatingIDOriginatingID[dbo].[uniqueid]9NOT NULLOriginating Medication. Link to Medication.ID
Indexes nix_MedOffer_OfferCancelDTTMOfferCancelDTTMdatetime8NOT NULLTime stamp after which the offer can no longer be claimed
PrescribingUrlvarchar(max)maxNOT NULL('')URL to Prescribing Information distributed by the pharmaceutical company.
StructuredOffervarchar(max)maxNULL allowedeCoupon in a JSON format
Indexes NIX_MedOffer_OfferExternalID_MedOfferTypeDEForeign Keys FK_MedOffer_MedOfferTypeDE_MedOffer_Type_DE_ID: [dbo].[MedOffer_Type_DE].MedOfferTypeDEMedOfferTypeDE[dbo].[dict_id]5NOT NULL((0))Type of coupon offer. Link to Medication_Type_DE.ID.