Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HTBEventLog This table holds a log of milestone events recorded for each visit.
Column Name Column Datatype Column Null Option Column Comment
TBEventLogOidINTNOT NULL This is the unique ID of the milestone event log item.
PatientVisitOidINTNOT NULL This is a foreign key to HPatientVisit.
TBVisitOidINTNOT NULL This is a foreign key to HTBVisit.
TBVisitStatusSMALLINTNOT NULL This is a foreign key to HTBVisit, it indicates the status of this visit. Allowable values: 0 - active, 1 - ended.
AutoUpdateKeyTypeVARCHAR(40)NULL This is the ED Auto-Update key type to support certain milestones that require updating. This field identifies what type of information is stored in the AutoUpdateKeyValue field.
AutoUpdateKeyValueVARCHAR(40)NULL This is the ED Auto-Update key to support certain milestones that require updating. This is the state information that identifies the original Soarian event that caused this patient event to be saved.
EventNameVARCHAR(40)NOT NULL This is the name of the milestone event item, as defined in the HTBEventDefinitionTable.
TriggerNameVARCHAR(64)NOT NULL This is the name of the trigger item, as defined in the HTBEventTriggerDefinitionTable.
EventDateTimeDATETIMENOT NULL This indicates the date/time of the milestone event occurrence.
EventLogUpdatedByUserOidINTNULL This is the user object ID of the user who added/updated the milestone event log item.
EventLogUpdatedByLoginIdVARCHAR(100)NULL This is the user name of the user who added/updated milestone event log item.
EventLogManuallyUpdatedSMALLINTNOT NULL This is the flag indicating if the milestone event log item is manually updated, so automatic updates should not be applied.
CreateDTimeMinsSMALLDATETIMENOT NULL This indicates the date/time when the milestone event log was created/started.
LastCngDtimeDATETIMENOT NULL This indicates the current Universal Time Coordinate or Greenwich Mean Time.

Return to Table-Index

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