TRN_PREREQ_SS

(SQL View)
 Index Back

Prerequisite view -Self Svc

Prerequisite Course View - Self Service This view is used in the HR self service Training Summary transaction. It contains all of the prerequisite course codes that are associated with employees/courses that are found on the TRAINING_SUM_VW.

SELECT DISTINCT A.EMPLID , B.COURSE , B.PREREQ_COURSE_CD FROM PS_TRAINING_SUM_VW A , PS_TRN_PREREQ_CRSE B WHERE A.COURSE = B.COURSE

# 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