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