GPGB_PMT_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	RECIPIENT_ID	Character(8)	VARCHAR2(8) NOT NULL	Payment recipient ID
3	GPGB_DEST_SORTCODE	Character(11)	VARCHAR2(11) NOT NULL	UK Destination Sorting Code for EFT
4	GPGB_DEST_ACCT_NBR	Character(35)	VARCHAR2(35) NOT NULL	UK Destination Account Number for EFT
5	GPGB_DEST_ACCTNAME	Character(50)	VARCHAR2(50) NOT NULL	UK Destination Account Name for EFT
6	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
7	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
8	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
9	STRM_NUM	Number(4,0)	SMALLINT NOT NULL	Stream Number
10	EMPLID_FROM	Character(11)	VARCHAR2(11) NOT NULL	EMPLID (first for a range)
11	EMPLID_TO	Character(11)	VARCHAR2(11) NOT NULL	EmplID To
12	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity
13	PRD_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Period Type C=Current R=Retro
14	ORG_LINK_OPTN	Character(2)	VARCHAR2(2) NOT NULL	Identifies at what org level source banks are assigned. Value set at this time: Company, Dept, Location, Pay Entity, Pay Group CO=Company DE=Department ET=Establishment LO=Location PG=Pay Group
15	RUN_CALC_IND	Character(1)	VARCHAR2(1) NOT NULL	Calculate Payees Y/N Table Edit Default Value: N
16	RUN_FINAL_IND	Character(1)	VARCHAR2(1) NOT NULL	Finalize Entire Run Y/N Table Edit Default Value: N
17	UPDATE_STATS_IND	Character(1)	VARCHAR2(1) NOT NULL	Update Statistics