SCC_SS_GE_SRCH

(SQL View)
Index Back

Eval Management Self-Service

Evaluation Management Self-Service Search Record.

SELECT A.EMPLID , B.OPRID FROM PS_SCC_PRI_NAME_VW A , PSOPRDEFN B WHERE A.EMPLID = B.EMPLID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PEOPLE_SRCH

2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).