EMPLIDPrompt Table: PERSON
EFFDTDefault Value: %date
Prompt Table: POSITION_DATA
0=Ready Now
1=Ready in 1 to 2 Years
2=Ready in 3 to 5 Years
E=Ready in an Emergency
R=Retire in Current Position
SUCCESS_BLCK_VW(SQL View) |
Index Back |
|---|---|
Successn-Cands w/Min ReadinessSUCCESS_BLCK_VW is a view which selects the minimum readiness for each candidate in a succession plan. This represents the "readiest" they are for any position in the plan, and thus how long it is likely to be before they are promoted. This view is brought into the Succession Plan panel to display the readiness of the key position incumbent. The incumbent's readiness is also used to determine if the candidates below are blocked from advancing. |
| SELECT A.EMPLID ,A.EFFDT ,A.POSITION_NBR ,A.RANK ,A.READINESS ,A.TARGETED_READY_DT FROM PS_SUCCESSION_PLAN A WHERE A.READINESS = (SELECT MIN(READINESS) FROM PS_SUCCESSION_PLAN B WHERE B.EMPLID = A.EMPLID AND B.EMPL_RCD = A.EMPL_RCD AND B.EFFDT = A.EFFDT) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | POSITION_NBR | Character(8) | VARCHAR2(8) NOT NULL |
Position Number
Prompt Table: POSITION_DATA |
| 4 | RANK | Number(3,0) | SMALLINT NOT NULL | Force Ranking |
| 5 | READINESS | Character(1) | VARCHAR2(1) NOT NULL |
Readiness Timeframe
0=Ready Now 1=Ready in 1 to 2 Years 2=Ready in 3 to 5 Years E=Ready in an Emergency R=Retire in Current Position |
| 6 | TARGETED_READY_DT | Date(10) | DATE | Target Date |