Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.PMP_History
Touchworks 25.2
[dbo].[PMP_History]
MS_Description
documentation for Prescription Monitoring Program (PMP) Registry consultation
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Identity
Description
ID
[dbo].[uniqueid]
9
NOT NULL
1 - 1
Key to the PMP_History table
PatientID
[dbo].[uniqueid]
9
NOT NULL
Patient. Links to Person.ID
UserID
[dbo].[uniqueid]
9
NOT NULL
User. Links to IDX_User.ID
EncounterID
[dbo].[uniqueid]
9
NOT NULL
Encounter. Links to Encounter.ID
RecordedDTTM
datetime
8
NULL allowed
Recorded Date and Time
PMPReasonDE
[dbo].[dict_id]
5
NOT NULL
PMP Reason. Links to PMP_Reason_DE.ID
FreeTextReason
varchar(70)
70
NULL allowed
Free text reason