TR_INTEREST_VW1

(SQL View)

SELECT I.BUSINESS_UNIT ,I.TREAS_HEADER_ID ,I.TRANSACTION_LINE ,I.NOMINAL_DT ,I.RATE_RESET_DT FROM PS_TRX_INTEREST_TR I WHERE TRX_PAYMENT_TYPE = 'I'

# 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 TRANSACTION_LINE Number(3,0) SMALLINT NOT NULL The separate and distinct base instrument type components of a given deal transaction.

4 NOMINAL_DT Date(10) DATE The nominal (non-adjusted) date for a given deal transaction cash flow.

5 RATE_RESET_DT Date(10) DATE The date that an interest rate quoted in the market is captured for purposes of calculating interest

#	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	TRANSACTION_LINE	Number(3,0)	SMALLINT NOT NULL	The separate and distinct base instrument type components of a given deal transaction.
4	NOMINAL_DT	Date(10)	DATE	The nominal (non-adjusted) date for a given deal transaction cash flow.
5	RATE_RESET_DT	Date(10)	DATE	The date that an interest rate quoted in the market is captured for purposes of calculating interest