Author(s)
Kyle Kwaiser
Authoring Organization(s)
U of Michigan / CEPI
Use Case Title
Add County Name to DimOrganizationAddresses
Use Case Overview
The field CountyAnsiCodeCode has an entry in the DimOrganizationAddresses table. However, the element Address County Name is not represented with the FactDirectory portion of the CEDS DW schema.
https://ceds.ed.gov/element/000190
Components Affected
CEDS Data Warehouse (complete DW Design Overview Table)