FCLTY_LOCINT_VW (SQL View)	Index Back
Lines of Credit Interim Paymnt Summary view of Interim Paydowns for Line of Credit Borrowings Paydown Date

FCLTY_LOCINT_VW

(SQL View)

Lines of Credit Interim Paymnt

Summary view of Interim Paydowns for Line of Credit Borrowings Paydown Date

SELECT SETID , FCLTY_ID , SUM(ACCRUED_INT) FROM PS_TRX_LOCINTA_VW GROUP BY SETID , FCLTY_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

2 FCLTY_ID Character(12) VARCHAR2(12) NOT NULL A unique key identifier that represents a given counterparty facility.

3 ACCRUED_INT Signed Number(28,3) DECIMAL(26,3) NOT NULL The periodic amount of accrued interest for a given deal transaction.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	FCLTY_ID	Character(12)	VARCHAR2(12) NOT NULL	A unique key identifier that represents a given counterparty facility.
3	ACCRUED_INT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	The periodic amount of accrued interest for a given deal transaction.