Skip to content

Email Template Fill Point Variable Syntax and Available Fields

An email template FillPoint variable is used to insert event-specific information into the subject or body of a reminder email. For example, an email reminder should contain event information like time and location, the name of the primary involved person, the location of the event, etc.

Email Template FillPoint Variable Syntax:

%[DatabaseFieldName]

Email Template FillPoint Variable Example:

%[RecipientFullName]

Email Template Subject Example:

Event Reminder for %[CaseTitle]

Email Template Body Example:

This is a reminder for %[RecipientFullName], concerning the following event:
Event: %[EventTypeDescription]
Date and Time: %[EventDt]
Location: %[EventLocationDescription]
Case: %[CaseTitle]
Defendant: %[PIPFullName]

The following database fields can be used in the subject and body of an email reminder template:

  • RecipientFullName: Full name of the event involved person receiving the email reminder in the following format: (First Name) (Middle Initial) (Last Name).
  • RecipientFullName2: Full name of the event involved person receiving the email reminder in the following format: (Last Name), (First Name) (Middle Initial).
  • RecipientFirstName: First name of the event involved person receiving the email reminder.
  • RecipientLastName: Last name of the event involved person receiving the email reminder.
  • RecipientMiddleName: Middle name of the event involved person receiving the email reminder.
  • RecipientTitle: Title of the event involved person receiving the email reminder.
  • RecipientPrefix: Prefix of the event involved person receiving the email reminder.
  • EventID: JustWare event ID.
  • CaseID: JustWare case ID.
  • EventType: Event type code.
  • EventTypeDescription: Event type description.
  • EventLocation: Event location code.
  • EventLocationDescription: Event location description.
  • EventDt: Date and time the event is scheduled to start.
  • EventEndDt: Date and time the event is scheduled to end.
  • Status: Event status code.
  • StatusDescription: Event status description.
  • Notes: Event notes.
  • CaseType: Case type code (i.e. felony).
  • CaseTypeDescription: Case type description.
  • CaseStatus: Case status code.
  • CaseStatusDescription: Case status description.
  • LawNum: Case Law Number value.
  • DefNum: Case Defense Number value.
  • ProsNum: Case Prosecution Number value.
  • CourtNum: Case Court Number value.
  • MiscNum: Case Miscellaneous Number value.
  • LocalID: Case Local ID value.
  • LawNumType: Case Law Number Type.
  • CourtNumType: Case Court Number Type.
  • DefNumType: Case Defense Number Type.
  • ProsNumType: Case Prosecution Number Type.
  • MiscNumType: Case Miscellaneous Number Type.
  • CaseTitle
  • EventAddByNameID: Name ID of the person who created the event.
  • PIPFullName: Full name of the primary involved person on the case.
  • PIPNameID: Name ID of the primary involved person.
  • PIPInvolveType: Involvement type of the primary involved person.