POSITION_NBRPrompt Table: POSITION_DATA
EFFDTPrompt Table: PERSON
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_RANK1(SQL View) |
Index Back |
|---|---|
Succession-First-Ranked CandsSUCCESS_RANK1 is a view which selects the first-ranked candidate for each key position for each Succession Plan. This view is used to display the slate of candidates below each successor in the Succession Slate panel. The readiness of each top candidate is also used to determine if they are blocking the candidate below them in the slate. |
| SELECT A.POSITION_NBR ,A.EFFDT ,A.EMPLID ,A.EMPL_RCD ,A.READINESS ,A.TARGETED_READY_DT ,A.BLOCKED FROM PS_SUCCESSION_PLAN A WHERE A.RANK = 1 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | POSITION_NBR |
Character(8) | VARCHAR2(8) NOT NULL |
Position Number
Prompt Table: POSITION_DATA |
| 2 | EFFDT |
Date(10) | DATE NOT NULL | Effective Date |
| 3 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
| 4 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 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 |
| 7 | BLOCKED | Character(1) | VARCHAR2(1) NOT NULL | Blocked |