All case fields
The "All case fields" report type extracts all metadata available on cases, both explicit and implicit data. For example, if a user is specified in the "Responsible" field on the case, you can extract the user’s name (explicit data) with the "Responsible" column, but also the unit in which the user has a job role (implicit data) with the "Responsible unit" column.
The report type contains one default configuration that creates a standardised extraction of cases' metadata.
The "Standard" default configuration
Use the "Standard" default configuration to extract an overview of cases in the organisation’s archive. The overview shows the latest version of each case and includes most of its metadata.
The configuration contains neither filters nor fields to fill in.
| Column name | Description | Examples |
|---|---|---|
Case completed by |
Name of the user who last completed the case. |
Holly Rogers Isaac Johnson |
Case completed |
Date and time when the case last changed status to "Completed". |
2023-11-14T12:40:29.597 2023-04-12T15:30:20.773 |
Case responsible |
The user or unit specified in the "Responsible" metadata field. |
Holly Rogers HR |
SSN/CVR No of case |
The value specified in the "SSN/CVR No" metadata field. |
010203-4679 12345678 |
External ID |
The value specified in the "External ID" metadata field. |
201345 2021 - 789 |
Case keyword |
The keyword(s) specified in the "Keyword" metadata field. |
Quality report Complaint; FOI Request |
Case deadline |
The date specified in the "Deadline" metadata field at midnight. |
2023-11-14T12:40:29.597 2023-04-12T15:30:20.773 |
Case created |
Date and time when the record was created. |
2023-11-14T12:40:29.597 2023-04-12T15:30:20.773 |
File plan |
The value specified in the "File plan" metadata field. |
00 - Public auth. 07 - Rubbish and recycling |
Action code |
The value specified in the "Action code" metadata field. |
A0 - Organisation P23 - Control |
Disposal code |
The value specified in the "Disposal code" metadata field. |
D - Discard P - Preserve |
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 status |
The value specified in the "Status" metadata field. |
InProgress Closed |
Progress code |
The name of the progress code. |
In process Awaiting hearing |
Previous case No. |
The case number specified in the "Previous case No." metadata field. |
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 |
Unit responsible for case |
The unit or the unit associated with the user that is specified in the "Responsible" metadata field. |
HR Administration |
Case created by |
Name of the user who created the case. |
Holly Rogers Isaac Johnson |
Case suppl. case mgr. |
Names of users specified in the "Suppl. case mgr." metadata field. |
Holly Rogers Isaac Johnson |
Case suppl. units |
Units specified in the "Suppl. case mgr." metadata field. |
HR IT office |
Case participants |
The case participant(s) specified in the "Case participants" metadata field. |
Martin Safadi |
Access limitation on case |
All users, units, teams, and security groups specified in the "Access restriction" metadata field. |
HR Isaac Johnson; SG: Managers |
Extension data fields 01-10 |
Any additional fields that can be configured for items such as records and cases in F2. The number of available fields and their data format depend on your organisation’s installation. |
N/A |