EMPLIDCOURSECOMPETENCYCM_EE_COMP_TRN(SQL View) |
Index Back |
|---|---|
EE CompetenciesCM_EE_COMP_TRN contains each course for which the person is enrolled and the targeted competencies of the course. |
| select distinct a.emplid, a.course, b.competency from PS_TRAINING A, ps_course_comps B where a.attendance = 'E' and a.course = b.course |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | COURSE |
Character(6) | VARCHAR2(6) NOT NULL | Course Code |
| 3 | COMPETENCY |
Character(8) | VARCHAR2(8) NOT NULL | Competency |