11.46 idmrpt_sod_v

Catalog of separation of duties information.

sod_id

VARCHAR(32)

The unique ID of this SOD in the reporting warehouse

sod_dn

VARCHAR(255)

The DN of this SOD

sod_guid

VARCHAR(64)

The GUID of this SOD in the Identity Vault

idv_id

VARCHAR(32)

The ID of the Identity Vault containing this SOD

role_id_1

VARCHAR(32)

role_id_2

VARCHAR(32)

sod_name

VARCHAR(4000)

The name of this SOD

sod_desc

VARCHAR(4000)

The description of the SOD

sod_approval_type

int2

The approval type of this SOD

idmrpt_valid_from

TIMESTAMP WITHOUT TIME ZONE

The date this SOD became valid

idmrpt_deleted

bool

TRUE if this SOD has been deleted and FALSE otherwise

idmrpt_syn_state

int2

The sync state of this SOD

custom_appr

bool

TRUE if this SOD is a custom approval type and false otherwise