Create new table to link People and Addresses

[DPDonovan]

This is for capturing needs not currently supported by the CEDS model. Please do not send or share actual data as examples in this issue or in attachments.

Author(s)
Deborah Donovan
Authoring Organization(s)
Mississippi Department of Education
Email Address
ddonovan@mdek12.org
Use Case Title
Create new table to link People and Addresses

Use Case Overview
We would like to be able to link a person (student and staff in particular) with all of their associated addresses, including mailing and physical addresses. There is not currently a way to link this data together for all use cases using existing tables.

Pull Request Number(s) (If applicable)
N/A
Use Case Background
See overview above. For example, we want to display the mailing and physical addresses for all students. Currently, there is no link available.

Components Affected
Delete everything from the list below except the components affected:

CEDS Data Warehouse (complete DW Design Overview Table)

CEDS Data Warehouse Parquet (complete DW Parquet Design Overview Table)

---

DATA WAREHOUSE DESIGN OVERVIEW (Includes Dim, Fact, and Report tables)

---