SETIDBANK_CDBANK_CD_CPTYBANK_ACCT_KEYBNK_ID_NBRBANK_ACCOUNT_NUMDefault Value: %datetime
BANK_ACCT_CRYPT(SQL Table) |
Index Back |
|---|---|
BANK_ACCT_CRYPTRecord to Store Encrypted Values of External Accounts |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | BANK_CD |
Character(5) | VARCHAR2(5) NOT NULL | Bank Code |
| 3 | BANK_CD_CPTY |
Character(5) | VARCHAR2(5) NOT NULL | An internal key field convention that facilitates the system distinction between banks and counterparties. |
| 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 | BNK_ID_NBR |
Character(20) | VARCHAR2(20) NOT NULL | A literal alphanumeric attribute that uniquely identifies a given bank or counterparty. |
| 6 | BANK_ACCOUNT_NUM |
Character(35) | VARCHAR2(35) NOT NULL | The literal unique identifier associated with a given bank/counterparty account. |
| 7 | LASTFOUR | Character(4) | VARCHAR2(4) NOT NULL | Last Four Digits |
| 8 | BANK_ACCT_ENCRYPT | Character(250) | VARCHAR2(250) NOT NULL | Stores Encrypted BankAccount Value |
| 9 | SEQNBR | Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 10 | BNK_ID_ACT_ENCRYPT | Character(250) | VARCHAR2(250) NOT NULL | Stores Encrypted value of BankID and AccountNumber |
| 11 | IBAN_ID | Character(34) | VARCHAR2(34) NOT NULL | IBAN - Internation Bank Account Number is used in European countries to uniquely identify Bank accounts across borders |
| 12 | IBAN_ID_ENCRYPT | Character(250) | VARCHAR2(250) NOT NULL | Encrypt IBAN |
| 13 | DATETIME_STAMP | DateTime(26) | TIMESTAMP |
DateTime Stamp
Default Value: %datetime |