Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
OBJECT_ID | VARCHAR2 | 30 | null |
|
|
The ID based in which the source identifies the Operation. |
||||
DESCRIPTION | VARCHAR2 | 100 | √ | null |
|
|
The full name of the Operation. |
|||
CODE | VARCHAR2 | 50 | √ | null |
|
|
The short code to be displayed as Select Value. |
|||
ACTIVE | CHAR | 1 | √ | null |
|
|
Indicates if this Operation is active or deleted. In case of false, this operation won’t be displayed among the available options of the operations to be selected from OIM |
|||
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 |
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
OPERATION_PK | Primary key | Asc | OBJECT_ID |
OPERATION__UN | Must be unique | Asc | CODE |