Deleted records

The "Deleted records" report type extracts data about records in F2 that have been deleted including information about the record itself, its case, and the user who deleted it.

The report type contains one default configuration that focuses on the records' different metadata and their deletion time.

The "Standard" default configuration

Use the "Standard" default configuration to create a list of deleted records, time of deletion, and a range of metadata that indicate the record type and purpose before deletion.

The configuration contains neither filters nor fields to fill in.

Column name Description Examples

Record ID

The record’s unique ID number in the authority’s archive displayed at the top of the record window.

82

346

Record title

The full record title displayed at the top of the record window and in the "Title" metadata field.

Reply to Section 20 no. 351 regarding budget expansion

Citizen Request

Sender

The user, unit, or external participant specified in the "From" metadata field. If the record has been sent as an email, it will correspond to the sender.

Holly Rogers

citizen@email.com

Recipient

The user, unit, or external participant specified in the "To" metadata field. If the record was sent as an email, it will correspond to the recipient.

Holly Rogers

citizen@email.com

Cc

The participant(s) specified in the "Cc" metadata field, if any.

Holly Rogers

citizen@email.com

Letter date

Date and time specified in the "Letter date" metadata field.

2023-11-14T12:40:29.597

2023-04-12T15:30:20.773

Email sent

Date and time when the record was sent as an email. This typically corresponds to the "Letter date" metadata field.

2023-11-14T12:40:29.597

2023-04-12T15:30:20.773

Email received

Date and time specified in the "Received date" metadata field.

2023-11-14T12:40:29.597

2023-04-12T15:30:20.773

Record created by

Name of the user who created the record specified in the "Created date" metadata field.

Holly Rogers

Isaac Johnson

Record created

Date and time specified in the "Created date" metadata field.

2023-11-14T12:40:29.597

2023-04-12T15:30:20.773

Binned on

Date and time when the record was moved to the "My deleted records" archive area.

2023-11-14T12:40:29.597

2023-04-12T15:30:20.773

Deleted by

Name of the user who performed a deletion action.

In this instance it means deleting the record.

Holly Rogers

Isaac Johnson

Deleted at

Date and time for the deletion action.

2023-11-14T12:40:29.597

2023-04-12T15:30:20.773

Email title

The title of the record at the time it was sent as an email.

Request for professional assessment

Sv: Citizen Request

Case No

The unique ID number in the authority’s archive for a case with which another element in F2 is associated, or for the case itself as seen at the top of the case window.

2024 - 48

2023 - 5

Case title

The full case title displayed at the top of the case window and in the "Title" metadata field.

Board meeting

Section 20 question regarding data protection

Other available columns

The following table covers columns that are accessible when configuring reports, but are not included in the default configurations.

Column name Description Examples

Count

Accumulates identical rows in the data extract and returns the total.

249