GP_PI_MNL_ED_VW

(SQL View)
 Index Back

SearchRec for ManualPI for E&D

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

SELECT %Sql(SCRTY_SEL_PKEY,SEC,SEC) , 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 NOT 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='A') AND NOT EXISTS ( SELECT 1 FROM PS_GP_OFFCYCL_M_VW MP WHERE MNL.GP_PAYGROUP = MP.GP_PAYGROUP AND MNL.CAL_ID = MP.CAL_ID AND MNL.EMPLID = MP.EMPLID AND MNL.EMPL_RCD = MP.EMPL_RCD)

# 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 ROWSECCLASS Character(30) VARCHAR2(30) NOT NULL The class used to determine row level security
3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
5 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group

Prompt Table: GP_PYGRP_PAY_VW

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

Prompt Table: GP_PAY_CAL_VW

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