The ARF_IU_ORG table stores data about internal organizations.

Column Name

Type

Length

Null Allowed

Description

ID

varchar

40

No

Identifier; primary key.

ORG_ID

varchar

40

No

Organization’s natural key.

NAME_EN

varchar

40

No

Name of the organization in English.

DESCRIPTION_EN

varchar

254

Yes

Description of the organization in English.

PARENT_ORG_ID

varchar

40

Yes

Identifier of the parent organization, if applicable. Foreign key to the ID column of this table.

DIR_LVL_ID

varchar

40

No

Identifies the level of this organization. Foreign key to the ID column of the ARF_IU_DIR_LVL column.

LAST_UPDATED

timestamp

No

Date this record was last updated

DELETED

numeric

1

No

Whether this record indicates deleted organization.


Copyright © 1997, 2013 Oracle and/or its affiliates. All rights reserved. Legal Notices