EPO_DEPT_SCH_L2

(SQL View)
 Index Back

Department Search Results

Departments with Business Objectives returned search results

SELECT DEPT.SETID , DEPT.DEPTID , DEPTL.LANGUAGE_CD , %Upper(DEPTL.DESCR) , DEPTL.DESCR FROM PS_DEPT_TBL_EFF_VW DEPT , PS_EPO_PGHDR_EFFV2 PG , PS_DEPT_TBL_LANG DEPTL WHERE DEPT.SETID = PG.SETID AND DEPT.DEPTID = PG.EPO_NODE_ID AND DEPT.SETID = DEPTL.SETID AND DEPT.DEPTID = DEPTL.DEPTID AND DEPT.EFFDT = DEPTL.EFFDT

  • Related Language Record for EPO_DEPT_SCH_V2

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DEPT_DESCR Character(30) VARCHAR2(30) NOT NULL Department Description