PROFILE

614 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
OBJECT_ID VARCHAR2 30 null
PROFILE_ORGANIZATION.PROFILE_OBJECT_ID FK_ASS_7R
PROFILE_ROLE.PROFILE_OBJECT_ID FK_ASS_13R

The Id based in which the source identifies the Profile. This value will be stored within the OIM Lookup related to the profile.

DESCRIPTION VARCHAR2 100 null

The full name of the Profile.

CODE VARCHAR2 50 null

The code to be displayed as Select Value. This value will be stored within the OIM Lookup related to the profile.

ACTIVE CHAR 1 null

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

HUMAN_SYSTEM CHAR 1 null

Indicates whether the role is human or not.

LAST_CHANGED TIMESTAMP(6) 11,6 null

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

SECURITY_LEVEL NUMBER 0 null

The security level that corresponds to the profile.

LONG_DESCRIPTION VARCHAR2 1000 null

Long description for contextual help

Indexes

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

Relationships