GPFR_RTO_VW_LNG

(SQL View)
 Index Back

Terminated Employees View-Rel

Related View to retrieve Terminated employees from Retro Triggers

SELECT DISTINCT RTOVW.EMPLID , SEGVW.EMPL_RCD , CONT.CONTRACT_NUM , ACT.LANGUAGE_CD ,ACT.ACTION_DESCR ,RES.DESCR FROM PS_GP_RTO_TRGR_VW RTOVW , PS_GP_SEG_TRGR_VW SEGVW , PS_JOB JOB ,PS_CNT_ACTIVE_VW CONT , PS_NAMES NAM , PS_ACTION_LNG ACT ,PS_ACTN_RSN_LANG RES ,PS_GP_PYE_SEG_STAT PYESTAT WHERE RTOVW.TRGR_EVENT_ID IN ( SELECT TRGR_EVENT_ID FROM PS_GPFR_TERM_TRG WHERE TRGR_TYPE='R') AND RTOVW.EMPLID=JOB.EMPLID AND CONT.EMPLID=RTOVW.EMPLID AND CONT.CONTRACT_END_DT = %DateAdd(RTOVW.TRGR_EFFDT,-1) AND RTOVW.EMPLID=NAM.EMPLID AND RTOVW.EMPLID=PYESTAT.EMPLID AND PYESTAT.PYE_CALC_STAT = '70' AND JOB.EFFDT=RTOVW.TRGR_EFFDT AND JOB.ACTION=ACT.ACTION AND JOB.ACTION_REASON=RES.ACTION_REASON AND SEGVW.EMPLID=RTOVW.EMPLID AND SEGVW.TRGR_EFFDT=RTOVW.TRGR_EFFDT AND SEGVW.COUNTRY=RTOVW.COUNTRY AND SEGVW.TRGR_EVENT_ID=RTOVW.TRGR_EVENT_ID AND SEGVW.TRGR_CREATE_TS=RTOVW.TRGR_CREATE_TS

  • Related Language Record for GPFR_TER_RTO_VW

    • # 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 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract Number
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 ACTION_DESCR Character(50) VARCHAR2(50) NOT NULL Action Description
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description