BANK_IMP_CRYPT (SQL Table)	Index Back
BANK_IMP_CRYPT Record to Store Encrypted Values of Bank Accounts when import bank statements are processed

BANK_IMP_CRYPT

(SQL Table)

BANK_IMP_CRYPT

Record to Store Encrypted Values of Bank Accounts when import bank statements are processed

# 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 LASTFOUR Character(4) VARCHAR2(4) NOT NULL Last Four Digits

4 BANK_ACCT_ENCRYPT Character(250) VARCHAR2(250) NOT NULL Stores Encrypted BankAccount Value

5 SEQNBR Number(5,0) INTEGER NOT NULL Sequence Number

6 BNK_ID_ACT_ENCRYPT Character(250) VARCHAR2(250) NOT NULL Stores Encrypted value of BankID and AccountNumber

7 DATETIME_STAMP DateTime(26) TIMESTAMP DateTime Stamp
Default Value: %datetime

#	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	LASTFOUR	Character(4)	VARCHAR2(4) NOT NULL	Last Four Digits
4	BANK_ACCT_ENCRYPT	Character(250)	VARCHAR2(250) NOT NULL	Stores Encrypted BankAccount Value
5	SEQNBR	Number(5,0)	INTEGER NOT NULL	Sequence Number
6	BNK_ID_ACT_ENCRYPT	Character(250)	VARCHAR2(250) NOT NULL	Stores Encrypted value of BankID and AccountNumber
7	DATETIME_STAMP	DateTime(26)	TIMESTAMP	DateTime Stamp Default Value: %datetime