HR_RWORKVW_LNG

(SQL View)
 Index Back

Remote worker view

This view holds the active employees job and remote request details

SELECT DISTINCT A.emplid ,A.empl_rcd ,l.language_cd , CASE WHEN A.EMPL_TYPE='H' THEN ( SELECT XLATLONGNAME FROM PSXLATITEMLANG XL WHERE FIELDNAME = 'HR_RW_TYPE' AND FIELDVALUE = 'H' AND XL.LANGUAGE_CD=L.LANGUAGE_CD AND EFFDT = ( SELECT MAX(EFFDT) FROM PSXLATITEMLANG AA WHERE XL.FIELDNAME = AA.FIELDNAME AND XL.FIELDVALUE = AA.FIELDVALUE AND XL.LANGUAGE_CD=AA.LANGUAGE_CD AND AA.EFFDT <= %CurrentDateIn) ) WHEN A.EMPL_TYPE='F' THEN ( SELECT XLATLONGNAME FROM PSXLATITEMLANG XL WHERE FIELDNAME = 'HR_RW_TYPE' AND FIELDVALUE = 'F' AND XL.LANGUAGE_CD=L.LANGUAGE_CD AND EFFDT = ( SELECT MAX(EFFDT) FROM PSXLATITEMLANG AA WHERE XL.FIELDNAME = AA.FIELDNAME AND XL.FIELDVALUE = AA.FIELDVALUE AND XL.LANGUAGE_CD=AA.LANGUAGE_CD AND AA.EFFDT <= %CurrentDateIn) ) ELSE ( SELECT MESSAGE_TEXT FROM PSMSGCATLANG ML WHERE ML.message_set_nbr=1000 AND ML.message_nbr=3050 AND ML.LANGUAGE_CD=L.LANGUAGE_CD ) END FROM ps_hr_rworkvw A,PSPRSMDEFNLANG L WHERE L.PORTAL_OBJNAME='HC_HR_SRCH_CD_GBL'

  • Related Language Record for HR_RWORKVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Default Value: PER_ORG_ASGN.EMPLID

    Prompt Table: PERS_SRCH_GBL

    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 RW_TYPE_DESCR Character(30) VARCHAR2(30) NOT NULL Remote Worker Type