HR_RW_ELIG_VW

(SQL View)

SELECT J.emplid ,J.EMPL_RCD , CASE WHEN C.HR_RW_JOB_ELIGIBLE='Y' THEN ( SELECT MESSAGE_TEXT FROM PSMSGCATDEFN WHERE message_set_nbr='1000' AND message_nbr='1787' ) WHEN P.HR_RW_POS_ELIGIBLE='Y' THEN ( SELECT MESSAGE_TEXT FROM PSMSGCATDEFN WHERE message_set_nbr='1000' AND message_nbr='1787' ) WHEN J.HR_RW_JOB_ELIGIBLE='Y' THEN ( SELECT MESSAGE_TEXT FROM PSMSGCATDEFN WHERE message_set_nbr='1000' AND message_nbr='1787' ) ELSE ( SELECT MESSAGE_TEXT FROM PSMSGCATDEFN WHERE message_set_nbr='1000' AND message_nbr='1788' ) END ,CASE WHEN J.LASTUPDDTTM IS NOT NULL AND J.LASTUPDDTTM>=P.LASTUPDDTTM AND J.LASTUPDDTTM>=C.LASTUPDDTTM THEN J.LASTUPDDTTM WHEN P.LASTUPDDTTM IS NOT NULL AND P.LASTUPDDTTM>=J.LASTUPDDTTM AND P.LASTUPDDTTM>=C.LASTUPDDTTM THEN P.LASTUPDDTTM WHEN C.LASTUPDDTTM IS NOT NULL AND C.LASTUPDDTTM>=P.LASTUPDDTTM AND C.LASTUPDDTTM>=J.LASTUPDDTTM THEN C.LASTUPDDTTM END FROM ps_HR_RW_JCELG_VW J ,ps_HR_RW_POSELG_VW P ,PS_HR_RW_CFELG_VW C WHERE J.emplid=P.emplid AND J.EMPL_RCD=P.EMPL_RCD AND C.EMPLID=J.EMPLID AND C.EMPL_RCD=J.EMPL_RCD AND J.REG_REGIon=P.REG_REGION AND P.REG_REGION=C.REG_REGION

# 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 HR_RW_ELIGIBILITY Character(20) VARCHAR2(20) NOT NULL Remote Work Eligibility

4 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	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	HR_RW_ELIGIBILITY	Character(20)	VARCHAR2(20) NOT NULL	Remote Work Eligibility
4	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.