Tables [dbo].[UnverifiedItem_Medication]
Medications imported via External sources.
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Cluster Key CIX_UnverifiedItem_Medication_UnverifiedItemID: UnverifiedItemIDForeign Keys FK_UnverifiedItem_Medication_UnverifiedItemID_Unverified_Item_ID: [dbo].[Unverified_Item].UnverifiedItemIDUnverifiedItemID[dbo].[uniqueid]9NOT NULLItem. Link to Unverified_Item.ID
FreeTextSIGvarchar(1000)1000NULL allowedFree text Sig
Dosevarchar(10)10NULL allowedDose
AdministrationDosevarchar(10)10NULL allowedAdministration Dose
FreqUnitsDE[dbo].[dict_id]5NOT NULLFrequency Units. Link to Frequency_Units_DE.ID
AdministrationRouteDE[dbo].[dict_id]5NOT NULLRoute of Administration. Link to Route_of_Admin_DE.ID
PerformedFuzzyWhenvarchar(50)50NOT NULLPerformed Date based on column PerformedFuzzySpecificity. If 'D' then ithis column will have Day. If 'Y' then Year.. Etc
PerformedFuzzySortAsdatetime8NULL allowedPerformed Date and Time
PerformedFuzzySpecificitychar(1)1NOT NULLPerformed Date Specificity. D - Day, Y - Year , M - Month , T - Date Time , F - Text
VaccineManufacturerDE[dbo].[dict_id]5NOT NULL((0))Manufacturer. Link to Vaccine_Manufacturer_DE.ID
QuantityToDispensevarchar(10)10NOT NULL('')Quantity to Dispense
DaysToTakevarchar(10)10NOT NULL('')Number of days medicine to be taken
EndFuzzyWhenvarchar(50)50NOT NULL('')Medication End Date. Fuzzy Date Format.
EndFuzzySortAsdatetime8NULL allowedMedication End Date. Fuzzy Date Format.
EndFuzzySpecificitychar(1)1NOT NULL('')Medication End Date. Fuzzy Date Format.
Specificity Column
D - Day
M - Month
Y - Year
F - Freetext
FreeTextPrescribervarchar(150)150NOT NULL('')Prescriber name
PrescribedByID[dbo].[uniqueid]9NOT NULL((0))Prescribed By Provider
Refillsmallint2NOT NULL((0))Refill quantity
ExpirationDTTMdatetime8NULL allowedExpiration Date&Time
AdministrationBodySiteDE[dbo].[dict_id]5NOT NULL((0))Administration Body Site. Link to Body_Site_DE.ID
Commentsvarchar(255)255NOT NULL('')Comments
TherapyStartDTTMdatetime8NULL allowedTherapy Start Date time