Previous Topic: OBJECT_CLASSNext Topic: PAD_CREATE


ORGANIZAT_UNIT

The following table details various column names along with their descriptions.

Col

Column Name

Len

Coltype

Description

1

MODEL_ID

4

INTEGER

ID of the containing model

2

TBNAME

16

CHAR

ORGANIZAT_UNIT

3

ID

4

INTEGER

Unique identifier

4

ORG_ID

4

INTEGER

Original object identifier

5

NAME

32

VARCHAR

Name of the organizational unit

6

SEQ

2

SMALLINT

Sequence within matrix.

Use ORDER_BY_SEQ to return the organizations in the same order as specified in the toolset.

7

WILLBE_SEQ

4

INTEGER

Sequence that will be within matrix.

Use ORDER_BY_SEQ to return the organizational units in the same order as specified in the toolset (will be used in a future release).

8

MANAGER_NAME

32

VARCHAR

Name of manager

9

MANAGER_TITLE

32

VARCHAR

Title of manager

10

STATUS

1

CHAR

Organization Status:

  • C (Current)
  • P (Planned)

11

PARENT_ORG_ID

4

INTEGER

ID of the parent organizational unit.

Join with ORGANIZAT_UNIT.

12

PARENT_
WILLBE_ID

4

INTEGER

ID of organizational unit. Join with ORGANIZAT_UNIT.

Zero for the root organizational unit (will be used in future release).