Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.UnverifiedItem_Medication
Touchworks 25.2
[dbo].[UnverifiedItem_Medication]
MS_Description
Medications imported via External sources.
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Default
Description
UnverifiedItemID
[dbo].[uniqueid]
9
NOT NULL
Item. Link to Unverified_Item.ID
FreeTextSIG
varchar(1000)
1000
NULL allowed
Free text Sig
Dose
varchar(10)
10
NULL allowed
Dose
AdministrationDose
varchar(10)
10
NULL allowed
Administration Dose
FreqUnitsDE
[dbo].[dict_id]
5
NOT NULL
Frequency Units. Link to Frequency_Units_DE.ID
AdministrationRouteDE
[dbo].[dict_id]
5
NOT NULL
Route of Administration. Link to Route_of_Admin_DE.ID
PerformedFuzzyWhen
varchar(50)
50
NOT NULL
Performed Date based on column PerformedFuzzySpecificity. If 'D' then ithis column will have Day. If 'Y' then Year.. Etc
PerformedFuzzySortAs
datetime
8
NULL allowed
Performed Date and Time
PerformedFuzzySpecificity
char(1)
1
NOT NULL
Performed Date Specificity. D - Day, Y - Year , M - Month , T - Date Time , F - Text
VaccineManufacturerDE
[dbo].[dict_id]
5
NOT NULL
((0))
Manufacturer. Link to Vaccine_Manufacturer_DE.ID
QuantityToDispense
varchar(10)
10
NOT NULL
('')
Quantity to Dispense
DaysToTake
varchar(10)
10
NOT NULL
('')
Number of days medicine to be taken
EndFuzzyWhen
varchar(50)
50
NOT NULL
('')
Medication End Date. Fuzzy Date Format.
EndFuzzySortAs
datetime
8
NULL allowed
Medication End Date. Fuzzy Date Format.
EndFuzzySpecificity
char(1)
1
NOT NULL
('')
Medication End Date. Fuzzy Date Format.
Specificity Column
D - Day
M - Month
Y - Year
F - Freetext
FreeTextPrescriber
varchar(150)
150
NOT NULL
('')
Prescriber name
PrescribedByID
[dbo].[uniqueid]
9
NOT NULL
((0))
Prescribed By Provider
Refill
smallint
2
NOT NULL
((0))
Refill quantity
ExpirationDTTM
datetime
8
NULL allowed
Expiration Date&Time
AdministrationBodySiteDE
[dbo].[dict_id]
5
NOT NULL
((0))
Administration Body Site. Link to Body_Site_DE.ID
Comments
varchar(255)
255
NOT NULL
('')
Comments
TherapyStartDTTM
datetime
8
NULL allowed
Therapy Start Date time