HR_CP_MENTOR (SQL View)	Index Back
EE Career Mentors HR_CP_MENTOR is view based upon CAREER_MENTOR. It is part of Career Planning Self Service for an employee. Use it to identify any individuals who have coached or mentored the employee with regard to a goal associated with their job or career.

HR_CP_MENTOR

(SQL View)

EE Career Mentors

HR_CP_MENTOR is view based upon CAREER_MENTOR. It is part of Career Planning Self Service for an employee. Use it to identify any individuals who have coached or mentored the employee with regard to a goal associated with their job or career.

SELECT A.EMPLID , A.EFFDT , A.EST_COMPLETION_DT , A.SEQ_NUM , A.MENTOR_NAME , A.MENTOR_TITLE , A.MENTOR_TYPE , A.CAREER_GOAL , A.ACT_COMPLETION_DT ,%subrec(CAR_MEN_FED_SBR, A) FROM PS_CAREER_MENTOR A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_CAREER_MENTOR B WHERE B.EMPLID = A.EMPLID AND B.EFFDT <= %CurrentDateIn)

Related Language Record: CAREER_MNTR_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 MENTOR_NAME Character(50) VARCHAR2(50) NOT NULL Mentor Name

6 MENTOR_TITLE Character(50) VARCHAR2(50) NOT NULL Mentor Title

7 MENTOR_TYPE Character(1) VARCHAR2(1) NOT NULL Mentor Type
1=Mentor
2=Coach
3=Endorser
4=Reviewer/Rater
5=Supervisor
6=Functional Specialist
7=Teacher
8=Other

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

9 ACT_COMPLETION_DT Date(10) DATE Actual Completion Date

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	MENTOR_NAME	Character(50)	VARCHAR2(50) NOT NULL	Mentor Name
6	MENTOR_TITLE	Character(50)	VARCHAR2(50) NOT NULL	Mentor Title
7	MENTOR_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Mentor Type 1=Mentor 2=Coach 3=Endorser 4=Reviewer/Rater 5=Supervisor 6=Functional Specialist 7=Teacher 8=Other
8	CAREER_GOAL	Character(120)	VARCHAR2(120) NOT NULL	Career Goal
9	ACT_COMPLETION_DT	Date(10)	DATE	Actual Completion Date
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