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 acronymSMS 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:
- acronymSMS table
- The acronymSMS table is a copy of the data from the student management system. Submissions compares the data in the acronymSMS table with the data in the student management system to decide whether to report a new, changed, or removed record to acronym taxi.
- 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 acronym taxi.
- acronym taxi table
- The acronym taxi table contains the data submitted to acronym taxi. Therefore, on submitting a record to acronym taxi, Submission's acronym taxi table is updated with the new record.
The diagram Submissions table illustrates that the record Campus eh has been created in the student management system and is waiting in the staging table to be approved and submitted to acronym taxi.
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 acronym taxi.
