Documentation for Administrators

Generate MOSIS Extracts

Updated on

The Generate MOSIS Extracts screen is used to generate, view, and download extracts for state reporting.

Generating MOSIS Extracts

1. In the Missouri Reports menu, click Generate MOSIS Extracts.

Generate MOSIS Extracts

2. Select the Cycle.

3. Select the Effective Date.

For the October cycle, the Effective Date should be the last Wednesday in September. For the February cycle, the Effective Date should be the last Wednesday in January.

4. Select the File Download Format. Options are Comma Separated File and Text File.

Generate MOSIS Extracts

Some cycles have additional options that display once selected. When "Cycle 10 - Assessment Precode" is selected, the Precode pull-down is displayed, where you will select an option.

When "Cycle 12 - MOSIS ID Batch" is selected, the "Include Students with a MOSIS ID" option is displayed. When this option is selected, all students are included in the extract instead of only students who are missing an ID. The "Include student enrollments on or after" date field is also displayed to pull students enrolled on or after the selected date.  

Generate MOSIS Extracts
Generate MOSIS Extracts

5. Select the check box for each of the extracts you want to generate, or click Select All. The list of extracts depends on the Cycle selected at the top of the screen.

Generate MOSIS Extracts

6. Click Generate Extract(s).

Generate MOSIS Extracts

"Generating..." will display next to an extract as it is generating. A green check mark and "Extract Successful" message will briefly display next to an extract once it has been successfully generated.

Generate MOSIS Extracts

7. Click Download Extract next to an extract to download the file to your computer. The type of file that downloads depends on the File Download Format selected at the top of the screen.

Generate MOSIS Extracts

8. Click HTML View next to an extract to view the extract data in a more readable format in Focus.

Generate MOSIS Extracts

The results of the extract will display in a table view, which can be exported to CSV/Excel, printed, and filtered.

9. Click Go back when finished.

Generate MOSIS Extracts

10. For a complete history of users who have generated extracts, click Extract History.

Generate MOSIS Extracts

A pop-up screen opens that lists the Extract User, School Year, Extract, Time and Date, and the Number of Records.

Battery

11. Close the pop-up window when finished.

Next Article MOSIS Verification Reports