BNK_ID_NBRBANK_ACCOUNT_NUMTR_IHB_RTIDX_VW(SQL View) |
Index Back |
|---|---|
Internal Bank Rate Index |
| SELECT A.BNK_ID_NBR , B.BANK_ACCOUNT_NUM , C.DEBIT_RT_INDEX , C.DEBIT_MARGIN_PTS , C.CREDIT_RT_INDEX , C.CREDIT_MARGIN_PTS FROM PS_BANK_CD_TBL A , PS_BANK_ACCT_CPTY B , PS_BANK_ACCT_DEFN C WHERE A.BANK_TYPE = 'I' AND A.SETID = B.SETID AND A.BANK_CD = B.COUNTERPARTY AND B.SETID = C.SETID AND B.BANK_CD = C.BANK_CD AND B.BANK_CD_CPTY = C.BANK_CD_CPTY AND B.BANK_ACCT_KEY = C.BANK_ACCT_KEY |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BNK_ID_NBR |
Character(20) | VARCHAR2(20) NOT NULL | A literal alphanumeric attribute that uniquely identifies a given bank or counterparty. |
| 2 | BANK_ACCOUNT_NUM |
Character(35) | VARCHAR2(35) NOT NULL | The literal unique identifier associated with a given bank/counterparty account. |
| 3 | DEBIT_RT_INDEX | Character(10) | VARCHAR2(10) NOT NULL | Debit Rate Index |
| 4 | DEBIT_MARGIN_PTS | Signed Number(13,8) | DECIMAL(11,8) NOT NULL | Debit Margin Point |
| 5 | CREDIT_RT_INDEX | Character(10) | VARCHAR2(10) NOT NULL | Credit Rate Index |
| 6 | CREDIT_MARGIN_PTS | Signed Number(13,8) | DECIMAL(11,8) NOT NULL | Credit Margin Point |