Attendance Letter Merge Fields

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.