GP_ACM_ADJ_SRCH

(SQL View)
 Index Back

Accumulator Adj. Search Record

This is a Search Record for the User Adjustment to Accumulators panel group.

SELECT %Sql(SCRTY_SEL_PKEY,SEC,SEC) , A.CAL_RUN_ID , A.CAL_ID , A.GP_PAYGROUP , SEC.NAME FROM PS_GP_PYE_PRC_STAT A , PS_GP_CAL_RUN C , PS_EMPLMT_SRCH_GBL SEC WHERE A.EMPLID = SEC.EMPLID AND A.EMPL_RCD = SEC.EMPL_RCD AND A.PRD_TYPE <> 'H' AND A.CAL_RUN_ID = C.CAL_RUN_ID AND C.RUN_FINALIZED_IND = 'Y'

# 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 Rcd Nbr
5 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id

Prompt Table: GP_RSLT_ACM_VW1

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

Prompt Table: GP_RSLT_ACM_VW2

7 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
8 NAME Character(50) VARCHAR2(50) NOT NULL Name