CSR | Flex Note Archiving
311 Service Request Flex Note Archiving
Last updated
Was this helpful?
311 Service Request Flex Note Archiving
Last updated
Was this helpful?
When we receive a 311 Service Requests record from our CSR integration, we also receive related "Flex Notes" which contain additional SR attributes specific to each SR type.
An SR can have as many as seven or eight flex notes, so they start to account for many thousands of records in the Data Tracker.
To save storage space we have agreed with business owners that we will delete the flex note records from the Data Tracker if the service request is in a Closed status.
In the event that a user wants to view any flex notes which are no longer in the Data Tracker a user can use the 311 CSR system to view the record.
Login to production data tracker builder
Navigate to the csr_flex_notes object.
As a validation check, we first filter the object to see how many records will be deleted. Use the object filters to select records that meet the following criteria:
ISSUE_STATUS_CODE contains closed
CREATED_DATE is before <two months ago>
After applying the filters, verify that the results appear as expected, and note how many records will be deleted.
Now it's time to batch delete the flex note records. From the csr_flex_notes records view in the builder, click on the Delete drop-down, and choose Batch Delete
Apply the same filters as defined in step 3, and click Next. On the next screen you will be prompted to confirm the delete. Verify that the # of records to be deleted matches the results from step 4.
Click Delete Records to confirm your delete.
Lastly, update the and note how many records were deleted.
We have a template to use in the atd-data-tech repo
Use the current month to name the issue, for example January 2020 for the November 1st 2019 date referenced below.
