Generic columns

Analytics lets you extract data that is not necessarily tied to a specific data type (records, cases, etc.), but is more generic. These generic columns include everything from the user actions affecting the system’s data to different ways of timestamping the actions.

Calculations

It is possible to perform calculations as part of drawing a report. These calculations are based on the extracted data, and therefore the results are context-dependent. This is important to keep in mind when the columns are used in report configurations.

Column name	Description	Value type
Count	Accumulates identical rows in the data extract and returns the total.	Number
Avg. duration	The average of the values in the "Duration" column for otherwise identical rows in the data extract.	Number
Avg. processing time	Average processing time for otherwise identical rows.	Number
Avg. deadline adherence	Average deadline adherence in minutes for otherwise identical rows.	Number
Avg. deadline adherence in days	The average deadline adherence within office hours converted to days for otherwise identical rows.	Number
Avg. internal deadline adherence	The average deadline adherence in minutes for internal deadlines on requests.	Number
Avg. turnaround time	Average turnaround time for approvals of identical data.	Number
Avg. minutes to record deadline	Average of the values in the "Minutes to record deadline" column for otherwise identical rows in the data extract.	Number
Avg. minutes to approval deadline	Average of the values in the "Minutes to approval deadline" column for otherwise identical rows in the data extract.	Number
Total duration	Sum of the values in the "Duration" column for otherwise identical rows in the data extract.	Number

Column name

Description

Value type

Count

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

Number

Avg. duration

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

Number

Avg. processing time

Average processing time for otherwise identical rows.

Number

Avg. deadline adherence

Average deadline adherence in minutes for otherwise identical rows.

Number

Avg. deadline adherence in days

The average deadline adherence within office hours converted to days for otherwise identical rows.

Number

Avg. internal deadline adherence

The average deadline adherence in minutes for internal deadlines on requests.

Number

Avg. turnaround time

Average turnaround time for approvals of identical data.

Number

Avg. minutes to record deadline

Average of the values in the "Minutes to record deadline" column for otherwise identical rows in the data extract.

Number

Avg. minutes to approval deadline

Average of the values in the "Minutes to approval deadline" column for otherwise identical rows in the data extract.

Number

Total duration

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

Number

Actions

F2 logs various actions taken by users as well as by administrators. These include everything from updates of role descriptions to searches in the participant register. Below are described the columns that extract data about actions as well as the users who performed them.

Column name	Description	Value type
Updated property	The setup property that a given action has changed.	String
Attribute name	The metadata or other data-related attribute that a given action has affected.	String
Reason	User-specified reason for an action the user has taken.	String
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.	Number
Details	Any system-generated text that describes or elaborates on an action.	String
After	A property, attribute, or field’s new value after an action.	String
Before	A property, attribute, or field’s old value before an action.	String
Action	Name of the action that was performed.	String
Action related to access	Indicates whether a given action pertains to accessing an item and its data.	Boolean
Action related to search	Indicates whether a given action is a search.	Boolean
Operation type	The unique action ID	Number
Involvement	The participant’s type of involvement in a given record in connection with an action.	String
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.	String
Login name	If a user has performed the action on behalf of another user, the name of the logged-in user is specified.	String
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.	String
Deleted by	Name of the user who performed a deletion action.	String
Search criteria	Description of criteria for a search action.	String
Selected tree	The node in the participant register in which a participant-related action was performed.	String

Column name

Description

Value type

Updated property

The setup property that a given action has changed.

String

Attribute name

The metadata or other data-related attribute that a given action has affected.

String

Reason

User-specified reason for an action the user has taken.

String

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.

Number

Details

Any system-generated text that describes or elaborates on an action.

String

After

A property, attribute, or field’s new value after an action.

String

Before

A property, attribute, or field’s old value before an action.

String

Action

Name of the action that was performed.

String

Action related to access

Indicates whether a given action pertains to accessing an item and its data.

Boolean

Action related to search

Indicates whether a given action is a search.

Boolean

Operation type

The unique action ID

Number

Involvement

The participant’s type of involvement in a given record in connection with an action.

String

If a user has performed the action on behalf of another user, the unique user ID of the logged-in user is specified.

String

If a user has performed the action on behalf of another user, the name of the logged-in user is specified.

String

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.

String

Deleted by

Name of the user who performed a deletion action.

String

Search criteria

Description of criteria for a search action.

String

Selected tree

The node in the participant register in which a participant-related action was performed.

String

Time stamps

Some report types use generic timestamps, for example for actions. This category of columns does not include timestamps otherwise displayed as metadata, such as "Letter date" on records.

Column name	Description	Value type
Year	The year in the timestamp.	Date
Date	Day.	Date
Date and time	The full timestamp with year, month, day, hour, minute, and second.	Date
Minute	The minute in the timestamp.	Date
Authority	The authority about which data is extracted.	String
Month	The month in the timestamp.	Date
Deleted at	Date and time for the deletion action.	Date
Time	Hour, minute, and second.	Date
Hour	The hour in the timestamp.	Date
Weekday	The weekday in the timestamp.	Date

Column name

Description

Value type

Year

The year in the timestamp.

Date

Day.

Date

Date and time

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

Date

Minute

The minute in the timestamp.

Date

Authority

The authority about which data is extracted.

String

Month

The month in the timestamp.

Date

Deleted at

Date and time for the deletion action.

Date

Time

Hour, minute, and second.

Date

Hour

The hour in the timestamp.

Date

Weekday

The weekday in the timestamp.

Date

Miscellaneous

Listed below are the columns which do not fall under other categories.

Column name	Description	Value type
External reference	The item’s external ID.	Number
Item type	The type of F2 item on which data has been extracted.	String
From	The beginning of a time period. The column is best used for delimitation.	Date
Internal ID	The unique value that serves as the item’s ID in the database.	Number
To	The end of a time period. The column is best used for delimitation.	Date
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

Column name

Description

Value type

External reference

The item’s external ID.

Number

Item type

The type of F2 item on which data has been extracted.

String

From

The beginning of a time period. The column is best used for delimitation.

Date

Internal ID

The unique value that serves as the item’s ID in the database.

Number

The end of a time period. The column is best used for delimitation.

Date

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