GPES_ST_EES_VW

(SQL View)
 Index Back

EE Segmentation Triggers

Employees with segmentation triggers filtered by Company, SSN Employer, trigger year and trigger month. This view uses row level security.

SELECT DISTINCT J.GP_PAYGROUP , %Sql(SCRTY_SEL_PKEY,SEC,SEC) , %Sql(SCRTY_SEL_NMSBR,SEC,SEC) FROM PS_JOB J , PS_PERS_SRCH_GBL SEC WHERE SEC.EMPLID = J.EMPLID AND SEC.EMPL_RCD = J.EMPL_RCD AND J.EFFDT = ( SELECT MAX(EFFDT) FROM PS_JOB WHERE EMPLID = J.EMPLID AND EMPL_RCD = J.EMPL_RCD AND EFFDT <= %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 ROWSECCLASS Character(30) VARCHAR2(30) NOT NULL The class used to determine row level security
4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
5 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
6 NAME Character(50) VARCHAR2(50) NOT NULL Name
7 NAME_DISPLAY_SRCH Character(50) VARCHAR2(50) NOT NULL Uppercase version of Name to improve performance on searches.
8 NAME_PSFORMAT Character(50) VARCHAR2(50) NOT NULL A Person's name in the Peoplesoft Format (basically LN,FN MI
9 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
10 SECOND_LAST_SRCH Character(30) VARCHAR2(30) NOT NULL Second Last Name
11 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
12 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
13 SECOND_LAST_NAME Character(30) VARCHAR2(30) NOT NULL Second Last Name
14 NAME_AC Character(50) VARCHAR2(50) NOT NULL Alternate Character Name
15 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL MIDDLE_NAME
16 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country