RSK_DEAL_MTM_C

(SQL Table)
Index Back

BTF: Risk Deal MTM value

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 TEST_CASE Character(30) VARCHAR2(30) NOT NULL BTF Test Case
2 COMPARE_TYPE Character(1) VARCHAR2(1) NOT NULL Compare report type
1=Delta (Results v.s Expected)
2=Expected data not in Results
3=Unexpected data in Results
3 COMPARE_SOURCE Character(1) VARCHAR2(1) NOT NULL Compare data source (Actuals or Expected results).
A=Actuals
E=Expected
4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
5 TREAS_HEADER_ID Character(12) VARCHAR2(12) NOT NULL The unique key identifier for a given deal transaction.
6 AS_OF_DATE Date(10) DATE As of Date
7 MTM_CURRENCY Character(3) VARCHAR2(3) NOT NULL The stated currency for a deal transaction's fair value (mark-to-market)
8 MTM_ACCTG_VALUE_PR Signed Number(28,3) DECIMAL(26,3) NOT NULL Fair Value
9 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
10 MTM_EXCL_VALUE_PR Signed Number(28,3) DECIMAL(26,3) NOT NULL Previous (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.
11 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)
12 ACCOUNTED_GAINLOSS Signed Number(28,3) DECIMAL(26,3) NOT NULL Gain or Loss accounted for
13 ACCOUNTED_FOR Character(1) VARCHAR2(1) NOT NULL Whether Accounted for
14 BSE_RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Base Rate Divisor for Exchange Rates
15 BSE_RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Base Rate Multiplier for Exchange Rates