HR_CPPOSDATA_VW

(SQL View)
 Index Back

CP_IDP Position Data Work

Data used for Career Planning Individual Development Plan report.

SELECT POSITION_NBR , EFFDT , EFF_STATUS , DESCR , JOBCODE , GVT_PAY_PLAN , MANAGER_LEVEL , ' ' , GVT_OCC_SERIES , GVT_TARGET_GRADE , GRADE FROM PS_POSITION_DATA

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number

Default Value: 00000000

2 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

Default Value: A

4 DESCR3 Character(30) VARCHAR2(30) NOT NULL Descr 3
5 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
6 GVT_PAY_PLAN Character(2) VARCHAR2(2) NOT NULL Pay Plan
7 MANAGER_LEVEL Character(2) VARCHAR2(2) NOT NULL Manager Level
0=Chief Operating Officer
1=Director
2=Senior Officer
3=Vice President
4=Senior Manager
5=Mid-Level Manager
6=First-Line Manager
7=Supervisor
8=All Other Positions
9=Non-Manager
8 DESCR4 Character(30) VARCHAR2(30) NOT NULL Descr 4
9 GVT_OCC_SERIES Character(4) VARCHAR2(4) NOT NULL Occupational Series
10 GVT_TARGET_GRADE Character(2) VARCHAR2(2) NOT NULL Target Grade
11 GRADE Character(3) VARCHAR2(3) NOT NULL Salary Grade

Prompt Table: %EDITTABLE2