CAREER_MENTOR(SQL Table) |
Index Back |
|---|---|
EE Career MentorsCAREER_MENTOR is part of Career Planning 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. |
| # | 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_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 |
| 7 | CAREER_GOAL | Character(40) | VARCHAR2(40) NOT NULL | Career Goal |
| 8 | ACT_COMPLETION_DT | Date(10) | DATE | Actual Completion Date |
| 9 | GVT_SELF_DEVELOP | Character(1) | VARCHAR2(1) NOT NULL |
Self-Development
Y/N Table Edit Default Value: N |
| 10 | GVT_ESTIMATED_COST | Number(10,2) | DECIMAL(9,2) NOT NULL | Estimated Cost |
| 11 | GVT_ACTUAL_COST | Number(10,2) | DECIMAL(9,2) NOT NULL | Actual Cost |
| 12 | GVT_ACT_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Activity Status
1=Requested 2=Approved 3=Disapproved 4=Deferred 5=In Progress 6=Completed |
| 13 | GVT_REQD_ACTVTY | Character(1) | VARCHAR2(1) NOT NULL |
Activity Required
Y/N Table Edit Default Value: N |
| 14 | NEED_IDENTIFIED_DT | Date(10) | DATE | Date Need Identified |
| 15 | 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 |