RS_WRKSPCTYP_VW

(SQL View)
 Index Back

SELECT A.RS_TYPE , A.DESCR FROM %Table(RS_TYPE_TBL) A , PSTREENODE B , PSTREEDEFN D 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

  • Related Language Record: RS_WRKSPCTYP_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