6 Trigger on Upload Table

This topic describes an overview to trigger the Upload Table.

Triggers would be created on Master Upload Table to insert records into Upload Process Tables on insert of records in upload tables. For uploading, each record is processed from a cursor on process tables.

Guidelines

• If the column for Action code is not present in the master upload table, then the Action code column in process table would be updated as NEW.
• If the upload routine is present for parent and child function IDs, then the master upload table would be the same. In such cases, the FUNCTION_ID column should be present in the master upload table and the same would be inserted into the process table. Hence the same trigger would hold good for all the child screens.
• There would be no separate trigger for any call form function IDs, as call form records do not exist independently.

Refer to the sample Upload Table Trigger documents as follows:

• Maintenance_Upload_Trigger.sql
• Txn_Upload_Trigger.sql