# |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
1 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
2 |
TREAS_HEADER_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
The unique key identifier for a given deal transaction.
|
3 |
EFFDT |
Date(10) |
DATE |
Effective Date
|
4 |
SEQNUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence Number
|
5 |
MTM_SCENARIO_NM |
Character(15) |
VARCHAR2(15) NOT NULL |
Risk analysis Scenario Set name
|
6 |
MTM_SCEN_COMP_SEQ |
Number(3,0) |
SMALLINT NOT NULL |
Scenario component sequence number
|
7 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
8 |
RSK_CASHFLOWS |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Cashflows or Mark to Market value of a financial instrument
|