LA SIS Export File

From EDgearWiki
Jump to navigationJump to search

This program will build the records for submitting student information to the state for any of the processing periods. The file(s) that are created will be saved on jDrive. As part of the build process you will select a folder on jDrive saving the file. You will then download a copy of this file to your computer in an area similar to what you have done in the past.

Menu Location

Sis sis sis.png

On the left navigation panel select Required Reporting > Export >LA SIS Export File.

Setup Options

A small setup box will appear that has the Year and the District number. Verify this information and click the OK button.

Sts first set up.png

Sis setup.PNG


The next part of the setup will appear. It is divided into 4 sections: Student, Discipline, Schedule and Build.

Use the following instructions for each of these sections to complete the setup for building your SIS file.

Student Section - This section is for all processing periods.

  • School: - Leave this field blank to send all schools or select the school(s) that you want to include in the file.
  • Grades: - Leave this field blank to send all grade levels or select the grade level that you want to include in the file.
  • Stu As-of-Date: - Only the students with attendance records and/or discipline referrals as of this date will be processed. This date is based on the processing period being submitted: Oct 1 (MFP or CLASS), Feb 1 MFP, or EOY (the last instructional day).
  • Check Box Selection: Be sure to always make the same selection(s) each time you run this program.
    • Send Homeless and Migrant Students as LU1 - If selected, students identified as homeless or migrant will always be given Lunch Code LU1. All districts check this option.
    • Use SIS school for reporting - Use the SIS School instead of the enrollment school. Districts may have programs and/or special schools, that are not included in the Sponsor Site file at DOE, that identify students as being enrolled at other schools in the district at DOE. This school is called the students' SIS school. If you have this situation in your district then you must check this item.
    • Re-assign Student SSN - (No longer used) Check if the SSN of one of more students have changes since the last processing period.
    • Include Address 120 Records - Only Type 2 Charter schools/districts and OJJ (Office of Juvenile Justice) are required to include the address records for students. All other districts must leave this item unchecked.
    • Send E1 as C4 - You MUST check this item if your district number has been changed by DOE from the previous year's number.


Discipline Section - This section is for all processing periods

  • Include Event Records (007, 091, 092, 093, 094,) - Check to create the SIS Event file for Discipline records.

Schedule Section - This section is used for Oct 1 Class processing ONLY.

  • Include 110 records - Check to include schedule records in the SIS file that is being built.
  • Classes as of date - Includes students enrolled in classes that began as of the date selected. Use Oct 1 when it is on a weekday. Use Sept 30 when Oct 1 is on Saturday. Use Oct 2 when Oct 1 is on Sunday.
  • Send Vocational after 10/1 - Check to process students active in vocational classes that started after 10/1. This setting overrides the "As of Date" for vocational records. Making this selection will have a positive effect on your vocational dollars.
  • Use Active Master Schedule - Choose whether to use your district's current Master Schedule or your district's Master Schedule as of the most recent occurrence of 10/1 for processing. NOTE: The selected option must also be used for CUR and PEP reporting.
Use October Master Schedule - Choose whether to use your district's current Master Schedule or your district's Master Schedule as of the most recent occurrence of 10/1 for processing. NOTE: The selected option must also be used for CUR and PEP reporting.

Build Section

  • Try To Fix Errors - Check to update the generated SIS files to correct for common errors in SIS. Entry code and date errors, etc.
  • '"Separate Files for Event and Class - Check to create separate files for discipline record types 007, 091, 092, 093, 094 (event records) and 110 (schedule records). This is NOT usually selected.
  • New SIS files every ... - Choose the maximum row count of a single SIS file. If more rows exist, they will be added to a new SIS file.
  • NOTE - Be sure to submit all of these files that are built when downloading the files to your computer.
  • File Format - Choose which year's SIS file layout to export.
  • File Type: Select either File Type 1 (Full) or File Type 2 (Partial).
    • File Type 1 (Full) - This selection can be the district, a single school or multiple schools, with one or more grades for the district or for the schools selected.
    • File Type 2 (Partial) - This selection results in a Student field to become active. Select one or more student(s) from the student list popup. You can search for students using the search field at the top of the student list. You can sort by ID number(s) or by name.
  • Save Location: When you click in the field, jDrive will open. Any previously created folders and/or documents will be displayed. If you do not have a SIS folder, click the folder with the plus sign in the upper left corner of the jDrive display to create a new folder. A popup will appear in which you will enter the name of the SIS folder. The simple name SIS is sufficient. Click OK. Double click the folder. The folder name is entered into the field at the bottom left of the popup. The selected folder name will be entered into the field at the bottom left of the screen. Click Choose.
  • Click the Build button at the bottom of the setup box.
  • NOTE - You will receive two messages about this particular process: (1) the number of students whose records will be built and (2) a reminder that you can view the status of the build process and that you will receive an email when the program has finished


**********While the file is processing, progress can be monitored by clicking the TASK STATUS button at the bottom of the window.

  1. There are two tabs on the Task Status window--Current and Completed
  2. The Current tab will automatically refresh, giving you information about the processing.
    • Pending--This status indicates that the file is waiting to process.
    • Start--This status indicates that the file is gathering the records to process.
    • Running--This status indicates that the file is processing. There will be a progress bar and a Report: current date/clock time
  3. After the file has finished processing, the Current tab screen will be blank.
  4. The Completed tab will display four columns of information about the files that have been built.
    • siLASISlogic x.xx.xx--this is the program name that is being used with the version (x.xx.xx) number of the program.
    • Completed progress bar--this shows the number of records processed
    • Status--the status will always be Finish
    • Report:date/time--This information will be used to identify which file(s) you must use when submitting SIS to the Leads Portal.
  5. The Completed tab is where you access the errors that are found during the SIS build process.
  6. Click on the status line to get the Error popup.
  7. If you have requested only a few of your schools, the error report will include errors from all schools.
  8. At the bottom of the error list popup there is a check box to print errors by school. You can then select to print only the pages for the small group of schools that you are focusing on.


**********After the file has been processed, you must save a copy of the jDrive file(s) to a location on your computer.

  1. Open the jDrive by clicking on the Cloud icon on the top right of the JCampus screen.
  2. Navigate to the file(s) that you created.
  3. Right click on the file and click Download.
  4. A preview of the file will appear on your screen in the upper left corner.
  5. Right click on the preview and select Save As.
  6. Navigate to the location where you want to save these files. There will be a file name in this popup; if you have created multiple files be sure to change it to a unique name.
  7. Repeat this for the remaining SIS files.
  8. Be sure to download the Event file.
  9. After downloading the SIS and Event files, you are ready to submit them to DOE.

Q & A

Q: I thought all our graduates used the last day of school, because it coincided with SIS and SPC (calendar). So, is there supposed to be different graduation dates in STS and SIS?
A: Yes, these two dates are different. The graduation date in STS is the date the student walks across the 'stage' to get their diploma as specified in the Calendar Editor. The SIS date is a program completer date which is the last day of school. Just remember in SIS, graduates are to be exited last day of school, not graduation date.


Required Reporting Main Page

JCampus Main Page

Retrieved from EDgear Wiki