Functional Vision

Story

As a school district data analyst, I want to have a set of simplified views for the Ed-Fi ODS, so that I can develop reports/analyses and/or provide easy-to-consume data models to downstream users.

Acceptance Criteria

• Support for Data Standard 2

• Views for an Early Warning System focused on ABC: Attendance, Behavior, Course Performance (grades)

• Views for Program participation

• Support for record-level security appropriate for a district, a school, or a teacher 

Components

Configuration Tables

• Analytics Middle Tier Schema Version Table

• Authorization Scope Table

• Index Journal Table

• Staff Classification Descriptor Scope Table

Views

• Contact Person Dimension View

• Date Dimension View

• Grading Period Dimension View

• Local Education Agency Dimension View

• Most Recent Grading Period View

• Program Type Dimension View

• School Dimension View

• School Network Association Dimension View

• Student Data Authorization View

• Student Dimension View

• Student Early Warning Fact View

• Student Program Event View

• Student Program Fact View

• Student Section Dimension View

• Student Section Grade Fact

• User Authorization View

• User Dimension View

• User Student Data Authorization View

Configuration Stored Procedures

• Insert Staff Classification Descriptor Scope Stored Procedure

• Remove Staff Classification Descriptor Scope Stored Procedure

• View Staff Classification Descriptor Scope Stored Procedure