Ed-Fi Assessment Item Score Data Types

Summary of outcomes for Data Standard 3.2

• Problem Addressed: Assessment scores are not always whole number values but elements in the data model to record these scores are integers.
• High-level Reasoning: Changing elements to be decimals would not be a breaking change (as all integers are also decimals) as long as the total number of digits encompassed the max number of digits for an integer. There is also a request to make this change for Suite 2. This is captured in DATASTD-1377.
• Changes Made: Changed the datatype for MaxRawScore and RawScoreResult from integer to decimal (15,5). These elements are found on Assessment, ObjectiveAssessment, AssessmentItem, and StudentAssessmentItem.

Original ticket description follows:

Overview

The data type for AssessmentItem.maxRawScore and StudentAssessment.items.rawScoreResult is type integer. We have a substantial amount of clients that use decimal/fractional values for their item type scores (i.e., 1.5, 2.3, etc). It is not possible to accurately push item scores with the constraint of type integer.

Desired Resolution

Change the data type for AssessmentItem.maxRawScore and StudentAssessment.items.rawScoreResult to type decimal.