Progress codes

The "Progress codes" report type extracts data about progress codes on cases. The logging is more specific than what can be extracted with the "Access log" report type, since it only includes data relevant to progress codes.

The report type does not include a default configuration, so you can create reports that fit your organisation’s needs based on its columns and relevant limitations.

Available columns

The following table describes columns that are available when configuring reports.

Column name	Description	Examples
Progress code ID	The progress code’s unique ID.	5 17
Progress code	The name of the progress code.	In progress Awaiting hearing
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
Duration	The total duration in minutes that a progress code has been active on a given case.	38 4821
Date and time	The full timestamp with year, month, day, hour, minute, and second.	2023-11-14T12:40:29.597 2023-04-12T15:30:20.773
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
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 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
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
Progress code is current	Indicates whether the selected progress code at the time of extract is assigned to a given case.	true 0
Count	Accumulates identical rows in the data extract and returns the total.	249
Total duration	Sum of the values in the "Duration" column for otherwise identical rows in the data extract.	68 10946
Avg. duration	The average of the values in the "Duration" column for otherwise identical rows in the data extract.	14 206

Column name

Description

Examples

Progress code ID

The progress code’s unique ID.

Progress code

The name of the progress code.

In progress

Awaiting hearing

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

Duration

The total duration in minutes that a progress code has been active on a given case.

4821

Date and time

The full timestamp with year, month, day, hour, minute, and second.

2023-11-14T12:40:29.597

2023-04-12T15:30:20.773

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

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

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

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

Progress code is current

Indicates whether the selected progress code at the time of extract is assigned to a given case.

true

Count

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

249

Total duration

Sum of the values in the "Duration" column for otherwise identical rows in the data extract.

10946

Avg. duration

The average of the values in the "Duration" column for otherwise identical rows in the data extract.

206