Repository navigation
Schedulers
Archive applications some days after study period end date. The number of days is based on an environment variable: APPLICATION_ARCHIVE_DAYS.
Checks for ATBC processed records. This is not in use and a new path for integration with ATBC is in progress with an API implementation.
Income verification request creation. This file is created with a lifetime sequence and merged into the outbound sequence with files from SFAS.
Income verification response files are processed. Files are received with a sequence number and include files with SFAS records as well.
Imports the disbursement receipt file and sends an email to the finance team. This fails if it does not have a file to read, requiring clearing of failed jobs due to holidays/non-processing days. Check with the finance contact if not sure if it's a day with no file expected (email address from 'Ministry notification for provincial daily disbursement report.')
Generates ECE (CON) file for institutions that have integration. These are picked up by a job to be merged with a CON file generated by SFAS into a single file consumed by integrated institutions.
Read the ECE Response file (CONR) from institutions to update COE and sends email to the integration_contact.
Import federal restrictions snapshot, creates new federal restrictions for any SIMS students and resolves any active federal restrictions when they do not exist on the inbound file.
Generates full-time e-Certs. e-Certs send student and funding information to to NSLSC for disbursement to the student. Different layout from the FT Ecert file that SFAS sends. Only valid ecerts that are within the timeframe will be sent.
Imports e-Cert full-time feedback file with errors. Feedback errors have a description and a code. When they are considered to block funding an email is sent to the ministry and the student to notify them that there is something preventing them from getting funds disbursed. The applications will also have an updated tracker card with a message about it.
Creates the full-time MSFAA pending records file request to be sent to NSLSC. These are picked up by a job to be merged with a MSFAA file generated by SFAS.
Imports the full-time MSFAA confirmations and cancellations. Not a 1:1 match for all pending MSFAAs that were sent out. Shared with SFAS.
Creates the Institution IER12 file. See k) SIMS Operations & Maintenance\Tech Operations\SIMS PSI Integration.docx or SIMS PSI Engagement\General\2025 IER and ECE Workshops\File Information for layout information and troubleshooting the process.
Generates part-time e-Certs. e-Certs send student and funding information to to NSLSC for disbursement to the student. All part-time BC grants are included under a single funding code BCSG.
Imports e-Cert part-time feedback file with errors. Feedback errors have a description and a code. When they are considered to block funding an email is sent to the ministry and the student to notify them that there is something preventing them from getting funds disbursed. The applications will also have an updated tracker card with a message about it.
Creates the part-time MSFAA pending records file request to be sent to NSLSC.
Imports the part-time MSFAA confirmations and cancellations. Not a 1:1 match for all pending MSFAAs that were sent out.
Imports SFAS (legacy) record files into the sfas_ tables. This is a delta file from SFAS so will continue to provide data as activity winds down. While automatic profile matches to legacy don't require this process, any manual legacy student matches require this process to run in order to have their profile updated with the relevant overawards/app history/restrictions.
SIN validation request includes all new sin records that have not received a validation. This file has a sequence in the filename. Harry has a job that automatically renames and re-sequences the file in line with the files being generated by SFAS.
Processes the response files for SIN validation. Two file types are processed ".IS" and ".ISR". ".IS" are the automatic responses based on the submitted data. Some response codes indicate a manual review will occur without sending a new sin validation request, these manual review responses are ".ISR" files. Students are sent a response when they are in the response file.
Monthly incoming file from NSLSC to report on the CSL-PT status for all students. Any matching SIMS profiles will have a new record related to their student profile. This number is used in the part-time assessment.
Requests or creates a supplier maintenance record for all students who have a valid SIN.
Creates an invoice batch for cas-send-invoices of all pending invoices. Before they get sent for invoicing, the batch must be approved by someone with CAS-ExpenseAuthority access.
Connects to the CAS invoicing API. Invoicing is done for all students who have we are responsible for issuing T4As for.
Application changes report integration. Sometimes called the "type b" report. This reports any changes to applications like study end date that have already been sent to NSLSC.
Scheduled application related email notifications:
- PD/PPD Student reminder email 8 weeks before end date.
- Second disbursement reminder email.
- COE required reminder email when study end date is within 10 days.
- Assessment reminder email when assessment is overdue by 7 days.
- CRA file response overdue by 5 days reminder email. Uses env variable
CRA_FILE_OVERDUE_DAYS. - SIN file response overdue by 5 days reminder email. Uses env variable
ESDC_FILE_OVERDUE_DAYS.
Process the e-cert cancellation file(s) and reject the disbursements.
Search T4A files in SFTP and create t4a-upload queue batches.
Generates a file if there are any changes related to student, application or restriction information. This gets sent back to SFAS to ensure the remaining applications are processed according to policy.
Process notifications which are unsent. See the Notifications page in the wiki for more info.
| Scheduler Name | PCT | REPEAT | SEQUENTIAL | ARCHIVING ON ERROR |
|---|---|---|---|---|
| archive-applications | 12:00 AM | Every day. | - | - |
| atbc-response-integration | 10:00 AM | Every day. | - | - |
| cra-process-integration | 10:00 PM | Every day. | - | - |
| cra-response-integration | 9:00 AM | Every day. | NO | YES |
| disbursement-receipts-file-integration | 7:00 AM | Weekdays. | NO | YES |
| ece-process-integration | 12:00 AM | Every day. | - | - |
| ece-process-response-integration | 11:45 PM | Every day. | NO | YES |
| federal-restrictions-integration | 6:00 AM | Every day. | NO | YES |
| full-time-e-cert-integration | 1:00 AM | Weekdays. | - | - |
| full-time-feedback-integration | 12:00 PM | Every day. | NO | NO |
| full-time-msfaa-integration | 2:00 AM | Weekdays. | - | - |
| full-time-msfaa-process-response-integration | 10:15 AM | Every day. | NO | YES |
| ier12-integration | 6:00 AM | Every 30 minutes at :15 and :45 minutes on the hour | - | - |
| part-time-e-cert-integration | 1:00 AM | Every day. | - | - |
| part-time-feedback-integration | 5:00 AM | Every day. | NO | NO |
| part-time-msfaa-process-integration | 1:00 AM | Every day. | - | - |
| part-time-msfaa-process-response-integration | 5:00 AM | Every day. | NO | YES |
| sfas-integration | - | Every 30 minutes at :15 and :45 minutes on the hour | YES | NO |
| sin-validation-process-integration | 7:00 AM | Every day. | - | - |
| sin-validation-response-integration | 7:00 AM | Every day. | NO | YES |
| student-loan-balances-part-time-integration | 11:30 PM | Every day. | NO | YES |
| cas-supplier-integration | 1:00 PM | Weekdays. | - | - |
| cas-invoices-batches-creation | 9:00 PM | Weekdays. | - | - |
| cas-send-invoices | 7:00 PM, 8:00 AM, 1:00 PM | Weekdays. | - | - |
| application-changes-report-integration | 9:00 AM | Every week on Monday. | - | - |
| student-application-notifications | 1:00 AM | Every day. | - | - |
| e-cert-cancellation-response-integration | 9:00 PM | Every week on Sunday(PST Saturday). | NO | NO |
| t4a-upload-enqueuer | 6:00 AM | Every day, from February to May. | NO | YES |
| sims-to-sfas-integration | 5:00 PM + 4hrs | Every 4 hours on the hour starting at midnight UTC. | - | - |
Parameters:
- pollingRecordsLimit : Maximum number of CAS Integration records to process per schedule.
Sample payload:
{
"pollingRecordsLimit": 2000
}
Parameters:
- modifiedSince (optional): Inclusive date since the application or student data was modified. Includes all updates until the job execution date/time to ensure that the extract is current. The date should be in ISO format (YYYY-MM-DD). Can be no earlier than 1 year in the past. If not provided, it will pick up records for the previous day from the beginning of the day until mignight.
- institutionCode (optional): Institution code to limit applications to a specific institution.
Sample payload:
{
"modifiedSince": "2026-06-01",
"institutionCode": "ABCD"
}
Sample jobOptions (overrides default schedule options and runs a single job once right now)
{
"jobId": "manual-ier12-avad-20260820-001",
"attempts": 1,
"repeat": {
"every": 1000,
"limit": 1
}
}
Parameters:
- maxFileUploadsPerBatch : Maximum number of uploads per batch.
Sample jobData payload:
{
"maxFileUploadsPerBatch": 100
}
To do a manual job run (e.g. ier12-integration for a specific time frame/institution), do the following:
- Navigate to the Queues Dashboard.
- Select the queue from the left hand menu.
- Click the DELAYED tab.
- Find an existing job and click the Duplicate icon. Important: If you just edit an existing job, the "normal" scheduled job is replaced with the edited version.
- Add the jobData (as required), modify the jobOptions (as required) and click Duplicate.
- Click the Promote icon.
- Check the job progress under Active or Completed.