HR_CP_TRAINING(SQL View) |
Index Back |
|---|---|
EE Career Training PlanHR_CP_TRAINING is a view based upon CAREER_TRAINING. It is part of Career Planning Self service product for an employee. Use it to identify training courses an employee should take to further enhance their career potential. |
| SELECT A.EMPLID , A.EFFDT , A.TRN_PROGRAM , A.EST_COMPLETION_DT , A.COURSE_SEQUENCE , A.COURSE , A.COURSE_TITLE , A.INTERNAL_EXTERNAL , A.TRAINING_REASON , A.REQUIRED_CRSE , A.SCHOOL_CODE , A.SCHOOL , A.NEED_IDENTIFIED_DT , A.ACT_COMPLETION_DT , %subrec(HR_CP_T_FED_SBR, A) FROM PS_CAREER_TRAINING A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_CAREER_TRAINING B WHERE B.EMPLID = A.EMPLID AND B.EFFDT <= %CurrentDateIn) |
| # | 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 | TRN_PROGRAM |
Character(6) | VARCHAR2(6) NOT NULL | Training Program |
| 4 | EST_COMPLETION_DT |
Date(10) | DATE NOT NULL | Estimated Completion Date |
| 5 | COURSE_SEQUENCE |
Number(2,0) | SMALLINT NOT NULL |
Course Sequence
Default Value: 1 |
| 6 | COURSE |
Character(6) | VARCHAR2(6) NOT NULL |
Course Code
Prompt Table: COURSE_TBL |
| 7 | COURSE_TITLE |
Character(30) | VARCHAR2(30) NOT NULL | Course Title |
| 8 | INTERNAL_EXTERNAL | Character(1) | VARCHAR2(1) NOT NULL |
Internal/External
E=External I=Internal |
| 9 | TRAINING_REASON | Character(2) | VARCHAR2(2) NOT NULL |
Training Reason
CM=Compliance DV=Development EN=Enrichment JR=Job Requirement LC=License Renewal MD=Management Discretion RQ=Requalification SE=Skill Enhancement |
| 10 | REQUIRED_CRSE | Character(1) | VARCHAR2(1) NOT NULL |
Required
Y/N Table Edit Default Value: N |
| 11 | SCHOOL_CODE | Character(10) | VARCHAR2(10) NOT NULL |
School Code
Prompt Table: SCHOOL_TBL_VW2 |
| 12 | SCHOOL | Character(30) | VARCHAR2(30) NOT NULL | School Name |
| 13 | NEED_IDENTIFIED_DT | Date(10) | DATE | Date Need Identified |
| 14 | ACT_COMPLETION_DT | Date(10) | DATE | Actual Completion Date |
| 15 | GVT_SELF_DEVELOP | Character(1) | VARCHAR2(1) NOT NULL |
Self-Development
Y/N Table Edit Default Value: N |
| 16 | GVT_ESTIMATED_COST | Number(10,2) | DECIMAL(9,2) NOT NULL | Estimated Cost |
| 17 | GVT_ACTUAL_COST | Number(10,2) | DECIMAL(9,2) NOT NULL | Actual Cost |
| 18 | GVT_ACT_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Activity Status
1=Requested 2=Approved 3=Disapproved 4=Deferred 5=In Progress 6=Completed |