GPFR_ILL_SRCH1

(SQL View)
 Index Back

ILL: Used as Prompt Table

ILL: Used as Prompt Table in the search record. dedicated to EMPLID selection.

SELECT DISTINCT(A.EMPLID) , SEC.OPRID , B.NAME , SEC.ROWSECCLASS FROM PS_GPFR_ILL_ADMIN A , PS_PERSON_NAME B %Sql(GPFR_SECU_PERS_SQL, A) AND A.EMPLID = B.EMPLID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 NAME Character(50) VARCHAR2(50) NOT NULL Name

Prompt Table: PERSON

4 ROWSECCLASS Character(30) VARCHAR2(30) NOT NULL The class used to determine row level security