...
Column | Definition | Example | ||||||
|---|---|---|---|---|---|---|---|---|
User id | The unique identifier of the user who has access to the topic with the formal assessment. | 12345 | ||||||
Username | The username of the user with access to the topic with the formal assessment. | john.smith | ||||||
First name | The username of the user with access to the topic with the formal assessment. | John | ||||||
Last name | The family name/surname of the user with access to the topic with the formal assessment. | Smith | ||||||
The email address of the user with access to the topic with the formal assessment. | john.smith@fuseuniversal.com | |||||||
System role | The account type of the user with access to the topic with the formal assessment. The following user types are available:
| User | ||||||
Creation date | The date the user with access to the topic with the formal assessment was created in the platform. | 08-07-2025 12:14:38 | ||||||
Last activity date | The date and time the user last accessed the platform. | 08-07-2025 12:14:38 | ||||||
Time zone setting | The user’s time zone, as set in their profile. | London | ||||||
Language setting | The user's language, as set in their profile. | en-GB | ||||||
Manager username(s) | The username of the user’s manager(s). | jane.doe
| ||||||
Manager id(s) | The unique identifier of the user’s manager(s) | 97735
| ||||||
Manager e-mail(s) | The email address of the user’s manager. | jane.doe@fuseuniversal.com
| ||||||
Community id(s) | The unique identifier of the community where the topic exists. | 12345 | ||||||
Community name(s) | The name of the community where the topic exists. | Sales Enablement Community | ||||||
Topic id | The unique identifier of the topic with the formal assessment. | 12345 | ||||||
Topic name | The name of the topic with the formal assessment. | Sales Enablement Programme | ||||||
Assessment id | The unique identifier of the formal assessment in the topic. | 12345 | ||||||
Assessment creation date | The date and time the formal assessment was created in the topic. | 08-07-2025 12:14:38 | ||||||
Last updated date | The date and time the formal assessment in the topic was last edited.
| 08-07-2025 12:14:38 | ||||||
Start date | The date the user started the formal assessment. This is as soon as the user clicks Start assessment and views the first question in the formal assessment. | 09-07-2025 12:14:38 | ||||||
Completed date | The date and time the user passed/completed the formal assessment. | 09-07-2025 12:14:38 | ||||||
Assessment user status | The user’s status for the formal assessment. The available statuses are:
| Passed | ||||||
Attempt id | The unique identifier for the user’s formal assessment attempt. | 12345 | ||||||
Raw score | The total number of points the user has scored in their latest attempt.
| 20 | ||||||
Assessment result | The user’s assessment result, shown as a percentage. For example, if the user has answered all the questions correctly, 100% is shown in this column for that user.
| 100% | ||||||
Attempt count | The number of completion attempts the user has made for the formal assessment. For example: 1 is shown if a first attempt has been made, 2 is shown if a second attempt has been made, and so on. | 2 | ||||||
Total questions | The total number of questions presented to the users. | 5 | ||||||
Question id | The unique identifier of a question in the formal assessment. | 12345 | ||||||
Question type | The type of question defined by the assessment:
| One correct | ||||||
Question | The text of a question that appears in the assessment. | How many fire wardens are there in the organisation? | ||||||
Answer id(s) | The unique identifier of a user’s answer to a question in the assessment.
| 12345 | ||||||
Answer(s) | The answer(s) the user has selected for a question. | questions with multiple answers, this columns show in 1 field and be seperate by semi colon (;)2
| ||||||
Answer score | The raw score of the relating answer. | 1 | ||||||
Mark | Did the user achieve the marks needed for the Question to be marked as | Correct |
...