CAD Publish and Attach Events are not Logged Historically in the Tririga DB

IBM Ticket - TS016365859

As established in the above ticket, the CAD_DRAWING table stores a row per floor with information like created_by, created_date, modified_by, and modified_date, and is updated any time a user attaches a floor plan in CAD Integrator. It was expected that this row maintained its traceability over time, meaning that if a user created a new floor plan for ABC-Floor1, the created_by would be set to their user, and the created_date would be set to that dates tamp. Then if another user attached the same floor plan later, it would leave the created_by and created_date fields AS IS, and update the modified_by and _modified_date accordingly. This in fact is not how it works today. Today CI will delete the original row and insert a new row every time you reattach a floor plan, meaning you lose the information for who originally created it.

Additionally, we explored the DRAWING_HEADER table. This table stores similar information, but is tied to the Publish events that come from CI, instead of the Attach events. Additionally, this table stores up to two rows per floor, which will always be the two most recent publish events, meaning once a floor plan has been published more than two times, the original publish event is lost.

IBM should either make it be that these tables hold a more accurate account of past events against a floor plan, or create a log table to store this information so that clients may monitor this information accordingly. This may seem trivial, but for large implementations with 40+ CAD users, its imperative to have traceability back to the root of an issue so that it can be addressed quickly and accurately.