FC_SUPR_SRCH_VW (SQL View)	Index Back
Supervisor List Returns list of supervisors along with related forecast horizons that have associated employees. This view is used as the search view for the Forecast Review by Supervisor page. This view uses EX_EE_AUTH_TBL to determine which employee id's the user has access to.

FC_SUPR_SRCH_VW

(SQL View)

Supervisor List

Returns list of supervisors along with related forecast horizons that have associated employees. This view is used as the search view for the Forecast Review by Supervisor page. This view uses EX_EE_AUTH_TBL to determine which employee id's the user has access to.

SELECT OPRID , SUPERVISOR_ID , BUSINESS_UNIT_GL , BEGIN_DT , END_DT , NAME FROM PS_FC_SUPR_RVW_LST

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 SUPERVISOR_ID Character(11) VARCHAR2(11) NOT NULL Supervisor ID

3 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

4 BEGIN_DT Date(10) DATE Begin Date

5 END_DT Date(10) DATE End Date

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	SUPERVISOR_ID	Character(11)	VARCHAR2(11) NOT NULL	Supervisor ID
3	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
4	BEGIN_DT	Date(10)	DATE	Begin Date
5	END_DT	Date(10)	DATE	End Date
6	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name