Skip to main content

AMT Collections

The Analytics Middle Tier contains a core collection of views and configuration tables that are always installed. The core collection provides views for a robust set of common use cases.

The Analytics Middle Tier also provides optional collections that can be installed at any time. Each of these optional collections is tuned to a specific use case, and therefore may have logic that is not appropriate for other use cases. The AMT Deployment Guide describes the process of deploying a use-case specific collection. Each collection has a formal name and short code name which is used during the deployment process (e.g. "EWS" for the "Early Warning System" collection).

The following table shows the optional collections:

Install CodeFull NameWhen to Use
RLSRow-Level SecurityCan be used to assist in securing an end-user application by restricting access to student information at the level of the district (LEA), school, or section.
​Required for the [Ed-Fi ODS/API and Microsoft Power BI Starter Kit v2](Ed-Fi ODS/API and Microsoft Power BI Starter Kit v2).
​EWSEarly Warning System​​Required for the [Ed-Fi ODS/API and Microsoft Power BI Starter Kit v2](Ed-Fi ODS/API and Microsoft Power BI Starter Kit v2).
Note, a separate collection to support the AWS QuickSight EWS Starter Kit can be found AWS QuickSight Starter Kit.
CHRABChronic AbsenteeismRequired for the Chronic Absenteeism Quick Start Guide for Metabase
Can be used to evaluate chronic absenteeism as described in CHRONIC ABSENTEEISM IN THE NATION'S SCHOOLS: A hidden educational crisis by the U.S. Department of Education.
ASMTAssessmentRequired for the Assessment Starter Kit
Can be used to see students scores, performance levels, and learning standards across assessments and objective assessments
EQUITYStudent EquityRequired for the Student Equity Starter Kit
Includes student discipline, feeder schools, student food service programs, and student history.
ENGAGEStudent EngagementRequired for the Engage Online Learners Starter Kit
Includes student assignment and student assignment submission information.
EPPEducator Prep ProgramClinical Experience and Performance Collection 
Program Diversity and Persistence