CAREER_DEVELOP(SQL Table) |
Index Back |
|---|---|
EE Career Development PlanCAREER_DEVELOP 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. |
| # | 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 | COMPETENCY | Character(8) | VARCHAR2(8) NOT NULL |
Competency
Prompt Table: COMPETENCY_TBL |
| 6 | CAREER_GOAL | Character(40) | VARCHAR2(40) NOT NULL | Career Goal |
| 7 | ACT_COMPLETION_DT | Date(10) | DATE | Actual Completion Date |
| 8 | DESCRLONG | Long Character | CLOB | Long Description |
| 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 |