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 COURSE ,SESSION_NBR ,EMPLID ,ATTENDANCE FROM PS_TRAINING WHERE 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 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