TRN_PREREQ_VW

(SQL View)
 Index Back

Prerequisite Course View

Prerequisite Course View

SELECT DISTINCT C.EMPLID , A.COURSE , C.COURSE , C.SESSION_NBR , C.COURSE_START_DT , C.COURSE_END_DT , C.ATTENDANCE FROM PS_COURSE_TBL A , PS_TRN_PREREQ_CRSE B , PS_TRAINING C WHERE A.COURSE = B.COURSE AND B.PREREQ_COURSE_CD = C.COURSE

  • Parent record: COURSE_TBL

    • # 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

    Prompt Table: COURSE_TBL

    3 PREREQ_COURSE_CD Character(6) VARCHAR2(6) NOT NULL Prerequisite Course Code

    Prompt Table: COURSE_TBL

    4 SESSION_NBR Character(4) VARCHAR2(4) NOT NULL Course Session Nbr
    5 COURSE_START_DT Date(10) DATE Course Start Date
    6 COURSE_END_DT Date(10) DATE Course End Date
    7 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