DV-510 ⁃ Add "UserInput" attribute into the Trigger Table when its created in Process Images and Historical Importer

I think this task is going to be a time-consuming one, but very important.

While working on https://pantheracorporation.atlassian.net/browse/MAIN-754, we have come to realize that the “UserInput” attribute doesn’t get created in the Trigger Table upon processing in the Process Images or Historical Importer modules (and it definitely should). It gets created in the CA sheet and TS sheet (as expected), but it doesn’t get created in the Trigger Table :disappointed:

We need to add this attribute into the trigger table as soon as the dataset is created in Process Images and Historical Importer (it will be filled with the user’s email address, just as it does in the CA and TS tables).

NB: I imagine adding an attribute to the trigger table is going to have knock on effects on other modules- because suddenly we’ll have another column in the trigger table…, however, I believe its worth it because that is really important information to have recorded in the trigger table. Other modules that I think may need to be adjusted once we add this attribute to the trigger table include: Tables, Bulk Data Export, Independent Captures, Intelligent Queries, Metadata Backup (modules that pushed databases to Redshift), to name a few (list not exhaustive).

┆Issue is synchronized with this Jira Task by Unito

pantheracorp / PantheraIDS_Features

DV-510 ⁃ Add "UserInput" attribute into the Trigger Table when its created in Process Images and Historical Importer #468