Directly link FinancialAccount and FinancialAccountLocal tables #91
Description
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): CJ Gilbert, CEPI, Michigan
Email Address: GilbertC6@michigan.gov
Use Case Title
Directly link FinancialAccount and FinancialAccountLocal tables
Use Case Overview
Add a foreign key FinacialAccountId to FinancialAccountLocal table in the IDS (and add the corresponding relationship in the Ontology) so that FinancialAccountLocal can work as a sub of FinancialAccount as intended.
Use Case Background
Michigan has a need to connect the employment with a specific staff member with the Financial Account Local Function Code used to fund that assignment, however we do not need to link it to a specific OrganizationCalendarSession. We reached out to Nathan Clinton, who then reached out to Duane Brown to help find a resolution, and he discovered part of the problems was a missing link: "I think we are missing a link from Financial Account to Financial Account Local since Financial Account Local is supposed to be a sub of Financial Account indicating the local codes used that equal the federal codes. This should probably be done by placing the Financial Account Id on the Financial Account Local table."
Components Affected
• CEDS Integrated Data Store (complete IDS Design Overview Table)
• CEDS Ontology
INTEGRATED DATA STORE DESIGN OVERVIEW
Description of Proposed Changes
Add a foreign key FinancialAccountId to the FinancialAccountLocal table in the IDS
ONTOLOGY DESIGN OVERVIEW
Description of Proposed Changes
Add the appropriate relationship between FinancialAccountId and FinancialAccountLocal