Add additional columns to the historical meter reading, gas quality, and supporting tables using the MeasConfig tool

This procedure will guide you through the process of adding additional columns using the MeasConfig tool.

AVEVA has provided an example of additional column set up. For more information refer to Configure additional columns in the historical data tables.

Columns can be added to the history tables (for example, hourlyMeterReading and dailyMeterReading) without having to modify backend code.

Columns for meter and GQ data are automatically added in the Meter and Gas Quality Data Editors. Columns for other tables may need HMI modifications to display this information correctly.

Any additional column involved in gas calculations or complex validation rules, such as combined C5 plus validation, will require some modifications to the code.

Note: AVEVA recommends that to ensure the codes used are unique, you find the maximum baseline code used and add 10,000 to that value. This will ensure that collisions are avoided. This is the recommendation for all instances where a code is required (for example, the configCode, or when setting the objItemCode).

To add columns to the history tables

1. Select the configDesc table.

2. From the Database dropdown list, select New Module... and enter a configDefine value for the new column.

   Throughout this procedure, we have used CD_NAME. You should choose a name that best reflects the column you are trying to create.

3. Select Insert.

4. Edit the configDefine cell to create a new identifier for your new column. This must be the name chosen in step 2.

5. Enter a configName that describes your new column.

6. Enter a unique configCode.

7. Set the booleanValue to Y so that the other files will be loaded.

8. Create the associated tableColumnDesc data for the extra column.

   Your new column should meet the following requirements:

   • Ensure the column does not contain a 1 at the end. Other numbers are fine.

   • Set the generateMacros column to Y.

   • Ensure that each column added has a unique columnOrder and tableColumnCode.

     Note: To view these extra columns in the AVEVA Measurement Advisor client, you must set the inHMI column to Y.

9. If you wish to validate the new column or to provide a default estimation, navigate to Select Table and choose the tableColumnDesc.alterValidation and tableColumnDesc.alterEstimation tables.

10. Select Insert to create the tableColumnDesc.alterValidation and tableColumnDesc.alterEstimation files for your new column.

    For more information, refer to Configure additional columns in the historical data tables.

11. Add properties to the objItemDesc table.

    If you do not want to validate the new column, then you do not have to create the associated files.

    • objItemDefine should following the naming conventions described in Understand the extra column examples.

    • Set the objitemCode to a code that is currently not used by objItemDesc.

    • Enter the name you used for the columnName in the tableColumnDesc in the module field.

    • For the numericSetName, enter the appropriate numeric set.

      In the Unit Summary in the AVEVA Measurement Advisor client, the numeric set is referred to as the Unit Category. You can view possible numeric set options there.

      For more information, refer to Configure additional columns in the historical data tables.

    • For the objItemDefine column, use the prefixes defined in tableColumnDesc.alterValidation.CD_NAME and tableColumnDesc.alterEstimation.CD_NAME.

    • Set the displayOrder so the validation checks will appear in the desired order when you open the property window.

12. Create objItemSubGroupNames.CD_NAME to create the new subgroups used by the new validation properties. To do so, perform the following steps:

    • Open the objItemSubGroupDesc.

    • Select Insert.

    • Add all of the required subgroups.

13. For objItemDesc.sysdefNumericValue.CD_NAME, select Insert to add rows for the new properties and set the default numericValues to something appropriate for your validation checks and default estimation.

14. For objItemDesc.sysdefDomainValue.CD_NAME, select Insert to add rows for the new properties and set the default numericValues to something appropriate for your validation checks.

15. Select Update Database.

    This will take a few minutes. When complete, a message that states DONE will be displayed on the panel.

16. Open the AVEVA Measurement Advisor client.

17. View the properties that you created, and adjust the displayOrder in measConfig if required.

    If you edit the display order, select Update Database again.

    You will now be able to see the new columns in the Gas Quality or Meter Data Editors if the columns were configured to be included in the AVEVA Measurement Advisor client.