Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Feature] Add MBES line numbers to Budget #4648

Open
4 tasks
thetif opened this issue Mar 29, 2023 · 0 comments
Open
4 tasks

[Feature] Add MBES line numbers to Budget #4648

thetif opened this issue Mar 29, 2023 · 0 comments
Labels
Development Issues for the dev team resolve medium

Comments

@thetif
Copy link
Contributor

thetif commented Mar 29, 2023

Description and related issues

In order to build the MDBT table, we need to store the MBES line numbers for the different cost categories. These are based on the APD Type, Funding Category, Fed-State Split, and Cost Category. Jerome created this flow diagram to explain which line number goes with what configuration of the above.

MDBT/MBES Classification Flow

We need to store these values in the budget under the activityTotals because they will be different for each activity. They should be determined as part of the budget calculation.

Their schemas should look like

// HITECH (values are always the same regardless of split)
const budgetSchema = new mongoose.Schema({
	...,
        activityTotals: [{
                ...,
	        mbes: {
		        statePersonnel: String, // always 24C
		        expenses: String, // always 24C
		        contractors: String, // always 24D
		        epAmt: String, // always 24E
		        ehAmt: String // always 24F
                }
	}]
});

// MMIS
const budgetSchema = new mongoose.Schema({
	...,
        activityTotals: [{
                ...,
	        mbes: {
		        statePersonnel: String, // DDI - 2A, M&O - 5A
		        expenses: String, // DDI - 2A, M&O - 5A
		        contractors: String, // DDI 2B, M&O - 5B
		        interagencyCost: String // only for M&O - 5C
                }
	}]
})

Acceptance criteria

  • create constants for MBES line numbers
  • update activityTotals in the Budget schema to save these values
  • update the budget calculation to calculate the correct line number based on the APD Type and Funding Category
  • save the MBES line numbers to the Budget

Testing criteria

Given When Then Covered
a HITECH APD the activity has any funding source mbes should be set to
mbes: { statePersonnel: '24C', expenses: '24C', contractors: '24D', epAmt: '24E', ehAmt: '24F' }
a MMIS APD the activity has funding category DDI mbes should be set to
mbes: { statePersonnel: '2A', expenses: '2A', contractors: '2B', interagencyCost: '' }
a MMIS APD the activity has funding category M&O mbes should be set to
mbes: { statePersonnel: '5A', expenses: '5A', contractors: '5B', interagencyCost: '5C' }
@thetif thetif added Development Issues for the dev team resolve medium labels Mar 29, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Development Issues for the dev team resolve medium
Projects
None yet
Development

No branches or pull requests

1 participant