Eagle Software
Aeries Student Information System
Aeries Users' Conferences Aeries Users' Workshops

CALPADS FAQs

CALPADS Frequently Asked Questions (FAQs)

 
QWhen I submit data to CALPADS, I get errors about "invalid characters". What could be causing this?
AThere is a known bug in CALPADS that generates errors when the Parent/Guardian field in Aeries contains non-alpha characters like "/". Until CALPADS corrects this problem in their system, you need to open the SINF file using Notepad and replace all slash characters with blanks.
QWhen doing the ODS Audit process, I click on the "Evaluate Records and Create New SENR File" button. Then I get a message: "SENR File created. 0 Records Extracted". Why?
AYou probably selected the wrong File Delimiter when you imported the file. Change the selection and re-import the file. It might also be that you did not have any schools selected from the list on the right-hand side of the form. The ODS Audit process will only evaluate the schools selected.
QWhat do I put into the "STU.ED Use Date" field on the Create CALPADS Extracts form?
AStart first by reading the description of this field on the Help tab of the form. Here is also another way to explain the use of that field:

You need to first, figure out how good your ENR data is. Determine the date after which data in ENR is good. Put that date into the "STU.ED Use Date" field. Determining the "goodness" of your ENR table is not something that Aeries support can do for you. You need to do that on your own. You need to figure out how long you have been on Aeries and how long you have been updating your district database. If you have incomplete ENR data, you can go back into prior years, build the ENR data in that year and then use the form: "Pull ENR From Another Database" to copy it into the following school year. Continue to do that until you get to the current year. Then you have good ENR data going back to the school year you started with.
QHow do I import my SEIDs?
AIn the Aeries District software, open the Create CSIS Data Files form. There is a tab called "Load SEID" that can be used to import the SEID values into the Aeries Staff (STF) table.
QHow do I know if I need to perform the "Data Reconciliation" process?
AAll districts need to perform a "Data Reconciliation" when you start using CALPADS and should be done at least once every two months thereafter. Please refer to the "Getting Started with CALPADS" document: www.aeries.com/Support/downloads.asp?catid=886914049.
QWhich Reconciliation Approach should I use?
AAeries districts should use Approach #1. Aeries has a built-in reconciliation process called the ODS Audit. Refer to the Getting Started with CALPADS document for more information.
QWhat are the quick steps for performing the Reconciliation process.
AIn Aeries, this is called the "ODS Audit". The first step in the process is to go to CALPADS and get the file from them. Then you import the file into Aeries, let Aeries process the data and create a new file. Then take that new file and send it up to CALPADS to fix their data. You can find more detailed information in the "Getting Started With CALPADS" document here.
QDo I need to work from a "Snapshot" database?
ANO. Make a backup of your database(s) on Info Day and place it aside, just in case you need to come back to it. You shouldn't need this backup, but it doesn't hurt to have it. Continue to work out of you live database and extract data from your live database.
QDo I need to enter an NSLP Free and Reduced Start Date?
ANo. If you leave the Eligibility Start Date empty, Aeries will use the current enrollment range and school year to extract that information.
QWhat do I do if I did not do the End of Year Enrollment Update in CSIS?
AFirst check with CALPADS to find out what they will require. Because the Start Date values for last year's students will probably not match what Aeries thinks the Start Date should be, you need to be able to do a ODS Audit process for last year's students or you need to manually update that information in CALPADS. The only alternative is to do an Enrollment Update from Aeries and manually adjust the file to make sure the Start Dates match. But that process would probably be more cumbersome than just updating the records in CALPADS. The easiest way would be if the ODS Audit process could work against last year's data, but you need to verify that CALPADS will accept it in "batch" format.
QWhat is Reconciliation?
AIn Aeries, we call this process the “ODS Audit”. It will take data from CALPADS and compare it against the data in Aeries. It then creates a file to be submitted to CALPADS to correct the data in the CALPADS ODS. That way, subsequent enrollment update submissions will be more successful. See “Getting Started With CALPADS” documentation for steps to complete the process.
QDo I need to convert my existing Ethnicity information to the new Race and Ethnicity fields?
ANo. The CALPADS extract from Aeries will convert this information on the fly. But for certain reports in Aeries, you need to convert your existing data to the new fields. You can do this by using the Macro called: "Populate New Race and Ethnicity Fields."
QCan I do an Identifier Request without getting all the code translations and the STU.ED Use Date in?
ASomewhat. Code Value Translations and all options need to be populated before performing any CALPADS Extracts. But for new students, the "STU.ED Use Date" won't be a factor because for new students, their STU.ED date should be very recent and the ENR data for those students should be valid for this school year.
QCan you explain why both Student Enter Date (STU.ED) and Enrollment History (ENR) are used for reporting Student School Enter Date to CALPADS?
AStudent School Enrollment Start Date is the single most important value in CALPADS Reporting. If the system can't figure out when a student started attending a school, nothing else matters. That is why Aeries gives you the option of having either good ENR data or good STU.ED data and provides a threshold for determining when to use these two resources. Your ENR data should always be accurate for the current year because it is managed on the fly by Aeries. It is getting good data for prior years that can be difficult.
QHow do we manage the local mapping of our courses to the Course Group State codes as provided in the CALPADS code sets?
AOn the Course table in the bottom right you will see a CBEDS number field. That is the Course Group State field for CALPADS and the numbers are correct but many are listed that say “No Longer Used” because they were dropped. Also, you can use 6012 for courses you do NOT want to report and Aeries will know not to extract them.
QIs there any documentation to explain what the codes mean for MST.HQT, the Highly Qualified dropdown?
AYou can use the CALPADS Code Sets document and various NCLB documents to determine which value to use. You should also consult with the person in your district in charge of credentialing.
QWhat are the Deadlines for CALPADS?
AYou can find this information on the CALPADS Website: www.cde.ca.gov/CALPADS.
QDo I need to delete Classified staff from the STF Table and leave Certificated only?
ANo. As long as they do not have any STJ (Staff Job Assignments) records, they will not be extracted.
QFor Student Primary Residence Code (SSD.HMT) do I have to populate this field for every student?
AThis is a Required Field in CALPADS, but using the Code Value Translations tab on the Create CALPADS Extracts form, you can translate a Blank to "200" (Permanent Housing). This information is not analyzed by CALPADS until the end of the year, so by the end of the year, you do need to evaluate all of your students and populate actual values for the sake of accuracy.
QHow to set up security for site users who now need access to District for CALPADS access?
AYour schol level users should not need access to the district database because all information can be input from the school level. Eventually, Aeries will allow site-level users to create their own SSID Request files, but this will only be enabled after CALPADS stabilizes.
QI am trying to add new SSID #s received from CALPADS into Aeries and getting an error that this is not a valid CSIS number. Why am I getting this and how do I fix this?
ASSIDs assigned by CSIS used a different validation algorithm than is being used by CALPADS now. Eagle Software is working with CALPADS to determine their validation rules and will implement them into Aeries as soon as possible. Until then, you need to import the SSID results into the system using the batch method, or use the Query Change form to enter the value.
QIf we currently house our NSLP (Free and Reduced Meals) eligibility data in the FRM table at the school level, does the CALPADS extract look at the FRM table for data? Or do we need to move this data to the FAR table at the district level?
ACurrently the CALPADS extract only looks at the FAR table in the district database. This information is not currently be used by CALPADS. An option will be added to the extract form to pull this information from either the school level FRM table or the district level FAR table.
QI don't want to use code "F" and "R" for Free and Reduced Meals Eligibility. Can I use different codes?
ACurrently only the "F" and "R" codes are acceptable for CALPADS reporting. This might be translatable later as the extract system is enhanced.
QDo you know if there is a code for teacher assignments for grades 9-12 Special Ed self-contained? Also, where are Elementary course assignments now coded?
AThere is an Other Fields Tab on the TCH table....that is where you add a CBEDS code of 1000 to all Self-Contained Classes and the on the Instr. Strategy there is a flag for Sp Ed.
QWhat CBEDS Code should we use for "Lunch"?
AUse code "6012" and Aeries will automatically skip this course and not extract it.
QWhat do I do if I have a course section that falls into more than one Instructional Strategy and one of those is Special Education?
AFor the 09/10 reporting year, if you have a course section that falls into more than one Instructional Strategy and one of those strategies happens to be special education (special day class), then you should select special education. Special education should trump all other strategies. In future years we will revise the CALPADS specifications so that you can submit these independently. Additionally, if the choice comes down to choosing between the EL strategies and home and hospital strategies, then select Home and Hospital.
QWhat if the Instructional Strategy is English Learner?
AThe CALPADS English Learner Accountability Office decided that they did not want to establish a "ranking order" for the EL strategies, so please use the one code you feel is most appropriate for the 09/10 school year. This is a local call. CALPADS will amend their program for the 10/11 school year so that they can capture that multiple strategies are taught in one course section. In addition, if the choice comes down to choosing between the EL Strategies and Home and Hospital strategies, then select Home and Hospital.
QDo we have to report Infants in CALPADS?
ASchool Districts each make a local determination of whether to track infants or not. Once you start tracking a student, you will always need to track that student.
QDuring the ODS Audit/Reconciliation process, I import 2000 records into Aeries, but only 500 get extracted into the SENR file. Is this correct?
AYes. Only records that need to be changed are extracted into the SENR file you upload back to CALPADS.
QWhere do I find the ART (CSIS Academic Records Transfer) extract form in Aeries?
ARecords Transfer is still a CSIS function of the SRRTS systems. At the school level in Aeries, go to View All Forms, add filter, type in "CSIS", Open Create CSIS Data Files, "Create Records Transfer File" tab. Also, on our website under Support, Documents and Downloads, in the CSIS category, look for Records_Transfer_File_Layouts_K12_to_K12.pdf. This will give you K12-K12 Records Transfer Submission File Layouts.
QSpecial Ed enter date/ I have been putting in the date that student first received services in Special Education instead of the date they enrolled in my program. Do I need to change this?
ANo, you should enter the date of their initial IEP.
QIf the Race and Ethnicity for a student is "Intentionally Left Blank" do we have to create a code in the Code Table for this item or can we just leave it blank?
AEagle Software advises that you create a code in the Code Table for this so that you can make sure that the field is populated correctly. Leaving it blank makes it difficult to determine if the field was left blank intentionally or in error. But, blank values will be correctly extracted to CALPADS if they are there.
QWhat student grade levels need to be translated on the Code Value Translation tab in Aeries?
AThe extract from Aeries will automatically translate grade 0 to "KN" and will automatically add the leading zero to grades 1-9. You only need to enter translation values for grades higher than 12.
QDo I need to run the CBEDS Reports in Aeries?
ANo. CALPADS reporting is based completely off of student enrollment information. The old "Counted in CBEDS" flag no longer applies for CALPADS reporting. You can still run these reports for your own information, but these reports will be changing soon to reflect how CALPADS breaks down students during Fall 1 Aggregations. When these reports are adjusted, they will also use student enrollment data to determine which students were enrolled on Information Day.
QWhat Date Range should I use when creating the ODS Extract in CALPADS?
AThe Start Date you should use should be "7/1/2003". It is important to use a date that encompasses all the enrollment information that CALPADS has on your students. Otherwise, you will end up getting errors in CALPADS about Overlapping Enrollments.
QHow do I generate the extract from CALPADS for the Reconciliation/ODS Audit process?
AGo into the CALPADS website. Then navigate to: Reports > Extracts > ODS Extracts. Select the "SSID Enrollment ODS Download". DO NOT use the "SSID Enrollment –Data Reconciliation", even though CALPADS instructions may tell you to. Choose a Start Date of "7/1/2003". Here is a screen shot:
QHow do I handle my Graduates and Matriculating students in last year?
AIf you didn't update these students with End Of Year and Graduation Status values last year and submit these students to CSIS, you need to now go back into last year and populate the Grad Status (STU.HSG) and the Date Graduated (STU.DG) fields. You do not have to populate End Of Year (STU.EOY) values unless you want to. Aeries will automatically extract the correct Exit Reason for students with the STU.HSG field populated. Then you need to complete the Reconciliation / ODS Audit process in last year to report these students to CALPADS.
QWhen I import the CALPADS ODS Download file into Aeries for the ODS Audit process, it tells me that some record were removed because of unmatched SSIDs? Is this something I should be concerned with?
ANo - do not worry. The CALPADS ODS Download file often contains students who are no longer in your district. This is perfectly normal. The message is simply letting you know how many records the system found in the file and how many will be evaluated by the ODS Audit process. There is nothing you need to do to fix anything. This is all normal.
QWhich Exit Code should I use when exiting a student from a "Secondary Enrollment?"
ACALPADS recommends using code "400 - Other".
QCommon Error: GERR001 - Required Field Missing
AReason:
You didn't populate required information
Resolution:
Populate the required data fields in Aeries. Sometimes the field identified by this error is conditionally required and the field driving the current field's requirement might be incorrectly populated. Consult the CFS if this one gives you trouble.
QCommon Error: GERR002 - Value Not Found in Reference Set
AReason:
You didn't translate your codes correctly.
Resolution:
Use the Code Value Translations tab to account for EVERY code used by Aeries. If the error is occurring because of values that are not in the COD table, use the Update Code Table form or Query to identify all the values in the Aeries field. You can then either adjust the values, adjust the codes, or translate the invalid values.
QCommon Error: GERR005 - Student not owned by LEA or School
AReason:
Enrollment Record for this student was not posted to CALPADS.
Resolution:
Do not submit SINF files until your SENR file has been posted without any errors (or with very few errors). If this student was the student with an SENR error then that is the problem. It could also be that you uploaded the SINF file before the SENR file posted. You should wait 1 to 2 days AFTER you post the SENR file to upload the SINF file. And then you should wait 1 to 2 days after the SINF file posted to upload the SPRG file.
QCommon Error: SENR0001 - Invalid Submitter
AReason:
CDS codes in LOC are wrong.
Resolution:
Use the School Options form to verify and adjust your CDS codes.
QCommon Error: SENR0004 - Missing NPS School
AReason:
The CSE table is not populated with the "School Code" of the NPS school the student is attending.
Resolution:
Populate the "School Code" (CSE.SS) field on the Special Ed form with the NPS school the student is attending. If the student is no longer attending an NPS school, you still need to have the NPS school populated in CSE. This may be changed in the future to store the NPS school code in the ATT and ENR tables.
QCommon Error: SENR0009 - Invalid Characters in Field
AReason:
CALPADS is resticting the characters in the current field.
Resolution:
This normally happens with the Parent-Guardian Name (STU.PG) field. Remove non-alpha characters from this field and re-extract.
QCommon Error: SENR0015 - Missing Exit Date
AReason:
There could be many causes for this issue.
Resolution:
Check the school and district calendars for invalid or incorrect dates. Check to make sure you haven't translated a Blank Exit Reason or Completion Status to something. Make sure the student doesn't have an HSG or EOY value populated. You may also need to "Fix ENR" from AdminCS or re-update your Access district database.
QCommon Error: SENR0018 - School Exit Date Less Than School Start Date
AReason:
There could be many causes for this issue.
Resolution:
Check the school and district calendars for invalid or incorrect dates. Check to make sure you haven't translated a Blank Exit Reason or Completion Status to something. Make sure the student doesn't have an HSG or EOY value populated. And of course check the student leave date and graduation date fields for correct values. You may also need to "Fix ENR" from AdminCS or re-update your Access district database.
QCommon Error: SENR0019 - School Exit Date Greater Than Current Date plus 30 days
AReason:
There could be many causes for this issue.
Resolution:
Check the school and district calendars for invalid or incorrect dates. Check to make sure you haven't translated a Blank Exit Reason or Completion Status to something. Make sure the student doesn't have an HSG or EOY value populated. And of course check the student leave date and graduation date fields for correct values. You may also need to "Fix ENR" from AdminCS or re-update your Access district database.
QCommon Error: SENR0021 - Duplicate records with status of Graduate
AReason:
You have a graduate who returned.
Resolution:
Aeries does not support assigning a "Completer Code" to a particular enrollment record. If a student "Graduates" and then returns to the same school in the same year, you need to remove the Graduation Status and Graduation Dates values and enter that information in the Transcript Comment area. When the student finally completes the school year and leaves permanently, you may re-enter the Grad Status and Grad Date.
QCommon Error: SENR0022 - Invalid Exit Reason and Completion Status Combination
AReason:
Bad EOY value.
Resolution:
Check the EOY or last Exit Reason for the student and make sure it is "230" for any student with a Grad Status value.
QCommon Error: SENR0024 - Reenrolling Graduate within LEA
AReason:
See SENR0021
Resolution:
See SENR0021
QCommon Error: SENR0027 - Multiple Primary Enrollments within LEA
AReason:
CALPADS still thinks there is another Primary Enrollment for this student at the same time as the record you are sending.
Resolution:
First, this error may be caused by a different SENR record in the file getting a fatal error. So you should only worry about this error if there are no other errors in the file. But if you have gotten that far, make sure you completed the Reconciliation for 08-09. That means you have gone through the ODS Audit as well as the Enrollment Update for 08-09. You should also double-check your Enrollment Status code value translations. You need to translate any "Secondary Enrollment Codes" correctly.
QCommon Error: SENR0030 - Missing Expected Receiver School of Attendance
AReason:
Incorrectly populated data.
Resolution:
Check the attendance and enrollment history and make sure that the student has a correct Exit Reason and populate a Next School if necessary. You need to also make sure that the Next School chosen has a full 14-digit CDS code populated in the CHI table.
QCommon Error: SENR0031 - Missing Met UC CSU Indicator
AReason:
Missing data.
Resolution:
Run the "Update College Entrance Requirements" Macro.
QCommon Error: SENR0038 - Overlapping enrollment - Start Date or Exit Date between existing closed enrollment
AReason:
See SENR0027
Resolution:
See SENR0027
QCommon Error: SENR0039 - Overlapping Enrollment - Start Date or Exit Date after existing open enrollment
AReason:
See SENR0027
Resolution:
See SENR0027
QCommon Error: SENR0041 - Overlapping enrollment - Start date between Start and Exit date of existing closed enrollment within LEA
AReason:
See SENR0027
Resolution:
See SENR0027
QCommon Error: SENR0042 - Overlapping enrollment - Start date between Start and Exit date of existing closed enrollment within CALPADS
AReason:
See SENR0027
Resolution:
See SENR0027
QCommon Error: SENR0044 - Multiple Primary Enrollments - Invalid Start Date
AReason:
See SENR0027
Resolution:
See SENR0027
QCommon Error: SENR0045 - Invalid LEA
AReason:
Bad CDS code in Aeries.
Resolution:
Check your LOC and CHI tables for full 14-digit CDS codes on all appropriate records.
QCommon Error: SINF0056 - Missing Student Proficient or Advanced for ELA Code
AReason:
LAC.ELP field is blank.
Resolution:
This field is required for RFEP students. Either manually populate this field for your students or run the "Update English Language Proficiency (LAC ELP)" Macro and then verify students marked with an "N".
QCommon Error: SINF0058 - Missing Student Initial US School Enrollment Date
AReason:
LAC.USS is blank.
Resolution:
Students born outside the US and Puerto Rico must have the US School Entry date populated.
QCommon Error: SINF0061 - Missing Enrolled in US School less than Three Cumulative Years Indicator
AReason:
SSD.SUS is blank.
Resolution:
Students born outside the US and Puerto Rico must have this field populated. You must populate this information by hand or use a Query to look at students where the LAC.USS value is less than 3 years ago and populate those students with a "Y". "Y" means that the student has been enrolled in US schools for LESS THAN 3 years cumulatively. "N" means the student has been enrolled in US schools for MORE THAN 3 years cumulatively. An "N" can not be determined in mass because of potential gaps in enrollment since the US School Entry Date.
QCommon Error: SINF0066 - Effective End Date less than Effective Start Date
AReason:
Incorrect data in Aeries.
Resolution:
Check enrollment data for the student. Check the school and district calendar for incorrect dates in ANY month.
QCommon Error: SINF0068 - Mismatch of SSID Demographics for Student Information Update
AReason:
Student Data being sent to CALPADS doesn't match what CALPADS already has.
Resolution:
There is a known CALPADS issue with this, although it can happen if students change names or if you correct a Gender or Birth Date. This is also known to happen for students with non-alpha-numeric characters in the name fields.
QCommon Error: SINF0165 - Missing English Language Acquisition Status Code
AReason:
Missing data in Aeries.
Resolution:
EL students need to have the Start Date on the Language Assessment screen populated. IFEP students need to have "IFEP Date" populated and RFEP students need to have "Redesignation Date" populated.
QCommon Error: SINF0166 - Missing Student Initial Ninth Grade Entry Year
AReason:
Missing STU.INE value.
Resolution:
All students in grades 9 and above need to have the STU.INE field populated. You can do this in mass using Query and then make adjustments for any student who was held back.
QCommon Error: SPRG0071 - Student not enrolled during Program Membership Date Range specified
AReason:
See GERR005
Resolution:
See GERR005
QCommon Error: SPRG0079 - Invalid Primary Residence Category
AReason:
Missing SSD.HMT
Resolution:
Students who were part of the Homeless program for ANY time during the school year need to continue to have the "Home Type" (SSD.HMT) field populated with the homeless dwelling type through the end of the school year. You also need to post the SINF file with that information, then wait 1 to 2 days to upload the SPRG file.
QCommon Error: SPRG0081 - Missing Education Service Code
AReason:
Missing Title 1 Services
Resolution:
Code 122 (NCLB Title 1 Part A Basic Targeted) need to have Services (PGM.SR) populated on the PGM record.
QCommon Error: SPRG0082 - Invalid Education Service Code
AReason:
An invalid code is getting through to CALPADS.
Resolution:
Make sure you translate all of your non-CALPADS Service Codes to a blank. This includes all the old CSIS codes.
QCommon Error: SPRG0083 - Missing California Partnership Academy ID
AReason:
Missing PGM.CPA
Resolution:
Code 113 requires that you populate the CA Partnership ID in the PGM record.
QCommon Error: SPRG0084 - Missing Migrant Student ID
AReason:
Missing SSD.MID
Resolution:
Any student in the Migrant program (code 135) at any time during the current school year needs to have the "Migrant ID" (SSD.MID) field populated with what the state calls, the "MSD Number."
QCommon Error: SPRG0085 - Missing Primary Disability Code
AReason:
Missing CSE.DI
Resolution:
Any student in the Special Ed program during any part of the year must have the Disability (CSE.DI) field populated through the end of the school year.
QCommon Error: SPRG0087 - Missing District of Special Education Accountability
AReason:
Missing CSE.DR
Resolution:
Any student in the Special Ed program during any part of the year must have the "District" (CSE.DR) field populated through the end of the school year.
QCommon Error: CERT003 - Missing Effective Current Year Grade Level between 7/1 and Census Day for Student
AFirst and foremost, do not worry about ANY CERT errors until you can post SENR, SINF, and SPRG files consistently with few to no errors. Data that was not posted due to errors in those files are the probable cause to almost all CERT errors. The 2nd most likely cause of all of these errors is data not populated in Aeries.
Reason:
SENR and SINF records were not completely posted.
Resolution:
Perform a full year Enrollment Update and make sure that you have no errors and that all records post. It has been seen in the past that some records posted to CALPADS do not actually post to the CALPADS ODS.
QCommon Error: CERT015 - No Graduates from previous Year's Grade 12 Enrollment
AFirst and foremost, do not worry about ANY CERT errors until you can post SENR, SINF, and SPRG files consistently with few to no errors. Data that was not posted due to errors in those files are the probable cause to almost all CERT errors. The 2nd most likely cause of all of these errors is data not populated in Aeries.
Reason:
Missing Graduate information from last year.
Resolution:
Start the Reconciliation Process over from the start. Begin with 08-09 ODS Audit, then 08-09 EU, thn 09-10 ODS Audit, then 09-10 EU.
QCommon Error: CERT041 - Duplicate Open Enrollments
AFirst and foremost, do not worry about ANY CERT errors until you can post SENR, SINF, and SPRG files consistently with few to no errors. Data that was not posted due to errors in those files are the probable cause to almost all CERT errors. The 2nd most likely cause of all of these errors is data not populated in Aeries.
Reason:
Enrollment Updates did not fully post.
Resolution:
Depending on how extensive this situation is, you may be able to just go through the normal EU process again, but if this error is extensive, you may need to start the Reconciliation process again. See major note above.
QHow do I create the CALPADS Spring 1 submission files?
AIn the Aeries District software, open the Create CALPADS Extracts form. On the Enrollment Update tab, use the Create Enrollment Update Files to create the SENR and SINF files. CALPADS is collecting data for English Learner and Immigrant counts as of the Spring Census Day of March 1st, 2011.