GP_SCH_MNG_VW (SQL View)	Index Back
Self Service Search Vw Search view intended for use by administrative operators such as data entry clerks or with Manager events. The view returns the employee names and job titles for each employee and job that the operator has access to. Access is determined using HR Security

GP_SCH_MNG_VW

(SQL View)

Self Service Search Vw

Search view intended for use by administrative operators such as data entry clerks or with Manager events. The view returns the employee names and job titles for each employee and job that the operator has access to. Access is determined using HR Security

SELECT A.OPRID , A.EMPLID , A.EMPL_RCD , %DateIn('1900-01-01') , A.NAME , A.JOBCODE , A.JOBCODE_DESCR FROM PS_GP_EMPLMT_SRCH A

# 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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: GP_SCH_EMPL_VW

3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
Prompt Table: GP_SCH_ERC_VW

4 DUR Date(10) DATE Date Under Report associates time being reported, scheduled or paid, to a specific date.
Default Value: %date

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

6 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

7 JOBCODE_DESCR Character(30) VARCHAR2(30) NOT NULL Job Code Description

#	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	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: GP_SCH_EMPL_VW
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record Prompt Table: GP_SCH_ERC_VW
4	DUR	Date(10)	DATE	Date Under Report associates time being reported, scheduled or paid, to a specific date. Default Value: %date
5	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
6	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code
7	JOBCODE_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Job Code Description