GPGB_NIC_EMP_VW

(SQL View)
 Index Back

Employee NIC view

Employee NIC view based on pay entity

SELECT DISTINCT P.PAY_ENTITY ,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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
4 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name