Update Utility - STUPSU

The SubTracker (ST) Update Utility (STUPSU) page is used to perform additional updates to the Imported Data and/or the Attendance records. It is limited to Updates and Deletes (based on the Action field), and it is limited to performing those actions against SubTracker tables only (based on the Data Set field). This page is optional, and is based on the complexity of the implementation.

Sequence #: Each statement needs its own sequence number. This number is nothing more than a unique identifier for the record.
Description: Description of your record.
Global Run Link ID: This is a way to run groups of SQL statements at one time. When the SubTracker (ST) Run Client-Defined SQLs (STUTRS) utility is run, the statements can be run by Sequence or by Global Run Link ID. Most clients will make some sort of "AFTERIMPORT" Global Run Link ID, as well as an "AFTERATTEND" ID, allowing two sets of statements to be run with ease. Any text may be typed in this field.
Global Run Order: The order in which this update statement will be processed if it is selected to process with a group of other statements as well.
Action: Either Update, or Delete From.
Data Set: The table against the SQL statement is written.
Statement: The SQL statement. Note: The "UPDATE <TABLENAME>" or "DELETE FROM <TABLENAME>" is assumed. The statement would begin with the text immediately after this section. Long SQL statements are automatically divided by the system and stored in multiple columns in the table.  The columns are:  st_stmt, st_stmt2, st_stmt3, and st_stmt4.
Notes: Any notes to include on this record. Typically used for an explanation of the purpose of this record.