DEPTID_PCAM_VW

(SQL View)
 Index Back

Departments PC AM View

Used to display Departments used in the Filter Criteria for the Projects to Assets integration.

SELECT DISTINCT A.SETID , A.INTEGRATION_TMPL , C.DEPTID , C.DESCR , C.MANAGER_NAME FROM PS_PC_INT_TMPL_GL A , PS_SET_CNTRL_REC B , PS_DEPT_TBL C WHERE A.BUSINESS_UNIT_GL = B.SETCNTRLVALUE AND B.RECNAME = 'DEPT_TBL' AND B.SETID = C.SETID AND C.BUDGETARY_ONLY= 'N'

  • Related Language Record: DEPTID_PCAM_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 INTEGRATION_TMPL Character(15) VARCHAR2(15) NOT NULL Integration
    3 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 MANAGER_NAME Character(30) VARCHAR2(30) NOT NULL Identifies the name of the manager of a specified department.