DEPT_MC_VW

(SQL View)
 Index Back

View of all Dept for MassChg


SELECT DISTINCT a.DEPTID , a.descr , a.manager_name FROM PS_DEPT_TBL a WHERE a.effdt = ( SELECT MAX(b.effdt) FROM PS_DEPT_TBL b WHERE a.setid = b.setid AND a.DEPTID = b.DEPTID) AND a.EFF_STATUS = 'A' AND a.DEPTID <> 'ALL_DEPTS'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

Prompt Table: DEPT_TBL

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