Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.MedOfferDistribution
Touchworks 25.2
[dbo].[MedOfferDistribution]
MS_Description
This table logs individual distribution events for dbo.Medication_MedOffer records
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Identity
Default
Description
ID
[dbo].[uniqueid]
9
NOT NULL
1 - 1
Key to the MedOfferDistribution table
MedOfferID
[dbo].[uniqueid]
9
NOT NULL
Medication Offer. Link to MedOffer.ID.
DistributionTypeDE
[dbo].[dict_id]
5
NOT NULL
Distribution Type. Link to MedOffer_Distribution_type_DE.ID
DistributionDTTM
datetime
8
NULL allowed
Date/Time the coupon was distributed to a patient
DistributedByID
[dbo].[uniqueid]
9
NOT NULL
ID of provider who distributed the coupon
ScriptDestination
varchar(35)
35
NOT NULL
Indicates how the prescription was distributed e.g. 'fax', 'script', 'print', 'dispense'
IsDistributed
bit
1
NOT NULL
((0))
Was the offer distributed.