GPMY_NRP_RCP_VW

(SQL View)
 Index Back

Recipient Payment File - Body

Body (detail lines) of the Recipient Payment File

SELECT A.RECIPIENT_ID ,A.GPMY_RCP_GROUP_ID ,A.PAY_ENTITY ,A.PAYMENT_DT ,A.EMPLID ,A.EMPL_RCD ,A.PIN_NUM + 50000000 ,A.FIRST_NAME ,A.LAST_NAME ,A.GPMY_MEMBER_ID ,A.GP_PMT_AMT FROM PS_GPMY_RCPPAY_DTL A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RECIPIENT_ID Character(8) VARCHAR2(8) NOT NULL Payment recipient ID
2 GPMY_RCP_GROUP_ID Character(10) VARCHAR2(10) 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.
3 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
4 PAYMENT_DT Date(10) DATE NOT NULL Payment Date
5 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
6 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
7 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
8 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
9 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
10 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.
11 GP_PMT_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount field on GP PAYMENT table