SERVICE

19 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
OBJECT_ID VARCHAR2 30 null
SERVICE_ROLE.SERVICE_OBJECT_ID FK_ASS_11R

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

Relationships