TRN_T_ENRL2_ESP(SQL View) |
Index Back |
|---|---|
FT Students Enrollment VWTripartite Foundation. This view is used to show the Students Salaries. |
| SELECT A.COURSE ,A.SESSION_NBR ,A.EMPLID ,A.EMPL_RCD ,A.ATTENDANCE ,%Substring(B.NAME,1,40) ,A.BUSINESS_UNIT ,A.DEPTID ,C.COMPANY FROM PS_TRAINING A , PS_NAMES_VW B , PS_DEPT_TBL C WHERE A.ATTENDANCE IN ( 'A', 'C', 'E', 'O') AND A.EMPLID = B.EMPLID AND A.DEPTID = C.DEPTID AND A.BUSINESS_UNIT = C.SETID AND C.EFFDT = ( SELECT MAX(ED.EFFDT) FROM PS_DEPT_TBL ED WHERE ED.SETID = A.BUSINESS_UNIT AND ED.DEPTID = A.DEPTID AND ED.EFFDT <= A.COURSE_START_DT) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  COURSE |
Character(6) | VARCHAR2(6) NOT NULL |
Course Code
Prompt Table: COURSE_TBL |
| 2 | SESSION_NBR |
Character(4) | VARCHAR2(4) NOT NULL |
Course Session Nbr
Prompt Table: CRSE_SESSN_VW |
| 3 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: %EDITTABLE |
| 4 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 5 | ATTENDANCE | Character(1) | VARCHAR2(1) NOT NULL |
Enrollment/Attendance
A=Currently Attending C=Completed D=Dropped E=Enrolled I=Incomplete L=Cancelled N=No Show O=Training Request Approved P=Need for Career Plan R=Request S=Session Waitlist T=Need for Training Program U=Training Request Authorized W=Course Waitlist X=Cancel Request for Training |
| 6 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
| 7 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 8 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 9 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |