GP_PA_DEPT_VW1

(SQL View)
 Index Back

Pivot Grid Table

To be used in Payroll Analytics grid

SELECT A.SETID ,A.DEPTID ,A.DESCR FROM PS_DEPT_TBL A WHERE %EffdtCheck(DEPT_TBL A1, A, %CurrentDateIn) AND A.EFF_STATUS = 'A'

  • Related Language Record: GP_DEPT_LANG_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 DEPT_DESCR Character(30) VARCHAR2(30) NOT NULL Department Description