Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.Medication_Fill_History
Touchworks 25.2
[dbo].[Medication_Fill_History]
MS_Description
History of medication fulfillments from a pharmacy.
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Identity
Default
Description
ID
[dbo].[uniqueid]
9
NOT NULL
1 - 1
Key to the Medication_Fill_History table
(3)
PatientID
[dbo].[uniqueid]
9
NULL allowed
Patient. Link to Person.ID
(2)
MedDictDE
[dbo].[dict_id]
5
NULL allowed
Medication. Link to Medication_DE.ID
FillDTTM
datetime
8
NULL allowed
Date filled
Quantity
varchar(20)
20
NULL allowed
Number of pills
DaysSupply
int
4
NULL allowed
How many days will medication last you
DaysFromLastFill
int
4
NULL allowed
How many days since last filled
FillSource
varchar(100)
100
NULL allowed
Source
SIG
varchar(1000)
1000
NULL allowed
The SIG used in the prescription (ie take 1 pill daily).
PrescriberName
varchar(100)
100
NULL allowed
Prescriber Name
NABP
varchar(35)
35
NULL allowed
NABP number. Link to Pharmacy_de.pharmacynabp
ClinicNm
varchar(35)
35
NULL allowed
Clinic Name
(2)
PatPBMUniqueID
varchar(80)
80
NULL allowed
Patient identifier given by PBM
NDC
char(12)
12
NULL allowed
NDC code of the medication given
MAIFillDesc
varchar(255)
255
NOT NULL
('')
Perscription Fill Description
MAIFillDaysLate
int
4
NOT NULL
((0))
Perscription Fill - Number of Days Late
MAIFillInd
char(15)
15
NOT NULL
('')
Perscription Fill Index
RxFillID
varchar(255)
255
NOT NULL
('')
Perscription Fill Identifier
UnverifiedItemID
[dbo].[uniqueid]
9
NULL allowed
Unverified Item. link to Unverified_Item.ID
ImportedDrugDescription
varchar(255)
255
NULL allowed
('')
Drug Description
ItemId
[dbo].[uniqueid]
9
NOT NULL
((0))
Item. Link to item_medication.id
FillStatus
varchar(255)
255
NULL allowed
Fill Status Text
FillComments
varchar(255)
255
NULL allowed