GPJP_BA_TRANS

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	JOBINSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Job Instance
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	BANK_CD	Character(11)	VARCHAR2(11) NOT NULL	Bank ID
4	BRANCH_EC_CD	Character(17)	VARCHAR2(17) NOT NULL	Bank Branch ID
5	ACCOUNT_EC_ID	Character(35)	VARCHAR2(35) NOT NULL	Account Number used in banking.
6	ACCOUNT_ID	Number(3,0)	SMALLINT NOT NULL	Account ID
7	BANK_NAME_AC	Character(15)	VARCHAR2(15) NOT NULL	This field stores the bank name in an alternate character format
8	BRANCH_NAME_AC	Character(15)	VARCHAR2(15) NOT NULL	This field stores the branch name in an alternate character format
9	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
10	ACCOUNT_NAME_AC	Character(40)	VARCHAR2(40) NOT NULL	This field stores the account name in an alternate character format
11	GP_PMT_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Amount field on GP PAYMENT table
12	GPJP_PMT_AMT_CHAR	Character(12)	VARCHAR2(12) NOT NULL	Tracks the value of GP_PMT_AMT in a character format.
13	COUNTRY_CD	Character(3)	VARCHAR2(3) NOT NULL	Country Code
14	GPJP_BANK_CD	Character(4)	VARCHAR2(4) NOT NULL	Stores bank code in a right justified, 0 filled format, i.e. 0009.
15	GPJP_BRANCH_EC_CD	Character(3)	VARCHAR2(3) NOT NULL	Stores Branch Number in a right justified, zero filled format, i.e. 009.
16	GPJP_ACCOUNT_EC_ID	Character(7)	VARCHAR2(7) NOT NULL	Stores Account Number in a right justified, zero filled format, i.e. 0009999.