Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
AlertID | int | NOT NULL | The alert ID with which the Role_oid is mapped. |
SuggActionID | smallint | NOT NULL | The unique ID of the suggested action associated with the alert. |
SuggActionName | varchar(100) | NOT NULL | The name of the suggested action associated with the alert. |
SuggActionDesc | varchar(255) | NOT NULL | The description of the suggested action associated with the alert. |
IsMandatory | tinyint | NOT NULL | When set to True, indicates that the suggested action is mandatory and must be carried out to complete the alert. |
Executed | tinyint | NOT NULL | When set to True, indicates that the suggested action was carried out. |
ExecutedBy | int | NULL | The user ID of the user who carried out the suggested action. Allowable Values: 0 - Not executed, 1 - Executed, 2 - Inprogress. |
ExecutedDateTime | smalldatetime | NULL | The date and time when the suggested action was carried out. |
FieldValues | varchar(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. |
FieldValueLocal | tinyint | NOT NULL | When 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. |
LastCngDtime | DATETIME | NOT NULL | Current Universal Time Coordinate or Greenwich Mean Time |
|
|