DEPTID_BUPC_VW

(SQL View)
 Index Back

Departments BU PC View


SELECT %Substring(B.SETCNTRLVALUE,1,5) , A.DEPTID , A.DESCR , A.MANAGER_NAME FROM PS_DEPT_TBL A , PS_SET_CNTRL_REC B WHERE B.REC_GROUP_ID = 'FS_06' AND B.RECNAME = 'DEPTID_BUGL_VW' AND A.BUDGETARY_ONLY= 'N' AND A.SETID = B.SETID AND A.EFFDT= ( SELECT MAX(AA.EFFDT) FROM PS_DEPT_TBL AA WHERE A.SETID = AA.SETID AND AA.DEPTID = A.DEPTID AND AA.SETID = B.SETID AND AA.EFFDT<=%CurrentDateIn) AND A.EFF_STATUS<>'I'

  • Related Language Record: DEPTID_BUPC_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
    2 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: DEPTID_NB_VW

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 MANAGER_NAME Character(30) VARCHAR2(30) NOT NULL Identifies the name of the manager of a specified department.