Data Source Description: Assessment Instance
Summary
View Type | Reporting |
---|---|
English Name | Assessment Instance |
Description | List of Assessment Instances with their status, and the ID of the entity instance, if any. |
Content | New in 12.x? |
Usage
Suggested uses for this view include:
Reports on Assessment Completions
Data Fields
Field Name | English Name | Description | Notes | Available in LearningBuilder Version |
---|---|---|---|---|
AssessmentInstanceId | Assessment Instance ID | Primary Key | There could be duplicates if the same Assessement Instance is referenced by more than one attribute as in if the value were copied from one to another. |
|
AssessmentFormId | Assessment Form ID | Foreign Key to the Assessment Form |
|
|
AssessmentId | Assessment ID | Foreign Key to the Assessment |
|
|
FormCode | Form Code | Form Code of the form |
|
|
FormStatus | Form Status |
|
|
|
FormPriority | Form Priority | Priority for selecting that form over other forms. |
|
|
AssessmentTitle | Assessment Title | Title of the Assessment |
|
|
AssessmentType | Assessment Type |
|
|
|
MemberId | Member ID | Member ID of the Member who took the assessment. |
|
|
FirstName | First Name | First Name of the Member who took the assessment. | These live in the Member table and are brought in by reference through the Member ID |
|
LastName | Last Name | Last Name of the Member who took the assessment. | These live in the Member table and are brought in by reference through the Member ID |
|
MemberName | Member Name | Member name of the Member who took the assessment. | These live in the Member table and are brought in by reference through the Member ID First and Last Name for individual members and Organization Name for organizational members. |
|
Source | Source | Source of the Assessment Instance. Might not be used. |
|
|
Status |
|
|
|
|
ExpirationDate | Expiration Date | Expiration Date of the Assessment Instance. Might not be used. |
|
|
Score | Score | Sum of Scored Questions |
|
|
AnsweredQuestions | Answered Questions | Count of Answered Questions |
|
|
ScoredQuestions | Scored Questions | Count of Scored Questions |
|
|
LastAnswerTime | Last Answer Time | Date and Time of the last question was answered |
|
|
CutScore | Cut Score | The Cut Score for the Form |
|
|
ScoreStatus | Score Status | The Status, except when SCORED, then SCORED - FAIL or SCORED - PASS based on the Cut Score and the Score |
|
|
Links to the entities that own the Assessment Attribute | ||||
ActivityItemId | Activity Item ID | If the Assessment Attribute was on an Activity, it shows a value here. |
|
|
ActivityInstanceId | Activity Instance ID | If the Assessment Attribute was on an Activity Instance, it shows a value here. |
|
|
LearningPlanInstanceId | Learning Plan Instance ID | If the Assessment Attribute was on a Learning Plan, it shows the ID of the Learning Plan Instance. |
|
|
MemberRoleId | Member Role ID | If the Assessment Attribute was on a Role, it shows a value here. |
|
|
ActivityOfferingId | Activity Offering ID | If the Assessment Attribute was on an Offering, it shows a value here. |
|
|
AttributeName | Attribute Name | Name of the attribute linked to this Assessment Instance |
|
|
AttributeId | Attribute ID | The ID of the attribute linked to the Assessment Instance |
|
|