PY_ELIGIBLE_VW (SQL View)	Index Back
Year End Form Self Service Stores eligibility information about whether employee can grant consent to receive electronic year end form.

PY_ELIGIBLE_VW

(SQL View)

Year End Form Self Service

Stores eligibility information about whether employee can grant consent to receive electronic year end form.

SELECT DISTINCT A.EMPLID ,C.COUNTRY ,'Y' FROM PS_PERSON A ,PS_JOB B ,PS_PAYGROUP_TBL C WHERE B.EMPLID=A.EMPLID AND B.EFFDT= ( SELECT MAX (G.EFFDT) FROM PS_JOB G WHERE G.EMPLID=B.EMPLID AND G.EMPL_RCD=B.EMPL_RCD AND G.EFFDT<= %CurrentDateIn) AND C.COMPANY=B.COMPANY AND C.PAYGROUP=B.PAYGROUP AND C.EFFDT= ( SELECT MAX (H.EFFDT) FROM PS_PAYGROUP_TBL H WHERE H.COMPANY=B.COMPANY AND H.PAYGROUP=B.PAYGROUP AND H.EFFDT<= %CurrentDateIn) AND ( (C.COUNTRY='USA' AND EXISTS ( SELECT 'x' FROM PS_CHECK_YTD US WHERE US.EMPLID=A.EMPLID AND US.COMPANY=B.COMPANY)) OR (C.COUNTRY='CAN' AND EXISTS ( SELECT 'x' FROM PS_CAN_CHECK_YTD US WHERE US.EMPLID=A.EMPLID AND US.COMPANY=B.COMPANY)))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

3 PY_YE_ELIGIBLE Character(1) VARCHAR2(1) NOT NULL Self Service Year End Forms
Y/N Table Edit

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
3	PY_YE_ELIGIBLE	Character(1)	VARCHAR2(1) NOT NULL	Self Service Year End Forms Y/N Table Edit