SSF_COR_BANKACC

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EXT_ORG_ID	Character(11)	VARCHAR2(11) NOT NULL	External Org ID Prompt Table: EXT_ORG_TBL
2	ACCOUNT_ID	Number(3,0)	SMALLINT NOT NULL	Account ID
3	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
4	ACCT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Account Status A=Active I=Inactive Default Value: A
5	SSF_TUIT_CH_NLD	Character(1)	VARCHAR2(1) NOT NULL	Tuition Check NLD Y/N Table Edit Default Value: N
6	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
7	COUNTRY_CD	Character(3)	VARCHAR2(3) NOT NULL	Country Code Default Value: OPR_DEF_TBL_HR.COUNTRY Prompt Table: COUNTRY_TBL
8	BANK_CD	Character(11)	VARCHAR2(11) NOT NULL	Bank ID Prompt Table: BANK_EC_TBL
9	BRANCH_EC_CD	Character(17)	VARCHAR2(17) NOT NULL	Bank Branch ID Prompt Table: %GP_EDIT_FLD1
10	ACCOUNT_EC_ID	Character(35)	VARCHAR2(35) NOT NULL	Account Number used in banking.
11	CHECK_DIGIT	Character(2)	VARCHAR2(2) NOT NULL	Check Digit
12	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: COUNTRY_CUR_TBL.CURRENCY_CD Prompt Table: CURRENCY_CD_TBL
13	ACCOUNT_NAME	Character(50)	VARCHAR2(50) NOT NULL	Account Name
14	INTL_BANK_ACCT_NBR	Character(34)	VARCHAR2(34) NOT NULL	IBAN International Bank Account Number
15	ROLL_NAME	Character(50)	VARCHAR2(50) NOT NULL	Roll Name
16	ROLL_NUMBER	Character(20)	VARCHAR2(20) NOT NULL	Roll Number
17	IAT_IND	Character(1)	VARCHAR2(1) NOT NULL	International ACH Transaction Bank (or IAT) Indicator Y/N Table Edit Default Value: N