Tables [dbo].[PMP_History]
documentation for Prescription Monitoring Program (PMP) Registry consultation
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDescription
Cluster Primary Key PK_PMP_History_ID: IDID[dbo].[uniqueid]9NOT NULL1 - 1Key to the PMP_History table
Indexes NIX_PMP_History_PatientIDForeign Keys FK_PMP_History_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientIDPatientID[dbo].[uniqueid]9NOT NULLPatient. Links to Person.ID
UserID[dbo].[uniqueid]9NOT NULLUser. Links to IDX_User.ID
EncounterID[dbo].[uniqueid]9NOT NULLEncounter. Links to Encounter.ID
RecordedDTTMdatetime8NULL allowedRecorded Date and Time
Foreign Keys FK_PMP_History_PMPReasonDE: [dbo].[PMP_Reason_DE].PMPReasonDEPMPReasonDE[dbo].[dict_id]5NOT NULLPMP Reason. Links to PMP_Reason_DE.ID
FreeTextReasonvarchar(70)70NULL allowedFree text reason