EM_HRDL_RATE_VW(SQL View) |
Index Back |
---|---|
Bank Hurdle Rate by BuyerBank 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 |