| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 2 |
TRD_TRADE_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Trade ID
|
| 3 |
TRANSACTION_LINE |
Number(3,0) |
SMALLINT NOT NULL |
The separate and distinct base instrument type components of a given deal transaction.
|
| 4 |
INSTRMNT_BASE_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Instrument base type used as a building block for Treasury deals
01=Interest Rate Physical
02=Interest Rate Swap
03=FX Deal Physical
04=Option
05=Option - Binary Payoff
06=Futures Contract
07=Commodity
08=Generic Instrument
09=Equity
|
| 5 |
OPT_EXERCISE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
The option exercise type.
A=American
B=Bermudan
E=European
|
| 6 |
OPT_EXERCISE_INTO |
Character(1) |
VARCHAR2(1) NOT NULL |
Allows the user to select the method in which a given option transaction will be exercised.
A=Delivery of Payoff
C=Cash Difference
|
| 7 |
OPT_PURCHASE_WRITE |
Character(1) |
VARCHAR2(1) NOT NULL |
Describes whether the dealer is purchasing or writing a given option transaction.
P=Purchase
W=Write
|
| 8 |
OPT_PUT_CALL |
Character(1) |
VARCHAR2(1) NOT NULL |
Describes whether a given option transaction reflects a short or long position.
C=Call
P=Put
|
| 9 |
OPT_PUTCALL_DESCR |
Character(40) |
VARCHAR2(40) NOT NULL |
Description for a put or call option transaction.
|
| 10 |
OPT_STRIKE_VARIES |
Character(1) |
VARCHAR2(1) NOT NULL |
Allows the user to designate that a given option transaction's strike rate can vary o
Y/N Table Edit
|
| 11 |
OPT_STRIKE_RATE |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
"The strike
|
| 12 |
OPT_INT_RATE_CAP |
Character(1) |
VARCHAR2(1) NOT NULL |
An indicator for the type of option. Cap/floor or an option on a swap (swaption).
B=Binary Cap/Floor
N=Swaption
Y=Cap / Floor
|
| 13 |
CONTINGENT_UPON |
Character(2) |
VARCHAR2(2) NOT NULL |
Instrument field for future. Indicates its line is currently 'underlying' another line. That is this security, say a T-Bond, will not be in position as a live instrument unless (06) the future (T-Bond Future) that it underlies is settled physically or (04) the option (Option on T-Bond) is exercised.
04=Option
06=Future
|
| 14 |
OPT_TRANSACT_LINE |
Number(3,0) |
SMALLINT NOT NULL |
Points to the line in a deal which the current line underlies. That is, the line number pointed to by this field must be either exercised or settled physically for the line containing this field to become 'real'.
|
| 15 |
RATE_RESET_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Describes whether a given deal transaction is subject to a fixed or floating interest rate.
FL=Floating
FX=Fixed
|
| 16 |
RATE_RESET_TYPE_2 |
Character(2) |
VARCHAR2(2) NOT NULL |
Describes whether a given deal transaction is subject to a fixed or floating interest rate for the sec
FL=Floating
FX=Fixed
|
| 17 |
TRANSACTION_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
The nominal or actual deal transaction amount.
|
| 18 |
TRANSACTION_AMT_2 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
The nominal transaction amount for the second leg of a deal transacation.
|
| 19 |
TRANSACT_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
"The nominal
Prompt Table:
CURRENCY_CD_TBL
|
| 20 |
TRANS_CURRENCY_2 |
Character(3) |
VARCHAR2(3) NOT NULL |
"The nominal
Prompt Table:
CURRENCY_CD_TBL
|
| 21 |
PRICE_PERCENT_PAR |
Number(14,8) |
DECIMAL(13,8) NOT NULL |
The percentage of par value of which a financial instrument is priced when booked into the system.
|
| 22 |
TRANSACTION_PRICE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
The preferred business price for a given deal transaction.
|
| 23 |
EXP_SETTLEMENT_DT |
Date(10) |
DATE |
Expected Settlement Date
|
| 24 |
TRANSACTION_RATE |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
The applicable interest rate for a given deal transaction.
|
| 25 |
TRANSACTION_RATE_2 |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
The applicable interest rate for the second leg of a given deal transaction.
|
| 26 |
ASSET_LIABILITY |
Character(1) |
VARCHAR2(1) NOT NULL |
Whether the deal transaction leg represents an asset or a liability
A=Asset
L=Liability
|
| 27 |
ASSET_LIABILITY_2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Whether the deal transaction leg represents an asset or a liability for the second leg
A=Asset
L=Liability
|
| 28 |
RT_RATE_INDEX |
Character(10) |
VARCHAR2(10) NOT NULL |
Market Rate Index
Default Value: BUS_UNIT_TBL_GL.TR_RVL_RATE_INDEX
Prompt Table:
RT_INDEX_TBL
|
| 29 |
RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
Default Value: BUS_UNIT_TBL_GL.TR_RVL_RT_TYPE
|
| 30 |
RT_RATE |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Market Rate
|
| 31 |
RT_RATE_2 |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Market Rate
|
| 32 |
FLOATING_MKT_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
The code used as a key for obtaining market rates for interest rates and futures prices.
Prompt Table:
TRX_RT_RESET_CD
|
| 33 |
FLOATING_MKT_CD_2 |
Character(10) |
VARCHAR2(10) NOT NULL |
A unique key identifier that describes a floating rate index basis associated with the second leg of a
Prompt Table:
TRX_RT_RESET_CD
|
| 34 |
FLT_MARGIN_OP |
Character(1) |
VARCHAR2(1) NOT NULL |
1st floating margin operation, +/- or *//
*=Multiply By
+=Add
|
| 35 |
FLT_MARGIN_OP_2 |
Character(1) |
VARCHAR2(1) NOT NULL |
1st floating margin operation, +/- or *//
*=Multiply By
+=Add
|
| 36 |
FLOATING_MARGIN |
Signed Number(13,8) |
DECIMAL(11,8) NOT NULL |
The supplemental interest rate
|
| 37 |
FLOATING_MARGIN_2 |
Signed Number(13,8) |
DECIMAL(11,8) NOT NULL |
The supplemental interest rate
|
| 38 |
FLT2_MARGIN_OP |
Character(1) |
VARCHAR2(1) NOT NULL |
Floating margin operations, +/- or *//
*=Multiply By
+=Add
|
| 39 |
FLT2_MARGIN_OP_2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Floating margin operation, +/- or *//
*=Multiply By
+=Add
|
| 40 |
FLOATING2_MARGIN |
Signed Number(13,8) |
DECIMAL(11,8) NOT NULL |
The supplemental interest rate
|
| 41 |
FLOATING2_MARGIN_2 |
Signed Number(13,8) |
DECIMAL(11,8) NOT NULL |
The supplemental interest rate
|
| 42 |
COMMODITY_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Commodity Code
Prompt Table:
COMMOD_CODE
|
| 43 |
EXCHG_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Trading exchange code
Prompt Table:
TRX_EXCHANGE_CD
|
| 44 |
UNIT_OF_MEASURE |
Character(3) |
VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
Prompt Table:
UNITS_TBL
|
| 45 |
QUANTITY |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Qty Interface
|
| 46 |
COMMODITY_RT_INDEX |
Character(10) |
VARCHAR2(10) NOT NULL |
The code used as a key for obtaining market rates for Commodity Prices
Prompt Table:
RT_INDEX_COM_VW
|
| 47 |
EQUITY_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Equity Identification Number - used to identify an equity in the system. the number is system generated and used for technical purposes only.
|
| 48 |
EQUITY_SYMBOL |
Character(15) |
VARCHAR2(15) NOT NULL |
Ticker symbol to identify an equity on the exchange that it is traded on
|
| 49 |
SPOT_RATE_MULT |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
An internal convention utilized for determing whether a currency exchange spot rate is stored ei
Default Value: 1
|
| 50 |
SPOT_RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
An internal convention utilized for determing whether a currency exchange spot rate is stored either
Default Value: 1
|
| 51 |
FORWARD_RATE_MULT |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
An internal convention utilized for determing whether a currency exchange forward rate is
Default Value: 1
|
| 52 |
FORWARD_RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
An internal convention utilized for determing whether a currency exchange forward rate is stor
Default Value: 1
|
| 53 |
SPOT_RT_LEG1_MULT |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
An internal convention utilized for determing whether a currency exchange spot rate is stored
Default Value: 1
|
| 54 |
SPOT_RT_LEG1_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
An internal convention utilized for determing whether a currency exchange spot rate is stored eit
Default Value: 1
|
| 55 |
FWD_RT_LEG1_MULT |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
An internal convention utilized for determing whether a currency exchange forward rate is s
Default Value: 1
|
| 56 |
FWD_RT_LEG1_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
An internal convention utilized for determing whether a currency exchange forward rate is store
Default Value: 1
|
| 57 |
SPOT_RT_LEG2_MULT |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
An internal convention utilized for determing whether a currency exchange spot rate is stored
Default Value: 1
|
| 58 |
SPOT_RT_LEG2_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
An internal convention utilized for determing whether a currency exchange spot rate is stored eit
Default Value: 1
|
| 59 |
FWD_RT_LEG2_MULT |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
An internal convention utilized for determing whether a currency exchange forward rate is s
Default Value: 1
|
| 60 |
FWD_RT_LEG2_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
An internal convention utilized for determing whether a currency exchange forward rate is store
Default Value: 1
|
| 61 |
ANCHOR_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
The base currency of the business unit that generates a given deal transaction.
Default Value: BUS_UNIT_TBL_GL.BASE_CURRENCY
Prompt Table:
CURRENCY_CD_TBL
|
| 62 |
ANCHOR_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Principal amount of a given deal transaction denominated in the anchor currency.
|
| 63 |
NBR_OF_CONTRACTS |
Signed Number(18,4) |
DECIMAL(16,4) NOT NULL |
This is the number of future contracts associated with a deal
|
| 64 |
TICK_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
The amount or value of each increment (tick) of a futures contract.
|
| 65 |
UNDERLYING_CCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Underlying Currency
|
| 66 |
SETTLEMENT_CCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Settlement Currency
|
| 67 |
TICK_MIN_INTERVAL |
Signed Number(12,8) |
DECIMAL(10,8) NOT NULL |
The miinimum interval amount from one price or rate quote to the next. Fractions, like 1/32 should be entered in decimal format.
|
| 68 |
MARGIN_MIN_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Minimummargin amount for an exchange traded futures contract.
|
| 69 |
MARGIN_INITIAL_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Initial margin amount for an exchange traded futures contract.
|
| 70 |
DELIVERY_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Delivery Year
|
| 71 |
MONTHCD |
Character(2) |
VARCHAR2(2) NOT NULL |
Month
01=01 - January
02=02 - February
03=03 - March
04=04 - April
05=05 - May
06=06 - June
07=07 - July
08=08 - August
09=09 - September
10=10 - October
11=11 - November
12=12 - December
|
| 72 |
LAST_TRADE_DT |
Date(10) |
DATE |
The last date on which a deal can be traded.
|
| 73 |
FIRST_DELIVERY_DT |
Date(10) |
DATE |
Physical date of position.
|
| 74 |
FIRST_TRADE_DT |
Date(10) |
DATE |
The lfirst date on which a deal can be traded.
|
| 75 |
LAST_DELIVERY_DT |
Date(10) |
DATE |
Last delivery date for a contract
.
|
| 76 |
PAY_BANK_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
The PeopleSoft tableset ID for a bank on the disbursing side of a settlement transaction.
Prompt Table:
SP_SETID_NONVW
|
| 77 |
PAY_BANK_CD_CUST |
Character(5) |
VARCHAR2(5) NOT NULL |
Represents the owning counterparty of a given internal account slated to pay out a settlement.
|
| 78 |
PAY_BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
The bank for the disbursing side of a settlement transaction.
Prompt Table:
BANK_TR_BANK_VW
|
| 79 |
PAY_BANK_ACCT_KEY |
Character(4) |
VARCHAR2(4) NOT NULL |
The bank account for the disbursing side of a settlement transaction.
Prompt Table:
BANK_TR_ACTP_VW
|
| 80 |
PAY_BNK_ID_NBR |
Character(20) |
VARCHAR2(20) NOT NULL |
The alphanumeric bank identifier associated with a bank on the disbursing side of a settlement trans
|
| 81 |
PAY_BANK_ACCT_NUM |
Character(35) |
VARCHAR2(35) NOT NULL |
The bank account number for the disbursing side of a settlement transaction.
|
| 82 |
PAY_SETTLEMENT_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Represents the settlement instructions identifier associated with the submitter of a
Prompt Table:
BANK_SETL_CP_VW
|
| 83 |
REC_BANK_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
The PeopleSoft tableset ID for a bank on the receiving side of a settlement transaction.
Prompt Table:
SP_SETID_NONVW
|
| 84 |
REC_BANK_CD_CUST |
Character(5) |
VARCHAR2(5) NOT NULL |
Represents the owning counterparty of a given internal account slated to receive a settlement.
|
| 85 |
REC_BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
The bank for the receiving side of a settlement transaction.
Prompt Table:
BANK_TR_BANK_VW
|
| 86 |
REC_BANK_ACCT_KEY |
Character(4) |
VARCHAR2(4) NOT NULL |
The bank account for the receiving side of a settlement transaction.
Prompt Table:
BANK_TR_ACTR_VW
|
| 87 |
REC_BNK_ID_NBR |
Character(20) |
VARCHAR2(20) NOT NULL |
The alphanumeric bank identifier associated with a bank on the receiving side of a settlement transa
|
| 88 |
REC_BANK_ACCT_NUM |
Character(35) |
VARCHAR2(35) NOT NULL |
The bank account number for the receiving side of a settlement transaction.
|
| 89 |
REC_SETTLEMENT_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
The settlement instructions associated with the bank and account on the receiving side
Prompt Table:
STL_INSTR_R_VW
|
| 90 |
LAST_MAINT_DTTM |
DateTime(26) |
TIMESTAMP |
A system generated value that reflects the date and time a transaction was last modified
|
| 91 |
LAST_MAINT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Maintained By Operator ID
|