11.48 idmrpt_approval_v

Information about the approval activities for resource and role assignments as well as separation of duties exceptions.

approval_id

VARCHAR(32)

identity_id

VARCHAR(32)

item_type_id

VARCHAR(32)

item_id

VARCHAR(32)

approval_date

TIMESTAMP WITH TIME ZONE

approval_type

int2

approval type; grant? 1, revoke 2, grant & revoke 3

action

VARCHAR(16)

idmrpt_valid_from

TIMESTAMP WITHOUT TIME ZONE

idmrpt_deleted

bool

idmrpt_syn_state

int2