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