RY_SVY_ESRVC_VW (SQL View)	Index Back
Employee Service Date view View of most recent service date for each EMPLID

RY_SVY_ESRVC_VW

(SQL View)

Employee Service Date view

View of most recent service date for each EMPLID

SELECT EMPLID , MAX(HIRE_DT) FROM PS_JOB GROUP BY EMPLID HAVING MAX(HIRE_DT) IS NOT NULL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 HIRE_DT Date(10) DATE Hire Date field used in HD_360_RESPONSE_SYNC message.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	HIRE_DT	Date(10)	DATE	Hire Date field used in HD_360_RESPONSE_SYNC message.