Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HUserPatientUnlock Contains user/staff information for the locked patient
Column Name Column Datatype Column Null Option Column Comment
User_OIDintNOT NULL Holds user object id necessary to access table for non-staff users.
Staff_oidintNULL Holds staff object id of staff who unlocked a patient.
Patient_oidintNOT NULL Holds patient object ID of lockbox patient unlocked by indicated Staff_OID or User_OID
CreationDTimesmalldatetimeNOT NULL Date and time when patient was unlocked for the user.

Return to Table-Index

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