TR_SEC_MTM_WRK

(SQL Table)
Index Back

Work Table for TR_SEC_MTM AE

Used as a temporary table in the TR_SEC_MTM Application Engine process.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 AS_OF_DATE Date(10) DATE As of Date
4 BUSINESS_UNIT_TRX Character(5) VARCHAR2(5) NOT NULL The Business Unit for a Treasury Deal (table TRX_HEADER_TR)
5 TREAS_HEADER_ID Character(12) VARCHAR2(12) NOT NULL The unique key identifier for a given deal transaction.
6 MTM_CURRENCY Character(3) VARCHAR2(3) NOT NULL The stated currency for a deal transaction's fair value (mark-to-market)
7 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
8 ERROR_TYPE Character(3) VARCHAR2(3) NOT NULL Error Type
ERR=Stop
NON=None
WAR=Warning
9 ERROR_VALUE Character(1) VARCHAR2(1) NOT NULL Error Status value
10 AS_OF_DATE_01 Date(10) DATE As of Date 01
11 INSTRUMENT_TYPE Character(10) VARCHAR2(10) NOT NULL Instrument type
12 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
13 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
14 ACCTG_TMPL_ID Character(15) VARCHAR2(15) NOT NULL A unique key identifier that represents a predefined accounting template, that is a set of rules used to generate debits and credits.
15 SECURITY_ID Character(10) VARCHAR2(10) NOT NULL A reference identifier for a given deal transaction.
16 MKT_PRICE Number(14,8) DECIMAL(13,8) NOT NULL Market Price
17 PRINCIPAL_BALANCE Signed Number(28,3) DECIMAL(26,3) NOT NULL The notional principal balance of a given deal transaction at commencement.
18 TRANSACTION_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL The nominal or actual deal transaction amount.
19 TRANSACTION_PRICE Signed Number(28,3) DECIMAL(26,3) NOT NULL The preferred business price for a given deal transaction.
20 NBR_OF_CONTRACTS Signed Number(18,4) DECIMAL(16,4) NOT NULL This is the number of future contracts associated with a deal
21 QUANTITY Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Interface
22 ACCRUED_UP_TO_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL "An internal work field utilized for calculating the interest
23 FEE_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL The transaction fee amount.
24 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
25 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)
26 DOC_TYPE Character(8) VARCHAR2(8) NOT NULL Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.
27 BOOK_VALUE Signed Number(28,3) DECIMAL(26,3) NOT NULL Book Value