CS_DEPT2_VW

(SQL View)
 Index Back

Dept ID for all SetIDs

9/10/2008 RMK Prompt table to search department for all setids

SELECT DISTINCT A.CS_SETID ,B.DEPTID , B.descr , B.manager_name FROM PS_CS_DOC_HDR A , PS_DEPT_TBL B WHERE A.CS_SETID = B.SETID AND B.EFFDT = ( SELECT MAX(C.EFFDT) FROM PS_DEPT_TBL C WHERE C.SETID = B.SETID AND B.DEPTID = C.DEPTID AND C.EFF_STATUS = 'A')

  • Related Language Record: CS_DEPT2_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CS_SETID Character(5) VARCHAR2(5) NOT NULL setid for the document objects
    2 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
    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.