GPJP_YEARW_SRCH

(SQL View)
 Index Back

YEA Review/Update Search Rcd

This Search record is used in the component used to review/update the YEA Report Data.

SELECT DISTINCT %Sql(SCRTY_SEL_PKEY, OPR, SEC) , NM.NAME , NM.LAST_NAME_SRCH , NM.NAME_AC FROM %Sql(SCRTY_PER_NM_FROM) , PS_GPJP_YEA_TABLE A WHERE SEC.APPT_TYPE IN ('0', '3') AND SEC.EMPLID = A.EMPLID AND SEC.EMPL_RCD = A.EMPL_RCD AND %Sql(SCRTY_NAME) AND %Sql(SCRTY_WHERE, 'PPLJOB')

# 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 NAME Character(50) VARCHAR2(50) NOT NULL Name
6 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
7 NAME_AC Character(50) VARCHAR2(50) NOT NULL Alternate Character Name