GPMY_RCPFIL_AET (SQL Table)	Index Back
Recipient EFT Payment - MYS State Record for Recipient Payment File generation process for Malaysia.

GPMY_RCPFIL_AET

(SQL Table)

Recipient EFT Payment - MYS

State Record for Recipient Payment File generation process for Malaysia.

# 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 GPMY_RCPNT_OPTN Character(2) VARCHAR2(2) NOT NULL Determines how recipients are to be selected for inclusiuon in the MYS 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 GPMY_MEMBER_ID Character(15) VARCHAR2(15) NOT NULL This is the employees membership id number issued by a recipient organization to identify the employee.

12 GPMY_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 GPMY_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

#	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	GPMY_RCPNT_OPTN	Character(2)	VARCHAR2(2) NOT NULL	Determines how recipients are to be selected for inclusiuon in the MYS 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	GPMY_MEMBER_ID	Character(15)	VARCHAR2(15) NOT NULL	This is the employees membership id number issued by a recipient organization to identify the employee.
12	GPMY_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	GPMY_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