| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID_TREE |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 2 |
SETCNTRLVALUE |
Character(20) |
VARCHAR2(20) NOT NULL |
Tree Definition User Key Value
|
| 3 |
TREE_NAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Tree Name
|
| 4 |
TREE_EFFDT |
Date(10) |
DATE |
Effective date of the Tree
|
| 5 |
FIELD_DESC |
Character(30) |
VARCHAR2(30) NOT NULL |
Field Description
|
| 6 |
TLVL1 |
Character(10) |
VARCHAR2(10) NOT NULL |
OTBI: Tree Level Number
|
| 7 |
TLVL1_DESC |
Character(30) |
VARCHAR2(30) NOT NULL |
OTBI: Tree Level Description
|
| 8 |
TNODE1 |
Character(20) |
VARCHAR2(20) NOT NULL |
OTBI: Node name
|
| 9 |
TNODE1_DESC |
Character(30) |
VARCHAR2(30) NOT NULL |
OTBI: Tree Node Description
|
| 10 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 11 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 12 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
|
| 13 |
OTBI_SRC_INSTANCE |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
OTBI Process Instance
|