Process for Uploading SENR and SPRG Files
SINF - Parent/Guardian Contact and Parent Ed Level Data
Full Extracts - Create Legacy Files
Other Information Related to Extracts
Do Not Extract Dates in the Future
NOTE: Due to the changes CALPADS launched in their new environment, we were notified that we need to make immediate adjustments to several CALPADS Extracts. This documentation outlines the changes made and the steps needed moving forward for extracting Enrollment Update files and importing files into CALPADS as of 08/25/2022.
CALPADS released Update Flash #224 with the details of the required file changes.
For information about the Post Redesign changes. See Post Redesign Changes.
The Enrollment Update tab has been updated with new vertical tabs for the SENR (Student Enrollment), SINF (Student Information), SPRG (Student Programs) and SELA (Student English Language Acquisition) extract files to submit to CALPADS. These files are used for Fall 1, Fall 2 and EOY submissions. All functions related to those specific extracts have been moved to these vertical tabs.
The SENR (Student Enrollment) and SPRG (Student Programs) extracts have been adjusted to use the new CALPADS History (XRP table). When an SENR or SPRG extract is generated, the data is now saved in Aeries in the CALPADS History (XRP table), and the user can indicate that the file successfully posted to CALPADS. Aeries will then take those changes into account when generating subsequent extract files. When a new ODS extract for a particular process (SENR, SPRG) is processed, the CALPADS History will start over again from the beginning, with the latest ODS Extract.
This new process will ensure the SENR (Student Enrollment) and SPRG (Student Programs) changes made from the last successful submission to CALPADS will be included in the new extract files. Consequently, the files will be much smaller than before.
When running the process in the current year database, at the beginning of the school year, the previous year’s enrollment must be closed out.
NOTE: Due to the CALPADS Post Process Redevelopment Project, we were required to adjust our extracts and split up exits and new enrollments into separate files. Submit and post the file that includes Exits first, followed by the file that includes new enrollments. Per CALPADS Flash #224.
The Enrollment Update page will be the primary function used for creating SENR, SINF, SPRG and SELA files from the LEA's database which will be used to upload data changes into CALPADS.
The new CALPADS History table (XRP) will be used to store all SENR and SPRG ODS data imported from CALPADS. The data will remain in this table until a new ODS file is imported from CALPADS. At that point, the corresponding CALPADS History data will be wiped clean and new data will be stored. The page will indicate a timestamp of the last time an ODS file was imported. This will help to ensure that the CALPADS History table accurately reflects the current CALPADS data.
NOTE: If the user chooses to start the process over, a new CALPADS ODS file needs to be imported to establish a clean CALPADS History table in XRP. Starting the process over does not have any negative impacts on the import process and is recommended every couple months.
Process for Uploading SENR and SPRG Files ↑
Both SENR and SPRG tabs have been updated to use the new CALPADS History (XRP) table.
Ensure all schools that will be reported to CALPADS and included in the extract are selected appropriately in the Schools tab on the CALPADS Extracts page. These schools should match the schools being extracted from the ODS file in CALPADS. Verify all code translations are correct on the Code Translations tab.
The suggested order for uploading files is outlined below.
The first time the process is run, an ODS file needs to be extracted from CALPADS and used as the initial import into Aeries.
- In CALPADS:
- Navigate to Extracts > ODS Extracts > SSID Enrollment ODS Download
- Do not select the "Active Student" option, select the "DATE RANGE" option
- For SENR - Enter an Enrollment Start Date of July 1st that is 2 years prior to the current school year (i.e. 07/01/2020)
- For SPRG - Enter an Enrollment Start Date of July 1st that is 10 years prior to the current school year (i.e. 07/01/2012)
- Enter an Enrollment End Date of today.
- Select all schools that will be extracted from CALPADS that are reported by the LEA and maintained in the SIS.
- Download the file to a location on your hard-drive
In Aeries, on the CALPADS EXTRACTS page, select the appropriate vertical tab (SENR or SPRG) that will be used for the process. Extracts must be done in a particular order, starting with SENR. When an ODS file is being imported for the first time, the option Use CALPADS History is disabled.
If extracting a SENR file, click the Select SENR ODS Extract File button, then navigate to the location where the file is saved on the computer drive.
NOTE: When extracting a SPRG file, make sure you are on the SPRG vertical tab, click the Select SPRG ODS Extract File button, then navigate to the location of where the file is saved on the computer drive. The entire process is the same for both the SENR vertical tab and the SPRG vertical tab.
Once the file is selected, it will display under the button. Select the Load File, Evaluate, and Create New (SENR or SPRG) File(s) button. This process will return a zip file containing multiples files that are necessary for importing into CALPADS.
The File Download area will contain a zip file with two options.
- A file download button
- A shortcut to the CALPADS History (XRP) table
Download the zip file and extract each file contained within the zip file, saving each file to the local hard drive.
CALPADS History XRP ↑
Once the files have been created, the CALPADS History (XRP) page will now contain a transaction log of each record (extract) created and will be listed in the order in which the record will need to be posted. Each record will also be numbered with 001, 002, 003, etc.
There is an option on the top of the CALPADS History page for Show Everything. When this option is selected, all records from all previous and current extracts will display in the list that have been created since the ODS import date which is located on the SENR or SPRG tab.
To only display the list of processed records that are currently available to POST, uncheck the Show Everything option. In this example, the 002_EXITS file for SENR is available to POST.
Filters are available on CALPADS History tab for columns labeled Process and FileName. For example, a user can filter the Process column to limit the display to only SENR record transactions. The Process, File Name and Status columns can be sorted by selecting the header name of the column.
In CALPADS, upload each file in order starting with the file labeled with 001. Once all files have been posted successfully, log back into Aeries and post each record on the CALPADS History (XRP) page.
The files must be submitted and Posted in the correct order to be processed correctly by CALPADS:
On the CALPADS History (XRP) page, only the file labeled with 001 will be available with a POST button. If the file posted successfully in CALPADS, select the POST button in CALPADS History. When prompted with the confirmation message, select YES. The POST button will trigger the data in the XRP table related to this file record to have a flag that indicates the file has been applied.
As each file is posted successfully in CALPADS, each file must be posted on the CALPADS History (XRP) page. The POST button will be replaced with Posted on the Actions column for the record where the POST button was applied. The next available file will now be unlocked and display with a POST button. Repeat this process for each file as they were successfully imported into CALPADS until all files in the CALPADS History page have an Action of Posted.
NOTE: A process was needed for brand-new enrollments that have a change in the Enter Date. The only way to fix that enrollment record in CALPADS now is to delete the existing, incorrect record and upload a new record with the correct date. However, if there is only one SENR record for a student in CALPADS, their system will not allow you to delete that record. Therefore Aeries SENR ODS logic has been adjusted to update that enrollment record to a “No Show” enrollment (N470 exit code), then add a new record with the correct enrollment date.
Once all steps have been completed for uploading the SENR files, then proceed to importing the SPRG files. To avoid errors such as GERR0005 - LEA does not have ownership of student enrollment to make the update, be sure that all SENR records have a status of COMPLETE prior to importing SINF, SPRG or SELA records. Per CALPADS, the ODS files are a snapshot as of 10:00 p.m. the previous day. For the CALPADS processing schedule, see CALPADS Hours.
For detailed information on SENR ODS Extracts, see SENR ODS Extracts.
For detailed information on SPRG ODS Extracts, see SPRG ODS Extracts.
Rejected Files ↑
If a file loaded to CALPADS is rejected, the errors will need to be fixed in Aeries before a new set of files are created. Fix all errors from the file, then create a new batch of Extract files again in Aeries. If file 001-REMOVED has already been submitted and posted with no errors, but file 002-EXITS had errors, then after fixing the errors in Aeries, extract a new set of files. There may not be a file for REMOVED if no further changes have occurred and the first file may begin with EXITS and will be file #001. The user may have multiple records shown ready to POST.
- Upload file number 001. If the files passes, move on to file number 002.
- If the file fails, fix the errors in Aeries
- Go to the Enrollment Update tab in Aeries, with the Use CALPADS History option selected, select CREATE New SENR or SPRG files. (A newer set of files will display at the top.)
- Download ALL files locally and upload each file again into CALPADS making sure all files are posting successfully.
- On the CALPADS History page, select POST for the most recent file shown that matches the file submitted to CALPADS. As the most recent files are submitted, the status of the older set of files will change to Obsolete.
Maintaining EXTRACT Updates ↑
SENR, SINF, SPRG and SELA uploads should be generated regularly to ensure that student information is accurate in CALPADS. This new process, which includes the CALPADS History (XRP) table, will ensure only SENR (Student Enrollment) and SPRG (Student Programs) changes made from the last submission will be included in the new files. The process can be repeated as often as needed, however, it is recommended that it be run once every couple weeks. A new ODS file should be extracted once every couple months.
The next time the process is run after the initial upload of an ODS file, the option to Use CALPADS History must be selected and will default to "checked" when there is data in the CALPADS History (XRP) table. The CALPADS History table will be used as a temporary holding place to easily identify changes between CALPADS and Aeries without having to import a new ODS again each time extracts are run.
Run the processes regularly every couple weeks by following these steps:
- Select the option Use CALPADS History
- Select Create New (SENR or SPRG) File(s).
- Download the zip file and extract all files locally
- Submit and Post each file in CALPADS in order starting with 001, 002, 003, etc.
- If all files posted to CALPADS successfully, POST each matching file on the CALPADS History page starting with 001.
- If any file is rejected, fix the errors in Aeries then create a new set of files and repeat the process starting with the most recent batch of files.
- Repeat the process anytime changes in Aeries are made regularly every couple weeks as necessary.
SINF TAB ↑
The Create SINF Extract File button will extract various Student Demographic data required to be submitted for CALPADS.
When this option is de-selected, the regular SINF extract is generated and only students with changes that are logged in the CALPADS Log Details (LGD) table and the Address History (ADH) table will be extracted.
The option Extract SINF For All Students, when selected, will allow the creation of the SINF extract for ALL students. This option is available for districts that mass change data (ex: SQL or Aeries Queries) where the information doesn't write to LGD (CALPADS Log Details) or ADH (Address History) tables. The Extract SINF File for ALL Students button is optional and is not necessary to run for most districts.
To help prevent CALPADS errors when changes are made to specific fields, the SINF extract will ignore the date of the change from the CALPADS Log Details (LGD) table and instead use the student enrollment start date. The fields are: Student Birth Date (STU.BD), Student Birth City (STU.BCY), Student Birth State (STU.BST), Student Birth Country (STU.BCU), Student Ethnicity (STU.ETH), Student Race (STU.RC1-RC5), and US School Enter Date (LAC.USS).
SINF - Parent/Guardian Contact and Parent Ed Level Data ↑
When Extract SINF for All Students is de-selected:
- The Parent/Guardian Last Name and First Name will extract based on the CALPADS Extracts - Other Options tab settings.
- The Parent Ed level will pull from the LGD table for the STU.PED record.
- If multiple records exists in the LGD table for STU.PED, all records will be extracted.
- The effective date will display based on the date in LGD.
- If more than one record exists for the same date, only the highest Ed level will extract for that date.
When Extract SINF for All Students is selected:
- The extract will pull all of the same students based on the above criteria where students have an LGD record.
- Additionally, students with no LGD record will also get extracted.
- The extract will pull the Parent/Guardian Last Name and First Name according to the CALPADS Extracts - Other Options tab settings.
- For students with no LGD records for STU.PED, the Parent Ed Level will pull from STU.PED on Demographics page.
SELA TAB ↑
The CALPADS SELA file collects English Language Acquisition Status (ELAS) information that has changed from what was originally reported to CALPADS.
To accommodate this, an ODS import process has been added to Aeries to import student’s existing CALPADS English Language Acquisition Status (ELAS) information. The SELA ODS Import process will import CALPADS data into two Aeries Language fields. See SELA Import for more information.
Full Extracts - Create Legacy Files ↑
Legacy files can still be generated by selecting Create Legacy SENR Extract File from the SENR tab or by selecting the Create Legacy SPRG Extract File from the SPRG tab. These processes are not recommended since the file type requirements have changed in CALPADS and files with duplicate operational keys are included in these extracts which will cause IVR0034 errors.
Other Information Related to Extracts ↑
When running the process at the end of the school year (within 14 days of the last school day), the SENR ODS process will include the Exit codes of E155 and E156 exit codes to close out the enrollments. However, if testing is still going on, and you do NOT want exits reported yet, this process can be controlled by the deselecting that option on the Other Options tab. However, be sure to run another Enrollment Update after testing is complete to close out all enrollments as of the end of each school year.
Do Not Extract Dates in the Future ↑
This option has been added if students need to complete the CAASPP test (TOMS) within the last two weeks of the school year. This option will exclude exit reasons (ex: E155) and dependent info from the SENR file. Using this option will ensure the student is active in TOMS.
Related Documents ↑
For more information related to CALPADS extracts and ODS files, see:
SENR ODS Extracts (Archived)
CALPADS Extracts - Enrollment Update Tab (Archived)
Student Withdrawal Data Population Chart
Known Issue - CALPADS Extract Changes required.