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").