RS_WRKSPCCMP_VW

(SQL View)
 Index Back

SELECT DISTINCT A.COMPETENCY , A.DESCR FROM %Table(COMPETENCY_TBL) A , %Table(COMPETENCY_TYPS) B , %Table(RS_WRKSPCTYP_VW) C WHERE A.COMPETENCY = B.COMPETENCY AND B.RS_TYPE = C.RS_WRKR_SPEC

  • Related Language Record: RS_WRKSPCCMP_VL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RS_WRKR_SPEC Character(8) VARCHAR2(8) NOT NULL Worker Specialty
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description