SIMS icon indicating copy to clipboard operation
SIMS copied to clipboard
verified publisher icon bcgov

Save fields from parttime assessment in Camunda to SIMS database

Open JasonCTang opened this issue 1 year ago • 2 comments

The Enterprise Data Warehouse team requires additional fields from the parttime assessment in Camunda to be saved to the database. Save the following fields from Camunda to the student_assessments table:

  • calculatedDataDependants11YearsOrUnder
  • calculatedDataDependants12YearsOverOnTaxes
  • calculatedDataPartner1TotalIncome
  • calculatedDataStudentTotalIncome

Acceptance Criteria

  • [ ] Camunda variables saved into the assessment_data column of the table, student_assessment

JasonCTang avatar Aug 15 '24 18:08 JasonCTang

Removed the following fields as they are not currently available in Camunda. Will create a ticket for future implementation as it will require modifications in Camunda.

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

JasonCTang avatar Aug 21 '24 18:08 JasonCTang

Removed the following fields after business discussed with Petr.

  • awardEligibilityCSPT
  • awardEligibilityCSGP
  • awardEligibilityCSGD
  • awardEligibilityBCAG
  • awardEligibilitySBSD
  • awardEligibilityCSLP

JasonCTang avatar Aug 21 '24 18:08 JasonCTang

Spoke with Petr @ EDW and updated to workflow_data from assessment_data

CarlyCotton avatar Aug 28 '24 19:08 CarlyCotton

Per lather - will combine with other EDW ticket re childcare changes and close this one.

CarlyCotton avatar Sep 12 '24 17:09 CarlyCotton

Added to #3560 - closing this ticket.

CarlyCotton avatar Sep 23 '24 20:09 CarlyCotton