EM_HRDL_RATE_VW

(SQL View)
Index Back

Bank Hurdle Rate by Buyer

Bank Hurdle Rate by Buyer

SELECT A.SETID , B.SETID , B.BANK_CD , B.BANK_ACCT_KEY , B.HURDLE_RATE FROM PS_BUS_UNIT_OPT_AP A , PS_BANK_HURDLE_RTE B WHERE A.EFFDT = ( SELECT MAX(C.EFFDT) FROM PS_BUS_UNIT_OPT_AP C WHERE C.SETID = A.SETID AND C.EFFDT <= %CurrentDateIn AND C.EFF_STATUS = 'A') AND A.BANK_CD = B.BANK_CD AND A.BANK_CD = B.BANK_CD_CPTY AND A.BANK_ACCT_KEY = B.BANK_ACCT_KEY AND B.EFFDT = ( SELECT MAX(D.EFFDT) FROM PS_BANK_HURDLE_RTE D WHERE B.SETID = D.SETID AND B.BANK_CD = D.BANK_CD AND B.BANK_CD = D.BANK_CD_CPTY AND B.BANK_ACCT_KEY = D.BANK_ACCT_KEY AND D.EFFDT <= %CurrentDateIn AND D.EFF_STATUS = 'A')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.
3 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code

Prompt Table: BANK_CD_TBL

4 BANK_ACCT_KEY Character(4) VARCHAR2(4) NOT NULL A user defined unique identifier that facilitates the identification of a given account with a given bank
5 HURDLE_RATE Number(9,5) DECIMAL(8,5) NOT NULL Interest Rate