SSF_BANKACC_NLD

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PEOPLE_SRCH
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	ACAD_YEAR	Character(4)	VARCHAR2(4) NOT NULL	Academic Year
8	COUNTRY_CD	Character(3)	VARCHAR2(3) NOT NULL	Country Code Default Value: OPR_DEF_TBL_HR.COUNTRY Prompt Table: COUNTRY_TBL
9	BANK_CD	Character(11)	VARCHAR2(11) NOT NULL	Bank ID Prompt Table: BANK_EC_TBL
10	BRANCH_EC_CD	Character(17)	VARCHAR2(17) NOT NULL	Bank Branch ID Prompt Table: %GP_EDIT_FLD1
11	ACCOUNT_EC_ID	Character(35)	VARCHAR2(35) NOT NULL	Account Number used in banking.
12	CHECK_DIGIT	Character(2)	VARCHAR2(2) NOT NULL	Check Digit
13	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: COUNTRY_CUR_TBL.CURRENCY_CD Prompt Table: CURRENCY_CD_TBL
14	ACCOUNT_NAME	Character(50)	VARCHAR2(50) NOT NULL	Account Name
15	INTL_BANK_ACCT_NBR	Character(34)	VARCHAR2(34) NOT NULL	IBAN International Bank Account Number
16	ROLL_NAME	Character(50)	VARCHAR2(50) NOT NULL	Roll Name
17	ROLL_NUMBER	Character(20)	VARCHAR2(20) NOT NULL	Roll Number
18	IAT_IND	Character(1)	VARCHAR2(1) NOT NULL	International ACH Transaction Bank (or IAT) Indicator Y/N Table Edit Default Value: N