School-based Attendance Letters do not generate for students who have enough absences to receive the next part in the letter set.

Cause

The letter ID in LET (LET.ID) contains a trailing space for subsequent letter parts

Resolution

Remove the trailing space from the Letter ID

Review records to identify trailing spaces

Example:

SELECT SC, '|' + ID + '|' ID, PT, HL, TY, NO, T1, T2, SL, SM, INV, CT, DEL, DTS
FROM LET WHERE ID LIKE '%DART%'

Update records with trailing spaces

Example:

UPDATE LET 
SET LET.ID = TRIM(LET.ID)
WHERE ID LIKE '%DART%'

SELECT PID, REPLACE(ID, '  ', ' ') ID, ID, DT, AM, NM, PD, CIS, SCL, TID, PT, DEL, DTS
FROM LTL WHERE ID LIKE 'DART__'

NOTE: LTL.ID contains LET.ID + LET.PT; a replace is used instead of TRIM

UPDATE LTL SET ID = REPLACE(ID, '  ', ' ')
FROM LTL WHERE ID LIKE 'DART___'