GPGB_NIC_EM_VW1

(SQL View)
 Index Back

Employee view for NIC

Employee NIC view based on pay entity and pay group

SELECT DISTINCT P.PAY_ENTITY ,P.GP_PAYGROUP ,J.EMPLID ,PD.FIRST_NAME ,PD.LAST_NAME FROM PS_JOB J ,PS_GP_PYGRP P , PS_PERSON_NAME PD WHERE J.EFFDT=( SELECT MAX(J1.EFFDT) FROM PS_JOB J1 WHERE J1.EMPLID=J.EMPLID AND J1.EMPL_RCD=J.EMPL_RCD AND J1.EFFDT<=%CurrentDateIn) AND J.EFFSEQ=( SELECT MAX(J2.EFFSEQ) FROM PS_JOB J2 WHERE J2.EMPLID=J.EMPLID AND J2.EMPL_RCD=J.EMPL_RCD AND J2.EFFDT=J.EFFDT) AND J.EMPLID = PD.EMPLID AND P.GP_PAYGROUP=J.GP_PAYGROUP AND J.REG_REGION IN ( SELECT DISTINCT R.REG_REGION FROM PS_REG_REGION_TBL R WHERE R.COUNTRY = 'GBR' AND R.REG_REGION <> 'ROI')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
2 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
4 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
5 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name