Users and participants

Data about users and participants can be divided into two categories: The setup of users plus their roles in F2 and metadata about participants - including users - registered in F2’s participant register.

User and role setup

Columns that extract data specifically about the administration of users and their roles are described below. The data is therefore directly related to the actions carried out in connection with the administration of users and units, roles and privileges, and membership of security groups.

Column name	Description	Value type
Description	User-provided description of a role.	String
User deactivated on	Date and time when a user was deactivated, if applicable.	Date
User is active	Indicates whether a user was active in F2 at the time of extraction.	Boolean
Job roles' locations	The unit where a user’s job role is located.	String
Missing action	The name of an unresolved action that wasn’t completed by a now deactivated user.	String
Notifications	Indicates where notifications about incoming approvals appear for a user with on behalf of rights within the "Can handle approvals" area.	String
Area	The "Area" value specified in the setup of on behalf of rights.	String
Privilege	Name of the privilege.	String
Privilege ID	The unique ID of the privilege.	Number
Role is active	Indicates whether the "Active" checkbox has been ticked for the role in the "Role types and privileges".	Boolean
Role is assigned	Indicates whether the user is assigned the given role at the time of extraction.	Boolean
Role assigned on	Date and time when a user was assigned the given role.	Date
Role name	Name of the affected role as specified under "Role type" in the "Roles and privileges" window.	String
Role’s unit	The unit with which the role is associated.	String
Role’s unit location	Path for the unit with which the role is associated.	String
Role type	The unique ID for the role that is affected.	String
Security group	Name of the security group associated with the given privilege of the "Archive access" type.	String

Column name

Description

Value type

Description

User-provided description of a role.

String

User deactivated on

Date and time when a user was deactivated, if applicable.

Date

User is active

Indicates whether a user was active in F2 at the time of extraction.

Boolean

Job roles' locations

The unit where a user’s job role is located.

String

Missing action

The name of an unresolved action that wasn’t completed by a now deactivated user.

String

Notifications

Indicates where notifications about incoming approvals appear for a user with on behalf of rights within the "Can handle approvals" area.

String

Area

The "Area" value specified in the setup of on behalf of rights.

String

Privilege

Name of the privilege.

String

Privilege ID

The unique ID of the privilege.

Number

Role is active

Indicates whether the "Active" checkbox has been ticked for the role in the "Role types and privileges".

Boolean

Role is assigned

Indicates whether the user is assigned the given role at the time of extraction.

Boolean

Role assigned on

Date and time when a user was assigned the given role.

Date

Role name

Name of the affected role as specified under "Role type" in the "Roles and privileges" window.

String

Role’s unit

The unit with which the role is associated.

String

Role’s unit location

Path for the unit with which the role is associated.

String

Role type

The unique ID for the role that is affected.

String

Security group

Name of the security group associated with the given privilege of the "Archive access" type.

String

Participant metadata

Participant metadata include the data of all participants in F2, both internal and external. This means that it corresponds to the data shown in the user setup dialogue and F2’s participant register, respectively.

Several of the columns are similar, because different columns can extract the same data about a more or less specific groups of participants. For example, "User participant no." only extracts data about users in the organisation’s participant register, while "Participants No" extracts data about users, units, and external participants.

Column name	Description	Value type
User’s username	The value specified in the "Username" field in the user properties.	String
Participant SSN/CVR No	The SSN or CVR number specified in the participant property "SSN/CVR No" or "SSN".	String
User ID	Unique user ID for the user affected by the action.	Number
Participant ID	The unique user ID for the participant affected by the action.	Number
User’s name and username	The "Name" and "Username" values in the user properties for the user affected by the action.	String
Username	The value indicated in the "Name" field in the user properties.	String
Participant name	The name specified in the "Name" participant property.	String
On behalf of, user ID	The unique user ID of the user who was granted "on behalf of" rights.	Number
On behalf of, name	The "Name" value in the properties of the user for whom another user has been granted "on behalf of" rights.	String
On behalf of, name and username	The "Name" and "Username" values in the properties of the user for whom another user has been granted "on behalf of" rights.	String
User participant no.	The user’s number in the organisation’s participant register.	Number
Unit participant no.	The unit’s number in the organisation’s participant register.	Number
Participants No	The participant’s number in the organisation’s participant register.	Number
Participant’s register type	The participant’s type in the participant register. If the participant is a unit, the unit type is specified.	String
Internal participant’s synchronisation key	The key that ensures correct synchronisation with AD of internal participants.	String

Column name

Description

Value type

User’s username

The value specified in the "Username" field in the user properties.

String

Participant SSN/CVR No

The SSN or CVR number specified in the participant property "SSN/CVR No" or "SSN".

String

User ID

Unique user ID for the user affected by the action.

Number

Participant ID

The unique user ID for the participant affected by the action.

Number

User’s name and username

The "Name" and "Username" values in the user properties for the user affected by the action.

String

Username

The value indicated in the "Name" field in the user properties.

String

Participant name

The name specified in the "Name" participant property.

String

On behalf of, user ID

The unique user ID of the user who was granted "on behalf of" rights.

Number

On behalf of, name

The "Name" value in the properties of the user for whom another user has been granted "on behalf of" rights.

String

On behalf of, name and username

The "Name" and "Username" values in the properties of the user for whom another user has been granted "on behalf of" rights.

String

User participant no.

The user’s number in the organisation’s participant register.

Number

Unit participant no.

The unit’s number in the organisation’s participant register.

Number

Participants No

The participant’s number in the organisation’s participant register.

Number

Participant’s register type

The participant’s type in the participant register. If the participant is a unit, the unit type is specified.

String

Internal participant’s synchronisation key

The key that ensures correct synchronisation with AD of internal participants.

String