| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table:
SP_BU_TRD_NONVW
|
| 2 |
TREAS_HEADER_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
The unique key identifier for a given deal transaction.
Default Value: NEXT
Prompt Table:
TRX_HEADER_TR
|
| 3 |
INSTRUMENT_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
Instrument type
Prompt Table:
INSTR_INST_H_VW
|
| 4 |
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:
INSTR_TMPL_H_VW
|
| 5 |
TRANSACTION_DT |
Date(10) |
DATE NOT NULL |
Transaction date (often used as trade date)
|
| 6 |
COUNTERPARTY_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
The PeopleSoft tableset ID associated with a given dealing counterparty.
|
| 7 |
COUNTERPARTY |
Character(5) |
VARCHAR2(5) NOT NULL |
Represents a treasury dealing counterpart.
Prompt Table:
BANK_TR_CPTY_VW
|
| 8 |
DEAL_FAMILY_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
When deals are linked together, a code is set to identify the nature of the linkage. (EG btb = back to back)
BTB=Back to Back
COPY=Other Purpose Deal Copy
MIR=Standard Mirror
MIRR=Other Purpose Deal Mirror
PART=Partial Sell/Buyback
RLFX=FX Swap Forward / Backward
RLPH=One Period Physical Rollover
SUB=Internal or Subsidiary
|
| 9 |
INTER_UNIT_DEAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Indication showing the deal is with the Treasury on an interunit or subsidiary basis.
Y/N Table Edit
|
| 10 |
TREAS_MAST_SUB_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
The business unit of the Treasury unit who controls a group of internal deals, soem of which may have different business units.
|
| 11 |
TREAS_MAST_SUB_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
This field contains the first deal id in a series of deals that are related for interunit dealing, on behalf dealing, or deals between subsidiaries.
|
| 12 |
TREAS_MAST_ROLL_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
This fields contains the first deal id in a series of deals that are related for deal rolling forward.
|
| 13 |
TREAS_BACK_ROLL_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
This fields contains the first deal id in a series of deals that are related for deal rolling forward.
|
| 14 |
TREAS_MIRROR_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
The business unit of the deal that is the opposite clearing deal of the current deal.
|
| 15 |
TREAS_MIRROR_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
The deal ID of the deal the is the offset for this deal.
|
| 16 |
TREAS_MIRROR_CPTY |
Character(5) |
VARCHAR2(5) NOT NULL |
The counterparty in a mirror clearing deal.
|
| 17 |
DESCR150_MIXED |
Character(150) |
VARCHAR2(150) NOT NULL |
Description
|
| 18 |
TRANSACTION_ISSUER |
Character(5) |
VARCHAR2(5) NOT NULL |
The entity or organization that sponsors the issuance of a given financial instrument on behalf of the tre
Prompt Table:
BANK_ISSUER_VW
|
| 19 |
TRANSACT_GUARANTOR |
Character(5) |
VARCHAR2(5) NOT NULL |
Entity that guarantees the credit worthiness of a financial instrument and its counterparty
Prompt Table:
BANK_GURANTR_VW
|
| 20 |
TRANSACTION_BROKER |
Character(5) |
VARCHAR2(5) NOT NULL |
"The deal transaction intermediary
Prompt Table:
BANK_BROKER_VW
|
| 21 |
DEALER_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A system generated value that reflects the operator that originally created and saved a given deal tran
Prompt Table:
OPRID_VW
|
| 22 |
TRANSACTION_DTTM |
DateTime(26) |
TIMESTAMP |
Transaction Date-Time
|
| 23 |
ORIG_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
User ID
Prompt Table:
OPRID_VW
|
| 24 |
ORIG_DTTM |
DateTime(26) |
TIMESTAMP |
A system generated value that reflects the original creation and saving of a given transaction.
|
| 25 |
TREASURY_PORTFOLIO |
Character(15) |
VARCHAR2(15) NOT NULL |
A unique key identifier for a position portfolio that may be associated with a given deal transaction.
Prompt Table:
TRX_PORTFLIO_TR
|
| 26 |
CPTY_DEALER |
Character(10) |
VARCHAR2(10) NOT NULL |
The assigned external dealer or trader associated with a given dealing counterparty.
Prompt Table:
%EDITTABLE7
|
| 27 |
CPTY_REFERENCE |
Character(15) |
VARCHAR2(15) NOT NULL |
A reference identifier associated with a dealing counterparty transaction.
|
| 28 |
TRANSACTION_LOCKED |
Character(1) |
VARCHAR2(1) NOT NULL |
"An internal work field that
Y/N Table Edit
Default Value: N
|
| 29 |
NET_CASHFLOWS |
Character(1) |
VARCHAR2(1) NOT NULL |
Allows the user to designate that the inbound and outbound cashflows for a given financi
Y/N Table Edit
|
| 30 |
TRA_ACTG_TREATMENT |
Character(2) |
VARCHAR2(2) NOT NULL |
Treasury Deal Accounting Treatment.
Edit Translates on this field to alter the Accounting Treatments available.
(Not quite a control table, but as good as it gets!)
01=Held to Maturity
02=Available for Sale
03=Trading
04=Other
05=Loans and Receivables
|
| 31 |
TR_COLL_LVL_MIN |
Number(27,3) |
DECIMAL(26,3) NOT NULL |
Amount of Collateral that agreed upon to be pledged for a repo.
|
| 32 |
TR_SUB_REPO |
Character(1) |
VARCHAR2(1) NOT NULL |
Switch to allow substitution of collateral.
L=Substitution with Limits
N=No Substitution
W=Unlimited Substitution
Default Value: N
|
| 33 |
TR_COLL_LVL_MAX |
Number(27,3) |
DECIMAL(26,3) NOT NULL |
Amount of Collateral that agreed upon to be pledged for a repo.
|
| 34 |
TR_SUB_LIMIT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Limit of substitution amount.
|
| 35 |
TR_REPO_PRICE |
Number(27,3) |
DECIMAL(26,3) NOT NULL |
The repurchase price of the instrument.
|
| 36 |
MTM_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
The stated currency for a deal transaction's fair value (mark-to-market)
Default Value: BUS_UNIT_TBL_GL.BASE_CURRENCY
Prompt Table:
CURRENCY_CD_TBL
|
| 37 |
MTM_VALUE_OVRD_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Allows the user to indicate that the returned output value from an analytics function may be
Y/N Table Edit
Default Value: N
|
| 38 |
MTM_ACCTG_VALUE_0 |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
The Initial (starting) Mark to Market Value for a Treasury Deal or other transaction
|
| 39 |
MTM_ACCTG_VALUE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
The Fair Value (Mark to Market) of a Treasury Deal, or the Fair Value or Cash Flows of a hedged item
|
| 40 |
MTM_EXCL_VALUE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
(Cumulative) Adjustment amount excluded from the calculation of the change in fair value of a deal or hedged item.
Corresponds to Amortized Cost for investments and to Para 19 adjustments for a hedged item.
NOTE: ONLY Label IDs 3 characters or less can be used as user-chosen labels on the Define Intruments / Analytics page (if added as XLATs to field MTM_EXCL_VAL_TYPE + C/P prefix)
|
| 41 |
MTM_DEAL_VALUE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
"A deal transaction's mark-to-market
|
| 42 |
SALE_CPTY_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
The subject settlement bank tableset ID for a buy/sellback transaction.
Prompt Table:
SP_SETID_NONVW
|
| 43 |
SALE_COUNTERPARTY |
Character(5) |
VARCHAR2(5) NOT NULL |
The subject counterparty for a buy/sellback transaction.
Prompt Table:
BANK_TR_CPTYS_V
|
| 44 |
SALE_CPTY_REF |
Character(15) |
VARCHAR2(15) NOT NULL |
The subject transaction reference identifier for a buy/sellback transaction.
|
| 45 |
SALE_CPTY_DEALER |
Character(10) |
VARCHAR2(10) NOT NULL |
The subject dealer for a buy/sellback transaction.
|
| 46 |
SALE_TRANS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Unwind Par Amount
|
| 47 |
SALE_PRICE_PERCENT |
Number(14,8) |
DECIMAL(13,8) NOT NULL |
The percentage of Unwind par value of which a financial instrument is priced when booked into the system.
|
| 48 |
SALE_PROCEEDS |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
The received sales proceeds for a buy/sellback transaction.
|
| 49 |
SALE_PRICE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
The sales price for a buy/sellback transaction.
|
| 50 |
SALE_PURCH_INT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
The amount of accrued interest associated with an instrument when the same is acquired.
|
| 51 |
PURCH_INT_SOURCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Whether purchased interest was input by user or calculated by system.
S=System Supplied
U=User Supplied
|
| 52 |
SALE_CURRENT_VALUE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
The subject accounting value for a buy/sellback transaction.
|
| 53 |
SALE_UBV_SOURCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Whether UBV was input by user or calculated by system.
S=System Supplied
U=User Supplied
|
| 54 |
SALE_UPB |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Unwind Principal Balance (Original Par Amount if no amortization OR Unamortized Principal Balance)
|
| 55 |
SALE_ORDER_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Type of the Sale Order - market or limit order
01=Market Order
02=Limit Order
|
| 56 |
AMORT_DISC_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Represents the discount amount deducted from the par price of a given deal transaction such as a bond.
|
| 57 |
UNAMORT_DISC_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Represents the Unamortized discount amount deducted from the par price of a given deal transaction such as a bond.
|
| 58 |
SALE_PRO_PERCENT |
Number(14,8) |
DECIMAL(13,8) NOT NULL |
The percentage of Unwind par value of which a financial instrument is priced when booked into the system.
|
| 59 |
WRITEOFF_UNAM |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Represents the discount amount deducted from the par price of a given deal transaction such as a bond.
|
| 60 |
SALE_FEE_BALANCE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Represents Fee Balance on Deal Fees
|
| 61 |
AMORT_FEE_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Represents Amortized Fee Balance on Deal Fees
|
| 62 |
UNAMORT_FEE_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Represents Unamortized Fee Balance on Deal Fees
|
| 63 |
WRITEOFF_FEE_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Represents Unamortized Fee Balance on Deal Fees
|
| 64 |
SALE_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
The subject transaction currency for a buy/sellback transaction.
Prompt Table:
CURRENCY_CD_TBL
|
| 65 |
SALE_DT |
Date(10) |
DATE |
The transaction sales date for a buy/sellback transaction.
|
| 66 |
SALE_SETTLEMENT_DT |
Date(10) |
DATE |
The agreed upon settlement date for a buy/sellback transaction.
|
| 67 |
SALE_BANK_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
The subject tableset ID associated with the treasury bank code for a buy/sellback transaction.
Prompt Table:
SP_SETID_NONVW
|
| 68 |
SALE_BANK_CD_CUST |
Character(5) |
VARCHAR2(5) NOT NULL |
The subject treasury bank code for a buy/sellback transaction.
|
| 69 |
SALE_BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
The subject settlement bank code for a buy/sellback transaction.
Prompt Table:
BANK_TR_SALE_VW
|
| 70 |
SALE_BANK_ACCT_KEY |
Character(4) |
VARCHAR2(4) NOT NULL |
The subject bank account for a buy/sellback transaction.
Prompt Table:
BANK_TR_ACTS_VW
|
| 71 |
SALE_SETTLEMENT_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
The subject settlement instructions for a buy/sellback transaction.
Prompt Table:
BANK_SETL_CS_VW
|
| 72 |
SALE_PYMNT_METHOD |
Character(3) |
VARCHAR2(3) NOT NULL |
Payment Method
ACH=Automated Clearing House
BEF=Draft - Customer EFT
BOO=Draft - Customer Initiated
CHK=System Check
DD=Direct Debit
DFT=Draft - Supplier Initiated
EFT=Electronic Funds Transfer
GE=Giro - EFT
GM=Giro - Manual
LC=Letter of Credit
MAN=Manual Check
TRW=Treasury Wire
WIR=Wire Transfer
Prompt Table:
BNK_ACCMTHD_VW2
|
| 73 |
SALE_FORMAT_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Format ID
Prompt Table:
TR_FORMAT_VW3
|
| 74 |
PREAPPV_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Allows the user to indicate that a deal transaction has been submitted for review via workflow process
Y/N Table Edit
Default Value: N
|
| 75 |
DEAL_PVW_SUBMITTED |
Character(1) |
VARCHAR2(1) NOT NULL |
An internal work field that indicates whether a deal transaction subject to the deal previ
Y/N Table Edit
Default Value: N
|
| 76 |
TR_APPV_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
An internal work field that indicates whether a given deal transaction has been approved by a reviewe
01=Authorized
02=Submitted
03=Pending Review
04=Deal Previewed
05=Deal Suspended
06=Deal Approved
Default Value: 01
|
| 77 |
PREAPPV_MAIL_SENT |
Character(2) |
VARCHAR2(2) NOT NULL |
An internal work field that indicates that a deal preview request has been rejected and an e-mai
01=Undelivered
02=Delivered
Default Value: 01
|
| 78 |
DEAL_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
Represents the specific state or point in the life cycle of a deal transaction.
01=Under Negotiation
02=Sample
03=Open
04=Matured
05=Deactivated
06=Rejected
07=Sold / Bought back
08=Forecasted
09=Partially Sold/Bought Back
Default Value: 03
|
| 79 |
DEAL_RVW_SUBMITTED |
Character(1) |
VARCHAR2(1) NOT NULL |
An internal work field that indicates whether a deal transaction subject to the deal review proc
Y/N Table Edit
Default Value: N
|
| 80 |
CONF_RVW_SUBMITTED |
Character(1) |
VARCHAR2(1) NOT NULL |
An internal work field that indicates that a deal transaction subject to confirmation review suc
Y/N Table Edit
Default Value: N
|
| 81 |
APPROVAL_DTTM |
DateTime(26) |
TIMESTAMP |
A system generated value that reflects the date and time a given transaction is approved by an oper
|
| 82 |
APPROVAL_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A system generated value that reflects the operator that approved a given transaction.
Prompt Table:
OPRID_VW
|
| 83 |
DEAL_CONF_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
Reflects the confirmation status of a given deal transaction at any particular point in time.
01=Pending
02=Confirmed
03=Invalid
Default Value: 01
|
| 84 |
DEAL_CONF_DTTM |
DateTime(26) |
TIMESTAMP |
A system generated value that reflects the date and time a given deal transaction is confirmed
|
| 85 |
DEAL_CONF_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A system generated value that reflects the operator that confirmed a given deal transaction.
Prompt Table:
OPRID_VW
|
| 86 |
AUTO_CONF_SENT |
Character(1) |
VARCHAR2(1) NOT NULL |
An internal work field that indicates whether a given deal transaction subject to outbound con
Y/N Table Edit
Default Value: N
|
| 87 |
CONF_MAIL_SENT |
Character(2) |
VARCHAR2(2) NOT NULL |
An internal work field that indicates that a deal transaction has been rejected in the confirmation
01=Undelivered
02=Delivered
Default Value: 01
|
| 88 |
CONFO_OUT_SENT |
Character(1) |
VARCHAR2(1) NOT NULL |
An internal work field that indicates that a given deal transaction subject to outbound confirmat
Y/N Table Edit
Default Value: N
|
| 89 |
LAST_MAINT_DTTM |
DateTime(26) |
TIMESTAMP |
A system generated value that reflects the date and time a transaction was last modified
|
| 90 |
LAST_MAINT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Maintained By Operator ID
Prompt Table:
OPRID_VW
|
| 91 |
EXCL_FROM_POSITION |
Character(1) |
VARCHAR2(1) NOT NULL |
Allows the user to designate that a given deal transaction is not to be included in a subse
N=Include in Position
Y=Exclude From Position
Y/N Table Edit
Default Value: N
|
| 92 |
LIMIT_RESERVED |
Character(1) |
VARCHAR2(1) NOT NULL |
An internal workfield that indicates whether a portion of a given treasury position's available exposu
N=UnReserved
Y=Limit Reserved
Y/N Table Edit
Default Value: N
|
| 93 |
FCLTY_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
A unique key identifier that represents a given counterparty facility.
Prompt Table:
%EDITTABLE4
|
| 94 |
TREAS_MASTER_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Master ID for a given deal header.
Prompt Table:
TRX_HEADER_VW2
|
| 95 |
TREAS_NEXT_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
The new deal id created by Partial Sell/Buy back activity.
|
| 96 |
TREAS_PREVIOUS_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Previous ID for a given deal header for Partial Sell/Buy back.
|
| 97 |
TRD_TRADE_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Trade ID
Prompt Table:
TRD_HEADER_VW
|
| 98 |
TRADE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Trade Type
C=Close
O=Open
|
| 99 |
TRD_SELLBUY_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Trade Sell/Buy Flag
Y/N Table Edit
Default Value: N
|
| 100 |
START_DT |
Date(10) |
DATE |
Start Date
|
| 101 |
START_DISCOUNT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Internal field utilized to determine the appropriate accrual accounting amount for a giv
|
| 102 |
SECURITY_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
A reference identifier for a given deal transaction.
Prompt Table:
TRX_SEC_VW
|
| 103 |
RUN_POSN |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag to check if position update to be run.
Y/N Table Edit
Default Value: Y
|
| 104 |
TRP_BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Pool Business Unit
Prompt Table:
SP_TRPBU_NONVW
|
| 105 |
POOL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Pool ID field.
Prompt Table:
TRP_PL_ACT_VW1
|
| 106 |
EVENT_TRACKING_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
The event tracking ID is used in order to correlate objects with an event. Each object (i.e. Payment) will store the tracking ID with a given payment. That way the system can obtain all the events for a given payment via the tracking ID.
|
| 107 |
CR_RATING_TYPE |
Character(8) |
VARCHAR2(8) NOT NULL |
The market credit agency associated wth a given group of credit ratings.
I=IBCA
M=Moody's
S=Standard && Poors
Prompt Table:
%EDITTABLE5
|
| 108 |
CR_RATING_VALUE |
Number(3,0) |
SMALLINT NOT NULL |
User defined rating values utilized to assign priorities to a given set of credit ratings.
Prompt Table:
%EDITTABLE6
|
| 109 |
CD |
Character(30) |
VARCHAR2(30) NOT NULL |
Code
Prompt Table:
EXT_CODE_VW
|
| 110 |
PRTRY |
Character(30) |
VARCHAR2(30) NOT NULL |
Proprietary
|