Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
HRESuggestedAction This table stores information related to the suggested actions for Alerts.
Column Name Column Datatype Column Null Option Column Comment
AlertIDintNOT NULL The alert ID with which the Role_oid is mapped.
SuggActionIDsmallintNOT NULL The unique ID of the suggested action associated with the alert.
SuggActionNamevarchar(100)NOT NULL The name of the suggested action associated with the alert.
SuggActionDescvarchar(255)NOT NULL The description of the suggested action associated with the alert.
IsMandatorytinyintNOT NULL When set to True, indicates that the suggested action is mandatory and must be carried out to complete the alert.
ExecutedtinyintNOT NULL When set to True, indicates that the suggested action was carried out.
ExecutedByintNULL The user ID of the user who carried out the suggested action. Allowable Values: 0 - Not executed, 1 - Executed, 2 - Inprogress.
ExecutedDateTimesmalldatetimeNULL The date and time when the suggested action was carried out.
FieldValuesvarchar(2000)NULL The value of the field in the record. This field is populated if the value of the field in the record is less than 2000 bytes. This field is added to avoid a call to the HRESuggestedActionField table and thus increase the application performance.
FieldValueLocaltinyintNOT NULLWhen set to 1, indicates that the values are available in this table. When set to 0, indicates that the HRESuggestedActionField table needs to be queried.
LastCngDtimeDATETIMENOT NULLCurrent Universal Time Coordinate or Greenwich Mean Time

Return to Table-Index

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