OTP_SIGN_INFO
Description:
The signing history for an order template.

Primary Key
Column Name Ordinal Position
OTP_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 OTP_ID NUMERIC No
The order template ID.
2 LINE INTEGER No
The line number that corresponds to each signing of the order template in this row.
3 OTP_PREAUTH_PROV_ID_PROV_NAME VARCHAR No
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
4 OTP_PREAUTH_HX_TM DATETIME (Local) No
The date/time in external format of a signing of the order template in this row.
5 ORD_SIGN_CNTXT_HX_C_NAME VARCHAR No
The context of revalidation of a signing of the order template in this row.
May contain organization-specific values: Yes
Category Entries:
Login
Other Encounters
Exam Room
Charting
Med Orders - Ambulatory and Inpatient
Addendum
Immunization
History
Procedure Orders - Ambulatory and Inpatient
Change Assoc DX
SmartSets
Meds except for reorders
Orders through Addendum
Mark letter as Sent
Cosign Orders
Sign Verbal Orders
Documentation Flowsheet
Discharge Writer
Notes
Discontinue/Cancel Order
Change Order Status from Report
Med Orders - Ambulatory
Procedure Orders - Ambulatory
Med Orders - Inpatient
Procedure Orders - Inpatient
RxRefill Request - In Basket Message (RAR)
Medication Administration
Pharmacy Enter Verification
Pharmacy Per Order Verification
E-Prescribing Pharmacy - Ambulatory
Medication Order Edit
Change Challenge Answers
Med Orders - Controlled
Pharmacy Controlled Med Verification
Pharmacy Dispense Checking
Pharmacy Compounding and Repackaging
Anesthesia User Verification
Medication Review Verification
Pharmacy Dispense Preparation
Imaging Study
Pre-Login Status Board Case Tracking
E-Prescribing Controlled Medications - First Context
E-Prescribing Controlled Medications - Second Context
Break-the-Glass
Home Care Add New Medication
Home Care Edit Medication Sig
Home Care Discontinue Medication
Rover Medication Administration
Ambulatory Pharmacy Prescription Actions
Remote Client Login
PDC Signoff
Pharmacy Intervention
Pharmacy Dispense Tracking
Minimum Data Set Signatures
Cosign Medication Orders
Cosign Procedure Orders
Sign Verbal Medications
Sign Verbal Procedures
Rover Feedings Administration
IRF Patient Assessment Instrument
Infertility Open Anonymous Chart
Standalone Staff Badge Scan
Specialty Narrator Staff Badge Scan
Chart Abstraction
Plan of Care Signatures
Enroll in Native Two Factor Authentication
PDC Waste Signoff
BMT Plan Verification
Dental Sign-Off
Rover Work List Authentication
Therapy Plan Review
Beacon Verbally Remove Orders
Beacon Sign Stage
Cancel Order Reconciliation
Anesthesia Narcotic Reconciliation First User Verification
Anesthesia Narcotic Reconciliation Second User Verification
OpTime Timeout Verification
Lab QC Report Signature
Fertility Embryology Documentation Finalize
Med Orders - Outpatient Controlled
Med Orders - Inpatient Controlled
MyChart Administrator Login
Fertility Embryology Personnel Authentication
OpTime Trigger Charges Verification
OpTime Scheduling Override Authentication
User Passive Authentication
CDA Password Verification
Authentication into Third Party
E-Signature Authentication
Willow Ambulatory Login
Ambulatory Pharmacy Security Point Actions (Login User Missing Security)
Ambulatory Pharmacy Security Point Actions
Ambulatory Pharmacy Point Of Sale Workflow Resumption
Stork Delivery Summary Sign
Clarity Console Login
Specialty Narrator Staff Sign-off
Default User
PATIENT 1
PATIENT 2
PATIENT 3
PATIENT 4
PATIENT 5
PATIENT 6
PATIENT 7
PATIENT 8
PATIENT 9
Kiosk Identification
Kiosk Verification
Hyperspace Identification
Hyperspace Verification
Hyperspace Passive Identification
Hyperspace On-Demand Identification
Hyperspace Enrollment
Kiosk Enrollment
Default Patient
E-Signature (Default)
E-Signature (Full Client)
E-Signature (Thin Client)
Haiku Login
Canto Login
Mobile Close Encounter
Canto SmartSets
Mobile Meds except for reorders
Mobile Cosign Orders
Mobile Sign Verbal Orders
Mobile Notes
Mobile Discontinue/Cancel Order
Mobile Med Orders - Ambulatory
Mobile Procedure Orders - Ambulatory
Mobile Med Orders - Inpatient
Mobile Procedure Orders - Inpatient
Mobile IP Discontinue Medication
Mobile IP Discontinue Procedure
Mobile Med Orders - Controlled
Mobile OP Discontinue Medication
Mobile Cosign Medication Orders
Mobile Cosign Procedure Orders
Mobile Sign Verbal Medications
Mobile Sign Verbal Procedures
Mobile Med Orders - Outpatient Controlled
Mobile Med Orders - Inpatient Controlled
Mobile E-Prescribing Pharmacy - Ambulatory
Mobile E-Prescribing Controlled Medications - First Context
Mobile E-Prescribing Controlled Medications - Second Context
Mobile Break-the-Glass
Epic Monitor Login
Rover Login
Mobile Change PIN
Mobile Medication Dual Sign
Default Context
EpicCare Link Login
6 ORD_SIGN_WKS_HX_ID_WORKSTATION_NAME VARCHAR No
This is the internal workstation name.
7 ORD_SIGN_RSLT_HX_C_NAME VARCHAR No
The result of validation of a signing of the order template in this row.
May contain organization-specific values: No
Category Entries:
Success
Fail
8 ORD_SIGN_DEVCE_HX_C_NAME VARCHAR No
The device used for a signing of the order template in this row.
May contain organization-specific values: Yes
9 OTP_SIGN_HX_PAT_ENC_CSN_ID NUMERIC No
Stores the history of the patient CSN that the order template was signed in.