Submissions receives data from the student management system and, optionally, from data uploaded from Excel spreadsheets.
Attention. Submissions validates the SmsRef for invalid characters, such as / and \, when retrieving data from the student management system or uploading data from Excel spreadsheets.
Submissions holds a copy of the data from the student management system in the SMS table that enables Submissions to detect changes to the data on the student management system such as data that has been created, updated, or deleted.
Submissions has the following tables:
- SMS table
- The SMS table is a copy of the data from the student management system. Submissions compares the data in the SMS table with the data in the student management system to decide whether to report a new, changed, or removed record to TCSI.
- Staging table
- The staging table has data with status information, which is visible in Submissions. Therefore, if Submissions needs to report a new record, the record is added to the staging table to be approved and submitted to TCSI.
- TCSI table
- The TCSI table contains the data submitted to TCSI. Therefore, on submitting a record to TCSI, Submission's TCSI table is updated with the new record.
The diagram Submissions table illustrates that the record Campus A has been created in the student management system and is waiting in the staging table to be approved and submitted to TCSI.
The diagram Data flow chart illustrates how Submissions data created, updated, or deleted in the student management system is compared with the data in the staging table and then reported to TCSI.
