Column reference
The following pages list all columns in Analytics. Users with the "F2 Analytics administrator" privilege can use these pages as a reference for columns that can be included in report configurations.
The column reference only covers columns from Analytics' standard report types. Which columns are included in a specific report type and how to use them are described as part of the report reference.
The columns can be divided according to the types of data they extract:
-
Records
-
Cases
-
Documents
-
Requests
-
Approvals
-
Users and participants
-
Generic columns.
Each column is described with the following information:
-
Column name shows the name of the column as it appears in the F2 user interface.
-
Description generally explains which data the column extracts from the database.
-
Value type is the format you can expect. The following possible formats exist:
-
Strings consist of letters, numbers, characters, and combinations thereof.
-
Numbers cover both integers and decimal numbers. If a column potentially can contain something other than numbers, it will be marked as a "string" even if it only contains numbers in your organisation.
-
Date refers to date objects, which are detailed timestamps. From this timestamp anything from minutes to years can be derived. Note that dates may have a different format when exported to Excel than indicated here, meaning that the first month of the year could potentially be displayed as "1" or "January" depending on the format.
-
Boolean values are either true ("yes") or false ("no").
-