EMPLIDPrompt Table: PERSON
0=Ready Now
1=1 - 2 Years
2=3 - 5 Years
E=Emergency
R=Retirement
HR_SP_RD_MBR_VW(SQL View) |
Index Back |
|---|---|
EE Curr Career Readiness ViewHR_SP_RD_VW is a view of CAREERPATH which retrieves the career readiness from the current career plan for an employee. It is used to intialize Succession Plans/Talent Pool Adhoc search. |
| SELECT DISTINCT A.EMPLID ,A.READINESS FROM PS_CAREERPATH A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_CAREERPATH B WHERE B.EMPLID = A.EMPLID) |
| # | 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 |