EMPLIDDefault Value: PER_ORG_ASGN.EMPLID
Prompt Table: PERS_SRCH_GBL
EMPL_RCDEFFDTDefault Value: %date
EFFSEQSTART_DATELANGUAGE_CDHR_RWORK_LVW(SQL View) |
Index Back |
|---|---|
Remote worker Rel langRelated lang record for HR_RWORK_VW |
| SELECT A.emplid ,A.empl_rcd ,a.effdt ,a.effseq ,R.start_date ,PNL.LANGUAGE_CD ,HR_RW_REASON ,CASE WHEN hr_rw_loc_type ='W' THEN( SELECT DESCR FROM PS_LOCATION_LANG L WHERE R.LOCATION=L.LOCATION AND L.LANGUAGE_CD= PNL.LANGUAGE_CD AND L.EFFDT=( SELECT MAX(L1.EFFDT) FROM PS_LOCATION_LANG L1 WHERE L.SETID = L1.SETID AND L.LOCATION = L1.LOCATION AND PNL.LANGUAGE_CD =L1.LANGUAGE_CD AND L1.EFFDT <= %CurrentDateIn) ) ELSE 'Not Applicable' END ,CASE WHEN RW_PERCENT>0 AND RW_PERCENT <=20 THEN '0-20%' WHEN RW_PERCENT >20 AND RW_PERCENT<=40 THEN '21%-40%' WHEN RW_PERCENT >40 AND RW_PERCENT<=60 THEN '41%-60%' WHEN RW_PERCENT >60 AND RW_PERCENT<=80 THEN '61%-80%' WHEN RW_PERCENT >80 THEN '81%-100%' ELSE ( SELECT MESSAGE_TEXT FROM PSMSGCATLANG ML WHERE message_set_nbr='1000' AND message_nbr='3051' AND ML.LANGUAGE_CD =PNL.LANGUAGE_CD ) END , CASE WHEN HR_RW_TYPE='H' THEN ( SELECT XLATLONGNAME FROM PSXLATITEMLANG A WHERE FIELDNAME = 'HR_RW_TYPE' AND FIELDVALUE = 'H' AND A.LANGUAGE_CD =PNL.LANGUAGE_CD AND EFFDT = ( SELECT MAX(EFFDT) FROM PSXLATITEMLANG AA WHERE A.FIELDNAME = AA.FIELDNAME AND A.FIELDVALUE = AA.FIELDVALUE AND PNL.LANGUAGE_CD =AA.LANGUAGE_CD AND AA.EFFDT <= %CurrentDateIn) ) WHEN HR_RW_TYPE='F' THEN ( SELECT XLATLONGNAME FROM PSXLATITEMLANG A WHERE FIELDNAME = 'HR_RW_TYPE' AND FIELDVALUE = 'F' AND PNL.LANGUAGE_CD =A.LANGUAGE_CD AND EFFDT = ( SELECT MAX(EFFDT) FROM PSXLATITEMLANG AA WHERE A.FIELDNAME = AA.FIELDNAME AND A.FIELDVALUE = AA.FIELDVALUE AND PNL.LANGUAGE_CD =AA.LANGUAGE_CD AND AA.EFFDT <= %CurrentDateIn) ) ELSE ( SELECT MESSAGE_TEXT FROM PSMSGCATLANG ML WHERE message_set_nbr='1000' AND message_nbr='3050' AND ML.LANGUAGE_CD =PNL.LANGUAGE_CD ) END FROM (PS_JOB A LEFT OUTER JOIN PS_HR_RWORK_TBL R ON A.EMPLID=R.EMPLID AND A.EMPL_RCD=R.EMPL_RCD AND R.RW_SS_STATUS='A' ) , PSPNLGDEFNLANG PNL WHERE PNL.PNLGRPNAME = 'JOB_DATA' AND PNL.MARKET = 'GBL' AND A.EFFDT = ( SELECT MAX(A_ED.EFFDT) FROM PS_JOB A_ED WHERE A.EMPLID = A_ED.EMPLID AND A.EMPL_RCD = A_ED.EMPL_RCD AND A_ED.EFFDT <= %CurrentDateIn) AND A.EFFSEQ = ( SELECT MAX(A_ES.EFFSEQ) FROM PS_JOB A_ES WHERE A.EMPLID = A_ES.EMPLID AND A.EMPL_RCD = A_ES.EMPL_RCD AND A.EFFDT = A_ES.EFFDT) |
| # | 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 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | EFFSEQ |
Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 5 | START_DATE |
Date(10) | DATE NOT NULL | Start Date for Gen Standing PO |
| 6 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 7 | HR_RW_REASON | Character(60) | VARCHAR2(60) NOT NULL | Remote Worker Reason |
| 8 | HR_RW_LOCATION | Character(30) | VARCHAR2(30) NOT NULL | Remote Work Location |
| 9 | RW_PERCENT_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Remote Work Percent |
| 10 | RW_TYPE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Remote Worker Type |