PeopleSoft Recruiting and Admissions 9.0 PeopleBook

Appendix: Recruiting and Admissions Reports

This appendix provides an overview of Recruiting and Admissions reports and enables you to:

View summary tables of all reports.
View report details and tables accessed.

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

Recruiting and Admissions Reports: A-Z

This table lists the Recruiting and Admissions reports, sorted alphanumerically by report ID. The reports listed are Crystal and SQR reports. If you need more information about a report, refer to the report details at the end of this appendix.

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

Report ID and Report Name	Description	Navigation	Run Control Page
ADAVGCUT Average Cutoff Report	Enables you to assess an evaluated applicant pool to determine the admissions averages that drive certain program actions. (SQR)	Student Admissions, Reports, Average Cutoff Report	RUNCTL_ADAVGCUT
ADFUNNEL Admissions Funnel	Lists prospect and applicant numbers across one or multiple terms. The report lists the numbers of individuals by applicant type and status as well as other various conditions that you choose, such as ethnicity, gender, region, and academic program (SQR).	Student Admissions, Reports, Admissions Funnel Report	RUNCTL_ADFUNNEL
AD701 Admissions Action Table	Lists all program actions defined on the Program Action Table page. (Crystal)	Set Up SACR, Product Related, Recruiting and Admissions, Reports, Applicants, Admissions Action Table	PRCSRUNCNTL_AD_RC
AD702 Test Table	Lists all of the tests defined on the Test Tables page. (Crystal)	Set Up SACR, Product Related, Recruiting and Admissions, Reports, External Test Scores, Test Tables	PRCSRUNCNTL_AD_RC
AD703 Recruiting Category Table	Lists all recruiting categories defined on the Recruiting Category Table page. (Crystal)	Set Up SACR, Product Related, Recruiting and Admissions, Reports, Recruiting, Recruiting Category Table	PRCSRUNCNTL_AD_RC
AD704 Referral Source Table	Lists all referral sources defined on the Referral Sources Table page. (Crystal)	Set Up SACR, Product Related, Recruiting and Admissions, Reports, Prospects, Referral Source Table	PRCSRUNCNTL_AD_RC
AD705 Region Table	Lists all regions defined on the Region Table page. (Crystal)	Set Up SACR, Product Related, Recruiting and Admissions, Reports, Recruiting, Region Table	PRCSRUNCNTL_AD_RC
AD710 Summary Type Table	Lists all summary types defined on the External Summary Type Table page. (Crystal)	Set Up SACR, Product Related, Recruiting and Admissions, Reports, External Education, External Summary Type Tbl	PRCSRUNCNTL_AD_RC
AD711 Admit Type Table	Lists all admit types defined on the Admit Type Table page. (Crystal)	Set Up SACR, Product Related, Recruiting and Admissions, Reports, Applicants, Admit Type Table	PRCSRUNCNTL_AD_RC
AD712 Application Center Table	Lists all application centers defined on the Application Center Table page. (Crystal)	Set Up SACR, Product Related, Recruiting and Admissions, Reports, Applicants, Application Center Table	PRCSRUNCNTL_AD_RC
AD713 Admission Evaluation Table	Lists all evaluation codes defined on the Evaluation Codes Table page. (Crystal)	Set Up SACR, Product Related, Recruiting and Admissions, Reports, Application Evaluation, Evaluation Table	PRCSRUNCNTL_AD_RC
AD714 Evaluation Committee Table	Lists all evaluation committees defined on the Evaluation Committee Table page. (Crystal)	Set Up SACR, Product Related, Recruiting and Admissions, Reports, Application Evaluation, Evaluation Committee Table	PRCSRUNCNTL_AD_RC
AD715 Evaluation Status Table	Lists all evaluation statuses defined on the Evaluation Status Table page. (Crystal)	Set Up SACR, Product Related, Recruiting and Admissions, Reports, Application Evaluation, Evaluation Status Table	PRCSRUNCNTL_AD_RC
AD716 GPA Type Table	Lists all GPA types defined on the GPA Type Table page. (Crystal)	Set Up SACR, Product Related, Recruiting and Admissions, Reports, External Education, GPA Type Table	PRCSRUNCNTL_AD_RC
AD717 GPA Rules Tables	Lists all GPA conversion rules defined on the GPA Rules Table page. (Crystal)	Set Up SACR, Product Related, Recruiting and Admissions, Reports, External Education, GPA Rules Table	PRCSRUNCNTL_AD_RC
AD718 Material Group Table	Lists all material groups defined on the Material Group Table page. (Crystal)	Set Up SACR, Product Related, Recruiting and Admissions, Reports, Application Evaluation, Material Group Table	PRCSRUNCNTL_AD_RC
AD719 Rating Scheme Table	Lists all rating schemes defined on the Rating Scheme Table page. (Crystal)	Set Up SACR, Product Related, Recruiting and Admissions, Reports, Application Evaluation, Rating Scheme Table	PRCSRUNCNTL_AD_RC
AD721 Recruiting Center Table	Lists all recruiting centers defined on the Recruiting Center Table page. (Crystal)	Set Up SACR, Product Related, Recruiting and Admissions, Reports, Prospects, Recruiting Center Table	PRCSRUNCNTL_AD_RC
AD724 Rating Scheme Component Table	Lists all rating components defined on the Rating Comp Def Table page. (Crystal)	Set Up SACR, Product Related, Recruiting and Admissions, Reports, Application Evaluation, Rating Component Table	PRCSRUNCNTL_AD_RC
AD726 Program Action Reason Table	Lists all program action reasons defined on the Program Action Reasons Table page. (Crystal)	Set Up SACR, Product Related, Recruiting and Admissions, Reports, Applicants, Program Action Reason Table	PRCSRUNCNTL_AD_RC
AD727 Material Type Table	Lists all material types and their variable data. (Crystal)	Set Up SACR, Product Related, Recruiting and Admissions, Reports, Application Evaluation, Material Type Table	PRCSRUNCNTL_AD_RC
AD728 School Type Table	Lists all school types defined on the School Types Table page. (Crystal)	Set Up SACR, Product Related, Recruiting and Admissions, Reports, External Education, School Type Table	PRCSRUNCNTL_AD_RC
AD729 Test Component Table	Lists all of the test components defined on the Test Components Table page. (Crystal)	Set Up SACR, Product Related, Recruiting and Admissions, Reports, External Test Scores, Test Component Table	PRCSRUNCNTL_AD_RC
AD730 Target Cohort Table	Lists all enrollment management target cohort levels that your institution has defined. (Crystal)	Set Up SACR, Product Related, Recruiting and Admissions, Reports, Enrollment Target, Enrollment Target Cohort	PRCSRUNCNTL_AD_RC
AD731 Target Division Table	Lists all enrollment management target division levels that your institution has defined. (Crystal)	Set Up SACR, Product Related, Recruiting and Admissions, Reports, Enrollment Target, Enrollment Target Division	PRCSRUNCNTL_AD_RC
AD732 Target Population Table	Lists all enrollment management target population levels that your institution has defined. (Crystal)	Set Up SACR, Product Related, Recruiting and Admissions, Reports, Enrollment Target, Enrollment Target Population	PRCSRUNCNTL_AD_RC

