| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
TREE_EVENT_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Tree Event Id
|
| 2 |
EVENTNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Defines a routing event for PS Workflow
|
| 3 |
SETID_OLD |
Character(5) |
VARCHAR2(5) NOT NULL |
Old SetID
|
| 4 |
SETCNTRLVALUE_OLD |
Character(20) |
VARCHAR2(20) NOT NULL |
Old User Key value for TREE_CHANGE PubSub message
|
| 5 |
TREE_NAME_OLD |
Character(18) |
VARCHAR2(18) NOT NULL |
Old Tree Name for TREE_CHANGE PubSub message
|
| 6 |
EFFDT_OLD |
Date(10) |
DATE NOT NULL |
Old Effective Date
|
| 7 |
TREE_BRANCH_OLD |
Character(20) |
VARCHAR2(20) NOT NULL |
Tree Branch Old
|
| 8 |
SETID_NEW |
Character(5) |
VARCHAR2(5) NOT NULL |
New SetID
|
| 9 |
SETCNTRLVALUE_NEW |
Character(20) |
VARCHAR2(20) NOT NULL |
New User Key value for TREE_CHANGE PubSub message
|
| 10 |
TREE_NAME_NEW |
Character(18) |
VARCHAR2(18) NOT NULL |
New Tree Name for TREE_CHANGE PubSub message
|
| 11 |
EFFDT_NEW |
Date(10) |
DATE NOT NULL |
New Effective Date
|
| 12 |
TREE_BRANCH_NEW |
Character(20) |
VARCHAR2(20) NOT NULL |
Tree Branch New
|
| 13 |
TREE_STRCT_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Tree Structure Name (see PSTREESTRCT).
|