How do we correct fatal errors due to data entry errors submitted through the SINF extract?

The Log Details (LGD) page in Aeries can be used to remove or edit data that is used for the SINF file.   



The CALPADS Log Details page allows users with permissions to modify the effective date or to delete records with bad data from the Log Details (LGD) table.  


On the Users, Security page, permissions to CALPADS Log Details needs to granted under the Other section.



The CALPADS Log Details page can also be used to adjust the Effective Date if the change needs to before Information Day for reporting purposes.  


Example: Student Data US School < 3 years field (SSD.SUS) was entered incorrectly and is being corrected after Information Day.  


User with permissions, can edit the record and adjust the Effective Date.



Changes to the following fields are logged in the Log Details (LGD) table and are used in the CALPADS SINF file.


Students Data (STU)

  • Names (LN, FN, MN, SF, LNA, FNA, MNA)
  • Address (AD, CY, ST, ZC, ZX)
  • Birth fields (BD, BCY, BST, BCU)
  • Gender (GN)
  • Ethnicity/Race(s) (ETH, RC1-RC5)
  • Parent Ed (PED)

Language Assessment (LAC)

  • US School Entry Date (USS)


Secondary Student Data (SSD)

  • US School < 3 Years (SUS)


Note:  Effective 2019/2020, the Student Information (SINF) extract has been adjusted 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. This will apply to the following absolute fields where data should not be changing for a student: 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).