The SINF is rejected by CALPADS. Is that an associated problem?
"Record Number: 1. Error Detail: Expected columns are: 44. Included columns are 42. Error Row is
The file layout changes that CALPADS implemented today for SENR and SINF are being released tonight. The issue noted here is separate from those changes.
More characters than 2 had to be deleted for the SENR. it said looking for something like 34 and there were 39
SINF file had two new fields added.
SENR file had one field re-named and 5 fields removed.
Yes, I was able to get the file uploaded by removing carats at the end. There were only 370 records and few were inter, so it was easy to do once I figured out how many carats to remove.
After I installed the most recent patch, the SENR worked just fine, but now when we try to re-import the SSID's from the CLAPADS extract, the system is not recognizing the records. Has anyone else mentioned this issue? We had 8 records that came in the SENR extract, and when we tried to re-import them, the system is reporting 0 records.
I am having the same issue. Did you do the update from last night, Tamara, and it still does not work?
Judy, yes, I installed the latest revision this morning and still having the issue.
The update that was released on 9/15/2020 made adjustments to the SENR and SINF files created in Aeries to accommodate the changes CALPADS released on that date. Those files are different than the SENR file that is extracted FROM CALPADS as part of the Identifier assignment process. A new field was also added to that file yesterday which is causing a separate issue.
The behavior you are reporting is exactly what this Known Issue under the Identifiers section is about. We are making adjustment to the SSID Upload process to accommodate this new field that CALPADS added yesterday. As soon as it passes QC testing, it will be released as a Hot-Fix. Click on the link above to add yourself to the AeriesIdeas Bug Item and you will be notified directly when action is taken on this specific item.
Perfect! Thank you!
Need clarification, am I just deleting the last indicator of "Y" or "N" in the txt file?
Emilee, I've added a screenshot to make it clear what needs to be removed. It would be the Y/N and also the carat preceding that letter.
Thank you for this info, Jan! I had the same problem with my SSID extract that I tried to load into Aeries today. I found it fairly easy to copy and paste the entire file from CALPADS into Excel, do text to columns as carat delimited, make every column "Text", delete the last column, then save as Tab-delimited .txt file, which Aeries accepted and loaded.
I just found a new issue that hopefully is already on your radar, but the E450 code is no longer acceptable for grades TK-6 (found in Valid Code Combos). Would it be possible to change the option, "Do Not Change Exit Reasons to E450 if Student is in Grade 6 or Lower" in "Other Options" to either no longer be valid, or only be valid for grade levels PS, IN, and TD? I'm hoping this change is already coming with the SENR format changes, but it did surprise me when I uploaded a new SSID Request today after I deleted the last 5 columns and all TK-6 students with an E450 failed. Thanks!
The following open issues have been identified with the CALPADS Submission process. We are updating this list as items are added and/or resolved. We apologize for the inconvenience and are working as quickly as possible to amend our extraction process.
CONFIRMED: LTEL file import process needs to be updated** --Fixed in the 11/09/21 update
We had received several tickets indicating the LTEL file that the CDE just released is not able to be imported into Aeries. After researching this, and getting access to the actual files released by the CDE, we confirmed that the file TYPE had changed for the .txt file. The CDE apparently changed it from fixed-width file type to a tab-delimited file-type. We were NOT informed of this change in advance, but are making changes to our import process to allow it to consume this file type appropriately. We intend to release this fix as soon as possible. We created an Aeries Idea item to track this item. Anyone who would like a personal message when the item is resolved, please add yourself to the following AeriesIdeas Item:
CALPADS - SDEM extract in EOY not handling Multiple Teacher flag properly **Fixed in the 7/9/21 update.
Staff Demographics (SDEM) extract is improperly excluding some teachers with the MTS flagged as 09. This is a hot item and will be released as soon as it passes QC testing. Also, we are adding back the list of files extracted by each button on the EOY tab.
CALPADS SINF Extract gets stuck in certain circumstances, never completes **Fixed in the 7/9/21 update
When students have a Home Reporting school (STU.HS) that is marked as Do Not Report (LOC.DNR) the file extraction process gets stuck and never completes. The only workaround is to remove the DNR tab from School Options for that school, but make sure that school is NOT selected on the Schools tab for CALPADS Extracts.
CALPADS EOY Extracts not working for non-flex schools using Section Staff **Fixed in the 7/7/21 Update
Schools who are not using Flexible Scheduling but are using section staff may not extract correctly for EOY Course and Staff files. This is a hot item and will be released as soon as it passes QC testing.
New SSID Import File **Fixed in the 6/22/21 Update
Please see this document for more information: CALPADS Extracts - Identifier Tab
Can't Import new SSIDs because of unrecognized data:
New SSID Extract files from CALPADS now include new data at the end of the file, and cannot be imported. Vendors were informed today (6/10/21) in the bi-weekly Vendor Call that they changed the New SSID file to include the Earliest CALPADS School Enrollment Date K-12 without informing us first so we could amend our import routines. We are working on this ASAP and will release a fix as soon as possible.
SCSC Extract for Middle School Transcript Records **Fixed in the 6/17/2021 update
SCSC Extract for Middle School (grades 7 and 8) Transcript Records with Credits Attempted = 0 are not extracting at this time. High School students (grades 9 to 12) with Credits Attempted = 0 are extracting correctly but Middle School students (grade 7 and 8) should be extracting also.
SENR - Improperly changing E450 Exit Codes for Preschool students with Non-ADA Enrollments **Fixed in the 6/8/21 Out-Of-Band Update
Confirmed as an issue for PS students with enrollment Status of 50 (Non-ADA enrollment). If they have an E450 exit (appropriate for PS students) the SENR extract is changing them to E170. That is correct for most Non-ADA Enrollments and Secondary Enrollments, but NOT for Preschool students. CALPADS rejects records for PS students with Non-ADA Enrollments.
WBLR - Records not extracted if GR=14 **Fixed in the 6/8/21 Out-Of-Band Update
Work-Based Learning Records for Transition students are not included in the WBLR extract if they are outside the grade range of 9-12. WBLR records should extract for all Student Grade Levels translated for CALPAD to grades 9-12 (so it would include transition students w/GR=14)
WBLR - Duplicate Records Rejected **Fixed in the 6/8/21 Out-Of-Band Update
In certain circumstances, duplicate WBLR records are being extracted. This is happening for students with ISP records who have multiple STU records (i.e. inactive record at another school, or a concurrent record at another school). The extract process is duplicating the WBLR records, which are being rejected by CALPADS when uploaded.
STAS file failing when codes are exempted in STU.SP **Fixed in the 6/8/21 Out-Of-Band Update
When exempting codes from STU.SP for STAS extract, the file is failing due to decimal rounding of data.
SENR: File to obtain new SSID Identifiers includes an E155 Exit Code when created within the last 2 weeks of school ** Resolved 5/29/21
When requesting new SSID Identifiers for new students, if a school's Calendar ends within the next 14 days, an E155 Exit Code is included in the extracted file. Normally this is not an issue, however when that school is taking advantage of the Extended CAASPP/ELAPC Testing Window for 20-21 and these new students need to be tested in the TOMS system, those enrollment records will contain a future exit date. An option to Not Extract Future Dates is needed here, similar to the one offered on the Enrollment Update tab.
In order to provide more flexibility to our customers, we are programming to make further changes to this process: **Fixed in the 2/19/21 Out-Of-Band Update
Staff extract was extracting staff with Hire dates up to October 31. **Fixed in the 2/19/21 Out-Of-Band Update
A new setting was added under Other Options to force Parent/Guardian information (SINF/SIAD) to be extracted exclusively from STU.PG and STU.PED. The option is deselected by default. See CALPADS Extracts - Other Options Tab
The Parent/Guardian Highest Education Level will always be pulled from STU.PED, even when processing Guardian information from the CON table. This will remain in place until CALPADS changes the SINF file layout in preparation for 22-23.
The Staff Demographics (SDEM)/Staff Assignments (SASS) extracts were adjusted to evaluate the staff hire date against Information Day, instead of October 31st as was required before. Also will evaluate the Assignment Start Date against Information Day.
CRSE Extract does not seem to be working properly for Itinerant Teachers **Fixed in the 2/12/21 update
We are investigating an issue that has been discovered stopping the CRSE Extract from including Itinerant Teachers even though the Itinerant field is populated with a Y. Programming is aware of the issue and is currently working on a fix. We will update this post once a fix is identified.
Upload Failed - File length Exceeded: **Fixed in the 2/12/21 update
This is generally occurring when the Multi-Teacher Status field is extracting 09 (No Multi-Teacher Status) because that field is only allowed to be 1 character. We will be changing the CRSE/CRSC extracts to ignore any records with the TCH.MTS/MST.MTS field value of 09.
CRSE Extract not working properly for Itinerant Teachers or Section Staff marked as NO State Reporting **Fixed in the 1/15 update
The CRSE Extract is not including Itinerant Teachers even though Itinerant is populated in MST.IT or TCH.IT. Programming is aware of the issue and is currently working on a fix. We will update this post once a fix is released.
The following Aeries Idea has also been created to keep users updated. https://ideas.aeries.com/forums/926386/suggestions/42420502
SSID Import fails with new CALPADS SpEd Indicator **Fixed in the 9/17 hot-fix
CALPADS added a new field to the SSID Extract file to hold a Special Education indicator as of 9/15/2020. We are adjusting our import process to handle this new indicator in a similar fashion as the English Language Acquisition Code and Date in the SSID Extract.
SENR0023 - Invalid Exit Reason and Grade Level Combination: **Fixed in the 9/17 hot-fix
SENR upload fails with this fatal error if Exit Code 450 is used with a grade level greater than Preschool.
CALPADS recently added a validation rule for this combination and made it a fatal error. We are working on making changes to the Option to replace other exit codes with 450.
The changes to the SINF process were included in the Update that was released 02/12/21.
Here are several links that should be helpful:
There are several changes to various areas of Aeries that this change CALPADS is making will require. I have linked AeriesIdeas items to each of them. Customers who add themselves to any of these items will be notified personally as action is taken on them.
SINF0551 - WARNING - Missing Guardian 1 First Name: **Partially fixed in the 2/12/21 update
CALPADS has added validations to prepare for the upcoming changes to the Parent/Guardian information, including separating First and Last Names for the Guardian(s). It is perfectly fine to ignore these warnings for this school year, but districts should attempt to make sure the CON records have First Name and Last Name fields populated.
SINF0010/SINF0011 - Missing Alias First Name/Missing Alias Last Name: **Fixed in the 9/18 hot-fix
SINF Upload rejects reccords when only 1 Alias Name field populated
We have identified this as an unintended consequence of the changes released on 9/15/2020 to add Preferred Names to the SINF extract. Development has already started on the fix and we will ship it as soon as it passes QC testing.
SENR Reconciliation Process:
SENR file- Upload Failed **Fixed in the 9/29 release
SENR file upload fails for a file created as part of the SENR Reconciliation Process. The process is still using the old SENR file layout, that changed as of 9/15. The process will be changed to use the new layout. (*Item added 9/21/20)
6 people like this