The ARF_IU_DIR_LVL table stores the levels of the hierarchy. By default, there are ten levels to which organizations can be assigned.

Column Name

Type

Length

Null Allowed

Description

ID

varchar

40

No

Identifier; primary key.

NAME_EN

varchar

40

No

Level name in English.

DPTH

smallint

No

Identifies the level’s depth.

PARENT_ID

varchar

40

Yes

Parent level of this level, if applicable. Foreign key to the ID column of this table.


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