GPFR_SEG_VW_LNG

(SQL View)
 Index Back

Terminated Employees View-Rel

Related View to retrieve Terminated employees from Segmentation Triggers

SELECT DISTINCT SEGVW.EMPLID , SEGVW.EMPL_RCD , CONT.CONTRACT_NUM ,ACT.LANGUAGE_CD ,ACT.ACTION_DESCR ,RES.DESCR FROM 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 SEGVW.TRGR_EVENT_ID IN ( SELECT TRGR_EVENT_ID FROM PS_GPFR_TERM_TRG WHERE TRGR_TYPE='S') AND SEGVW.EMPLID=JOB.EMPLID AND CONT.EMPLID=SEGVW.EMPLID AND CONT.CONTRACT_END_DT = %DateAdd(SEGVW.TRGR_EFFDT,-1) AND SEGVW.EMPLID=NAM.EMPLID AND SEGVW.EMPLID=PYESTAT.EMPLID AND PYESTAT.SEG_END_DT = %DateAdd(SEGVW.TRGR_EFFDT,-1) AND PYESTAT.PYE_CALC_STAT = '70' AND JOB.EFFDT=SEGVW.TRGR_EFFDT AND JOB.ACTION=ACT.ACTION AND JOB.ACTION_REASON=RES.ACTION_REASON

  • Related Language Record for GPFR_TER_SEG_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 Rcd Nbr
    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