Recruiting and Admissions Reports: Selected Reports

This section provides detailed information about individual reports including important fields and tables accessed. The reports are listed alphanumerically by report ID.

ADAVGCUT

Institution	Enter the institution name.
Academic Program	Enter the academic program for which you want to generate an average cutoff report.
Admit Term	Enter the admit term for which you want to generate an average cutoff report.

Running the process creates a file called adavgcut.lis. Use this file to view the output.

Note. If you enter an academic program and admit term combination that is not set up in the Average Cutoff Table page, you receive a blank report.

ADFUNNEL

Define the data that you want to appear in your report in the Report Request Parameters section.

Report Grouping	Group the data on your report. The default is to have the report grouped by at least the application type and status (Only by Application Type, Status). However, you can select a different option to group the report by other criteria in addition to application type and status. For example, if you select Also by Application Method, then the report will be grouped by application type, status, and application method. Values for this field are delivered with your system as translate values. You can modify these translate values but you may also need to modify the report according to the translate values added. The delivered values are Only by Application Type, Status, Also by Application Method, Also by Ethnicity, Also by Event Type, Also by Gender, Also by Program, Also by Region, and Also by Country/State.
Create Compare Report	Select if you want to compare terms on this report. After this check box is selected, additional fields appear on the screen enabling you to select additional terms. If you want to report on only one term, clear this check box.
Regulatory Region	Select the Regulatory Region to determine which Ethnic Groups to display in the report. The field will display when the Report Grouping of 'Also by Ethnicity' is selected.
Show Term Detail	Select if you want to see the set of terms and details regarding those terms. You can view details of up to five terms. If you have selected more than five terms and you select this check box, you will receive an error message. Clear this check box if you prefer to see your data in one group.
Address Type for Country/State	This field appears when you select Also By Country/State in the Report Grouping field. Select the address type that you want the system to use when grouping the report data.
All Terms for Academic Year	Select the year for which you want to run the report. After you select an academic year, the admit terms defined for that year automatically appear. You can remove any of the terms that you do not want to see. You must select a year for the Admissions Funnel Report process to run successfully.
All Terms in Comparison Year	If you are running a comparison report, select the year to which you are comparing.
Admit Term	The system populates the admit terms based on the year you selected in the All Terms for Academic Year. You can add and delete the admit terms if you want. However, you must select at least one admit term for the Admissions Funnel Report process to run successfully.
Comparison Admit Term	After you select a comparison year, the admit terms defined for that year automatically populate these fields. You can remove any of the terms you do not want to see.