HR_CP_DEVELOP (SQL View)	Index Back
EE Career Development Plan vw HR_CP_DEVELOP is a view based on CAREER_DEVELOP table for career planning self service product. It is part of Career Planning for an employee. Use it to identify a developmental action plan aimed at strengthening an employee's potential with regard to their job or career.

HR_CP_DEVELOP

(SQL View)

EE Career Development Plan vw

HR_CP_DEVELOP is a view based on CAREER_DEVELOP table for career planning self service product. It is part of Career Planning for an employee. Use it to identify a developmental action plan aimed at strengthening an employee's potential with regard to their job or career.

SELECT A.EMPLID , A.EFFDT , A.EST_COMPLETION_DT , A.SEQ_NUM , A.JPM_CAT_TYPE , A.CAREER_COMPETENCY , A.CAREER_GOAL , A.ACT_COMPLETION_DT , A.DESCRLONG ,%subrec(CAR_DEV_FED_SBR, A) FROM PS_CAREER_DEVELOP A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_CAREER_DEVELOP B WHERE B.EMPLID = A.EMPLID AND B.EFFDT <= %CurrentDateIn)

Related Language Record: CAREER_DVLP_LNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERSON

2 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

3 EST_COMPLETION_DT Date(10) DATE NOT NULL Estimated Completion Date

4 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

5 JPM_CAT_TYPE Character(12) VARCHAR2(12) NOT NULL The name of the type of items that will be used in a Catalog and or in a Profile.
Prompt Table: HR_CP_CONTENT_P

6 CAREER_COMPETENCY Character(12) VARCHAR2(12) NOT NULL Competency
Prompt Table: HR_CP_COMP_P

7 CAREER_GOAL Character(120) VARCHAR2(120) NOT NULL Career Goal

8 ACT_COMPLETION_DT Date(10) DATE Actual Completion Date

9 DESCRLONG Long Character CLOB Long Description

10 GVT_SELF_DEVELOP Character(1) VARCHAR2(1) NOT NULL Self-Development
Y/N Table Edit
Default Value: N

11 GVT_ESTIMATED_COST Number(10,2) DECIMAL(9,2) NOT NULL Estimated Cost

12 GVT_ACTUAL_COST Number(10,2) DECIMAL(9,2) NOT NULL Actual Cost

13 GVT_ACT_STATUS Character(2) VARCHAR2(2) NOT NULL Activity Status
1=Requested
2=Approved
3=Disapproved
4=Deferred
5=In Progress
6=Completed

14 GVT_REQD_ACTVTY Character(1) VARCHAR2(1) NOT NULL Activity Required
Y/N Table Edit
Default Value: N

15 NEED_IDENTIFIED_DT Date(10) DATE Date Need Identified

16 GVT_ACTVTY_REASON Character(2) VARCHAR2(2) NOT NULL Reason Activity Pursued
CM=Compliance
DV=Development
EN=Enrichment
JR=Job Requirement
LC=License Renewal
MD=Management Discretion
RQ=Requalification
SE=Skill Enhancement

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	EST_COMPLETION_DT	Date(10)	DATE NOT NULL	Estimated Completion Date
4	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
5	JPM_CAT_TYPE	Character(12)	VARCHAR2(12) NOT NULL	The name of the type of items that will be used in a Catalog and or in a Profile. Prompt Table: HR_CP_CONTENT_P
6	CAREER_COMPETENCY	Character(12)	VARCHAR2(12) NOT NULL	Competency Prompt Table: HR_CP_COMP_P
7	CAREER_GOAL	Character(120)	VARCHAR2(120) NOT NULL	Career Goal
8	ACT_COMPLETION_DT	Date(10)	DATE	Actual Completion Date
9	DESCRLONG	Long Character	CLOB	Long Description
10	GVT_SELF_DEVELOP	Character(1)	VARCHAR2(1) NOT NULL	Self-Development Y/N Table Edit Default Value: N
11	GVT_ESTIMATED_COST	Number(10,2)	DECIMAL(9,2) NOT NULL	Estimated Cost
12	GVT_ACTUAL_COST	Number(10,2)	DECIMAL(9,2) NOT NULL	Actual Cost
13	GVT_ACT_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Activity Status 1=Requested 2=Approved 3=Disapproved 4=Deferred 5=In Progress 6=Completed
14	GVT_REQD_ACTVTY	Character(1)	VARCHAR2(1) NOT NULL	Activity Required Y/N Table Edit Default Value: N
15	NEED_IDENTIFIED_DT	Date(10)	DATE	Date Need Identified
16	GVT_ACTVTY_REASON	Character(2)	VARCHAR2(2) NOT NULL	Reason Activity Pursued CM=Compliance DV=Development EN=Enrichment JR=Job Requirement LC=License Renewal MD=Management Discretion RQ=Requalification SE=Skill Enhancement