GPSG_NRP_RC2_VW (SQL View)	Index Back
Recipient Payee Sibling Rcd This is the recipient payee sibling record.

GPSG_NRP_RC2_VW

(SQL View)

Recipient Payee Sibling Rcd

This is the recipient payee sibling record.

SELECT EMPLID ,EMPL_RCD ,RECIPIENT_ID ,GPSG_MEMBER_ID ,EFFDT ,PIN_NUM + 50000000 FROM PS_GPSG_RCPPYE_DTL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERSON

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
Default Value: 0

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

4 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.

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

6 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
Prompt Table: GPAU_DED_SRCH

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record Default Value: 0
3	RECIPIENT_ID	Character(8)	VARCHAR2(8) NOT NULL	Payment recipient ID
4	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.
5	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
6	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number Prompt Table: GPAU_DED_SRCH