citydata-mesaaz-gov/business-services-attended-and-unattended-q9i3-qbrc

  • attended
  • payments
  • unattended

Business Services - Attended and Unattended Transactions

Business Services - Attended and Unattended Transactions

The location that was used to make the payment and did the payment method require the assistance of a City of Mesa employee. (locations can be mail, web, bill pay, business office, contact center, etc.) Unattended = Does not require COM employee assistance, Attended = Requires COM employee assistance.

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
AreaareaareaTextWhere the payment was made, abbreviated. (CKFR, CTYH, etc.)
RowIDrowidrowidNumberUnique Row Identifier
IncludeFlagincludeflagincludeflagNumberUsed to calculate an associated Performance Measure
FY Unattended Totalfy_unattended_totalfy_unattended_totalNumberTotal unattended transactions within one fiscal year. Used to calculate an associated Performance Measure.
Transaction Yeartransaction_yeartransaction_yearTextCalendar year of the transaction
CategorycategorycategoryTextUnattended = Does not require COM employee assistance, Attended = Requires COM employee assistance.
DescriptiondescriptiondescriptionTextWhere the payment was made, spelled out if the area is abbreviated. (Contact center, business office, web site, mail, bill pay)
CountcountcountNumberNumber of transactions for the area for the month.
Transaction Monthtransaction_monthtransaction_monthTextCalendar month of the transaction
Transaction Datetransaction_datetransaction_dateCalendar date1st day of the month that the transactions were made. Used for the measure to group by month. ie. 2021 Nov 01 12:00:00 AM
FY Total Countfy_total_countfy_total_countNumberTotal unattended and attended transactions within one fiscal year. Used to calculate an associated Performance Measure

Upstream Metadata