| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 3 |
FUNCLIB |
Character(1) |
VARCHAR2(1) NOT NULL |
Function Library
|
| 4 |
LOCK_ACQUIRED |
Character(1) |
VARCHAR2(1) NOT NULL |
Lock Acquired
Y/N Table Edit
Default Value: N
|
| 5 |
VERSION_UPDATED |
Character(1) |
VARCHAR2(1) NOT NULL |
Version Number Updated
|
| 6 |
ABORT_PROCESS_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Abort Processing Flag
|
| 7 |
VERSION |
Number(10,0) |
DECIMAL(10) NOT NULL |
Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
|
| 8 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 9 |
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
|
| 10 |
ALL_TREES_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
All Trees
Y/N Table Edit
Default Value: N
|
| 11 |
REPORT_ONLY_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Report Only
Y/N Table Edit
Default Value: N
|
| 12 |
ALLOW_SKIP_LEVELS |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Skip Levels
Y/N Table Edit
Default Value: N
|
| 13 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 14 |
SETCNTRLVALUE |
Character(20) |
VARCHAR2(20) NOT NULL |
Tree Definition User Key Value
|
| 15 |
TREE_NAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Tree Name
|
| 16 |
EFFDT |
Date(10) |
DATE |
Effective Date
|
| 17 |
TREE_BRANCH |
Character(20) |
VARCHAR2(20) NOT NULL |
Tree Branch
|
| 18 |
VALID_TREE |
Character(1) |
VARCHAR2(1) NOT NULL |
Valid Tree
N=Draft Tree
Y=Valid Tree
|
| 19 |
FIRST_CHILD_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
First Child
|
| 20 |
NODE_COUNT |
Number(10,0) |
DECIMAL(10) NOT NULL |
Tree Definition Node Count
|
| 21 |
TREE_MAX_NODE_NUM |
Number(10,0) |
DECIMAL(10) NOT NULL |
Maximum Node Number
|
| 22 |
TREE_GAP_SIZE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Tree Gap Size
|
| 23 |
TREE_NODE |
Character(20) |
VARCHAR2(20) NOT NULL |
Node name
|
| 24 |
TREE_NODE_NUM |
Number(10,0) |
DECIMAL(10) NOT NULL |
Internal beginning node range number
|
| 25 |
TREE_NODE_NUM_END |
Number(10,0) |
DECIMAL(10) NOT NULL |
Internal ending node range number
|
| 26 |
NEW_TREE_NODE_NUM |
Number(10,0) |
DECIMAL(10) NOT NULL |
Internal beginning node range number
|
| 27 |
OLD_PARENT_NODE |
Character(20) |
VARCHAR2(20) NOT NULL |
Parent Node Name
|
| 28 |
OLD_PARENT_NUM |
Number(10,0) |
DECIMAL(10) NOT NULL |
Old Parent Node Num
|
| 29 |
ROOT_NODE_NUM |
Number(10,0) |
DECIMAL(10) NOT NULL |
Root Node Number
|
| 30 |
PARENT_NODE_NUM |
Number(10,0) |
DECIMAL(10) NOT NULL |
Parent Node Number
|
| 31 |
PARENT_NODE_END |
Number(10,0) |
DECIMAL(10) NOT NULL |
Parent Node End Number
|
| 32 |
PARENT_NODE_NAME |
Character(20) |
VARCHAR2(20) NOT NULL |
Name of parent node
|
| 33 |
BASE_NODE_END |
Number(10,0) |
DECIMAL(10) NOT NULL |
Base Node End Number
|
| 34 |
NODE_INDEX |
Number(10,0) |
DECIMAL(10) NOT NULL |
Internal beginning node range number
|
| 35 |
LEVELS |
Number(3,0) |
SMALLINT NOT NULL |
Number of Levels
|
| 36 |
TREE_LEVEL_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Parent tree level if this is a part of the PSTREEBRANCH record
|
| 37 |
PARENT_LEVEL_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Parent tree level if this is a part of the PSTREEBRANCH record
|
| 38 |
NEW_LEVEL_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Parent tree level if this is a part of the PSTREEBRANCH record
|
| 39 |
RANGE_FROM |
Character(30) |
VARCHAR2(30) NOT NULL |
Lower boundary for detail value that contains a range of values
|
| 40 |
RANGE_TO |
Character(30) |
VARCHAR2(30) NOT NULL |
Upper boundary for detail value that contains a range of values
|
| 41 |
MESSAGE_SET_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Set Number. This field refers to the Message Set Number in the Message Catalog.
|
| 42 |
MESSAGE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
|
| 43 |
TOTAL_ROW_COUNT |
Number(8,0) |
INTEGER NOT NULL |
Total Row Count
|
| 44 |
RANGE_FROM_PREV |
Character(30) |
VARCHAR2(30) NOT NULL |
Previous range from value
|
| 45 |
RANGE_TO_PREV |
Character(30) |
VARCHAR2(30) NOT NULL |
Range To
|
| 46 |
RANGE_FROM_30 |
Character(30) |
VARCHAR2(30) NOT NULL |
Range From
|
| 47 |
ALL_VALUES |
Character(1) |
VARCHAR2(1) NOT NULL |
Tree Level All Values flag
|
| 48 |
DUPLICATE_LEAF |
Character(1) |
VARCHAR2(1) NOT NULL |
Tree Definition allow duplicate leaf flag
|
| 49 |
TREEEDITSTATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Tree Reservation Status
E=Editable
N=Not Used
R=Reserved
U=UnReserved
Default Value: N
|
| 50 |
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
|
| 51 |
TREE_AUDIT_SCOPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Audit Scope
M=Multiple Trees
S=Single Tree
|
| 52 |
ASOFDATE |
Date(10) |
DATE |
As of Date
|
| 53 |
AE_APPLID |
Character(12) |
VARCHAR2(12) NOT NULL |
Program Name (see PSAEAPPLDEFN).
|
| 54 |
AE_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
Section
|
| 55 |
AE_APPSTATUS |
Number(1,0) |
SMALLINT NOT NULL |
AE Application Warning Status
|
| 56 |
SQLTEXT |
Long Character(14000) |
CLOB |
SQL Statement Text
|