GPHK_PIADD_SRCH

(SQL View)
Index Back

Add search for payroll PI

This is the search record for manual PI for earnings and deductions. Add Search record for MPF Varying Daily Rates for Industrial Scheme Daily workers when they have Varying Daily rates

SELECT SEC.OPRID , MNL.EMPLID , MNL.EMPL_RCD , MNL.GP_PAYGROUP , MNL.CAL_ID , SEC.NAME FROM PS_GPHK_PI_TBL 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