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