Add School Identifier SAT column to DimK12Schools within FactDirectory #112
Description
Author(s)
Kyle Kwaiser
Authoring Organization(s)
U of Michigan / CEPI
Use Case Title
Add School Identifier SAT to DimK12Schools
Use Case Overview
The DimK12Schools table is part of the FactDirectory star schema within the CEDS DW. This table contains a SchoolIdentifierAct column but no analog for SAT. Request is to create a DimK12Schools.SchoolIdentifierSat column.
Use Case Background
At the time of initial development, it's likely SAT identifiers were not available and therefore were not included in the DW design. They are now available. Let's include them.
Components Affected
CEDS Data Warehouse (complete DW Design Overview Table)
DATA WAREHOUSE DESIGN OVERVIEW (Includes Dim, Fact, and Report tables)
DimK12Schools
Description of Proposed Changes
Request is to create a DimK12Schools.SchoolIdentifierSat column.