GPJP_BA01_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	JOBINSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Job Instance
4	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
5	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id Prompt Table: GP_CAL_RUN_SRC2
6	RUN_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Run Type Name
7	SRC_BANK_ID	Character(8)	VARCHAR2(8) NOT NULL	Source Bank ID
8	DEPOSIT_DATE	Date(10)	DATE	Deposit Date
9	FILE_HANDLE	Character(2)	VARCHAR2(2) NOT NULL	File Handle Prompt Table: GPJP_FILE_HANDL
10	GPJP_EFT_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Payment Type. 11=Salary 12=Bonus Default Value: 11
11	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
12	ERROR_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Error Type ERR=Stop NON=None WAR=Warning
13	GP_PMT_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Amount field on GP PAYMENT table
14	RECORD_COUNT	Number(7,0)	INTEGER NOT NULL	Count of Records
15	GPJP_PMT_AMT_CHAR	Character(12)	VARCHAR2(12) NOT NULL	Tracks the value of GP_PMT_AMT in a character format.
16	GPJP_COUNT_CHAR	Character(6)	VARCHAR2(6) NOT NULL	Tracks the value of GPJP_REC_COUNT in a character format.
17	GPJP_CHARDATE	Character(4)	VARCHAR2(4) NOT NULL	This field stores dates in a character format, specifically in the format of MMDD.
18	GPJP_COMPANY_CODE	Character(10)	VARCHAR2(10) NOT NULL	Tracks a company identifier assigned by the banking institution.
19	BANK_CD	Character(11)	VARCHAR2(11) NOT NULL	Bank ID
20	BRANCH_EC_CD	Character(17)	VARCHAR2(17) NOT NULL	Bank Branch ID
21	ACCOUNT_EC_ID	Character(35)	VARCHAR2(35) NOT NULL	Account Number used in banking.
22	GPJP_BANK_CD	Character(4)	VARCHAR2(4) NOT NULL	Stores bank code in a right justified, 0 filled format, i.e. 0009.
23	GPJP_BRANCH_EC_CD	Character(3)	VARCHAR2(3) NOT NULL	Stores Branch Number in a right justified, zero filled format, i.e. 009.
24	GPJP_ACCOUNT_EC_ID	Character(7)	VARCHAR2(7) NOT NULL	Stores Account Number in a right justified, zero filled format, i.e. 0009999.