Finastra Part-time File Review Changes

Compilation of bugs and changes needed after Finastra part-time file tests.

e-Cert tuition remittance

The system is saving to the column disbursement_schedules.tuition_remittance_effective_amount when it should actually be saving the minimum value between tuition_remittance_requested_amount and max calculated tuition remittance. Source code reference: e-cert-generation.service.ts

File name change

The name of the file that SIMS generates needs to be different than the one generated by SFAS. Waiting for Finastra to provide us with the file names.

File max line length

The total line length for the header, record, and footer must be adjusted to be 756.

Field of study

The "field of study" should be sent as a text but it is currently being sent as a number. So, considering the field of study as 32, it should be sent as "32 " instead of "0032".

Grants

The e-Cert generation is trying to find a grant named CSGPT but the workflow is actually generating the grant as CSPT and also the position of the grants is not correct.

[x] Rename CSGPT to CSPT on the e-Cert generation. Reference file e-cert-integration-model.
[x] Ensure that Canada grants CSGP, CSPT, and CSGD are in the right position on the e-Cert files, per the image below.
[x] Ensure that line 39 represents the total from lines 40, 42, 43, and 45. This should already be happening but because of the issue with CSPT, it may be wrong when the CSPT is present in the awards.

Feedback file

[ ] SIMS is expecting the file name to be EDU.PBC.ECERTSFB.PT.* when it needs to be a pattern to capture file names as TEDU.PBC.NEW.ECERTSFB.PT.20230511.001.
[ ]

Acceptance Criteria

[ ] See above
[ ]

bcgov / SIMS