Campus Community Reports A to Z

This appendix provides an overview of PeopleSoft Campus Community reports and enables you to view a summary table of all reports.

Note: If you are implementing separate instances of your PeopleSoft Campus Solutions and PeopleSoft HCM systems, you should read the additional documentation describing those integrations. Certain items and features that are detailed in this documentation may vary depending on how you configure your systems. The CS-HCM Integration Information Knowledge Document details the additional documents that describe the setup, functional, and technical implementation considerations.

On June 1, 2011, Oracle discontinued distribution of SAP’s Business Objects Enterprise and Crystal Reports with PeopleTools. Existing customers may use Business Objects Enterprise and Crystal Reports licenses previously received from Oracle. Customers who wish to use future versions of Business Objects and Crystal Reports products with PeopleSoft will need to obtain appropriate license and support directly from SAP/Business Objects.

The following table lists Campus Community reports, sorted alphabetically by report ID. You might also find PeopleSoft HRMS reports useful.

See HRMS 9.0 Application Fundamentals, "PeopleSoft Application Fundamentals for HRMS Reports."

Note: Use PeopleSoft Process Scheduler to run Crystal reports. See PeopleTools: Process Scheduler.

Report ID and Report Name	Description	Navigation	Run Control Page
PER020 Employee Home Address Listing (SQR Report)	Contains a complete listing of all employees with addresses and home phone numbers.	select Workforce Administration, then select Personal Information, then select Biographical, then select Home Address Report	PRCSRUNCNTL
PER032 Passport/Visa Expiration (SQR Report)	Lists individuals (students, exchange visitors, and dependents) that have passports, visas, or work permits on file that expire in 90 days of the report run date. The report is divided into two sections. The first section lists passport information including country, passport number, issue date, and expiration date. The second section lists visa and work permit information including country, visa and work permit number, type of permit, issue date, and expiration date.	select Campus Community, then select SEVIS, then select Reports, then select Passport/Visa Expiration select Workforce Administration, then select Personal Information, then select Citizenship, then select Passport/Visa Expiration Audit	PRCSRUNCNTL
PER033 Citizenship/Country/Visa Audit (SQR Report)	Lists discrepancies between citizenship country/status and visa data for individuals. Displays various discrepancies found for the employee citizenship status in the Personal Data table. Looks for the country specified in the Installation table and uses it as the local country.	select Campus Community, then select SEVIS, then select Reports, then select Citizenship/Country/Visa Audit select Workforce Administration, then select Personal Information, then select Citizenship, then select Citizenship/Country/Visa Audit	PRCSRUNCNTL
PER701 Department Table (CRYSTAL)	Lists all departments by Department ID.	select Set Up HRMS, then select Foundation Tables, then select Organization, then select Department Table Report	PRCSRUNCNTL
PER705 Department Table (CRYSTAL)	Lists each physical location by Location Code. Because you can define locations by effective date, the report program prints all locations (past, present, and future).	select Set Up HRMS, then select Foundation Tables, then select Organization, then select Location Table Report	PRCSRUNCNTL
PER708 Country Table (CRYSTAL)	Prints a list of all of the countries and their character codes that are in the system.	select Set Up HRMS, then select Install, then select Country Table Report	PRCSRUNCNTL