GP_PI_MNL_AE_VW

(SQL View)
 Index Back

SearchRec AE PI (adjustments)

This is the search record for manual PI for absence entitlement adjustments

SELECT %Sql(SCRTY_SEL_PKEY, SEC, SEC) , B.GP_PAYGROUP , B.CAL_ID , SEC.NAME , PRD.PRD_BGN_DT , PRD.PRD_END_DT FROM PS_GP_CALENDAR B , PS_GP_RUN_TYPE C , PS_GP_CAL_PRD PRD , PS_EMPLMT_SRCH_GBL SEC WHERE B.CAL_PRD_ID = PRD.CAL_PRD_ID AND B.GP_PAYGROUP IN ( SELECT DISTINCT GP_PAYGROUP FROM PS_JOB J WHERE J.EMPLID=SEC.EMPLID AND J.EMPL_RCD=SEC.EMPL_RCD AND (J.PAY_SYSTEM_FLG='GP' OR J.ABSENCE_SYSTEM_CD='AM')) AND B.RUN_TYPE = C.RUN_TYPE AND C.CALC_TYPE = 'A'

# 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

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

Prompt Table: GP_ABS_CAL_VW

7 NAME Character(50) VARCHAR2(50) NOT NULL Name
8 PRD_BGN_DT Date(10) DATE Period Begin Date
9 PRD_END_DT Date(10) DATE Pay Period End Date