RSK_DEAL_MTM_E

(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 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 TREAS_HEADER_ID Character(12) VARCHAR2(12) NOT NULL The unique key identifier for a given deal transaction.
4 AS_OF_DATE Date(10) DATE As of Date
5 MTM_CURRENCY Character(3) VARCHAR2(3) NOT NULL The stated currency for a deal transaction's fair value (mark-to-market)
6 MTM_ACCTG_VALUE_PR Signed Number(28,3) DECIMAL(26,3) NOT NULL Fair Value
7 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
8 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.
9 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)
10 ACCOUNTED_GAINLOSS Signed Number(28,3) DECIMAL(26,3) NOT NULL Gain or Loss accounted for
11 ACCOUNTED_FOR Character(1) VARCHAR2(1) NOT NULL Whether Accounted for
12 DTTM_REFRESHED DateTime(26) TIMESTAMP Specifies the date and time of the last refresh of the expected results data. This field is used in the Batch Test Framework process.
13 BSE_RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Base Rate Divisor for Exchange Rates
14 BSE_RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Base Rate Multiplier for Exchange Rates