PeopleSoft Field Name |
Field Type |
Column Type |
Description |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
TREE_NAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Tree Name
|
TREE_EFFDT |
Date(10) |
DATE |
Effective date of the Tree
|
SETCNTRLVALUE |
Character(20) |
VARCHAR2(20) NOT NULL |
Tree Definition User Key Value
|
TREE_BRANCH |
Character(20) |
VARCHAR2(20) NOT NULL |
Tree Branch
|
TREE_NODE |
Character(20) |
VARCHAR2(20) NOT NULL |
Node name
|
PDF_OPTIONS |
Character(20) |
VARCHAR2(20) NOT NULL |
PDF Options
|