The Code Translations tab is utilized to translate your Aeries code values (local codes) to CALPADS code values.   The following page will display.




TRANSLATION NOTES


  • If the Aeries Codes match the CALPADS Codes, the codes do not need to be translated and will not display on this page.
  • Certain values must be translated.  Language Fluency, Enrollment Status, Exit Reason, Parent Ed Level, Primary Residence Category and others should be verified before creating extracts.
  • Blank Aeries values can be translated to a CALPADS code. And Aeries code values can be translated to blanks.
  • Student Grade - STU.GR The 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 and less than 0.
  • The Add Default Translations button will add CALPADS translation values to the list of potential translations (this functionality was formally provided by the Update XRF button). 
  • The Add Local Codes button will add any existing local Aeries values for a a Code Set. The button is grayed out until a Code Set is selected from the dropdown.
    • Codes that are added to the code table but do not want extracted to CALPADS must be added and translated to a blank on the CALPADS side.


NOTE: Local codes that match the CALPADS codes do not need to be translated and do not need to display on the Code Translation tab. However, the values are available if you want to use them but it is not required. Certain values must be translated.


The Administrative Functions, Update USYSGCOD (Fixed codes) Table button can be run to ensure all fixed codes have been added to the CALPADS Code Translations.  For more information Administrative Functions




CODE TRANSLATION EXAMPLES


Below is an example of the Language Fluency Code Set.  Select Language Fluency from the dropdown. The Aeries Code dropdown on the left of the page will display codes in the COD table for the STU.LF field. The code value is only 1 character; therefore, they must be translated to the CALPADS codes.



Click the on the Add New Record button to add a record or click on the pencil (edit) icon to edit an existing record. Select the Aeries Code on the left that corresponds with the CALPADS Code on the right. 



Click on the Save icon.



Below is an example of the Enrollment Status Code Set. Select Enrollment Status from the dropdown. The Aeries Code dropdown on the left of the page will display codes in the COD table for the STU.SP field.  Then select the CALPADS Code dropdown on the right side of the page.



Below is an example of the Parent Ed Level (STU.PED). The Aeries Code dropdown on the left of the page will display codes in the COD table for the STU.PED field.  Select the Aeries Code on the left and the corresponding CALPADS Code on the right.



The Student Gender (STU.GN) field was recently added to the CALPADS Code Translations.  This will allow translating Non-binary gender codes in Aeries to the accepted CALPADS code of "X".