Attendance Letter Merge Fields

The following fields are included in the Attendance merge file.

Merge Field	Information to Print
file_name	Name of the form letter file to use for this letter record.
student_id	ID number of the student.
student_name	Student's full name.
first_name	Student's first name.
middle_name	Student's middle name.
last_name	Student's last name.
report_cycle_date	First date in the report cycle for which letter was calculated.
trigger_date	Date on which attendance information triggered the letter. This is the date that the absences that fulfilled the criteria occurred on.
notify_criteria	Criteria number for which the letter record was created.
report_cycle_type	Code for the type of reporting cycle for which the criteria calculates.
send_letter	Indicates if letter was already sent to student and/or guardians.
parent_first_name	Guardian contact's first name. If more than one guardian is selected to receive attendance notifications, the student will have multiple letter records in the merge file.
parent_last_name	Guardian contact's last name. If more than one guardian is selected to receive attendance notifications, the student will have multiple letter records in the merge file.
use_for_mailing	Indicator of whether the language for the student or guardian should be used for mailing.
language	Primary language of letter recipient.
title	Title for the recipient.
apartment	Apartment number for recipient.
complex	Complex name for recipient.
street_number	House number for recipient.
street_prefix	Prefix for street name for recipient.
street_name	Street name for recipient.
street_suffix	Suffix for street name for recipient.
street_type	Type of street for recipient. For example, Ave or St.
city	City for recipient.
state	State for recipient.
zip	Zip code for recipient.
email	Email address for recipient.
email_preference	Indicator of whether recipient has elected to receive notifications by email.
first_date	First date for which the Notification Calculation was run.
last_date	Last date for which the Notification Calculation was run.
counselor_name	Name of the student's counselor.
counselor_phone	Phone number of the student's counselor.
perfect_attendance	Indicator of whether the criteria indicates that the student has perfect attendance.
attendance_count	Number of absences being reported in the letter.
total_absence_value	Total absence value being reported in the letter.
total_absence_type	Indicates what the total_absence_value represents. The absence type that displays is based on how your criteria was defined. For example, type could be Absence, Days, or Present Minutes.
history_of_absences	A list of attendance history information including the date, period and/or course information, and the absence codes for all absences included in history. Headings are printed above the columns of data. You cannot include this field in the middle of a paragraph. It should be included below the letter text. Format this merge field in a non-proportional font so that headings align correctly. Additionally, you may need to adjust margins and use a smaller font size in order to fit the data appropriately. You may use any font, but using the following font and point size is recommended: Font Courier New Point Size 8.
building	Building for which attendance was entered.
grade	Student's grade.
track	Student's track code.
calendar	Student's calendar code.
house_team	Student's house/team code.
homeroom_primary	Student's primary homeroom.
homeroom_staff_id	Student's homeroom teacher's staff ID number.
homeroom_staff_name	Student's homeroom teacher's name.