Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
PdmpViewTracking This table stores the PDMP (prescription drug monitoring program) view information. A record will be added to this table every time a user views PDMP data.
Column Name Column Datatype Column Null Option Column Comment
PdmpViewTrackingOidINTNOT NULL Object ID of PdmpViewTracking table
PatientOidINTNOT NULL References to HPatient table Object ID column
PatientVisitOidINTNULL References to HPatientVisit table Object ID column
UserOidINTNOT NULL References to HSUser table Object ID column
LoginIDVARCHAR(100)NOT NULL References to HSUser table LoginID column
StaffOidINTNOT NULL References to HStaff table Object ID column
StaffNameVARCHAR(187)NOT NULL Name of the staff
PdmpSourceVARCHAR(16)NOT NULL Pdmp(prescription drug monitoring program) Source(allowable values: 'APPRISS' or 'DRFIRST' )(These are third party Pdmp data source)
PdmpViewDescriptionVARCHAR(30)NOT NULL Pdmp(prescription drug monitoring program) View Description allowable(values: 'Pdmp Scores' or 'Pdmp Report')
PdmpViewDTimeDATETIMENOT NULL DateTime the Pdmp(prescription drug monitoring program) information was viewed
RequestIDVARCHAR(64)NOT NULL The ID assigned to the request by Appriss or by Cerner for DrFirst
DurationMSINTNOT NULL Response time duration in milliseconds associated with the request
LastCngDTimeDATETIMENOT NULL Last Updated Date Time(UTC)

Return to Table-Index

  Soarian Clinicals Schema Documentation  
Copyright © 2023, Oracle and/or its affiliates