EXPLODE_BNK

(SQL Table)
Index Back

Explosion Join Table

Explosion Join Table - with bank keys as additional fields.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OLD_VAL_TO_SEQ Character(50) VARCHAR2(50) NOT NULL OLD VALUE
2 NEW_VAL_TO_SEQ Character(50) VARCHAR2(50) NOT NULL NEW VALUE
3 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code
4 BANK_CD_CUST Character(5) VARCHAR2(5) NOT NULL Represents the customer bank or counterparty in a relationship that pairs differing sets of b
5 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
6 BNK_ID_NBR Character(20) VARCHAR2(20) NOT NULL A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
7 BANK_ACCOUNT_NUM Character(35) VARCHAR2(35) NOT NULL The literal unique identifier associated with a given bank/counterparty account.