| # |
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
Prompt Table:
POS_SOURCE_TBL
Set Control Field: SETID
|
| 5 |
ALIAS_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
"A user defined synonym
Default Value: POS_ALAS_AMT_VW.ALIAS_NAME
Prompt Table:
POS_DEAL_SRC_VW
|
| 6 |
POS_PHYS_SWAP_VAL |
Character(30) |
VARCHAR2(30) NOT NULL |
An internal work field that contains the monetary amount field which is mapped to the dea
Default Value: POS_ALAS_AMT_VW.ALIAS_NAME
Prompt Table:
POS_DEAL_SRC_VW
|
| 7 |
POS_FX_VAL |
Character(30) |
VARCHAR2(30) NOT NULL |
An internal work field that contains the monetary amount field which is mapped to the deal capture
Default Value: POS_ALAS_AMT_VW.ALIAS_NAME
Prompt Table:
POS_DEAL_SRC_VW
|
| 8 |
POS_PHYS_BOROW_VAL |
Character(30) |
VARCHAR2(30) NOT NULL |
An internal work field that contains the monetary amount field which is mapped to the
Default Value: POS_ALAS_AMT_VW.ALIAS_NAME
Prompt Table:
POS_DEAL_SRC_VW
|
| 9 |
POS_PHYS_LEND_VAL |
Character(30) |
VARCHAR2(30) NOT NULL |
An internal work field that contains the monetary amount field which is mapped to the dea
Default Value: POS_ALAS_AMT_VW.ALIAS_NAME
Prompt Table:
POS_DEAL_SRC_VW
|
| 10 |
POS_OPT_VAL |
Character(30) |
VARCHAR2(30) NOT NULL |
An internal work field that contains the monetary amount field which is mapped to the deal options functio
Default Value: POS_ALAS_AMT_VW.ALIAS_NAME
Prompt Table:
POS_DEAL_SRC_VW
|
| 11 |
POS_BIN_OPT_VAL |
Character(30) |
VARCHAR2(30) NOT NULL |
An internal work field that contains the monetary amount field which is mapped to the deal capt
Default Value: POS_ALAS_AMT_VW.ALIAS_NAME
Prompt Table:
POS_DEAL_SRC_VW
|
| 12 |
POS_COMODITIES_VAL |
Character(30) |
VARCHAR2(30) NOT NULL |
Commodities
Default Value: POS_ALAS_AMT_VW.ALIAS_NAME
Prompt Table:
POS_DEAL_SRC_VW
|
| 13 |
POS_FUTURES_VAL |
Character(30) |
VARCHAR2(30) NOT NULL |
Futures
Default Value: POS_ALAS_AMT_VW.ALIAS_NAME
Prompt Table:
POS_DEAL_SRC_VW
|
| 14 |
POS_GENERIC_VAL |
Character(30) |
VARCHAR2(30) NOT NULL |
Generic
Default Value: POS_ALAS_AMT_VW.ALIAS_NAME
Prompt Table:
POS_DEAL_SRC_VW
|
| 15 |
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
|
| 16 |
POS_FROM_SQL |
Character(50) |
VARCHAR2(50) NOT NULL |
Represents SQL text that is utilized to specify selection criteria for position data at a
|
| 17 |
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
|