GPAU_EFT_PMT_VW (SQL View)	Index Back
EFT Pay Info for pay reporting Retrieves employee payment details

GPAU_EFT_PMT_VW

(SQL View)

EFT Pay Info for pay reporting

Retrieves employee payment details

SELECT DISTINCT TR.EMPLID , TR.EMPL_RCD , TR.GPAU_EFT_TRANS_CD , PER.NAME , HD.PAYMENT_DT , TR.GP_PMT_AMT FROM PS_GPAU_EFT_CMX_HD HD , PS_GPAU_EFT_CMX_TR TR , PS_PERSON_NAME PER WHERE HD.GPAU_EFT_USER_NO = TR.GPAU_EFT_USER_NO AND TR.EMPLID = PER.EMPLID AND TR.PMT_TYPE = '01'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

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

3 GPAU_EFT_TRANS_CD Character(2) VARCHAR2(2) NOT NULL This field tracks 3 values used in the output file for the AE program GPAU_EFT_CMX.
13=Debit
50=Recipient Credit
53=Payroll Credit
Default Value: 13

4 NAME Character(50) VARCHAR2(50) NOT NULL Name

5 PAYMENT_DT Date(10) DATE Payment Date

6 GP_PMT_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount field on GP PAYMENT table

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
3	GPAU_EFT_TRANS_CD	Character(2)	VARCHAR2(2) NOT NULL	This field tracks 3 values used in the output file for the AE program GPAU_EFT_CMX. 13=Debit 50=Recipient Credit 53=Payroll Credit Default Value: 13
4	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
5	PAYMENT_DT	Date(10)	DATE	Payment Date
6	GP_PMT_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Amount field on GP PAYMENT table