Modify Camunda workflow to generate individual allowed childcare amounts & save to database (EDW)

[JasonCTang]

User Story Currently, Camunda combines the childcare allowed amounts between dependents 11 & under and dependents 12 & over. EDW needs these values separately, but will live without it for the time being.

• 11 years and under child care allowed amount as calculated on assessment
• 12 years and over child care allowed amount as calculated on assessment

Acceptance Criteria

• [ ] Update Camunda variables saved into the workflow_data column of the table, student_assessment to include:
  • calculatedDataDependants11YearsOrUnder
  • calculatedDataDependants12YearsOverOnTaxes
  • calculatedDataPartner1TotalIncome
  • calculatedDataStudentTotalIncome
  • calculatedDataTotalDaycareCosts11YearsOrUnder (NEW IN THIS TICKET)
  • calculatedDataTotalDaycareCosts12YearsOrOver (NEW IN THIS TICKET)
• [ ] Create calculatedDataTotalDaycareCosts12YearsOrOver=

if calculatedDataDaycareCosts12YearsOrOver > 0
  then min(((offeringCourseLoad/100) * dmnPartTimeProgramYearMaximums.limitWeeklyChildCare 
    * calculatedDataOfferingWeeksMultiplier * calculatedDataDependants12YearsOverOnTaxes),
  calculatedDataDaycareCosts12YearsOrOver)
else 0

• [ ] Create calculatedDataTotalDaycareCosts11YearsOrUnder=

if calculatedDataDaycareCosts11YearsOrUnder > 0
  then min(((offeringCourseLoad/100) * dmnPartTimeProgramYearMaximums.limitWeeklyChildCare 
    * calculatedDataOfferingWeeksMultiplier * calculatedDataDependants11YearsOrUnder),
  calculatedDataDaycareCosts11YearsOrUnder)
else 0

• [ ] Update calculatedDataTotalChildCareCost= calculatedDataTotalDaycareCosts12YearsOrOver + calculatedDataTotalDaycareCosts11YearsOrUnder

Technical

• [ ] Use the code in the ACs.
• [ ] No new E2E expected. Ensure the current ones are passing.