# |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
1 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
This field is used to store the value of SetID on various setup tables.
|
2 |
BO_ID_PARENT |
Number(31,0) |
DECIMAL(31) NOT NULL |
Business Object ID of the Parent Company.
|
3 |
BO_ID |
Signed Number(32,0) |
DECIMAL(31) NOT NULL |
Business Object ID
|
4 |
PARENT_NODE_NAME |
Character(20) |
VARCHAR2(20) NOT NULL |
Name of parent node
|
5 |
TREE_NODE |
Character(20) |
VARCHAR2(20) NOT NULL |
Node name
|
6 |
TREE_NODE_NUM |
Number(10,0) |
DECIMAL(10) NOT NULL |
Internal beginning node range number
|
7 |
TREE_LEVEL_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Parent tree level if this is a part of the PSTREEBRANCH record
|
8 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|