Create SSID Request File (SENR)
Create Student Enrollment File (SENR)
Create SELA Extract for TBD Students
NOTE: The Summer ELPAC Testing tab functionality has not been adjusted to work with the SSID match tools. However, there is a work-around that can be used until this feature gets re-programmed. The Summer ELPAC Testing tab is expected to be released by Summer 2025. See the CALPADS EOY Summer ELPAC Testing Known Isssue page for an attached workaround that can be utilized for summer ELPAC testing.
Overview
Navigate to CALPADS Extracts > Summer ELPAC Testing
The Summer ELPAC Testing tab on the CALPADS Extracts page allows districts to complete the following summer ELPAC testing processes, including:
- Creating SSID request files
- Creating SENR update files
- Creating SELA Extract for TBD Students files
This facilitates sending future enrollment records to CALPADS for summer ELPAC testing, which can be done before or after the New Year Rollover.
Prerequisites
Before Rollover to a new year database
If ATT has already been initialized, the process will use the Next School (STU.NS), Next Grade (STU.NG), Next Program (STU.NSP) as needed. The Next Year Start Date (LOC.NSD) field on the School Options page will determine the expected Enrollment Date for each Next School value.
After the new year database has been created
If ATT has not been initialized, it is assumed that the processing is taking place in the new year database, before the school starts. This process will use the students' School Code (STU.SC), Grade Level (STU.GR), Special Program (STU.SP) and the Calendar table (DAY) for each School Code to determine the expected Enrollment Date,
Security ↑
To access the functions on the CALPADS Extracts page, the user must have one of the following:
- Only Admin users
- Users with the Administer function to State Reporting Program Area
Steps
Other Options tab ↑
- If processing records before rolling over to the new year (i.e., in the current year database), and if records for Pre-Enrolled students (STU.TG=*) have been created, ensure that * - Pre-Enrolled for next year is unselected under STU.TG values to skip.
Code Translations tab ↑
- Ensure the Code Set for Language Fluency (STU.LF) has a value mapped to the CALPADS code for To Be Determined (TBD) for the SELA extract. The translated value is used to determine which students are included in the SELA extract.
Schools tab ↑
Ensure only schools that will have students enrolled next year are selected, which will be determined according to the student Next School value.
Information Section ↑
On this page, in addition to the KEEP/SKIP flag, there are several pieces of information displayed that should be reviewed before using this process, as it will affect which students are extracted. This is why it is very important that the values in the student fields listed is correct, as well as the settings for the individual schools.
- Schools with ATT Initialized - Displays a list of schools where Attendance has ALREADY been initialized (ATT Table has records). This will trigger the process to analyze the Next School, Next Grade, Next Special Program, and Next Year Start Date to determine which students to include based on their Next School value.
- Schools without Next Year Start Date- Displays a list of schools that do NOT have a date populated in the Next Year Start Date (LOC.NSD) field on School Options page. When processing the students above,, if there is NO Next Year Start Date the students will be extracted with an Expected Enrollment Date of 7/1 for that Next School value. This query will show a list of the default schools marked to be included in the CALPADS extracts with their Next Year Start Date: LIST LOC CD NM SNM LO HI NSD IF DNR = 0
- Schools without Calendar - displays a list of schools where there are NO records in the DAY table. When processing for schools where attendance has not yet been initialized, students assigned to these schools will NOT be extracted if their school does not have a Calendar yet created. See the Push and Pull Setup Tables documentation for more info.
- Number of Student records with Invalid Next School - Displays a total of students who have an invalid Next School code. These may be students with a Next School value of the district (0), or a value that matches a school that is tagged in the School Options Do Not Report field (LOC.DNR is checked). These students will NOT be extracted. You should review that students have the proper Next School value set before running this process at the end of the school year. This query will help you find students with no Next School value: LIST STU ID NM GR NG SC NS IF NS = 0
NOTE: It is highly recommended that a KEEP or SKIP query is utilized to isolate only those students who need to be tested during the summer. Otherwise, this process will include enrollments for ALL students meeting the criteria. An example KEEP query would be something like this, with your own local codes used where appropriate:
KEEP STU IF NG > -1 AND HL > 00 AND ( TG = " " OR TG = "*" ) AND ( LF = " " OR LF = "T" )
File Creation Buttons ↑
Once the appropriate students are isolated, the required files can be created. They are designed to be run in the sequence displayed on the page. All files created on this page will have the suffix of _ST to identify that they were created as part of the Summer Testing process.
Create SSID Request File (SENR) ↑
This process will create a SENR file designed to request SSID numbers for students who have a blank Stateside Student Identifier field (STU.CID). This file will have the upcoming academic year and appropriate Expected Enrollment Date.
- This is the first step in the process. The file will be generated with a suffix of SENR_SSID_ST.txt to identify that it was the SENR file designed to obtain SSID numbers.
- Upload this file to CALPADS, perform the matching/selecting process and post the selected SSIDs.
- Extract the SSID results file and load it into the Identifiers tab on this page, and update the appropriate student fields.
Create Student Enrollment File (SENR) ↑
This process will create a SENR file to add a new enrollment record for the upcoming academic year, with the appropriate Grade Level, School of Attendance, and Expected Enrollment Date.
- This is the second step in the process.
- Upload this file to CALPADS, and correct any errors that stop the file from being accepted.
- Once the SENR file has been accepted and posted, continue on to the next step.
Create SELA Extract for TBD Students ↑
This process will create a SELA file designed to add the appropriate English Language Acquisition Status Code of TBD. There is an ELAS Suggested Date field that defaults to the current day. CALPADS will not accept a future date to be extracted, so the expected Enrollment Date cannot be used. This date will be used as the ELAS Effective date.
- This is the final step in the process.
- Upload this file to CALPADS, and correct any errors that stop the file from being accepted.
- Make sure the SENR file has been accepted and fully posted.
As you can see in the info box below, there are specific criteria to determine which students are included in the SELA file, since this process is designed to facilitate the Summer ELPAC Testing.
NOTE: It will take a day or two before these records are pushed from CALPADS up to the TOMS Testing Engine to allow the student to be tested.
Troubleshooting ↑
If anticipated students are missing in the extract, review these data fields to be sure they are populated appropriately.
- Students missing from SSID Request file or Student Enrollment File:
- Check the Other Options tab and review the different values that are marked to be skipped. For example, if you are trying to get SSID numbers for Pre-Enrolled students, make sure the Status tag of *-Pre-Enrolled is NOT selected to be skipped.
- Students missing from SELA Extract for TBD Students:
- Check the students' Language Assessment page. If the student has a current ELAS code in CALPADS, it will not be included, because CALPADS does not allow another, matching SELA record to be uploaded, only a record that changes the existing status in CALPADS are allowed.
- If the student does not have a LAC record at all, they will NOT be included in the SELA extract. Generally all students have a LAC record created when their student record is created, but if it is missing, add the LAC record for the student first, and then try the extract again.