TRN_CRS_STUD_VW

(SQL View)
Index Back

Student Training View

Administer Training view detailing student training information for course sessions.

SELECT DISTINCT SEC.OPRID , A.COURSE ,A.SESSION_NBR ,SEC.EMPLID ,SEC.NAME ,A.ATTENDANCE , A.COURSE_GRADE FROM PS_TRAINING A , PS_PERSON_NAME B , PS_TRNPER_SEC_SRCH SEC WHERE A.EMPLID=B.EMPLID AND A.SESSION_NBR <> ' ' AND A.EMPLID = SEC.EMPLID

  • Related Language Record: TRN_CRS_STUDVWL
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 COURSE Character(6) VARCHAR2(6) NOT NULL Course Code
    3 SESSION_NBR Character(4) VARCHAR2(4) NOT NULL Course Session Nbr
    4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    5 NAME Character(50) VARCHAR2(50) NOT NULL Name
    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_GRADE Character(3) VARCHAR2(3) NOT NULL Grade
    A=A
    B=B
    C=C
    D=D
    F=F
    FL=Fail
    P=Pass