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:
|
|
11 |
PARENT_ORG_ID |
4 |
INTEGER |
ID of the parent organizational unit. Join with ORGANIZAT_UNIT. |
|
12 |
PARENT_ |
4 |
INTEGER |
ID of organizational unit. Join with ORGANIZAT_UNIT. Zero for the root organizational unit (will be used in future release). |
|
Copyright © 2013 CA.
All rights reserved.
|
|