Save fields from parttime assessment in Camunda to SIMS database (EDW)

bcgov / SIMS

Student Information Management System. Post-Secondary Student Financial Aid System

Apache License 2.0

25 stars 14 forks source link

Save fields from parttime assessment in Camunda to SIMS database (EDW) #3636

Closed JasonCTang closed 1 month ago

JasonCTang commented 2 months ago

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 workflow_data column of the table, student_assessment

JasonCTang commented 2 months ago

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 commented 2 months ago

Removed the following fields after business discussed with Petr.

awardEligibilityCSPT
awardEligibilityCSGP
awardEligibilityCSGD
awardEligibilityBCAG
awardEligibilitySBSD
awardEligibilityCSLP

CarlyCotton commented 2 months ago

Spoke with Petr @ EDW and updated to workflow_data from assessment_data

CarlyCotton commented 1 month ago

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

CarlyCotton commented 1 month ago

Added to #3560 - closing this ticket.