ORGANIZATION

593 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
OBJECT_ID VARCHAR2 30 null
OPERATION_ORGANIZATION.ORGANIZATION_OBJECT_ID FK_ASS_6R
ORGANIZATION_PARENT.ORGANIZATION_ID ORG_PARENT_ORGANIZATION_FKR
ORGANIZATION_PARENT.PARENT_ID ORG_PARENT_ORGANIZATION_FKV1R
PROFILE_ORGANIZATION.ORGANIZATION_OBJECT_ID FK_ASS_8R

The ID based in which the source identifies the Organization.

DESCRIPTION VARCHAR2 100 null

The full name of the Organization. To be displayed as Select Value

COUNTRY_ID VARCHAR2 30 null
COUNTRY.OBJECT_ID ORGANIZATION_COUNTRY_FKR

The ID of the Country that this Organization belongs to.

CODE VARCHAR2 50 null

A short code which is retrieved from the COD Web Services and matches with the organizationID

ACTIVE CHAR 1 null

Indicates if this Organization is active or deleted. In case of false, the Organization won’t be displayed among the available options of the Organization in OIM

LAST_CHANGED TIMESTAMP(6) 11,6 null

The date and time of the last change of the record.

Indexes

Constraint Name Type Sort Column(s)
ORGANIZATION_PK Primary key Asc OBJECT_ID
ORGANIZATION__UN Must be unique Asc CODE

Relationships