All case fields

The content of this website is last updated to F2 version 11. cBrain are working hard on supplying you with the newest documentation of F2.

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

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