RS_WRKSPCTYP_VL

(SQL View)
 Index Back

SELECT A.RS_TYPE , L.LANGUAGE_CD , L.DESCR FROM %Table(RS_TYPE_TBL) A , PSTREENODE B , PSTREEDEFN D , %Table(RS_TYPE_LANG) L WHERE A.RS_TYPE = B.TREE_NODE AND D.SETID = ' ' AND D.SETCNTRLVALUE = ' ' AND D.TREE_NAME = 'COMPETENCY' AND D.EFF_STATUS = 'A' AND D.EFFDT = ( SELECT MAX(EFFDT) FROM PSTREEDEFN C WHERE C.SETID = D.SETID AND C.SETCNTRLVALUE = D.SETCNTRLVALUE AND C.TREE_NAME = D.TREE_NAME AND C.EFFDT <= %CurrentDateIn) AND D.SETID = B.SETID AND D.SETCNTRLVALUE = B.SETCNTRLVALUE AND D.TREE_NAME = B.TREE_NAME AND D.EFFDT = B.EFFDT AND L.RS_TYPE = A.RS_TYPE

  • Related Language Record for RS_WRKSPCTYP_VW

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