Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HTBEventTriggerDefinition This table contains the definition of milestone event triggers.
Column Name Column Datatype Column Null Option Column Comment
TriggerNameVARCHAR(64)NOT NULL This is the name of the trigger item.
TriggerDescVARCHAR(128)NOT NULL This is the description of the trigger item.
CriteriaRequired1SMALLINTNOT NULL This is the flag indicating whether the first filtering criterion is required.
CriteriaRequired2SMALLINTNOT NULL This is the flag indicating whether the second filtering criterion is required.
CriteriaRequired3SMALLINTNOT NULL This is the flag indicating whether the third filtering criterion is required.
CriteriaDisplayLabel1VARCHAR(64)NULL This is the label to display on the configuration page for the first criteria field.
CriteriaDisplayLabel2VARCHAR(64)NULL This is the label to display on the configuration page for the second criteria field.
CriteriaDisplayLabel3VARCHAR(64)NULL This is the label to display on the configuration page for the third criteria field.
CriteriaType1VARCHAR(20)NULL This is the type of the first filtering criteria field. For example: 'INDICATORS', 'CODED_TEXTS' or 'SERVICE_TYPES'
CriteriaType2VARCHAR(20)NULL This is the type of the second filtering criteria field. For example: 'INDICATORS', 'CODED_TEXTS' or 'SERVICE_TYPES'
CriteriaType3VARCHAR(20)NULL This is the type of the third filtering criteria field. For example: 'INDICATORS', 'CODED_TEXTS' or 'SERVICE_TYPES'
CreateDTimeMinsSMALLDATETIMENOT NULL This is the date/time when the event trigger 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