RSK_CF_TBL

(SQL Table)
Index Back

Repository for cashflows

This table contains the cashflows generated by PeopleSoft.

# 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