SSR_INSTRW_SRCH (SQL View)	Index Back
Weekly Schedule Search This view joins SCC_PERS_SA_VW and the Operator Definition table (to get OPRID). It has As of Date in order to allow navigation from other components with the date to start.

SSR_INSTRW_SRCH

(SQL View)

Weekly Schedule Search

This view joins SCC_PERS_SA_VW and the Operator Definition table (to get OPRID). It has As of Date in order to allow navigation from other components with the date to start.

SELECT A.EMPLID , B.OPRID , %DateNull , ' ' , ' ' , ' ' FROM PS_SCC_PERS_SA_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).

3 START_DT Date(10) DATE Start Date

4 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

5 STRM Character(4) VARCHAR2(4) NOT NULL Term

6 SSR_SELECT_CLASS Character(1) VARCHAR2(1) NOT NULL Select
A=Show All Classes
E=Show Enrolled Classes Only

#	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).
3	START_DT	Date(10)	DATE	Start Date
4	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution
5	STRM	Character(4)	VARCHAR2(4) NOT NULL	Term
6	SSR_SELECT_CLASS	Character(1)	VARCHAR2(1) NOT NULL	Select A=Show All Classes E=Show Enrolled Classes Only