HR_POTNL_KMETR

(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_KEY_PERS_SRCH 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

# 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