GP_SRCH_DEPT_VW

(SQL View)
 Index Back

GP Department view

This view is to retrieve the fields deptid and descr from dept table to use in GP search features.

SELECT DEPTID ,DESCR FROM PS_DEPT_TBL A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_DEPT_TBL B WHERE B.DEPTID=A.DEPTID)

  • Related Language Record: GP_SRCH_DEPT_VL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description