OPTE May
This section of the documentation will review prerequisites to creating the May OPTE file, outline the processing steps to create the file, and show the file layouts/mapping for each file included in the submission.
OPTE May Prerequisites
- Verify that the OPTE Mark Type, OPTE Mark Type TB print Value and OPTE Level Table Number fields have the correct values on the OR Configuration page.
- Make sure that the Grades validation table has the correct State Code Equiv values.
- Verify that the Withdrawals validation table has the correct State Code Equiv values.
- Make sure that the Course Grade validation table has the correct State Code Equivs to map your local grades to State grades.
- Verify that the Program Strand validation is up to date.
- Verify that the Report Period validation table has the correct dates and codes (see the Report Period Codes section for more information).
- Please make sure that the GPA Calculation has been run for the reporting period.
- Verify that the OR OPTE Information page has the correct values for the following fields:
- OPTE Flag: Set the value of this flag to 'Y' if the course needs to be included.
- Program Strand: Define the appropriate program strand for the course.
- Course Number: This is an optional field. Value entered here will be used as the course for submission. If left blank the master schedule course will be used. Please note that we are using the Course number as is and not the State Course number.
- Make sure that you have updated CTE Students with the correct CTE Assessment information on the OR OPTE page.
OPTE May Submission Processing
- Select Regulatory from the main menu, select Collections submenu, select Collections, and then select OR Student Download. Enter the prompts as specified in the section Prompts panel.
- For better performance, use some sort of filter, even if it is a filter that includes all of your buildings. Running the Download without a filter at all slows performance. The best filter would be an Area of Entry/Withdrawal, Field Name Building, Condition of 'is in" and then all buildings in the Value field separated by commas.
- Click the Run icon at the top right of the page.
- Review the errors in the Tasks/Reports menu's error log and update the data as necessary.
- Once any data updates are made, repeat step 1 using the same prompt values. Repeat Steps 1 through 4 until all errors are corrected.
- Go to the OR Student Submission Files page (menu path: select Regulatory from the main menu, select Collections submenu, select Collections, and then select OR Student Submission Files) and enter the values specified in the section OR Student Submission Files > Prompts panel.
- Click the Run icon at the top right of the page.
- Click the Tasks/Reports button on the Navigation bar to display the Tasks and Reports page. The csv filename is in the format OR_ReportingPeriod_Extract_datetime.csv.
OR Student Download
Menu path: Select Regulatory from the main menu, select Collections submenu, select Collections, and then select OR Student Download.
Prompts Panel
Field | Description |
|---|---|
School Year | The current school year. |
Reporting Period | Select OPTE Download. Your District may have named it something slightly different. |
Start Date | Defaults to the date specified in the Report Period validation table. |
End Date | Defaults to the date specified in the Report Period validation table. |
View Type | N/A |
GPA Type | Select GPA type (This is used to retrieve data to set the flag for academic disadvantage field.) |
Clear Existing | Checked (by default); Clears records from the download table for the specified school year, reporting period, collection and filter. |
Clear Override | Select this checkbox if you wish to delete records that were added or updated through the editable download record feature on the Student Download Summary page. |
Log File Type | Error logs can be created in pdf style, or can be created as CSV files so that you can open them in a spreadsheet program. |
Submission Files Panel
The following boxes are selected by default: SSID Data Section, Talented and Gifted Section, and Professional/Technical Ed.
OPTE May Submission Files
Menu path: Select Regulatory from the main menu, select Collections submenu, select Collections, and then select OR Student Submission Files.
Prompts Panel
Field | Description |
|---|---|
School Year | Enter the Current Year. |
Reporting Period | Select OPTE Download (your District may have named it something different). |
Submission Files Panel
The SSID Data Section, Talented and Gifted Section, Professional/Technical Ed: Student, and Professional/Technical Ed: Course boxes are selected by default.
OPTE Submission File Layouts
SSID File Layout/Mapping
OPTE Student File Layout/Mapping
OPTE Course File Layout/Mapping
Additional Information
The decimal formatting for columns in the Professional/Technical Ed (Career and Technical Course Enrollment) Download will convert the value to explicit decimal that allows precision to the tenth decimal place (for example: 5.5, 10.0, and 120.5). If there is any value present in the download as more than the tenth decimal, it will be made as tenth decimal point and also zero (0) padding will be used if fixed length size is not met.