| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 2 |
TREE_NAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Tree Name
|
| 3 |
SOURCE_SET |
Character(20) |
VARCHAR2(20) NOT NULL |
A field name describing a group od position sources.
|
| 4 |
POS_SOURCE_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
"A unique key identifier that represents a position source dataset
|
| 5 |
TREE_NODE |
Character(20) |
VARCHAR2(20) NOT NULL |
Node name
|
| 6 |
POS_DEAL_SRC_SET |
Character(1) |
VARCHAR2(1) NOT NULL |
A checkbox that determines if the current source set is to be used for deal condtions or selection criteria.
|
| 7 |
INCLUDE_DEAL_CHK |
Character(1) |
VARCHAR2(1) NOT NULL |
Allows the user to instruct the position monitor tool to utilize a particular tree node when
|
| 8 |
VERSION_NUMBER |
Number(5,0) |
INTEGER NOT NULL |
Represents the Tools version number of a given position tree object.
|
| 9 |
POS_IS_DEAL_SRC |
Character(1) |
VARCHAR2(1) NOT NULL |
Filed used to determine if a Position source is over a deal table
|
| 10 |
SQLTEXT |
Long Character(14000) |
CLOB |
SQL Statement Text
|