TR_INT_NOMDT_VW (SQL View)	Index Back
Nominal Dates for a deal View over TRX_INTEREST_TR to get a list of nominal dates

TR_INT_NOMDT_VW

(SQL View)

Nominal Dates for a deal

View over TRX_INTEREST_TR to get a list of nominal dates

SELECT I.BUSINESS_UNIT ,I.TREAS_HEADER_ID ,I.TRANSACTION_LINE ,I.NOMINAL_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.

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