RC_SS_USER_SRCH (SQL View)	Index Back
Self-Service User Search This view is used as a Search Record for Following Components 1. RC_CASE_HD_SS_SRCH (HelpDesk - Search Case) 2. RC_CASE_SS_SRCH (Support - Search Case)

RC_SS_USER_SRCH

(SQL View)

Self-Service User Search

This view is used as a Search Record for Following Components 1. RC_CASE_HD_SS_SRCH (HelpDesk - Search Case) 2. RC_CASE_SS_SRCH (Support - Search Case)

SELECT A.OPRID , A.PERSON_ID FROM PSOPRALIAS A WHERE A.OPRALIASTYPE = 'PER'

# 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 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID

#	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	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID