How can I find the latest EL information for a new student in CALPADS using SENR?

CALPADS is a great resource for finding out English Language information for your student in one place. But why would you try to retrieve your EL data from CALPADS instead of your SIS? There is one killer feature that makes it all worth while:

CALPADS can provide you with the latest EL status and start date EVEN IF THE STUDENT IS BRAND NEW TO YOUR SCHOOL

That’s right!  No more digging through or waiting for cumulative files to know your new student’s EL past.  This is especially helpful at the beginning of the year when you are planning to update your data for the start of CELDT testing!

All you need is your SENR file for CALPADS.  This article will show you how.

There are a few assumptions that are made:

  • Your SENR file is error free and fully posted.  If it is not, fix those errors before continuing
  • Your SENR file is current and contains the students whose EL information you are looking for.


Step 1:  In CALPADS, upload and fully post your SENR file with zero errors

Posting with zero errors ensures that your EL list is complete and less likely to contain issues that stem from the mis-assignment of SSIDs.

Screen Shot 2014-08-28 at 6.12.21 PM

Step 2:  Navigate to Reports > Extracts > SSID Extract

Screen Shot 2014-08-28 at 6.22.40 PM

Step 3:  Select your completely posted Job ID and click on “Request File” at the bottom of the page.

Screen Shot 2014-08-28 at 6.27.54 PM

Screen Shot 2014-08-28 at 6.31.31 PM

If successful, you will see the following alert at the top of the page.

Screen Shot 2014-08-28 at 6.33.27 PM

Step 4:  Navigate back to Reports > Extracts and select ODS Extracts at the bottom of the page.

Screen Shot 2014-08-28 at 6.38.31 PM

Step 5:  Ensure that the filter shows the “SSID Extract” and click the download button of your newly requested file.

Screen Shot 2014-08-28 at 6.49.04 PM

Step 6:  Upon opening the .txt file in Excel, use the text to columns feature to separate the fields by the “^” delimiter.

Screen Shot 2014-08-28 at 7.00.18 PM

You will now be able to find the following information which could be passed on to your Language Coordinator for updates to your SIS or for preparation for CELDT testing!

  • Column L = EL status of the latest school that this student attended
  • Column M = The EL Status start date of the latest EL status issued to this student
  • Column N = Primary Language Code.  The most common are 0 for English and 1 for Spanish but there are many more!
Updated on January 3, 2023

Was this article helpful?

Need Support?
Can't find the answer you're looking for? Don't worry we're here to help!

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Knowledge For Schools by Measure Education