Deleted cases
The "Deleted cases" report type extracts data about cases in F2 that have been deleted including information about the case itself and the user who deleted it.
The report type contains three default configurations that focus on cases and records affected by the deletion, and the reasons given for deletion. The limitations describe whether the extraction concerns the cases themselves or their records.
The "Case information" default configuration
Use the "Case information" default configuration to create a list of deleted cases and the reasons for their deletion.
The configuration contains neither filters nor fields to fill in.
| Column name | Description | Examples |
|---|---|---|
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 |
Reason |
User-specified reason for an action the user has taken. |
Deleted in accordance with GDPR as the case contained personal data. |
Name |
Name of the user who has performed an action. If the action was performed on behalf of another user, the name of the "on behalf of" user is specified. |
Holly Rogers Isaac Johnson |
Login name |
If a user has performed the action on behalf of another user, the name of the logged-in user is specified. |
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 |
Count |
Accumulates identical rows in the data extract and returns the total. |
249 |
The "Record information" default configuration
Use the "Record information" default configuration to create a list of deleted cases' records and the reasons given for deletion.
The configuration contains filters but no fields to fill in.
| Column name | Description | Examples |
|---|---|---|
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 |
External reference |
The item’s external ID. |
29 84 |
Reason |
User-specified reason for an action the user has taken. |
Deleted in accordance with GDPR as the case contained personal data. |
Name |
Name of the user who has performed an action. If the action was performed on behalf of another user, the name of the "on behalf of" user is specified. |
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 |
Count |
Accumulates identical rows in the data extract and returns the total. |
249 |
The "Related record information" default configuration
Use the "Related record information" default configuration to create a list of deleted cases' records and attachments, if any.
The configuration contains filters but no fields to fill in.
| Column name | Description | Examples |
|---|---|---|
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 |
Item type |
The type of F2 item on which data has been extracted. |
Dossier Attached Dossier |
External reference |
The item’s external ID. |
29 84 |
Reason |
User-specified reason for an action the user has taken. |
Deleted in accordance with GDPR as the case contained personal data. |
Name |
Name of the user who has performed an action. If the action was performed on behalf of another user, the name of the "on behalf of" user is specified. |
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 |
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 |
|---|---|---|
User ID |
The unique user ID of the user who has performed an action. If the action was performed on behalf of another user, the unique user ID of the "on behalf of" user is specified. |
107 124 |
Case internal ID |
The unique value that serves as the case’s ID in the database. |
2179 2998 |
Internal ID |
The unique value that serves as the item’s ID in the database. In this instance, it means the cases' records and their attachments, if any. |
2163 2514 |
Login user ID |
If a user has performed the action on behalf of another user, the unique user ID of the logged-in user is specified. |
107 124 |