HR_POTNL_NMETR

(SQL View)
 Index Back

Career Planning Summary Report

View used for Career Planning Summary Reports. (Key persons)

SELECT A.OPRID , A.ROWSECCLASS , A.EMPLID , A.EMPL_RCD , B.EFFDT , B.TIME_REMAINING , B.UNITS_OF_TIME , B.RETIREMENT_DT , P.POTENTIAL , P.REVIEW_DT , A.BUSINESS_UNIT , A.COMPANY , A.DEPTID , A.LOCATION , A.SETID_DEPT , A.SETID_LOCATION FROM PS_HR_CP_PERS_PJOB A LEFT OUTER JOIN PS_HR_CP_PLAN B ON A.EMPLID = B.EMPLID LEFT OUTER JOIN PS_CAREER_POTENTL P ON A.EMPLID = P.EMPLID AND P.EFFDT = B.EFFDT WHERE NOT EXISTS ( SELECT 'X' FROM PS_HR_TPOOL T , PS_HR_TPOOL_MBR TM WHERE T.STATUS = 'A' AND TM.HR_TP_ID = T.HR_TP_ID AND TM.EMPLID = A.EMPLID AND TM.EFFDT = T.EFFDT AND %EffdtCheck(HR_TPOOL, T, %CurrentDateIn) )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 ROWSECCLASS Character(30) VARCHAR2(30) NOT NULL The class used to determine row level security
3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
5 EFFDT Date(10) DATE Effective Date

Default Value: %date

6 TIME_REMAINING Number(2,0) SMALLINT NOT NULL Time Remaining in Role
7 UNITS_OF_TIME Character(1) VARCHAR2(1) NOT NULL Units of Time
1=Months
2=Years
8 RETIREMENT_DT Date(10) DATE Projected Retirement Date
9 POTENTIAL Character(1) VARCHAR2(1) NOT NULL Career Potential
H=High Potential Candidate
L=Lateral Transfer
O=Officer Potential
P=Promotable
W=Currently Well Placed
10 REVIEW_DT Date(10) DATE Review Date
11 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
12 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
13 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
14 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
15 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department Set ID
16 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location Set ID