DEPT_EE_EFF_VW (SQL View)	Index Back
Employee Department View DEPT_EE_VW selects the emplid and name for all employees in a specific department.

DEPT_EE_EFF_VW

(SQL View)

Employee Department View

DEPT_EE_VW selects the emplid and name for all employees in a specific department.

SELECT DISTINCT A.SETID_DEPT ,B.BUDGET_DEPTID ,A.EMPLID ,A.EMPL_RCD ,A.EFFDT ,B.EFFDT ,C.NAME FROM PS_JOB A , PS_DEPT_TBL B , PS_PERSON_NAME C WHERE A.SETID_DEPT = B.SETID AND A.DEPTID = B.DEPTID AND A.EMPLID = C.EMPLID AND A.EFFSEQ = ( SELECT MAX(A3.EFFSEQ) FROM PS_JOB A3 WHERE A3.EMPLID = A.EMPLID AND A3.EMPL_RCD = A.EMPL_RCD AND A3.EFFDT = A.EFFDT)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

2 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

5 EFFDT Date(10) DATE Effective Date
Default Value: %date

6 EFFDT_DEPT Date(10) DATE Dept Effective Date

7 NAME Character(50) VARCHAR2(50) NOT NULL Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
4	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
5	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
6	EFFDT_DEPT	Date(10)	DATE	Dept Effective Date
7	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name