Appendix: Campus Community Reports

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

Note. For samples of these reports, see the Portable Document Format (PDF) files published on CD-ROM with your documentation.

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 PeopleBook 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.

See Also

HRMS 9.0 Application Fundamentals PeopleBook, "PeopleSoft Application Fundamentals for HRMS Reports"

CS-HCM Integration Information, posted to My Oracle Support https://support.oracle.com

Click to jump to parent topicCampus Community Reports A to Z

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

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

Note. Use PeopleSoft Process Scheduler to run Crystal reports.

See PeopleTools: PeopleSoft 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.

Workforce Administration, Personal Information, Biographical, 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.

  • Campus Community, SEVIS, Reports, Passport/Visa Expiration

  • Workforce Administration, Personal Information, Citizenship, 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.

  • Campus Community, SEVIS, Reports, Citizenship/Country/Visa Audit

  • Workforce Administration, Personal Information, Citizenship, Citizenship/Country/Visa Audit

PRCSRUNCNTL

PER701

Department Table (CRYSTAL)

Lists all departments by Department ID.

Set Up HRMS, Foundation Tables, Organization, 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).

Set Up HRMS, Foundation Tables, Organization, 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.

Set Up HRMS, Install, Country Table Report

PRCSRUNCNTL