RS_ED_SO_COMP

(SQL View)
 Index Back

Person Competencies

COMPETENCIES contains the competency ratings for employee.

SELECT A.BUSINESS_UNIT , A.SO_ID , A.SO_LINE , A.COMPETENCY , B.DESCR , A.PROFICIENCY , A.YEARS_OF_EXP , C.DESCR FROM %Table(RS_SO_LINE_COMP) A , %Table(COMPETENCY_TBL) B , %Table(REVW_RATING_TBL) C , %Table(RS_SO_LINE) D , %Table(RS_SO_HDR) E WHERE A.BUSINESS_UNIT = E.BUSINESS_UNIT AND A.SO_ID = E.SO_ID AND E.SYSTEM_SOURCE = 'RS' AND A.BUSINESS_UNIT = D.BUSINESS_UNIT AND A.SO_ID = D.SO_ID AND A.SO_LINE = D.SO_LINE AND B.COMPETENCY = A.COMPETENCY AND C.RATING_MODEL = B.RATING_MODEL AND A.PROFICIENCY = C.REVIEW_RATING

  • Parent record: RS_EVALUATIONS

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 SO_ID Character(15) VARCHAR2(15) NOT NULL Service Order ID
    3 SO_LINE Number(3,0) SMALLINT NOT NULL Line Number
    4 COMPETENCY Character(8) VARCHAR2(8) NOT NULL Competency

    Prompt Table: COMPETENCY_TBL

    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 PROFICIENCY Character(1) VARCHAR2(1) NOT NULL Proficiency

    Prompt Table: REVW_RATING_TBL

    7 YEARS_OF_EXP Number(5,1) DECIMAL(4,1) NOT NULL Years of Work Experience
    8 PRO Character(32) VARCHAR2(32) NOT NULL Proficiency