CM_ACCOMP_TRN

(SQL View)
 Index Back

Accomplishment for Training

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

SELECT A.emplid , A.accomplishment , B.course , B.session_nbr , A.read_proficiency , A.write_proficiency , A.speak_proficiency , A.passed , A.license_verified , A.RENEWAL , A.NATIVE_LANGUAGE , A.TRANSLATOR , A.IPE_SW , A.GRADUATE_INDICATOR , A.DT_ISSUED FROM ps_accomplishments A , PS_TRAINING B WHERE A.emplid = B.emplid AND B.attendance IN ('E','A','C')

  • Parent record: ACCOMPLISHMENTS

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

    Prompt Table: PERSON

    2 ACCOMPLISHMENT Character(8) VARCHAR2(8) NOT NULL Accomplishment
    3 COURSE Character(6) VARCHAR2(6) NOT NULL Course Code
    4 SESSION_NBR Character(4) VARCHAR2(4) NOT NULL Course Session Nbr
    5 READ_PROFICIENCY Character(1) VARCHAR2(1) NOT NULL Reading Proficiency
    1=Low
    2=Moderate
    3=High
    6 WRITE_PROFICIENCY Character(1) VARCHAR2(1) NOT NULL Writing Proficiency
    1=Low
    2=Moderate
    3=High
    7 SPEAK_PROFICIENCY Character(1) VARCHAR2(1) NOT NULL Speaking Proficiency
    1=Low
    2=Moderate
    3=High
    8 PASSED Character(1) VARCHAR2(1) NOT NULL Passed Test
    N=No
    Y=Yes
    9 LICENSE_VERIFIED Character(1) VARCHAR2(1) NOT NULL License Verified
    10 RENEWAL Character(1) VARCHAR2(1) NOT NULL Renewal in Progress
    11 NATIVE_LANGUAGE Character(1) VARCHAR2(1) NOT NULL Native Language
    12 TRANSLATOR Character(1) VARCHAR2(1) NOT NULL Able to Translate
    13 IPE_SW Character(1) VARCHAR2(1) NOT NULL Intern Professional Education
    14 GRADUATE_INDICATOR Character(1) VARCHAR2(1) NOT NULL Graduated
    N=No
    Y=Yes
    15 DT_ISSUED Date(10) DATE Issue Date