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

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

  • DRAFT

  • PUBLISHED

 

 

FormPriority

Form Priority

Priority for selecting that form over other forms.

 

 

AssessmentTitle

Assessment Title

Title of the Assessment

 

 

AssessmentType

Assessment Type

  • REFLECTIVE_SELF

  • SCORED

 

 

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

 

  • InProgress

  • NEW

  • PREVIEW

  • PREVIEW_SCORE

  • Scored

  • STARTED

 

 

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