Review organization status tables for addition to FactDirectory schema #116
Description
Author(s)
Kyle Kwaiser
Authoring Organization(s)
U of Michigan / CEPI
Use Case Title
Fields identifying the status of an organization need to be represented within the FactDirectory area of the CEDS DW model.
Use Case Overview
There appear to be a number of organization status tables that are not yet joined into the FactDirectory table. For example:
- DimOrganizationTitleIStatuses
- DimPsInsitutionStatuses
Components Affected
CEDS Data Warehouse (complete DW Design Overview Table)