COURSE_COMPS_VW

(SQL View)
 Index Back

Course Competency Vw

This view is used within the link between Administer Training and Manage Competencies to select the Target Competencies per Course with the associated Proficiency / Review Points..

SELECT A.COURSE , A.COMPETENCY , A.PROFICIENCY , A.GRANT_TO_EE , C.REVIEW_POINTS FROM PS_COURSE_COMPS A , PS_COMPETENCY_TBL B , PS_REVW_RATING_TBL C WHERE A.GRANT_TO_EE = 'Y' AND A.COMPETENCY = B.COMPETENCY AND B.RATING_MODEL = C.RATING_MODEL AND A.PROFICIENCY = C.REVIEW_RATING AND C.EFFDT = ( SELECT MAX(EFFDT) FROM PS_RATING_MDL_TBL WHERE RATING_MODEL = C.RATING_MODEL AND EFFDT <= %CurrentDateIn)

  • Parent record: COURSE_TBL

    • # 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 COMPETENCY Character(8) VARCHAR2(8) NOT NULL Competency

    Prompt Table: COMPETENCY_TBL

    3 PROFICIENCY Character(1) VARCHAR2(1) NOT NULL Proficiency

    Prompt Table: REVW_RATING_TBL

    4 GRANT_TO_EE Character(1) VARCHAR2(1) NOT NULL Assign to EE after course

    Y/N Table Edit

    Default Value: Y

    5 REVIEW_POINTS Number(3,0) SMALLINT NOT NULL Review Points