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

[bidyashish]

• 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

• [x] 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)

• [x] Create and update the variables below in the parttime-assessment- bpmn for 2022-2023, 2023-2024 and 2024-2025

• [x] Create calculatedDataTotalDaycareCosts12YearsOrOver=

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

• [x] Create calculatedDataTotalDaycareCosts11YearsOrUnder=

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

• [x] Update calculatedDataTotalChildCareCost= calculatedDataTotalDaycareCosts12YearsOrOver + calculatedDataTotalDaycareCosts11YearsOrUnder

Technical

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

Local E2E test case

Sample Workflow Data for 1 child under 11 years.

{
    "calculatedData": {
        "familySize": 2,
        "pdppdStatus": false,
        "parentalAssets": null,
        "studentTotalIncome": 232323,
        "totalChildCareCost": 200,
        "partner1TotalIncome": null,
        "parentalContribution": null,
        "studentMSOLAllowance": null,
        "dependantChildQuantity": null,
        "dependantInfantQuantity": null,
        "totalEligibleDependents": 1,
        "totalNonEducationalCost": null,
        "dependants11YearsOrUnder": 1,
        "partnerStudentStudyWeeks": null,
        "studentMaritalStatusCode": null,
        "parentDiscretionaryIncome": null,
        "parentalAssetContribution": null,
        "dependantTotalMSOLAllowance": null,
        "dependants12YearsOverOnTaxes": 0,
        "dependantPostSecondaryQuantity": null,
        "totalDaycareCosts12YearsOrOver": 0,
        "dependantChildInDaycareQuantity": null,
        "totalDaycareCosts11YearsOrUnder": 200,
        "dependantDeclaredOnTaxesQuantity": null
    }
}

• Note: Update Camunda Modeler to 8.6 for all 3 part time assessment files.

[sonarcloud[bot]]

Quality Gate passed

Issues
0 New issues
0 Accepted issues

Measures
0 Security Hotspots
0.0% Coverage on New Code
0.0% Duplication on New Code

See analysis details on SonarCloud

[github-actions[bot]]

Backend Unit Tests Coverage Report

Totals
Statements:	22.3% ( 3697 / 16575 )
Methods:	10.31% ( 212 / 2057 )
Lines:	25.63% ( 3207 / 12513 )
Branches:	13.87% ( 278 / 2005 )

[bidyashish]

• Note: Update Camunda Modeler to 8.6 for all 3 part time assessment files giving lots of changes.

[github-actions[bot]]

E2E Workflow Workers Coverage Report

Totals
Statements:	65.43% ( 583 / 891 )
Methods:	59.26% ( 64 / 108 )
Lines:	68.54% ( 464 / 677 )
Branches:	51.89% ( 55 / 106 )

[github-actions[bot]]

E2E Queue Consumers Coverage Report

Totals
Statements:	85.92% ( 1220 / 1420 )
Methods:	87.86% ( 123 / 140 )
Lines:	86.83% ( 1035 / 1192 )
Branches:	70.45% ( 62 / 88 )

[github-actions[bot]]

E2E SIMS API Coverage Report

Totals
Statements:	66.45% ( 5642 / 8490 )
Methods:	63.9% ( 692 / 1083 )
Lines:	70.48% ( 4445 / 6307 )
Branches:	45.91% ( 505 / 1100 )