Purpose
Used for looking at Assessments within the ODS and how those assessment are organized in relation to scoring, subdivided into objective assessments, and related to learning standards.
SQL Object Name
analytics.asmt_AssessmentFact
Data Definition and Sources
Column | Data Type | Source | Description |
|---|---|---|---|
| AssessmentKey | nvarchar | Assessment | The unique key that describes the assessment |
| AssessmentIdentifier | nvarchar | Assessment | The unique identifier that describes the assessment |
| Namespace | nvarchar | Assessment | The namespace is part of the uniqueness defining the assessment View. |
| Title | nvarchar | Assessment | The title description of the assessment. |
| Version | int | Assessment | Describes what version the assessment or objective assessment focuses on. |
| Category | nvarchar | Assessment | Describes what category the assessment or objective assessment focuses on. |
| AssessedGradeLevel | nvarchar | Assessment | The grade level is the assessment focused on |
| AcademicSubject | nvarchar | Assessment | Describes what core subject the assessment or objective assessment focuses on. |
| ResultDataType | nvarchar | AssessmentScore | Describes what format the results for the assessment are reported. |
| ReportingMethod | nvarchar | AssessmentScore | Describes how the results of the assessment are reported. This will create multiple records if there are multiple reporting methods associated with the assessment. |
| ObjectiveAssessmentKey | nvarchar | ObjectiveAssessment | The key that defines the objective assessment associated with the record |
| IdentificationCode | nvarchar | ObjectiveAssessment | The identification code is part of the uniqueness defining the objective assessment View. |
| ParentObjectiveAssessmentKey | nvarchar | ObjectiveAssessment | Objective Assessments can be recursively associated to each other to clarify drill down relationships which are represented here. |
| ObjectiveAssessmentDescription | nvarchar | ObjectiveAssessment | A description of the objective assessment associated with the assessment |
| PercentofAssessment | decimal | ObjectiveAssessment | Documents the size of the assessment identified in the objective assessment |
| MinScore | nvarchar | AssessmentScore, ObjectiveAssessmentScore | This is the minimum score that can be achieved for this assessment or objective assessment |
| MaxScore | nvarchar | AssessmentScore, ObjectiveAssessmentScore | This is the maximum score that can be achieved for this assessment or objective assessment |
| LearningStandard | varchar | ObjectiveAssessmentLearningStandard | The learning standard description associated with the objective assessment associated with the record. This will create multiple records if there are multiple learning standards associated with the objective assessment. |