POSITION_NBRPrompt Table: POSITION_DATA
RANKREADINESS0=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
EMPLIDPrompt Table: PERSON
SUCCESS_TR_SRCH(SQL View) |
Index Back |
|---|---|
Search Vw-Succession Plan TreeSUCESS_TR_SRCH is a view which is used as the candidate search record in the Succession Plan trees. The Tree Editor's dynamic detail feature retrieves only the candidates for a particular key position from this view. The view sorts the candidates in Rank/Readiness order. 8/8/03 Lee - ICE 59502000 - Added position number to the where clause. |
| SELECT A.POSITION_NBR ,A.RANK ,A.READINESS ,A.EMPLID ,A.EFFDT ,B.NAME ,B.NAME_AC FROM PS_SUCCESSION_PLAN A ,PS_PERSON_NAME B WHERE B.EMPLID = A.EMPLID AND A.EFFDT = ( SELECT MAX(D.EFFDT) FROM PS_SUCCESSION_PLAN D WHERE D.EMPLID = A.EMPLID AND D.POSITION_NBR = A.POSITION_NBR) |
| # | 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 | RANK |
Number(3,0) | SMALLINT NOT NULL | Force Ranking |
| 3 | 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 |
| 4 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
| 5 | PLAN_DT | Date(10) | DATE | Succession Plan Date |
| 6 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 7 | NAME_AC | Character(50) | VARCHAR2(50) NOT NULL | Alternate Character Name |