| PeopleSoft Field Name |
Field Type |
Column Type |
Description |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| FUNCLIB |
Character(1) |
VARCHAR2(1) NOT NULL |
Function Library
|
| LOCK_ACQUIRED |
Character(1) |
VARCHAR2(1) NOT NULL |
Lock Acquired
Y/N Table Edit
Default: N
|
| VERSION_UPDATED |
Character(1) |
VARCHAR2(1) NOT NULL |
Version Number Updated
|
| ABORT_PROCESS_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Abort Processing Flag
|
| VERSION |
Number(10,0) |
DECIMAL(10) NOT NULL |
Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
|
| RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| TREE_UTILITY_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Tree Utility
00=Tree Audits
01=Correct Parent Node Numbers
02=Reset Tree Node Gaps
03=Correct Level Numbers
04=Delete Orphan Tree Objects
05=Remove Tree Branches
06=Update Tree Table Statistics
07=Remove Tree Reservations
|
| ALL_TREES_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
All Trees
Y/N Table Edit
Default: N
|
| REPORT_ONLY_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Report Only
Y/N Table Edit
Default: N
|
| ALLOW_SKIP_LEVELS |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Skip Levels
Y/N Table Edit
Default: N
|
| SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| SETCNTRLVALUE |
Character(20) |
VARCHAR2(20) NOT NULL |
Tree Definition User Key Value
|
| TREE_NAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Tree Name
|
| EFFDT |
Date(10) |
DATE |
Effective Date
|
| TREE_BRANCH |
Character(20) |
VARCHAR2(20) NOT NULL |
Tree Branch
|
| VALID_TREE |
Character(1) |
VARCHAR2(1) NOT NULL |
Valid Tree
N=Draft Tree
Y=Valid Tree
|
| FIRST_CHILD_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
First Child
|
| NODE_COUNT |
Number(10,0) |
DECIMAL(10) NOT NULL |
Tree Definition Node Count
|
| TREE_MAX_NODE_NUM |
Number(10,0) |
DECIMAL(10) NOT NULL |
Maximum Node Number
|
| TREE_GAP_SIZE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Tree Gap Size
|
| TREE_NODE |
Character(20) |
VARCHAR2(20) NOT NULL |
Node name
|
| TREE_NODE_NUM |
Number(10,0) |
DECIMAL(10) NOT NULL |
Internal beginning node range number
|
| TREE_NODE_NUM_END |
Number(10,0) |
DECIMAL(10) NOT NULL |
Internal ending node range number
|
| NEW_TREE_NODE_NUM |
Number(10,0) |
DECIMAL(10) NOT NULL |
Internal beginning node range number
|
| OLD_PARENT_NODE |
Character(20) |
VARCHAR2(20) NOT NULL |
Parent Node Name
|
| OLD_PARENT_NUM |
Number(10,0) |
DECIMAL(10) NOT NULL |
Old Parent Node Num
|
| ROOT_NODE_NUM |
Number(10,0) |
DECIMAL(10) NOT NULL |
Root Node Number
|
| PARENT_NODE_NUM |
Number(10,0) |
DECIMAL(10) NOT NULL |
Parent Node Number
|
| PARENT_NODE_END |
Number(10,0) |
DECIMAL(10) NOT NULL |
Parent Node End Number
|
| PARENT_NODE_NAME |
Character(20) |
VARCHAR2(20) NOT NULL |
Name of parent node
|
| BASE_NODE_END |
Number(10,0) |
DECIMAL(10) NOT NULL |
Base Node End Number
|
| NODE_INDEX |
Number(10,0) |
DECIMAL(10) NOT NULL |
Internal beginning node range number
|
| LEVELS |
Number(3,0) |
SMALLINT NOT NULL |
Number of Levels
|
| TREE_LEVEL_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Parent tree level if this is a part of the PSTREEBRANCH record
|
| PARENT_LEVEL_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Parent tree level if this is a part of the PSTREEBRANCH record
|
| NEW_LEVEL_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Parent tree level if this is a part of the PSTREEBRANCH record
|
| RANGE_FROM |
Character(30) |
VARCHAR2(30) NOT NULL |
Lower boundary for detail value that contains a range of values
|
| RANGE_TO |
Character(30) |
VARCHAR2(30) NOT NULL |
Upper boundary for detail value that contains a range of values
|
| MESSAGE_SET_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Set Number. This field refers to the Message Set Number in the Message Catalog.
|
| MESSAGE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
|
| TOTAL_ROW_COUNT |
Number(8,0) |
INTEGER NOT NULL |
Total Row Count
|
| RANGE_FROM_PREV |
Character(30) |
VARCHAR2(30) NOT NULL |
Previous range from value
|
| RANGE_TO_PREV |
Character(30) |
VARCHAR2(30) NOT NULL |
Range To
|
| RANGE_FROM_30 |
Character(30) |
VARCHAR2(30) NOT NULL |
Range From
|
| ALL_VALUES |
Character(1) |
VARCHAR2(1) NOT NULL |
Tree Level All Values flag
|
| DUPLICATE_LEAF |
Character(1) |
VARCHAR2(1) NOT NULL |
Tree Definition allow duplicate leaf flag
|
| TREEEDITSTATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Tree Reservation Status
E=Editable
N=Not Used
R=Reserved
U=UnReserved
Default: N
|
| AUDIT_ASOFDATE |
Character(1) |
VARCHAR2(1) NOT NULL |
As of Date Operator
A=All Trees
C=As of Current Date
E=Effective Date of Tree
S=As of Specific Date
|
| TREE_AUDIT_SCOPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Audit Scope
M=Multiple Trees
S=Single Tree
|
| ASOFDATE |
Date(10) |
DATE |
As of Date
|
| AE_APPLID |
Character(12) |
VARCHAR2(12) NOT NULL |
Program Name (see PSAEAPPLDEFN).
|
| AE_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
Section
|
| AE_APPSTATUS |
Number(1,0) |
SMALLINT NOT NULL |
AE Application Warning Status
|
| SQLTEXT |
Long Character(14000) |
CLOB |
SQL Statement Text
|