Reference Guide > TDV and Business Directory System Tables > SYS_TRIGGERS
 
SYS_TRIGGERS
The SYS_TRIGGERS system table provides a list of triggers defined in the system and their current status.
Users see no rows unless they have the ACCESS_TOOLS right. If they have this right, they see rows for all resources they have READ privilege to. Users with both ACCESS_TOOLS and READ_ALL_STATUS rights can see all rows.
Column
TDV
JDBC Data Type
Nullable
Description
RESOURCE_ID
INTEGER
 
The trigger’s resource ID.
RESOURCE_NAME
VARCHAR(255)
 
The trigger’s resource name.
OWNER_ID
INTEGER
 
The trigger resource owner ID.
OWNER
VARCHAR(255)
 
The trigger resource owner name.
PARENT_PATH
VARCHAR(65535)
 
The path of the trigger resource. Field length: 65535.
PARENT_TYPE
VARCHAR(255)
 
The type of the trigger’s parent resource.
CONDITION_TYPE
VARCHAR(60)
 
The trigger’s condition type. For example, TIMER.
ACTION_TYPE
VARCHAR(60)
 
The trigger’s action type. For example, PROCEDURE.
STATUS
VARCHAR(20)
 
The trigger’s current status:
DISABLED—The trigger is disabled.
ACTIVE—The trigger is enabled.
LAST_TIME
TIMESTAMP
 
The most recent time the trigger fired.
LAST_SUCCESS
TIMESTAMP
 
The most recent time the trigger succeeded.
LAST_FAIL
TIMESTAMP
 
The most recent time the trigger failed.
NUM_TOTAL
INTEGER
 
The number of times the trigger has fired.
NUM_SUCCESS
INTEGER
 
The number of times the trigger has succeeded.
NUM_FAIL
INTEGER
 
The number of times the trigger has failed.
INITAL_TIME
TIMESTAMP
Yes
The time the trigger was configured to first start. NULL if not condition type TIMER.
NEXT_TIME
TIMESTAMP
Yes
The time the trigger will next fire. NULL if not condition type TIMER.
FREQUENCY
VARCHAR(255)
Yes
Human-readable description of the frequency of the trigger. NULL if not condition type TIMER.
MESSAGE
VARCHAR(65535)
Yes
A message about the trigger status that is often set on failure. NULL if no message is available. Field length: 65535.