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 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. |