LOC_ACTIVITY_VW

(SQL View)
 Index Back

Lines of Credit Activity

Summary view of Lines of Credit Activities.

SELECT SETID , FCLTY_ID , TREAS_HEADER_ID , TRANSACTION_DT , AMOUNT , TRANSACT_CURRENCY FROM ( SELECT SETID , FCLTY_ID , TREAS_HEADER_ID , TRANSACTION_DT , (TRX_MATURING_AMT - TRX_ISSUED_AMT) AS AMOUNT , TRANSACT_CURRENCY FROM PS_FCLTY_LOCBRI_VW ) PS_FCLTY_LOCBRI_VW UNION ( SELECT SETID , FCLTY_ID , TREAS_HEADER_ID , TRANSACTION_DT , AMOUNT , TRANSACT_CURRENCY FROM ( SELECT SETID , FCLTY_ID , TREAS_HEADER_ID , TRANSACTION_DT , (TRX_MATURING_AMT - TRX_ISSUED_AMT) AS AMOUNT , TRANSACT_CURRENCY FROM PS_FCLTY_LOCPMT_VW ) PS_FCLTY_LOCPMT_VW UNION SELECT SETID , FCLTY_ID , TREAS_HEADER_ID , TRANSACTION_DT , (TRX_MATURING_AMT - TRX_ISSUED_AMT) AS AMOUNT , TRANSACT_CURRENCY FROM PS_FCLTY_LOCMAT_VW WHERE TRANSACTION_DT <= %CurrentDateIn UNION SELECT SETID , FCLTY_ID , TREAS_HEADER_ID , TRANSACTION_DT , (TRX_MATURING_AMT - TRX_ISSUED_AMT) AS AMOUNT , TRANSACT_CURRENCY FROM PS_FCLTY_LOCMTD_VW UNION SELECT SETID , FCLTY_ID , TREAS_HEADER_ID , TRANSACTION_DT , (TRX_MATURING_AMT - TRX_ISSUED_AMT) AS AMOUNT , TRANSACT_CURRENCY FROM PS_FCLTY_LOCROL_VW )

# 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 TREAS_HEADER_ID Character(12) VARCHAR2(12) NOT NULL The unique key identifier for a given deal transaction.
4 TRANSACTION_DT Date(10) DATE Transaction date (often used as trade date)
5 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
6 TRANSACT_CURRENCY Character(3) VARCHAR2(3) NOT NULL "The nominal