TRN_T_ENRL_ESP

(SQL View)
 Index Back

FT Course Enrollment View

Tripartite Foundation. This view is used to show the student status in FT Course Session.

SELECT A.COURSE , A.SESSION_NBR , A.EMPLID , A.EMPL_RCD , A.COURSE_TITLE , A.ATTENDANCE , A.COURSE_START_DT , B.COMPANY , A.DIPLOMA_ESP FROM PS_TRAINING A , PS_DEPT_TBL B WHERE A.DEPTID = B.DEPTID AND B.SETID = ( SELECT DISTINCT(AA.SETID) FROM PS_SET_CNTRL_GROUP AA , PS_SETID_TBL BB WHERE AA.REC_GROUP_ID = 'HR_01' AND AA.SETCNTRLVALUE = A.BUSINESS_UNIT) AND A.ATTENDANCE <> 'W' UNION SELECT A.COURSE , A.SESSION_NBR , A.EMPLID , A.EMPL_RCD , A.COURSE_TITLE , A.ATTENDANCE , A.COURSE_START_DT , ' ' , A.DIPLOMA_ESP FROM PS_TRAINING A WHERE NOT EXISTS ( SELECT 'X' FROM PS_DEPT_TBL B WHERE B.DEPTID = A.DEPTID AND B.SETID = ( SELECT DISTINCT(AA.SETID) FROM PS_SET_CNTRL_GROUP AA , PS_SETID_TBL BB WHERE AA.REC_GROUP_ID = 'HR_01' AND AA.SETCNTRLVALUE = A.BUSINESS_UNIT)) AND A.ATTENDANCE <> 'W'

# 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 COURSE_TITLE Character(30) VARCHAR2(30) NOT NULL Course Title
6 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
7 COURSE_START_DT Date(10) DATE Course Start Date
8 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
9 DIPLOMA_ESP Character(1) VARCHAR2(1) NOT NULL Accredinting diploma flag

Y/N Table Edit