Column reference

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