Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
PdmpViewTrackingOid | INT | NOT NULL | Object ID of PdmpViewTracking table |
PatientOid | INT | NOT NULL | References to HPatient table Object ID column |
PatientVisitOid | INT | NULL | References to HPatientVisit table Object ID column |
UserOid | INT | NOT NULL | References to HSUser table Object ID column |
LoginID | VARCHAR(100) | NOT NULL | References to HSUser table LoginID column |
StaffOid | INT | NOT NULL | References to HStaff table Object ID column |
StaffName | VARCHAR(187) | NOT NULL | Name of the staff |
PdmpSource | VARCHAR(16) | NOT NULL | Pdmp(prescription drug monitoring program) Source(allowable values: 'APPRISS' or 'DRFIRST' )(These are third party Pdmp data source) |
PdmpViewDescription | VARCHAR(30) | NOT NULL | Pdmp(prescription drug monitoring program) View Description allowable(values: 'Pdmp Scores' or 'Pdmp Report') |
PdmpViewDTime | DATETIME | NOT NULL | DateTime the Pdmp(prescription drug monitoring program) information was viewed |
RequestID | VARCHAR(64) | NOT NULL | The ID assigned to the request by Appriss or by Cerner for DrFirst |
DurationMS | INT | NOT NULL | Response time duration in milliseconds associated with the request |
LastCngDTime | DATETIME | NOT NULL | Last Updated Date Time(UTC) |