PYE_BANKACCT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	ACCOUNT_ID	Number(3,0)	SMALLINT NOT NULL	Account ID
3	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
4	ACCOUNT_TYPE_PYE	Character(1)	VARCHAR2(1) NOT NULL	Payee Bank Account Type A=Current Account B=Building Society Roll Number C=Checking G=Giro Account R=Regular S=Savings T=Salary Account Default Value: C
5	COUNTRY_CD	Character(3)	VARCHAR2(3) NOT NULL	Country Code Default Value: OPR_DEF_TBL_HR.COUNTRY Prompt Table: GPSC_CNT_DVW_FL
6	BANK_CD	Character(11)	VARCHAR2(11) NOT NULL	Bank ID Prompt Table: BANK_EC_TBL
7	BRANCH_EC_CD	Character(17)	VARCHAR2(17) NOT NULL	Bank Branch ID Prompt Table: %GP_EDIT_FLD1
8	ACCOUNT_EC_ID	Character(35)	VARCHAR2(35) NOT NULL	Account Number used in banking.
9	CHECK_DIGIT	Character(2)	VARCHAR2(2) NOT NULL	Check Digit
10	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: COUNTRY_CUR_TBL.CURRENCY_CD Prompt Table: CURRENCY_CD_TBL
11	ACCOUNT_NAME	Character(50)	VARCHAR2(50) NOT NULL	Account Name
12	INTL_BANK_ACCT_NBR	Character(34)	VARCHAR2(34) NOT NULL	IBAN International Bank Account Number
13	ROLL_NAME	Character(50)	VARCHAR2(50) NOT NULL	Roll Name
14	ROLL_NUMBER	Character(20)	VARCHAR2(20) NOT NULL	Roll Number
15	IAT_IND	Character(1)	VARCHAR2(1) NOT NULL	International ACH Transaction Bank (or IAT) Indicator Y/N Table Edit Default Value: N
16	ACCOUNT_NAME_AC	Character(40)	VARCHAR2(40) NOT NULL	This field stores the account name in an alternate character format
17	HSC_BANKACCCRYPT	Character(100)	VARCHAR2(100) NOT NULL	Encrypted Bank Account
18	HSC_BANKACCCRYPT3	Character(100)	VARCHAR2(100) NOT NULL	Encrypted Bank Account