...
Column | Definition | Example | ||
|---|---|---|---|---|
Attempt id | The unique identifier for the user’s formal assessment attempt. | 12345 | ||
User id | The unique identifier of the user who has access to the formal assessment. | 12345 | ||
Username | The username of the user who has access to the formal assessment. | john.doe | ||
First name | The first name of the user who has access to the formal assessment. | John | ||
Last name | The last name of the user who has access to the formal assessment. | Doe | ||
The email address of the user who has access to the formal assessment. | john.doe@fuseuniversal.com | |||
System role | The user's account type. The following user types are available:
| User | ||
Creation date | The creation date of the users' account1/1/2021 | 08-07-2016 12:14:38 | ||
Last activity date | The last date the user accessed the platform.17 | /5/202108-07-2016 12:14:38 | ||
Deactivation date | The date the user’s account was deactivated (if applicable) | 19/5/202108-07-2016 12:14:38 | ||
Time zone setting | The user’s time zone as set in their profile. | GMT +1:00 London | ||
Language setting | The user's language; as set in their profile. | en - English | ||
Manager id | The unique identifier of the user’s manager. | 33344
| ||
Manager username | Username of manager | jane.doe
| ||
Manager e-mail | The e-mail address of the user’s manager. | jane.doe@fuseuniversal.com
| ||
Community id | The unique identifier of the community where the topic containing the assessment exists. | 12345 | ||
Community name | The name of the community that contains the topic that the assessment is attached to. | Sales Enablement Community | ||
Topic id | The unique identifier of the topic the assessment is attached to. | 12345 | ||
Topic name | The name of the topic the assessment is attached to. | Sales Enablement Programme | ||
Assessment id | The unique identifier of the Assessment id. | 12345 | ||
Assessment creation date | The date the formal assessment was created. | 08-07-2016 12:14:38 | ||
Last updated date | The date the formal assessment was last edited.
| 08-07-2016 12:14:38 | ||
Start date | The date the user started the formal assessment. This is as soon as the user views the first question (clicks Start assessment). | 09-07-2016 12:14:38 | ||
Completed date | The date the user passed/completed the assessment | 09-07-2016 12:14:38 | ||
Assessment user status | The user’s status for the formal assessment.
| Passed | ||
Raw score | The total number of points the user has scored in their latest attempt.
| 10 | ||
Assessment result | The user’s assessment result, shown as a percentage.
| 100% | ||
Attempt count | The attempt number. | 2 | ||
Total questions | The total number of questions the user was required to answer. | 5 | ||
Nr of correctly answered questions | The total number of questions in the assessment that the user answered correctly. | 4 | ||
Nr of incorrectly answered questions | The total number of questions the user answered incorrectly. | 1 | ||
Question type | The type of question defined by the assessment:
| |||
Question id | The unique identifier for a specific question in the formal assessment. | 12335 |