Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
OBJECT_ID | VARCHAR2 | 30 | null |
|
|
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 |