GPFR_FOR_DATE (SQL View)	Index Back
Dates of Training DIF Alloc View contains Dates of Training DIF Allocation

GPFR_FOR_DATE

(SQL View)

Dates of Training DIF Alloc

View contains Dates of Training DIF Allocation

SELECT A2.EMPLID , A2.EMPL_RCD , A2.PRD_END_DT ,P2.PIN_NUM FROM PS_GP_PYE_PRC_STAT A2 , PS_GP_PYE_SEG_STAT B2 , PS_GP_RSLT_ERN_DED P2 WHERE B2.CAL_RUN_ID=A2.CAL_RUN_ID AND B2.EMPLID=A2.EMPLID AND B2.EMPL_RCD=A2.EMPL_RCD AND B2.GP_PAYGROUP=A2.GP_PAYGROUP AND B2.CAL_ID=A2.CAL_ID AND B2.ORIG_CAL_RUN_ID=A2.ORIG_CAL_RUN_ID AND B2.PYE_CALC_STAT>='50' AND B2.CALC_ACTION='C' AND P2.CAL_RUN_ID=A2.CAL_RUN_ID AND P2.EMPLID=A2.EMPLID AND P2.EMPL_RCD=A2.EMPL_RCD AND P2.GP_PAYGROUP=A2.GP_PAYGROUP AND P2.CAL_ID=A2.CAL_ID AND P2.ORIG_CAL_RUN_ID=A2.ORIG_CAL_RUN_ID AND P2.RSLT_SEG_NUM=B2.RSLT_SEG_NUM AND A2.RSLT_VER_NUM= ( SELECT MAX(V2.RSLT_VER_NUM) FROM PS_GP_PYE_PRC_STAT V2 WHERE V2.EMPLID=A2.EMPLID AND V2.EMPL_RCD=A2.EMPL_RCD AND V2.PRC_ORD_TS=A2.PRC_ORD_TS AND V2.COUNTRY=A2.COUNTRY) AND A2.RSLT_REV_NUM=1

# 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 Rcd Nbr

3 GPFR_END_DT Date(10) DATE End Date

4 GPFR_PIN_NUM1 Number(8,0) INTEGER NOT NULL GPFR: Sort Key 2

#	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 Rcd Nbr
3	GPFR_END_DT	Date(10)	DATE	End Date
4	GPFR_PIN_NUM1	Number(8,0)	INTEGER NOT NULL	GPFR: Sort Key 2