Customize Data saved at P&ID Reports Database Tables after Consolidation Routine is Executed

The project administrator can setup AVEVA P&ID to execute post processing SQL scripts after a consolidation routine is completed.

To do this, the project administrator must create a customized SQL script to modify the outcome of the most recent consolidation. The customized SQL script must be saved and registered on the P&ID Customized Reports tab, located in the P&ID Reports Utility. Refer to Create Reports with User Defined Queries.

To execute the customized SQL script, the project administrator must create a user defined directive named USER_EXECUTE_SQL_AFTER_COMMIT on the Miscellaneous – Settings Sub-Category of the AVEVA P&ID Project Administration program. Refer to Miscellaneous Configuration Category.

The value UPDINST is the name of the customized SQL script registered by the project administrator in the P&ID Reports Utility.