| # |
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 |
POSITION_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
The transaction currency of a given position or exposure.
|
| 7 |
WEIGHTING |
Signed Number(10,5) |
DECIMAL(8,5) NOT NULL |
Used for applying a weighting to totals.
e.g. Limit Utilisation totals
|
| 8 |
POS_DEF_SRC_SET |
Character(1) |
VARCHAR2(1) NOT NULL |
a checkbox that identifies the default position source set.
|
| 9 |
RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
|
| 10 |
CURRENCY_FIELDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Currency Field Name
|
| 11 |
POS_SELECT_SQL |
Character(254) |
VARCHAR2(254) NOT NULL |
Represents SQL text that is utilized to specify selection criteria for position data at a given tree no
|
| 12 |
POS_WHERE_SQL |
Character(93) |
VARCHAR2(93) NOT NULL |
Represents SQL text that is utilized to specify selection criteria for position data at a given tre
|
| 13 |
POS_FROM_SQL |
Character(50) |
VARCHAR2(50) NOT NULL |
Represents SQL text that is utilized to specify selection criteria for position data at a
|
| 14 |
SQLTEXT |
Long Character(14000) |
CLOB |
SQL Statement Text
|
| 15 |
VERSION_NUMBER |
Number(5,0) |
INTEGER NOT NULL |
Represents the Tools version number of a given position tree object.
|