Cases without records
The "Cases without records" report type extracts data that gives an overview of empty cases and displays any needs for cleaning up.
The report type contains one default configuration that gives an overview of empty cases and which users to contact for a possible cleanup.
The "Cases without records" default configuration
Use the "Cases without records" default configuration to extract data about cases without records, the case creators, and who is responsible. This data extraction can serve as a basis for cleanup work.
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 |
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 |
Case created by |
Name of the user who created the case. |
Holly Rogers Isaac Johnson |
Case responsible |
The user or unit specified in the "Responsible" metadata field. |
Holly Rogers HR |
Unit responsible for case |
The unit or the unit associated with the user that is specified in the "Responsible" metadata field. |
HR Administration |
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 |
Number of records attached to a case. |
8 21 |
No. of deleted records |
Number of records previously attached to the case and now deleted. |
8 21 |
No. of binned records |
Number of records previously attached to the case and now in the bin. |
8 21 |
No. of inactive record |
Old record versions associated with the case. When a record is moved to a new case, a new version of the record is created. |
8 21 |
Case created |
Date and time when the record was created. |
2023-11-14T12:40:29.597 2023-04-12T15:30:20.773 |
Case status |
The value specified in the "Status" metadata field. |
In progress |
File plan |
The value specified in the "File plan" metadata field. |
00 - Public auth. 07 - Rubbish and recycling |
Access limitation on case |
All users, units, teams, and security groups specified in the "Access restriction" metadata field. |
HR Isaac Johnson; SG: Managers |
Authority |
The authority about which data is extracted. |
Doc Authority Sister administration |
Count |
Accumulates identical rows in the data extract and returns the total. |
249 |