CALPADS is scheduled to implement new 3-character Language codes on 09/19/2023. Aeries will automatically map the old CALPADS codes to the new 3-character codes as of 09/19/2023 upon loading the CALPADS Extracts. New codes will display in the CALPADS Extracts > Code Translations > Code Set: Languages (STU.HL). Only codes that are currently mapped will be re-mapped to the 3-character Language code and will display in the XRF Languages Code Set (excluding custom codes or unmapped codes). The new 3-character Language code will be used in the CALPADS SELA extract. LEAs will continue to use the STU.HL field as-is and will only see the changes in the SELA Extract file.
See New CALPADS Language codes for a full listing of all 3-character Language codes.
Mapping Existing Codes ↑
On the Enrollment Update tab, under SENR, an effective date for SY 2023-24 was added to be used as a trigger date for implementing the required CALPADS 2023-24 changes. The date will default to 09/19/2023 and will be used to trigger the following:
- SINF-Extract Parent Ed Levels from CON for both Parent/Guardian1 and Parent/Guardian2.
- SELA-Extract the new 3 character language codes
- SENR-Extract the Graduation Exemption indicator value (used for the current 9th grade students-class of 2026-2027)
On or after the Effective date, upon loading the CALPADS Extracts > Code Translations for STU.HL, the conversion will begin and all existing 2 character codes will be re-mapped to the 3-character Language codes (excluding custom codes). It is not recommended to update this date unless CALPADS changes the release date for these 2023-24 changes (Parent Ed Level, 3-character Language codes and Graduation Exemption Indicator).
After the conversion, the list will display with the 3 character code as shown below.
Adding new Language Codes to COD table and XRF translations ↑
Additional language codes can be added to Aeries that can be mapped to the CALPADS 3-character
Language codes. The 2-character Language code must first be added to the COD table page for the Reporting Language (STU.HL) field, then added to the CALPADS Extracts > Code Set: Languages to be mapped to the 3 character code.
STU.HL is an alpha-numeric field and can contain many 2 digits codes. Users will continue to use STU.HL as a 2-digit field. It is recommended that codes start with C1-C9, D1-D9, etc. Codes can also be populated with CA, CB, CC, etc. if needed.
The Code Translation > Code Set: Languages (STU.HL) will display with all newly mapped 3-character Language codes. The new code list has over 400 + languages. It is only necessary to map the codes that are being used.
Custom codes will not be automatically mapped and must be translated by the user.
On 9/19/2023, when all codes have been automatically mapped, it is important to review all Languages to ensure all codes are mapped appropriately. If a language code needs to be mapped, select the edit icon next to the Language on the left side, then select the appropriate 3-character Language code from the drop-down on the right side. Select SAVE to save the record mapping.
|Code Table (COD)||Read|
Add new record
Beginning with the Aeries Update released 9/15/2023, a DPT record will be added with a date of 09/19/2023 that will be used as the trigger for extracting the new 3 character language code in the SELA extract.
|DPT.NM||CLPD_LANGUAGE_CODES_CHANGES_STARTDATE||DPT record that is used to trigger the CALPADS 2023-24 changes (Parent Ed Level, 3 character Language codes and Graduation Exemption Indicator).|
|DPT.CD||MM/DD/YYYY = 09/19/2023||The trigger date field used to generate the SELA extract along with the SENR (STU.GEX) and SINF (Parent/Guardian 2 Parent Ed Level)|
NOTE: All existing mapped Language Codes will be remapped to the 3-character Language code, excluding custom codes. STU.HL will continue to be used as a 2-character Language code in Aeries and will extract into CALPADS extract files as a 3-character Language code. Due to this change, it is important to review all Languages to ensure all codes are mapped appropriately.