Oregon State Reporting Window

This is a licensable feature and is currently available only for institutions of higher education in the state of Oregon.

The Oregon Community College Unified Reporting System (also referred to as OCCURS) consists of a standardized database of information that was developed by representatives from every community college in the state of Oregon. This method provides statistical data for federal and state reporting requirements that can be used for planning, research, and support purposes, such as Carl Perkins, Pell Grant, OPTEMIS, FTE reimbursement, and workforce reporting.

The required data elements have been incorporated in J1 Desktop to allow for the necessary data to be collected and reported using the appropriate state submission formats.

Report	Description
Course File	Contains information about every section of every course offered each term Data is used for enrollment, FTE, funding sources, special contracts, etc,. and can also be linked to activities and instructors to determine costs, facilities usage, etc. Submit after the 4^thweek of every term and after the end of every term Data elements for this report are Institution Code, Course Year, Course Term, Reporting Period, Reporting Date, and In-District/COD Identifier
Student File	Contains one record per student using the Student ID or SSN as an identifier and tracks information such as enrollment, progress, outcomes, etc. Submit after the 4^thweek of the fall term and after the end of every term Data elements for this report are Institution Code, Course Year, Student Term, Cohort Code, Reporting Period, Address Priority Code, and Reporting Date
Program Table	Contains information on all programs or areas of study including formal as well as quasi-programs Combination of college code, CIP code, and OCCURS extension provides the ability to maintain the course of study and student progress toward the course of study Submit end of term (or as needed) Data element for this report is Institution Code
Course Master	Contains information about every course offered by each college (not term-specific A course must appear in the Course Master before it can be included in the Course File Submit end of term (or as needed) Data elements for this report are Institution Code and Reporting Date
Enroll Table	Contains information as it relates to enrollment for each student, such as course, credits, clock hours, and grade Submit with end of term student file Data elements for this report are Institution Code, Reporting Date, Course Year, and Course Term
Student Completions File	Contains one record for each partially or fully completed program per student and provides an annual snapshot of the students progress Submit annually the end of the first full week in August Data elements for this report are Institution Code and Reporting Date
Credit & PT (Professional/Technical) Table	Contains one record for each credit student including those having a professional/technical major and includes special populations information such as Perkins, Pell grant and BIA Students must have earned more than zero credits in the current academic yea Submit annually the end of the first full week in August Data elements for this report are Institution Code and Reporting Date

This window is used to select a query and generate an import text file for Oregon State Reporting. There are two tabs on this window: Reporting and Text File.

Reporting Tab

Text File Tab

The Text File tab allows you to create, display, and print the report that was configured on the Reporting tab

How do I...

1. Only the state of Oregon is available from the State drop-down list.

2. Choose the appropriate report. Notice that the radio buttons from the Query Criteria group box become available or unavailable, depending on the type of report you choose.

3. Select from either the original Query that has been created for each state report or one that has been modified. You may click on the Customize button to launch InfoMaker and customize the report.

4. Click on the Populate Results button to display the query results in the Selected Items group box.

5. By clicking on the Change... button from the Query Criteria group box, the Select Report Criteria window will be displayed and allows you to add or remove rows that have been retrieved from the currently selected query.

6. When the correct report criteria has been determined, click on the Text File tab.

7. Choose Create The Report Import File button. The default path and report file name will automatically be displayed in the Enter the Report File Name window; however, you can make changes to either the path or file name. Click OK.

8. Depending on the type of report that has been requested, the Report Datawindow will be displayed and you will be required to enter the necessary data elements.

9. A prompt window will be displayed indicating that the report is being created. A second prompt window will then indicate that the text file is being created and the results will be displayed in the Report section of the Text File tab.

10. You can save the report as Excel, SQL, and HTML table formats.