ROLE

664 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
OBJECT_ID VARCHAR2 30 null
PROFILE_ROLE.ROLE_OBJECT_ID FK_ASS_14R
ROLE_PROVISIONING.ROLE_OBJECT_ID FK_ASS_9R
SERVICE_ROLE.ROLE_OBJECT_ID FK_ASS_12R

The ID based in which the source identifies the Role.This value will be stored within the OIM Lookup related to the role.

DESCRIPTION VARCHAR2 100 null

The full name of the Role.

CODE VARCHAR2 50 null

The short code to be displayed.

ACTIVE CHAR 1 null

Indicates if this Role is active or deleted. In case of false this role won’t be added in the list of available roles to be displayed on OIM UI.

LAST_CHANGED TIMESTAMP(6) 11,6 null

The date and time of the last change of the record.

LONG_DESCRIPTION VARCHAR2 1000 null

Long Description for contextual help

SECURITY_LEVEL NUMBER 0 null

Indexes

Constraint Name Type Sort Column(s)
ROLE_PK Primary key Asc OBJECT_ID
ROLE__UN Must be unique Asc CODE

Relationships