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%'


Review corresponding LTL records

Example:

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


Update corresponding LTL records 

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

Example:

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