RY_EE_DEPT_VW

(SQL View)
 Index Back

Department view

Workforce Connect - Related-display view on DEPT_TBL

SELECT D.SETID %Concat '.' %Concat D.DEPTID , D.DESCR FROM PS_DEPT_TBL D WHERE %EffdtCheck(DEPT_TBL, D, %CurrentDateIn)

  • Related Language Record: RY_EE_DEPT_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SID_DEPT Character(21) VARCHAR2(21) NOT NULL Workforce Connect - SetID_Department
    2 DESCR_DEPT Character(30) VARCHAR2(30) NOT NULL Description