Student Overawards - bcgov/SIMS GitHub Wiki
What it is?
A complete history of money amounts that the student owned one day(or still owns) alongside what was paid back by the same student.
Which types of records are kept
- Total balance imported from SFAS (only CSLF, BCSL)
- When the student creates his account
- When the student already has an account and SFAS tells SIMS that there was a change
- Manual entries added by the Ministry
- Allow adding deductions once the student paid his debt
- Allow fixing a wrong entered value
- Overawards generated during reassessments where the student already received more money than he was entitled to.
- Deductions executed when e-Certs are generated and the student has some overaward balance.
Overawards creation during reassessments
Please note that the examples below are considering that CSLF and BCSL can potentially be part of the first and second disbursements even that in the real-world scenario, accordingly to the Ministry policies, they can be part of only the first one or only the second one.
Assuming the below disbursements for an application ABC, assuming that the application ABC was never reassessed, and assuming the first disbursement was already sent.
| Application ABC | Loan | $ Amount | e-Cert |
|---|---|---|---|
| Disbursement 1 | CSLF | 5000 | Sent |
| BCSL | 750 | Sent | |
| Disbursement 2 | CSLF | 5000 | Pending |
| BCSL | 750 | Pending |
Total money already received by the student
- CSLF: 5000
- BCSL: 750
Assuming that the application ABC needed to be reassessed, the new values are shown below.
| Application ABC | Loan | $ Amount | Money already received |
|---|---|---|---|
| Disbursement 1 | CSLF | 2000 | 2000 |
| BCSL | 1000 | 750 | |
| Disbursement 2 | CSLF | 2000 | 2000 |
| BCSL | 1000 | 0 |
While calculating the new values, the $5000 already paid for the CSLF will be deducted from newly generated disbursements. In the event that the student already received more money than what he is now entitled to receive, the extra money received will generate an entry in the overawards table.
| Type | $ amount | Loan | |
|---|---|---|---|
| Reassessment overaward | 1000 | CSLF | Application ABC reassessment |
Overawards deductions during e-Cert generation
Please note that the examples below are considering that CSLF and BCSL can potentially be part of the first and second disbursements even that in the real-world scenario, accordingly to the Ministry policies, they can be part of only the first one or only the second one.
Assuming a student with the below balance history already in place.
| Type | $ amount | Loan | |
|---|---|---|---|
| Legacy overaward | 500 | CSLF | Imported from SFAS |
| Reassessment overaward | 1750 | BCSL | Generated during a reassessment |
| Reassessment overaward | 800 | CSLF | Generated during a reassessment |
| Manual record | -500 | CSLF | Added by a Ministry user manually |
Current total balance per loan
- CSLF: $800
- BCSL: $1750
Assuming the below disbursements for an application ABC waiting to be disbursed.
| Application ABC | Loan | $ Amount | e-Cert |
|---|---|---|---|
| Disbursement 1 | CSLF | 2000 | Pending |
| BCSL | 1000 | Pending | |
| Disbursement 2 | CSLF | 2000 | Pending |
| BCSL | 1000 | Pending |
Assuming the below disbursements for an application ABC when the first disbursement was already sent.
| Application ABC | Loan | $ Amount | Overaward deducted | e-Cert | e-Cert Amount |
|---|---|---|---|---|---|
| Disbursement 1 | CSLF | 2000 | 800 | Sent | 1200 |
| BCSL | 1000 | 1000 | Sent | 0 | |
| Disbursement 2 | CSLF | 2000 | Pending | ||
| BCSL | 1000 | Pending |
How the student overaward balance is impacted.
| Type | $ amount | Loan | Application |
|---|---|---|---|
| Legacy overaward | 500 | CSLF | |
| Reassessment overaward | 2000 | BCSL | Some past application prior to ABC |
| Reassessment overaward | 500 | CSLF | Some past application prior to ABC |
| Manual record | -500 | CSLF | |
| Award deducted | -800 | CSLF | Application ABC - First disbursement |
| Award deducted | -1000 | BCSL | Application ABC - First disbursement |
Updated student balance after first disbursement.
- CSLF: $0
- BCSL: $750
Assuming the below disbursements for an application ABC when the second disbursement was already sent.
| Application ABC | Loan | $ Amount | Overaward deducted | e-Cert | e-Cert Amount |
|---|---|---|---|---|---|
| Disbursement 1 | CSLF | 2000 | 800 | Sent | 1200 |
| BCSL | 1000 | 1000 | Sent | 0 | |
| Disbursement 2 | CSLF | 2000 | 0 | Sent | 2000 |
| BCSL | 1000 | 750 | Sent | 350 |
How the student overaward balance is impacted.
| Type | $ amount | Loan | Application |
|---|---|---|---|
| Legacy overaward | 500 | CSLF | |
| Reassessment overaward | 2000 | BCSL | Some past application prior to ABC |
| Reassessment overaward | 500 | CSLF | Some past application prior to ABC |
| Manual record | -500 | CSLF | |
| Award deducted | -500 | CSLF | Application ABC - First disbursement |
| Award deducted | -1000 | BCSL | Application ABC - First disbursement |
| Award deducted | -750 | BCSL | Application ABC - Second disbursement |
Updated student balance after second disbursement.
- CSLF: $0
- BCSL: $0
How the disbursement records looks like for a reassessments with overawards deductions
The below example is completely decoupled from the previous ones above just to give an idea about how the final award amount can be impacted.
| Application ABC | Loan | $ Amount | Money already received | Overaward deducted | e-Cert | e-Cert Amount |
|---|---|---|---|---|---|---|
| Disbursement 1 | CSLF | 2000 | 750 | 1000 | Sent | 350 |
| BCSL | 1000 | 1000 | 0 | Sent | 0 | |
| Disbursement 2 | CSLF | 2000 | 250 | 0 | Sent | 1750 |
| BCSL | 1000 | 0 | 0 | Sent | 1000 |
When the amounts and deductions are calculated
| Column name | Process |
|---|---|
| Amount | Assessment calculation |
| Money already received | Assessment calculation |
| Overaward deducted | Disbursement/e-Cert generation |
| e-Cert Amount | Disbursement/e-Cert generation |
Please note that prior to the Overaward deducted and e-Cert Amount columns are finally calculated, the system will also apply any restriction that can potentially affect the final amounts, for instance, any restriction that stops the BC funding or when the student reaches some maximum allowed award for his lifetime.