SSR_WEEK_SEC_VW (SQL View)	Index Back
Personal Data Name Security SSR_WEEK_SEC_VW joins Personal Data (to get the EMPLID and NAME) 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_WEEK_SEC_VW

(SQL View)

Personal Data Name Security

SSR_WEEK_SEC_VW joins Personal Data (to get the EMPLID and NAME) 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 , C.NAME FROM PS_SCC_PERS_SA_VW A , PSOPRDEFN B , PS_HCR_PERSON_NM_I C WHERE A.EMPLID = B.EMPLID AND A.EMPLID = C.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 AS_OF_DATE Date(10) DATE As of Date

4 NAME Character(50) VARCHAR2(50) NOT NULL Name

#	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	AS_OF_DATE	Date(10)	DATE	As of Date
4	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name