GM_DPT_CNTCT_VW (SQL View)	Index Back
Department Contacts This view is used to retrieve the officials that are associated with a particular Department. There can be many officials for one Department.

GM_DPT_CNTCT_VW

(SQL View)

Department Contacts

This view is used to retrieve the officials that are associated with a particular Department. There can be many officials for one Department.

SELECT SETID , DEPTID , C.EFFDT , C.EMPLID , P.FIRST_NAME , P.LAST_NAME , P.NAME FROM PS_GM_DEPT_CONTACT C , PS_PERS_DATA_EFFDT P WHERE C.EMPLID = P.EMPLID AND P.EFFDT = ( SELECT MAX(G.EFFDT) FROM PS_PERS_DATA_EFFDT G WHERE P.EMPLID=G.EMPLID)

# 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 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %DATE

4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: GM_PERSONAL1_VW

5 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name

6 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name

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	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %DATE
4	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: GM_PERSONAL1_VW
5	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
6	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
7	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name