POSITION_NBRRANKHR_SP_READINESS0=Ready Now
1=1 - 2 Years
2=3 - 5 Years
E=Emergency
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.HR_SUCC_PLAN_CTL ,A.RANK ,A.HR_SP_READINESS ,A.EMPLID ,A.EFFDT ,B.NAME ,B.NAME_AC FROM PS_HR_SUCC_PLN_DTL A ,PS_PERSON_NAME B WHERE B.EMPLID = A.EMPLID AND A.EFFDT = ( SELECT MAX(D.EFFDT) FROM PS_HR_SUCC_PLN_DTL D WHERE D.EMPLID = A.EMPLID AND D.HR_SUCC_PLAN_ID = A.HR_SUCC_PLAN_ID AND D.HR_SUCC_PLAN_TYPE = A.HR_SUCC_PLAN_TYPE AND D.HR_SUCC_PLAN_CTL = A.HR_SUCC_PLAN_CTL) AND A.HR_SUCC_PLAN_TYPE = '3' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | POSITION_NBR |
Character(8) | VARCHAR2(8) NOT NULL | Position Number |
| 2 | RANK |
Number(3,0) | SMALLINT NOT NULL | Rank |
| 3 | HR_SP_READINESS |
Character(1) | VARCHAR2(1) NOT NULL |
Displays Readiness of a Succession Plan Candidate.
0=Ready Now 1=1 - 2 Years 2=3 - 5 Years E=Emergency |
| 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 |