How to generate a list of students who received School Attendance Letters or District Attendance Letters


Query for a Specific Letter Set/Letter ID: 

LIST STU LTL STU.SC STU.ID STU.NM STU.GR LTL.ID LTL.PT LTL.DT LTL.CIS BY STU.NM LTL.ID LTL.DT IF LTL.DT > ##/##/#### AND LTL.ID : TRUANCY 

  • In place of ##/##/#### enter a date
  • After LTL.ID : Enter part of the title (no spaces) 


Query for all Letter Sets/Letter IDs:  

LIST STU LTL STU.SC STU.ID STU.NM STU.GR LTL.ID LTL.PT LTL.DT LTL.CIS BY STU.NM LTL.ID LTL.DT IF LTL.DT > ##/##/#### AND LTL.CIS = 1 

  • In place of ##/##/#### enter a date 


The Query results may be run to Report format