Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HOrdLevelOfCareTransition This table tracks the user action when Transfer level of Care(TLC) workflow is initiated on the Clinical UI
Column Name Column Datatype Column Null Option Column Comment
PatientOIDINTNOT NULL Internal Patient Identifier. ObjectID of Patient(HPatient table)
VisitOIDINTNOT NULL Internal Visit Identifier. ObjectID of Patient's visit(HPatientVisit table)
OrderSessionIDINTNULL unique Identifier of the TLC ordering session in which the Order was processed for Transfer level of care
OrderSessionTypeCHAR(3)NOT NULL Values always as 'TLC'
LevelOfCareActionCHAR(3)NOT NULL What kind of action was initiated during TLC workflow
Allowable Values:
INI - Initiated. When user clicks on the TLC link in Orders Tasckard to launch TLC worflow
PER - Performed. When user puts orders to continue/discontinue in TLC session
ActionByUserOIDINTNOT NULL ObjectID of the user(HSUser) who performed the Action
ActionDateTimeSMALLDATETIMENOT NULLDateTime at which the Action was performed.

Return to Table-Index

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