PY_BNKACCT_XREF (SQL Table)	Index Back
Bank Account XRef file This record is to map the Bank Account ID to Transit Number and Bank Account Number.

PY_BNKACCT_XREF

(SQL Table)

Bank Account XRef file

This record is to map the Bank Account ID to Transit Number and Bank Account Number.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PY_BNKACCT_ID Character(7) VARCHAR2(7) NOT NULL Identification Number to identify transit number and account number

2 TRANSIT_NUM Character(9) VARCHAR2(9) NOT NULL Bank Transit #

3 ACCOUNT_NUM Character(17) VARCHAR2(17) NOT NULL Account Number

4 PY_BANKACCCRYPT Character(100) VARCHAR2(100) NOT NULL Encrypted Bank Account

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PY_BNKACCT_ID	Character(7)	VARCHAR2(7) NOT NULL	Identification Number to identify transit number and account number
2	TRANSIT_NUM	Character(9)	VARCHAR2(9) NOT NULL	Bank Transit #
3	ACCOUNT_NUM	Character(17)	VARCHAR2(17) NOT NULL	Account Number
4	PY_BANKACCCRYPT	Character(100)	VARCHAR2(100) NOT NULL	Encrypted Bank Account