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