HR_WP_MNT_SRCH (SQL View)	Index Back
Wage Progression Activity This view contains all the Current Activities of an employee. If there is no current activity then the most recent future activity is shown.

HR_WP_MNT_SRCH

(SQL View)

Wage Progression Activity

This view contains all the Current Activities of an employee. If there is no current activity then the most recent future activity is shown.

SELECT DISTINCT %Sql(SCRTY_SEL_PKEY, SEC,SEC) ,SEC.NAME ,SEC.LAST_NAME_SRCH FROM PS_EMPLMT_SRCH_GBL SEC WHERE EXISTS ( SELECT 'X' FROM PS_HR_WP_ACTIVITY B WHERE SEC.EMPLID = B.EMPLID AND SEC.EMPL_RCD = B.EMPL_RCD )

# 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 ROWSECCLASS Character(30) VARCHAR2(30) NOT NULL The class used to determine row level security

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

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

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

6 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last 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	ROWSECCLASS	Character(30)	VARCHAR2(30) NOT NULL	The class used to determine row level security
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
4	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
5	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
6	LAST_NAME_SRCH	Character(30)	VARCHAR2(30) NOT NULL	Last Name