| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 2 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 3 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
|
| 4 |
SETID_TREE |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 5 |
SETCNTRLVALUE |
Character(20) |
VARCHAR2(20) NOT NULL |
Tree Definition User Key Value
|
| 6 |
TREE_NAME_OTBI |
Character(30) |
VARCHAR2(30) NOT NULL |
Tree Name
|
| 7 |
TREE_NAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Tree Name
|
| 8 |
TREE_EFFDT |
Date(10) |
DATE |
Effective date of the Tree
|
| 9 |
FIELD_DESC |
Character(30) |
VARCHAR2(30) NOT NULL |
Field Description
|
| 10 |
TLVL1 |
Character(10) |
VARCHAR2(10) NOT NULL |
OTBI: Tree Level Number
|
| 11 |
TLVL1_DESC |
Character(30) |
VARCHAR2(30) NOT NULL |
OTBI: Tree Level Description
|
| 12 |
TNODE1 |
Character(20) |
VARCHAR2(20) NOT NULL |
OTBI: Node name
|
| 13 |
TNODE1_DESC |
Character(30) |
VARCHAR2(30) NOT NULL |
OTBI: Tree Node Description
|
| 14 |
TLVL2 |
Character(10) |
VARCHAR2(10) NOT NULL |
OTBI: Tree Level Number
|
| 15 |
TLVL2_DESC |
Character(30) |
VARCHAR2(30) NOT NULL |
OTBI: Tree Level Description
|
| 16 |
TNODE2 |
Character(20) |
VARCHAR2(20) NOT NULL |
OTBI: Node name
|
| 17 |
TNODE2_DESC |
Character(30) |
VARCHAR2(30) NOT NULL |
OTBI: Tree Node Description
|
| 18 |
TLVL3 |
Character(10) |
VARCHAR2(10) NOT NULL |
OTBI: Tree Level Number
|
| 19 |
TLVL3_DESC |
Character(30) |
VARCHAR2(30) NOT NULL |
OTBI: Tree Level Description
|
| 20 |
TNODE3 |
Character(20) |
VARCHAR2(20) NOT NULL |
OTBI: Node name
|
| 21 |
TNODE3_DESC |
Character(30) |
VARCHAR2(30) NOT NULL |
OTBI: Tree Node Description
|
| 22 |
TLVL4 |
Character(10) |
VARCHAR2(10) NOT NULL |
OTBI: Tree Level Number
|
| 23 |
TLVL4_DESC |
Character(30) |
VARCHAR2(30) NOT NULL |
OTBI: Tree Level Description
|
| 24 |
TNODE4 |
Character(20) |
VARCHAR2(20) NOT NULL |
OTBI: Node name
|
| 25 |
TNODE4_DESC |
Character(30) |
VARCHAR2(30) NOT NULL |
OTBI: Tree Node Description
|
| 26 |
TLVL5 |
Character(10) |
VARCHAR2(10) NOT NULL |
OTBI: Tree Level Number
|
| 27 |
TLVL5_DESC |
Character(30) |
VARCHAR2(30) NOT NULL |
OTBI: Tree Level Description
|
| 28 |
TNODE5 |
Character(20) |
VARCHAR2(20) NOT NULL |
OTBI: Node name
|
| 29 |
TNODE5_DESC |
Character(30) |
VARCHAR2(30) NOT NULL |
OTBI: Tree Node Description
|
| 30 |
TLVL6 |
Character(10) |
VARCHAR2(10) NOT NULL |
OTBI: Tree Level Number
|
| 31 |
TLVL6_DESC |
Character(30) |
VARCHAR2(30) NOT NULL |
OTBI: Tree Level Description
|
| 32 |
TNODE6 |
Character(20) |
VARCHAR2(20) NOT NULL |
OTBI: Node name
|
| 33 |
TNODE6_DESC |
Character(30) |
VARCHAR2(30) NOT NULL |
OTBI: Tree Node Description
|
| 34 |
TLVL7 |
Character(10) |
VARCHAR2(10) NOT NULL |
OTBI: Tree Level Number
|
| 35 |
TLVL7_DESC |
Character(30) |
VARCHAR2(30) NOT NULL |
OTBI: Tree Level Description
|
| 36 |
TNODE7 |
Character(20) |
VARCHAR2(20) NOT NULL |
OTBI: Node name
|
| 37 |
TNODE7_DESC |
Character(30) |
VARCHAR2(30) NOT NULL |
OTBI: Tree Node Description
|
| 38 |
TLVL8 |
Character(10) |
VARCHAR2(10) NOT NULL |
OTBI: Tree Level Number
|
| 39 |
TLVL8_DESC |
Character(30) |
VARCHAR2(30) NOT NULL |
OTBI: Tree Level Description
|
| 40 |
TNODE8 |
Character(20) |
VARCHAR2(20) NOT NULL |
OTBI: Node name
|
| 41 |
TNODE8_DESC |
Character(30) |
VARCHAR2(30) NOT NULL |
OTBI: Tree Node Description
|
| 42 |
TLVL9 |
Character(10) |
VARCHAR2(10) NOT NULL |
OTBI: Tree Level Number
|
| 43 |
TLVL9_DESC |
Character(30) |
VARCHAR2(30) NOT NULL |
OTBI: Tree Level Description
|
| 44 |
TNODE9 |
Character(20) |
VARCHAR2(20) NOT NULL |
OTBI: Node name
|
| 45 |
TNODE9_DESC |
Character(30) |
VARCHAR2(30) NOT NULL |
OTBI: Tree Node Description
|
| 46 |
TLVL10 |
Character(10) |
VARCHAR2(10) NOT NULL |
OTBI: Tree Level Number
|
| 47 |
TLVL10_DESC |
Character(30) |
VARCHAR2(30) NOT NULL |
OTBI: Tree Level Description
|
| 48 |
TNODE10 |
Character(20) |
VARCHAR2(20) NOT NULL |
OTBI: Node name
|
| 49 |
TNODE10_DESC |
Character(30) |
VARCHAR2(30) NOT NULL |
OTBI: Tree Node Description
|
| 50 |
TLVL11 |
Character(10) |
VARCHAR2(10) NOT NULL |
OTBI: Tree Level Number
|
| 51 |
TLVL11_DESC |
Character(30) |
VARCHAR2(30) NOT NULL |
OTBI: Tree Level Description
|
| 52 |
TNODE11 |
Character(20) |
VARCHAR2(20) NOT NULL |
OTBI: Node name
|
| 53 |
TNODE11_DESC |
Character(30) |
VARCHAR2(30) NOT NULL |
OTBI: Tree Node Description
|
| 54 |
TLVL12 |
Character(10) |
VARCHAR2(10) NOT NULL |
OTBI: Tree Level Number
|
| 55 |
TLVL12_DESC |
Character(30) |
VARCHAR2(30) NOT NULL |
OTBI: Tree Level Description
|
| 56 |
TNODE12 |
Character(20) |
VARCHAR2(20) NOT NULL |
OTBI: Node name
|
| 57 |
TNODE12_DESC |
Character(30) |
VARCHAR2(30) NOT NULL |
OTBI: Tree Node Description
|
| 58 |
TLVL13 |
Character(10) |
VARCHAR2(10) NOT NULL |
OTBI: Tree Level Number
|
| 59 |
TLVL13_DESC |
Character(30) |
VARCHAR2(30) NOT NULL |
OTBI: Tree Level Description
|
| 60 |
TNODE13 |
Character(20) |
VARCHAR2(20) NOT NULL |
OTBI: Node name
|
| 61 |
TNODE13_DESC |
Character(30) |
VARCHAR2(30) NOT NULL |
OTBI: Tree Node Description
|
| 62 |
TLVL14 |
Character(10) |
VARCHAR2(10) NOT NULL |
OTBI: Tree Level Number
|
| 63 |
TLVL14_DESC |
Character(30) |
VARCHAR2(30) NOT NULL |
OTBI: Tree Level Description
|
| 64 |
TNODE14 |
Character(20) |
VARCHAR2(20) NOT NULL |
OTBI: Node name
|
| 65 |
TNODE14_DESC |
Character(30) |
VARCHAR2(30) NOT NULL |
OTBI: Tree Node Description
|
| 66 |
TLVL15 |
Character(10) |
VARCHAR2(10) NOT NULL |
OTBI: Tree Level Number
|
| 67 |
TLVL15_DESC |
Character(30) |
VARCHAR2(30) NOT NULL |
OTBI: Tree Level Description
|
| 68 |
TNODE15 |
Character(20) |
VARCHAR2(20) NOT NULL |
OTBI: Node name
|
| 69 |
TNODE15_DESC |
Character(30) |
VARCHAR2(30) NOT NULL |
OTBI: Tree Node Description
|
| 70 |
OTBI_SRC_INSTANCE |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
OTBI Process Instance
|