CM_EVAL_TRN

(SQL View)
 Index Back

Comp Evaluation for Training

This view is used in the functionality that assigns employee competency upon a course completion. It retrieves competency evaluation IDs for those students enrolled in a particular course session.

SELECT A.emplid , A.evaluation_id , B.course , B.session_nbr , A.evaluation_type , A.reviewer_id , A.reviewer_apprvd FROM ps_cm_evaluations A , PS_TRAINING B WHERE A.emplid = B.emplid AND B.attendance IN ('E','A','C')

  • Parent record: CM_EVALUATIONS

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSON

    2 EVALUATION_ID Character(2) VARCHAR2(2) NOT NULL Evaluation ID

    Default Value: 01

    3 COURSE Character(6) VARCHAR2(6) NOT NULL Course Code
    4 SESSION_NBR Character(4) VARCHAR2(4) NOT NULL Course Session Nbr
    5 EVALUATION_TYPE Character(1) VARCHAR2(1) NOT NULL Evaluation Type
    A=Approved/Official
    B=Subordinate
    C=Customer
    E=Executive Committee
    L=Learning
    M=Mentor
    P=Peer
    R=Supervisor/Manager
    S=Self
    6 REVIEWER_ID Character(11) VARCHAR2(11) NOT NULL Reviewer ID

    Prompt Table: PERSON

    7 REVIEWER_APPRVD Character(1) VARCHAR2(1) NOT NULL Reviewer is Approved

    Y/N Table Edit

    Default Value: N