Issue

When attempting to sync the Student Education Organization Association entity, the system returns four failed records with the error: dateMet is required for TxStudentEducationOrganizationAssociationTruancySet and cannot be null. Additionally, the “Export to Excel” function provides no data. 

Cause

The students causing the error had the Truant? (STU.TRU) field marked as “Yes” and Date Met STU.TDM) field as null.

Resolution

Ran the query to exclude School 999 and include inactive students.

LIST STU SC ID NM TRU TDM IF TRU = "Y" AND TDM = NULL AND SC # 999

The query returned the four students causing the failed error.  The Truant? (STU.TRU) field was cleared for the identified students.