...
| Info |
|---|
Notes:
|
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 |
given name/first name 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 and time 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 |
in 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. |
For questions with multiple answers, this columns show in 1 field and be seperate by semi colon (;)
2
|
|
| Info |
|---|
This will be null/blank if they have not yet answered the question. |
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 |