Add new element State Appropriation Methods to the IDS (see CEDS-Elements ticket #29)

[aemnathanclinton]

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)
Nathan Clinton

Authoring Organization(s)
AEM Corp

Email Address
[email protected]

Target Data Needed
4/21/2020

Use Case Title
Provide a concise description that defines the use case.
Support EDFacts file spec FS207 by adding a new element to track State Appropriation Methods for charter schools

Use Case Overview
Provide a concise, high-level description of the actions of the use case. While being concise, the description should cover all possible actions for the use case.
Refer to EDFacts file spec FS207. This is in support of Generate.

Use Case Background
Provide information related to why these changes/additions are needed.
See CEDS-Elements ticket #29

Components Affected

CEDS Integrated Data Store (complete IDS Design Overview Table)

---

INTEGRATED DATA STORE DESIGN OVERVIEW

Description of Proposed Changes
Provide a concise description of the proposed changes.
Add new Ref table called RefStateAppropriationMethod.
Add foreign key reference to RefStateAppropriationMethod to K12School table