Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HTBEventDefinition This table contains the definition of milestone events such as: Patient Arrival, Triage Start, etc.
Column Name Column Datatype Column Null Option Column Comment
EventNameVARCHAR(40)NOT NULL This is the name of the milestone event item.
EventShortDescVARCHAR(64)NOT NULL This is a short description of the milestone event for display on the user interface.
EventDescVARCHAR(128)NOT NULL This is a description of the milestone event item.
SendToDisplaySMALLINTNOT NULL This is the flag indicating that the milestone event item is to be displayed on the Tracking Board. Allowable Values: 0 - No, 1 - Yes.
SendToReportSMALLINTNOT NULL This is the flag indicating that the milestone event item is to be saved in the Event Log table for reports. Allowable Values: 0 - No, 1 - Yes.
CreateDTimeMinsSMALLDATETIMENOT NULL This indicates the date/time when the milestone event item 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