---
description: >-
  This page will document the steps required to update the Parking Citation
  Tracking done around the start of the new fiscal year.
---

# Update Parking Citation Report by Fiscal Year (FY)

On `parking_citation_numbers` object table, filter to the previous fiscal year for `FY is XX` .

Format spreadsheet:

* Change "Created By" to email address to the requester
* Change "FY" to the new fiscal year
* Blank out all entries per month (ex. 01-OCT, 02-NOV)
* Blank out `INDIVIDUAL TOTAL` and `Total`&#x20;

Import records as new entries to the `parking_citation_numbers` object table

* Does first row contain headers? | Yes
* Do you want to update existing parking\_citation\_numbers records with this import? | No, insert each row as a new record
* Fields:
  * CREATED\_BY | Email
  * Violation Category
  * Violation Description
  * FY
  * Total

After the records have been imported, you need to do two things:

1\) Set the [https://atd.knack.com/parking-enterprise#parking-citation-tracking/](https://atd.knack.com/parking-enterprise#parking-citation-tracking/) Parking Citations table to current fiscal year.

<figure><img src="https://3087753818-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LzNSSXajDFpzOv2IhIv%2Fuploads%2FR9YfrHKtguhInSj9uDoU%2Fimage.png?alt=media&#x26;token=818786ff-44f9-4432-9e9f-5ca55aae04ae" alt=""><figcaption><p>Builder link: <a href="https://builder.knack.com/atd/parking-enterprise/pages/scene_47">https://builder.knack.com/atd/parking-enterprise/pages/scene_47</a></p></figcaption></figure>

2\) Notify the requester that the report has been updated and verify on whether the page on [Inspections report](https://atd.knack.com/parking-enterprise#dispatch-reports/officer-metrics/inspections/) require updating the `CSR_ACTIVITY_DATETIME` to the new fiscal year.
