Tables [dbo].[PrescriptionLog]
Contains the Log of patient Prescriptions and the related provider and prescription information
KeyNameData TypeMax Length (Bytes)NullabilityDescription
Indexes TWstat_PrescriptionLog_UserIDUserID[dbo].[uniqueid]9NOT NULLThe user ID that did the prescription. Link to IDX_User.ID
Cluster Key cix_PrescriptionLog_ItemID: ItemIDItemID[dbo].[uniqueid]9NOT NULLItem ID - Item_Medication.ID
Indexes IX_PrescriptionLog_PatientIDForeign Keys FK_PrescriptionLog_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientIDPatientID[dbo].[uniqueid]9NOT NULLPatient. Link to Person.ID
Indexes TWstat_PrescriptionLog_OrderItemEXTOrderItemEXTvarchar(35)35NULL allowedExternal Order Identifier value associated to the medication Order
CurrentMedicationID[dbo].[uniqueid]9NOT NULLMedication ID. Link to Medication.ID
Indexes TWstat_PrescriptionLog_MedicationMedicationvarchar(255)255NOT NULLMedication description
Indexes TWstat_PrescriptionLog_DoseDosevarchar(35)35NULL allowedDose
Indexes TWstat_PrescriptionLog_RefillRefillsmallint2NULL allowednumber of refills
Indexes TWstat_PrescriptionLog_QuantityToDispenseQuantityToDispensevarchar(20)20NULL allowedQty to dispense
Indexes TWstat_PrescriptionLog_DaysToTakeDaysToTakesmallint2NULL allowedNumber of days to take the medication
Indexes TWstat_PrescriptionLog_PrescribedByPrescribedByvarchar(255)255NOT NULLName of the user who prescribed the medication
Indexes TWstat_PrescriptionLog_WhoForWhoForvarchar(255)255NOT NULLName of the user for who the prescription was done
Indexes TWstat_PrescriptionLog_WhoDidItWhoDidItvarchar(255)255NOT NULLName of the user who did the prescription
Indexes TWstat_PrescriptionLog_RecordedDTTMRecordedDTTMdatetime8NOT NULLDate prescription recorded
Indexes TWstat_PrescriptionLog_PrintRequestDTTMPrintRequestDTTMdatetime8NOT NULLPrescription Print requested Date
LogTypevarchar(20)20NULL allowedLog Type