SUJ--SQL of View Modified to list only Resource Management Resources

RS_SCHED_SYNCVW

(SQL View)

SELECT A.EMPLID , B.NAME , A.FOLDER_NAME FROM %Table (RS_EMPL_CAL_OPT) A , %Table (PERSONAL_DATA) B , %Table (RS_ELGBL_WRKR) D WHERE A.EMPLID = B.EMPLID AND A.EMPLID = D.EMPLID AND D.SYSTEM_SOURCE ='RS'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: RS_EMPLCALSYNVW

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

3 FOLDER_NAME Character(80) VARCHAR2(80) NOT NULL Calendar Folder Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: RS_EMPLCALSYNVW
2	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
3	FOLDER_NAME	Character(80)	VARCHAR2(80) NOT NULL	Calendar Folder Name