Add PersonIdentifierSSN to DimPeople

[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
[email protected]
Use Case Title
Add PersonIdentifierSSN to DimPeople

Use Case Overview
We need to capture SSN as an identifier type for people

Pull Request Number(s) (If applicable)
n/a
Use Case Background
Need to extend for this additional identifier type

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)

---