AVEVA™ Measurement Advisor

Understand the extra column examples

Save PDF

Understand the extra column examples

Save PDF

Last UpdatedDec 29, 2025
2 minute read

The files used to add a new column to the gas quality (GQ) or meter tables are provided in the following table.

Note: You do not need to add the validation or estimation properties (objItem) if you do not want to validate or estimate the data.

Required file for GQ records	Description
configDesc.CD_ADD_EXTRA_GQ_COLUMN.xml	A configDesc item to load all of the CD_ADD_EXTRA_GQ_COLUMN files.
tableColumnDesc.CD_ADD_EXTRA_GQ_COLUMN.xml	A row that defines the extra GQ column.
tableColumnDesc.alterValidation.CD_ADD_EXTRA_GQ_COLUMN.xml	Additional information for validation. These are the objItemDefine prefixes linking the new column to the validation properties.
tableColumnDesc.alterEstimation.CD_ADD_EXTRA_GQ_COLUMN.xml	Additional information for estimation. These are the objItemDefine prefixes linking the new column to the default estimation property.
objItemSubGroupDesc.CD_ADD_EXTRA_GQ_COLUMN.xml	Any new object item subgroups for validation.
objItemDesc.CD_ADD_EXTRA_GQ_COLUMN.xml	Any new properties for validation. To properly validate the new column, you should have the following components: Reasonability limit check — enable, low/high values, severity Operational limit check — enable, low/high values Historical average check — enable, tolerance, threshold Daily vs aggregation check — enable, tolerance Frozen value check — enable, tolerance A default estimation property containing the default value
objItemDesc.sysdefDomainValue.CD_ADD_EXTRA_GQ_COLUMN.xml	These are the default dropdown values for the validation severity.
objItemDesc.sysdefNumericValue.CD_ADD_EXTRA_GQ_COLUMN.xml	These are the default values for the validation thresholds and tolerances. Also, the value for the default estimation if one is not specified.

Required file for meter records	Description
configDesc.CD_ADD_EXTRA_MTR_COLUMN.xml	A configDesc item to load all of the CD_ADD_EXTRA_MTR_COLUMN files.
tableColumnDesc.CD_ADD_EXTRA_MTR_COLUMN.xml	A row that defines the extra column.
tableColumnDesc.alterValidation.CD_ADD_EXTRA_MTR_COLUMN.xml	Additional information for validation. These are the objItemDefine prefixes linking the new column to the validation properties.
tableColumnDesc.alterEstimation.CD_ADD_EXTRA_MTR_COLUMN.xml	Additional information for estimation. These are the objItemDefine prefixes linking the new column to the default estimation property.
objItemSubGroupDesc.CD_ADD_EXTRA_MTR_COLUMN.xml	Any new object item subgroups for validation.
objItemDesc.CD_ADD_EXTRA_MTR_COLUMN.xml	Any new properties for validation. To properly validate the new column, you should have: Reasonability limit check — enable, low/high values, severity Operational limit check — enable, low/high values Historical average check — enable, tolerance, threshold Rate of change check — enable, tolerance, severity Frozen validation — enable, tolerance For hourly validation of non-hourly meters: Hourly reas check — enable, low/high values Hourly oper check — enable, low/high values Hourly frozen check — enable, tolerance Hourly vs aggregation check - enable, tolerance, threshold For daily validation of non-daily meters: Daily reas check — enable, low/high values Daily oper check — enable, low/high values Daily frozen check — enable, tolerance Daily vs aggregation check — enable, tolerance, threshold A default estimation property containing the default value.
objItemDesc.sysdefDomainValue.CD_ADD_EXTRA_MTR_COLUMN.xml	These are the default dropdown values for the validation severity.
objItemDesc.sysdefNumericValue.CD_ADD_EXTRA_MTR_COLUMN.xml objItemDomainDesc.CD_ADD_EXTRA_MTR_COLUMN.xml	Additional information for estimation. These are the objItemDefine prefixes linking the new column to the default estimation property.

AVEVA™ Measurement Advisor

Understand the extra column examples

Table of Contents

Understand the extra column examples

Related Links