GPSG_RCPFIL_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
4	DEBIT_DT	Date(10)	DATE	Debit Date
5	PAYMENT_DT	Date(10)	DATE	Payment Date
6	GPSG_RCPNT_OPTN	Character(2)	VARCHAR2(2) NOT NULL	Determines how recipients are to be selected for inclusiuon in the SGP EFT & Recipient processing. 10=Selected Recipients 20=All Recipients 30=Selected Deduction
7	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
8	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
9	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
10	RECIPIENT_ID	Character(8)	VARCHAR2(8) NOT NULL	Payment recipient ID
11	GPSG_MEMBER_ID	Character(10)	VARCHAR2(10) NOT NULL	This is the employees membership id number issued by a recipient organization to identify the employee.
12	GPSG_MEMBERSHIP_TY	Character(1)	VARCHAR2(1) NOT NULL	Indicates whether the employee's Membership ID assigned to him/her by a recipient is the same value as the employee's primary national ID.
13	GPSG_RCP_COMM_TYPE	Character(2)	VARCHAR2(2) NOT NULL	This determines if a payment amount is reduced by any commission amount when paying a recipient. 10=Flat Amount 20=Percentage 30=None
14	ERROR_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Error Type ERR=Stop NON=None WAR=Warning