# |
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
|