Purpose

Used for looking at each student's results for the Assessments within the ODS. This view supports the overall assessment as well as the objective assessment granular detail.

SQL Object Name

analytics.asmt_StudentAssessmentFact

Data Definition and Sources

Column	Data Type	Source	Description
StudentAssessmentFactKey	nvarchar		The unique key that describes the Student Assessment Fact record
StudentAssessmentKey	nvarchar	StudentAssessment	The unique key that describes the student assessment
StudentObjectiveAssessmentKey	nvarchar	StudentAssessmentStudentObjectiveAssessment	The unique key that describes the student objective assessment
ObjectiveAssessmentKey	nvarchar	ObjectiveAssessment	The unique key that describes the objective assessment
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.
StudentAssessmentIdentifier	nvarchar	StudentAssessment	The unique identifier that is associated with the student assessment record
StudentUSI	int	Student	The global unique identifier associated with the student
StudentSchoolKey	nvarchar	StudentSchoolAssociation	For linking to the StudentSchoolDim View.
SchoolKey	int	School	For linking to SchoolDim View.
AdministrationDate	nvarchar	StudentAssessment	The date in which the assessment was conducted
AssessedGradeLevel	nvarchar	StudentAssessment	The grade level that the assessment was intended for
StudentScore	nvarchar	StudentAssessmentStudentObjectiveAssessmentScoreResult	The documented score for the overview student for the corresponding assessment or objective assessment
ResultDataType	nvarchar	StudentAssessmentStudentObjectiveAssessmentScoreResult	Describes what format the top results for the assessment are reported.
ReportingMethod	nvarchar	StudentAssessmentStudentObjectiveAssessmentScoreResult	Describes how the summary objective assessment results of the assessment are reported. This will create multiple records if there are multiple reporting methods associated with the assessment.
PerformanceResult	nvarchar	StudentAssessmentStudentObjectiveAssessmentPerformanceLevel	This is the categorical summary result of the students assessment
StudentAssessmentScore	nvarchar	StudentAssessmentStudentObjectiveAssessmentScoreResult	The documented score for the student for the corresponding assessment or objective assessment
StudentAssessmentResultDataType	nvarchar	StudentAssessmentStudentObjectiveAssessmentScoreResult	Describes what format the results for the assessment are reported.
StudentAssessmentReportingMethod	nvarchar	StudentAssessmentStudentObjectiveAssessmentScoreResult	Describes how the results of the assessment are reported. This will create multiple records if there are multiple reporting methods associated with the assessment.
StudentAssessmnetPerformanceReult	nvarchar	StudentAssessmentStudentObjectiveAssessmentPerformanceLevel	This is the categorical result of the students assessment