GPNZ_RCP_PYENT (SQL Table)	Index Back
Stores Extra Recipient Info The record is used for recipient country extension information. It stores commission options and group ids for each Pay Entity dealing with a particular recipient.

GPNZ_RCP_PYENT

(SQL Table)

Stores Extra Recipient Info

The record is used for recipient country extension information. It stores commission options and group ids for each Pay Entity dealing with a particular recipient.

Parent record: GPNZ_RECIPIENT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RECIPIENT_ID Character(8) VARCHAR2(8) NOT NULL Payment recipient ID

2 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

3 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
Prompt Table: GP_PYENT

4 GPNZ_RCP_COMM_AMT Number(9,2) DECIMAL(8,2) NOT NULL The Commission Amount is the percentage or flat amount deducted from payments to a recipient.

5 GPNZ_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
Default Value: 30

6 GPNZ_RCP_COMM_OPTN Character(2) VARCHAR2(2) NOT NULL This determines how commission on recipient payments is to be calculated.
10=Deduct from Payment
20=Report Only
30=None
Default Value: 30

7 GPNZ_RCP_GROUP_ID Character(12) VARCHAR2(12) NOT NULL The Group ID is an identifier that has been assigned to the Pay Entity by a recipient. It is used when reporting payments to recipients to identify the company the payments are from.

8 GPNZ_EFT_DETAIL Character(1) VARCHAR2(1) NOT NULL Indicates whether the recipient should receive a single EFT payment or one for each employee.
Y/N Table Edit
Default Value: N

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RECIPIENT_ID	Character(8)	VARCHAR2(8) NOT NULL	Payment recipient ID
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity Prompt Table: GP_PYENT
4	GPNZ_RCP_COMM_AMT	Number(9,2)	DECIMAL(8,2) NOT NULL	The Commission Amount is the percentage or flat amount deducted from payments to a recipient.
5	GPNZ_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 Default Value: 30
6	GPNZ_RCP_COMM_OPTN	Character(2)	VARCHAR2(2) NOT NULL	This determines how commission on recipient payments is to be calculated. 10=Deduct from Payment 20=Report Only 30=None Default Value: 30
7	GPNZ_RCP_GROUP_ID	Character(12)	VARCHAR2(12) NOT NULL	The Group ID is an identifier that has been assigned to the Pay Entity by a recipient. It is used when reporting payments to recipients to identify the company the payments are from.
8	GPNZ_EFT_DETAIL	Character(1)	VARCHAR2(1) NOT NULL	Indicates whether the recipient should receive a single EFT payment or one for each employee. Y/N Table Edit Default Value: N