TR_INT_RESDT_VW (SQL View)	Index Back
Reset Dates for a Deal View over TRX_INTEREST_TR to get a list of reset dates

TR_INT_RESDT_VW

(SQL View)

Reset Dates for a Deal

View over TRX_INTEREST_TR to get a list of reset dates

SELECT I.BUSINESS_UNIT ,I.TREAS_HEADER_ID ,I.TRANSACTION_LINE ,I.RATE_RESET_DT FROM PS_TRX_INTEREST_TR I WHERE TRX_PAYMENT_TYPE = 'I' AND RATE_RESET_DT IS NOT NULL

# 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 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	RATE_RESET_DT	Date(10)	DATE	The date that an interest rate quoted in the market is captured for purposes of calculating interest