READINESS_VW

(SQL View)
 Index Back

Readiness by EffDt

READINESS_VW is a view which selects the latest readiness value for each career plan from the CAREERPATH record. This is displayed for each candidate in the Succession Planning application.

SELECT A.EMPLID ,A.READINESS ,A.TARGETED_READY_DT FROM PS_CAREERPATH A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_CAREERPATH 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 READINESS Character(1) VARCHAR2(1) NOT NULL Readiness
    0=Ready Now
    1=1 - 2 Years
    2=3 - 5 Years
    E=Emergency
    R=Retirement
    3 TARGETED_READY_DT Date(10) DATE Targeted Ready Date