Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
OBJECT_ID | VARCHAR2 | 30 | null |
|
|
The ID based in which the source identifies the Service. |
||||
CODE | VARCHAR2 | 50 | √ | null |
|
|
The short code to be displayed as Select Value |
|||
DESCRIPTION | VARCHAR2 | 100 | √ | null |
|
|
The full name of the Service. |
|||
ACTIVE | CHAR | 1 | √ | null |
|
|
Indicates if this Service is active or deleted. In case of false, the service won’t be displayed among the available options of the list of services to be selected from OIM. |
|||
LAST_CHANGED | TIMESTAMP(6) | 11,6 | √ | null |
|
|
The date and time of the last change of the record in the Staging Database. |
|||
LONG_DESCRIPTION | VARCHAR2 | 1000 | √ | null |
|
|
Long description for contextual help |
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
SERVICE_PK | Primary key | Asc | OBJECT_ID |
SERVICE_CODE_UN | Must be unique | Asc | CODE |
Check Constraints
Constraint Name | Constraint |
---|---|
NNC_SERVICE_OBJECT_ID | "OBJECT_ID" IS NOT NULL |