GP_PI_PAY_SRCH

(SQL View)
 Index Back

Add search for payroll PI

This is the search record for manual PI for earnings and deductions.

SELECT SEC.OPRID , MNL.EMPLID , MNL.EMPL_RCD , MNL.GP_PAYGROUP , MNL.CAL_ID , SEC.NAME FROM PS_GP_PI_MNL_DATA MNL , PS_EMPLMT_SRCH_GBL SEC WHERE MNL.EMPLID=SEC.EMPLID AND MNL.EMPL_RCD=SEC.EMPL_RCD AND (EXISTS ( SELECT 1 FROM PS_GP_CALENDAR CAL , PS_GP_RUN_TYPE RT WHERE CAL.GP_PAYGROUP=MNL.GP_PAYGROUP AND CAL.CAL_ID=MNL.CAL_ID AND CAL.RUN_TYPE=RT.RUN_TYPE AND RT.CALC_TYPE='P') OR EXISTS ( SELECT 1 FROM PS_GP_PYE_CAL PC WHERE PC.EMPLID=MNL.EMPLID AND PC.EMPL_RCD=MNL.EMPL_RCD AND PC.GP_PAYGROUP=MNL.GP_PAYGROUP AND PC.CAL_ID=MNL.CAL_ID))

# 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: PERS_SRCH_GBL

3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

Prompt Table: EMPLMT_SRCH_GBL

4 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group

Prompt Table: GP_PYGRP_PAY_VW

5 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id

Prompt Table: GP_PAY_CAL_VW

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