CentralSquare Technologies LLC 1/17/2020

Alarmed Locati ons.xlsx Field Description AccountNumber* The unique identifier for this alarmed location. This value can be alpha-numeric LocationType* The type of building. (e.g. Residential, Commercial, Government, etc.) lastName* LastName for Residential alarmed locations, Business name for commercial alarmed locations FirstName First name for alarmed location for Residential. Empty for commercial MI Middle initial for Residential alarmed location, empty for commercial StrNumber* The street number of the alarmed location. Numeric values only StrPrefix Street prefix(if any)for the alarmed location (e.g. N, S, E,W) StrName* Street name for the alarmed location. StrName can include Prefix, suffix and Direction if that is how they are currently stored in your system(e.g. N MAIN ST W) StrSuffix Street suffix(if any)for the alarmed location (e.g. ST, DR, RD, etc.) StrDirection Street post direction(if any)for the alarmed location(e.g. N, S, E, W) Suite Suite or apartment City* City State* State Zip* Zip or postal code Phonel Main phone number including area code Phone2 Secondary phone number including area code datePurchased Date the alarm system was purchased datelnstalled Date alarm system was installed datelnspected Date alarm system was last inspected _datelssued Date a permit was issued to the alarmed location, if applicable dateExpires Date a permit will expire for the alarmed location, if applicable currentStatus Current status of the alarmed location, if applicable e.g.Active, Closed, Expired, etc. statusDate The date the current status was last changed, if applicable Beat Police or Fire beat/area where this alarmed location resides monitoredBy Account#of the alarm company monitoring this alarmed location soldBy Account#of the alarm company that sold alarm system servicedBy Account#of the alarm company servicing this alarm system installedBy Account#of the alarm company that installed this alarm system Created The date the alarmed location Account was first created Updated The date the alarmed location Account was last updated Email The main email address for the alarmed location Comments Any general comments stored for this alarmed location Customl-6 These six custom fields can be used to pass other values related to the alarm company not covered above Hazards Text field listing any hazards or special warning for this alarmed location adminNotes Text field for any administrative notes stored for this alarmed location escrow Numeric field for any money owed back to the alarmed location, or 0.00 Email Email address of the alarmed location bankrupt Integer value 0= NOT BANKRUPT, 1 = BANKRUPT The AlarmedLocations.xls form contains all of the alarmed locations. Each alarm location must be contained on a single line in the file. Each alarm location must have a unique identifier in the AccountNumber column. This number can be alpha-numeric and up to 15 characters.The same Excel form is usually used to submit all types of alarmed locations; residential, commercial,government, etc. But separate forms can be used for each if required by your current database layout. If separate alarm location forms are submitted,the Account Numbers must still be unique across all forms. Page 23 of 27 False Alarm Management Services Contract Agreement