RISK_LEAVING_VW

(SQL View)
 Index Back

Risk of Leaving by EffDt

RISK_LEAVING_VW is a view which selects the latest risk of leaving value for each career plan from the CAREERPLAN record. This is displayed for each candidate in the Succession Planning application.

SELECT A.EMPLID ,A.RISK_OF_LEAVING FROM PS_CAREERPLAN A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_CAREERPLAN B WHERE B.EMPLID = A.EMPLID AND B.EFFDT <= %CurrentDateIn)

  • Parent record: CAREERPLAN

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

    Prompt Table: PERSON

    2 RISK_OF_LEAVING Character(1) VARCHAR2(1) NOT NULL Risk of Leaving
    1=High
    2=Medium
    3=Low