GP_RSLT1_SRCH

(SQL View)
 Index Back

Results by Calendar Run ID

Payee Results Search

SELECT %Sql(SCRTY_SEL_PKEY,SEC,SEC) , A.PYMT_DT , A.CAL_RUN_ID , B.DESCR , SEC.NAME_DISPLAY , SEC.NAME_DISPLAY_SRCH FROM PS_GP_PYE_PRC_STAT A ,PS_EMPLMT_SRCH_GBL SEC ,PS_GP_CAL_RUN B WHERE A.EMPLID = SEC.EMPLID AND A.EMPL_RCD = SEC.EMPL_RCD AND B.CAL_RUN_ID = A.CAL_RUN_ID AND B.CAL_RUN_ID IN ( SELECT B1.CAL_RUN_ID FROM PS_GP_CAL_RUN_STRM B1 WHERE B1.STRM_IDNT_IND='Y') AND A.PYMT_DT = ( SELECT MAX(PPS.PYMT_DT) FROM PS_GP_PYE_PRC_STAT PPS WHERE PPS.EMPLID = A.EMPLID AND PPS.CAL_RUN_ID = A.CAL_RUN_ID AND PPS.EMPL_RCD = A.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 Rcd Nbr
5 PYMT_DT Date(10) DATE Payment Date
6 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id

Prompt Table: GP_CAL_RUN4_VW

7 DESCR Character(30) VARCHAR2(30) NOT NULL Description
8 NAME Character(50) VARCHAR2(50) NOT NULL Name
9 NAME_DISPLAY_SRCH Character(50) VARCHAR2(50) NOT NULL Uppercase version of Name to improve performance on searches.