SSF_BANK_ACCT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMMON_ID	Character(11)	VARCHAR2(11) NOT NULL	Common ID to store Personal ID / Ext Org ID value
2	SA_ID_TYPE	Character(1)	VARCHAR2(1) NOT NULL	ID Type O=Organization P=Person
3	SSF_BANK_ACCT_ID	Number(3,0)	SMALLINT NOT NULL	Unique Bank Account Identifier. It is a sequence number field, unique by COMMON_ID, SA_ID_TYPE.
4	ACCT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Account Status A=Active I=Inactive Default Value: A
5	BANK_ACCT_TYP	Character(1)	VARCHAR2(1) NOT NULL	Bank Account Type C=Checking S=Savings Default Value: C
6	COUNTRY_CD	Character(3)	VARCHAR2(3) NOT NULL	Country Code Default Value: INSTALLATION.COUNTRY Prompt Table: COUNTRY_TBL
7	BANK_CD	Character(11)	VARCHAR2(11) NOT NULL	Bank ID Prompt Table: BANK_EC_TBL
8	BRANCH_EC_CD	Character(17)	VARCHAR2(17) NOT NULL	Bank Branch ID Prompt Table: %GP_EDIT_FLD1
9	SSF_BNK_ACCT_NUM	Character(44)	VARCHAR2(44) NOT NULL	Bank Account Number
10	CHECK_DIGIT	Character(2)	VARCHAR2(2) NOT NULL	Check Digit
11	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
12	ACCOUNT_NAME	Character(50)	VARCHAR2(50) NOT NULL	Account Name
13	SSF_ACCT_NICKNAME	Character(50)	VARCHAR2(50) NOT NULL	Nickname on the Bank Accounts page.
14	SSF_IBAN_ENC	Character(128)	VARCHAR2(128) 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
18	PRENOTE_REQD	Character(1)	VARCHAR2(1) NOT NULL	Prenotification Reqd
19	PRENOTE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Prenotification Status C=Completed N=Not Submitted P=Pending R=Rejected S=Submitted
20	PRENOTE_DATE	Date(10)	DATE	Prenotification Date
21	SCC_ROW_ADD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Created By
22	SCC_ROW_ADD_DTTM	DateTime(26)	TIMESTAMP	Created
23	SCC_ROW_UPD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Updated By
24	SCC_ROW_UPD_DTTM	DateTime(26)	TIMESTAMP	Last Update Date/Time