SSF_BNK_NLD_STG

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SCC_TEMP_ID	Number(16,0)	DECIMAL(16) NOT NULL	Temp Constituent ID
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
9	BANK_CD	Character(11)	VARCHAR2(11) NOT NULL	Bank ID
10	BRANCH_EC_CD	Character(17)	VARCHAR2(17) NOT NULL	Bank Branch ID
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
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
19	SCC_ROW_ADD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Created By
20	SCC_ROW_ADD_DTTM	DateTime(26)	TIMESTAMP	Created
21	SCC_ROW_UPD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Updated By
22	SCC_ROW_UPD_DTTM	DateTime(26)	TIMESTAMP	Last Update Date/Time