| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Prompt Table:
SP_SETID_NONVW
|
| 2 |
POS_CALC_PREF |
Character(15) |
VARCHAR2(15) NOT NULL |
A hyperlink that allows the user to set up run time options.
|
| 3 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 4 |
DESCR60 |
Character(60) |
VARCHAR2(60) NOT NULL |
Description
|
| 5 |
PRIVATE_PREF_CB |
Character(1) |
VARCHAR2(1) NOT NULL |
Public/Private Preferences Checkbox
N=Public Preference
Y=Private Preference
Default Value: N
|
| 6 |
VALUE_DT |
Date(10) |
DATE |
Equivalent to a deal transaction's settlement date.
|
| 7 |
SOURCE_SET_DT |
Date(10) |
DATE |
A specific date realted to a position source set.
|
| 8 |
TIME_SET |
Character(10) |
VARCHAR2(10) NOT NULL |
A unique key identifier that represents a time horizon definition dataset.
|
| 9 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 10 |
BUSINESS_UNIT_BANK |
Character(5) |
VARCHAR2(5) NOT NULL |
The general ledger business unit associated with a given bank/counterparty.
Prompt Table:
SP_BU_FS_NONVW
|
| 11 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SP_BU_FS_NONVW
|
| 12 |
SOURCE_SET |
Character(20) |
VARCHAR2(20) NOT NULL |
A field name describing a group od position sources.
|
| 13 |
BANK_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
The PeopleSoft tableset ID associated with a given bank/counterparty.
Prompt Table:
SP_SETID_NONVW
|
| 14 |
BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Bank Code
Prompt Table:
BANK_CD_TBL
|
| 15 |
BANK_ACCT_KEY |
Character(4) |
VARCHAR2(4) NOT NULL |
A user defined unique identifier that facilitates the identification of a given account with a given bank
Prompt Table:
BANK_ACCT_TBL
|
| 16 |
RECALC_SW |
Character(2) |
VARCHAR2(2) NOT NULL |
Represents various recalculation methods as run time parameters in regards to a position worksheet.
01=Recalculate Current Position
02=Use Data Calculated On
03=Recalculate Entire Worksheet
04=View Copied Data
Default Value: 02
|
| 17 |
TIME_SPAN_SW |
Character(2) |
VARCHAR2(2) NOT NULL |
Allows the user on the cash position worksheet to indicate whether the results are to be based upon a given values
01=Time Set
02=Value Date
03=Source Set
|
| 18 |
POS_USECPY_HIST_CB |
Character(1) |
VARCHAR2(1) NOT NULL |
A checkbox that is used to determine if the user would like to view zero day columns on the CPW.
B=Calculated and Copied
C=Calculated
H=Copied Results
Default Value: N
|
| 19 |
POS_ZERODAY_CB |
Character(1) |
VARCHAR2(1) NOT NULL |
A checkbox that is used to determine if the user would like to view zero day columns on the CPW.
Y/N Table Edit
Default Value: Y
|
| 20 |
CALC_DT |
Date(10) |
DATE |
The calculation date for a given data set within the Position tools.
|
| 21 |
CALC_DT2 |
Date(10) |
DATE |
Copied Calculation Date
|
| 22 |
INSTRMNT_TEMPLATE |
Character(10) |
VARCHAR2(10) NOT NULL |
A unique key identifier associated with an instrument that describes a separate template version of a pre
Prompt Table:
%EDITTABLE
|
| 23 |
INSTRUMENT_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
Instrument type
Prompt Table:
INSTR_INST_H_VW
|
| 24 |
BAX_TEMPLATE_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
An unique key identifier that represents a bank transfer transaction template.
Prompt Table:
%EDITTABLE
|
| 25 |
TR_WR_TEMPLATE_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Treasury Wires / Treasury Wire Templates
This uniquely identifies templates within a Business Unit.
|
| 26 |
TR_TRANSFER_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Transfer Type
01=Wire Transfer
02=Bank Transfer
03=Deal Entry
Default Value: 01
|
| 27 |
TR_TRANSFER_BAX |
Character(2) |
VARCHAR2(2) NOT NULL |
Transfer Type
01=EFT Transfer
02=Bank Transfer
03=Deal Entry
|
| 28 |
TO_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Revalue Currency
|
| 29 |
REVALUE_DATE_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
The mark-to-market revaluation date type.
01=Use Current Date
02=Use Calculation Date
|
| 30 |
POS_DEFAULT_WEIGHT |
Character(1) |
VARCHAR2(1) NOT NULL |
Allows the user to elect for weighting multipliers to be applied to the results of a given
|
| 31 |
LOCK_REMINDER |
Character(1) |
VARCHAR2(1) NOT NULL |
Reminder to Lock field for Position Manager
Y/N Table Edit
Default Value: N
|
| 32 |
LOAD_EXT_DATA_CB |
Character(1) |
VARCHAR2(1) NOT NULL |
Determines whether to execute the external data load or not.
Y/N Table Edit
Default Value: N
|
| 33 |
POS_RUN_REPORT |
Character(1) |
VARCHAR2(1) NOT NULL |
Generate Report
Y/N Table Edit
Default Value: N
|
| 34 |
PT_FORMAT_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Output Format Type
HTM=HTML
PDF=PDF
RTF=RTF
TXT=TXT
XLS=XLS
Default Value: PDF
|