SOD_VIOLATION_STATUS table

Edit online

The SOD_VIOLATION_STATUS1 table stores current information about exemptions and violations for a separation of duty policy.

Table 1. SOD_VIOLATION_STATUS table
Column Name Description Data type
ID* Unique ID for this record of separation of duty violation. Primary key. Numeric
POLICY_GLOBAL_ID* The global identifier of the separation of duty policy in LDAP to which this record refers. Numeric
RULE_GLOBAL_ID* The global identifier of the separation of duty policy rule in LDAP to which this record refers. Numeric
PERSON_GLOBAL_ID* The global identifier of the person to which this violation refers in LDAP this record. Numeric
PERSON_NAME Name of the person to which this violation refers. Character (256)
PERSON_BU Name of the business unit of the person in PERSON_DN. Character (256)
PERSON_DN DN to the person record as specified in the IBM Verify Identity Governance LDAP store. Character (2000)
PROCESS_ID The associated workflow process ID that changed the state of this violation. It might not have a value if the violation was discovered by policy evaluation or exemption administration through the administrative console. Numeric
ADMIN_NAME Name of the person who revoked or exempted this violation. Character (256)
ADMIN_BU Name of the business unit of the person in ADMIN_DN. Character (256)
ADMIN_DN DN to the person record who revoked or exempted this violation as specified in the IBM Verify Identity Governance LDAP store. Character (2000)
ADMIN_NOTES Justification notes (text) that the person in column ADMIN_DN entered at time of revoke/exempt of violation. Character
STATUS The state of this record about a violation or exemption. Valid values are:

Violation (V)

Exemption (A)

 Character (1)
TS* Timestamp when the action recorded in this record occurred. Numeric
EVAL_TS* Timestamp when this violation was last known to be true during sod policy evaluation. Numeric

* Indicates the column is required and not null.

1 Indicates the table is added in release 5.1.