EPO_DEPT_SCH_LV

(SQL View)
 Index Back

Department Search Results

Left Outer Join View Used to display search results in search banner grid.

SELECT DEPT.SETID , DEPT.DEPTID , DEPTL.LANGUAGE_CD , %Upper(DEPTL.DESCR) , DEPTL.DESCR FROM PS_DEPT_TBL_EFF_VW DEPT LEFT OUTER JOIN PS_EPO_PGHDR_EFF_V PG ON DEPT.SETID = PG.SETID AND DEPT.DEPTID = PG.EPO_NODE_Id , PS_DEPT_TBL_LANG DEPTL WHERE DEPT.SETID = DEPTL.SETID AND DEPT.DEPTID = DEPTL.DEPTID AND DEPT.EFFDT = DEPTL.EFFDT

  • Related Language Record for EPO_DEPT_SCH_VW

    • # 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