Process MSFAA cancellation and reactivation from federal file.

[JasonCTang]

We are already reading the MSFAA cancellation from the federal file, and updating two fields in the database: the cancellation date column and the new issuing province column.

We will need to inform the student that their MSFAA has been cancelled in the interface through notification.

Federal government can also reactivate an existing cancelled MSFAA number. A "reactivated" MSFAA record just looks like the response to a new "received" MSFAA request from Finastra. In other words, this will look like a regular MSFAA record (cancelled date and new issuing province will be null).

When reactivating an MSFAA, update the signed date and null the "cancellation date" column and "new issuing province" column. Then reassociate MSFAA with any disbursements pending ECERT generation. Lastly, cancel any outstanding UNSIGNED MSFAA numbers for the student for the same offering intensity as the reactivated MSFAA (Full vs Part time) by updating the "cancellation date" and leave the "new issuing province" column blank.

As per the conversation with @JasonCTang, MSFAA reactivation template is not required as the federal government will send them notification. Received the following notification template for MSFAA Cancellation:

---

Template Name: Student - MSFAA cancelled

Subject line of the email: Your MSFAA number has been cancelled – StudentAid BC

Email message:

Hey ((givenNames)) ((lastName)),

Your Master Student Financial Assistance Agreement (MSFAA) has been cancelled by National Student Loan Service Centre (NSLSC).
This will not receive any further funds until your MSFAA is reinstated.

To resolve this issue, contact StudentAid BC by phone at 1-800-561-1818.

---

This is an automated email. Please do not reply. StudentAid BC is committed to protecting your privacy and personal information. For security reasons we do not include account details in automated notifications.

---

Additional Context

• We are already reading the file from Linda.
• We are already updating the fields.
• Cancellation message: "Your Master Student Financial Aid Agreement has been cancelled."
• Reactivation message: "Your previously signed Master Student Financial Aid Agreement has been reactivated."
• Confirmed that reactivation record just looks like a signed record response.

Acceptance Criteria

• Confirm that the cancellation date is being checked in the appropriate places to determine if the MSFAA is "cancelled." Modify if necessary.
• When MSFAA is cancelled and reactivated send notification to student.
• To reactivate the existing MSFAA, update the signed date and null the "cancellation date" column and "new issuing province" column.
• When MSFAA is reactivated, reassociate with all disbursements pending ecert generation for the same offering intensity. (Same logic as when a new MSFAA is generated.)
• When MSFAA is reactivated, Update ANY OTHER active (with null cancellation) MSFAA numbers for the student for the SAME OFFERING INTENSITY by populating the "cancellation date" column and leaving the "new issuing province" column null.
• Write e2e tests.

[sh16011993]

The following were checked to determine if the MSFAA is not "cancelled".