Update ACMDataMapping​.json

ACMDataMapping.json specifies the mapping of EFM buffer database columns to the parameters of the stored procedures that are called by monitorMeasurementBufferDB to send transformed data to AVEVA Measurement Advisor. The table below lists the keys included in ACMDataMapping.json and their descriptions. A sample ACMDataMapping.json follows.

The mapping for writeCombinedMtrConfigGQRecordBuffer is different from the mappings for the other stored procedures:

• It only requires a mapping for the columns in the ACM_Import table, tblAsiEFMConfigRecords, that do not have the same name as a parameter in the corresponding AVEVA Measurement Advisor stored procedure (writeCombinedMtrConfigGQRecord) that receives the data.

The mappings for the rest of the transfers—writeCombinedMtrGQRawHyBuffer, writeCombinedMtrGQRawDyBuffer, writeObjectEventBuffer—will only transfer the data columns that are defined in the mapping file.

Note: For detailed information on the data fields listed in the table below, see the related stored procedure that processes the data. These are documented in the AVEVA Measurement Advisor Developer Guide (for on-premises installations). The topic names are provided in the table below.

Sample ACMDataMapping.json File

{

"ACMDataConversion": {

"writeCombinedMtrGQRawHyBuffer": {

"MA_Column": "ACM_Column",

"energy": "Energy",

"flowTime": "FlowMinutes",

"intermediateValue": "COALESCE(Extension,RawVolume)",

"localTime": "FORMAT([RecordTime],'MM/dd/yy HH:mm:ss')",

"objName": "MeterID",

"pressure": "StaticPressure",

"rawValue": "COALESCE(DifferentialPressure,Pulses)",

"rawValueAccum": "AccumulatedPulses",

"temperature": "Temperature",

"timeFormat": "'%m/%d/%Y%T'",

"volume": "Volume",

"volumeAccum": "AccumulatedVolume",

"Ar": "Argon",

"CO": "CO",

"CO2": "CO2",

"H2": "H2",

"H2O": "H2O",

"H2S": "H2S",

"He": "Helium",

"N2": "N2",

"O2": "O2",

"C1": "Methane",

"C2": "Ethane",

"C3": "Propane",

"iC4": "iButane",

"nC4": "nButane",

"iC5": "iPentane",

"nC5":"nPentane",

"C6": "nHexane",

"C7": "nHeptane",

"C8": "nOctane",

"C9": "nNonane",

"C10": "nDecane",

"neoC5": "NeoPentane",

"heatingValue": "BTU",

"specificGravity": "SpecificGravity"

},

"writeCombinedMtrGQRawDyBuffer": {

"MA_Column": "ACM_Column",

"energy": "Energy",

"flowTime": "FlowMinutes",

"intermediateValue": "COALESCE(Extension,RawVolume)",

"localTime": "FORMAT([RecordTime],'MM/dd/yy HH:mm:ss')",

"objName": "MeterID",

"pressure": "StaticPressure",

"rawValue": "COALESCE(DifferentialPressure,Pulses)",

"rawValueAccum": "AccumulatedPulses",

"temperature": "Temperature",

"timeFormat": "'%m/%d/%Y%T'",

"volume": "Volume",

"volumeAccum": "AccumulatedVolume",

"Ar": "Argon",

"CO": "CO",

"CO2": "CO2",

"H2": "H2",

"H2O": "H2O",

"H2S": "H2S",

"He": "Helium",

"N2": "N2",

"O2": "O2",

"C1": "Methane",

"C2": "Ethane",

"C3": "Propane",

"iC4": "iButane",

"nC4": "nButane",

"iC5": "iPentane",

"nC5":"nPentane",

"C6": "nHexane",

"C7": "nHeptane",

"C8": "nOctane",

"C9": "nNonane",

"C10": "nDecane",

"neoC5": "NeoPentane",

"heatingValue": "BTU",

"specificGravity": "SpecificGravity"

},

"writeObjectEventBuffer": {

"MA_Column": "ACM_Column",

"localTime": "FORMAT([RecordTime],'MM/dd/yy HH:mm:ss')",

"timeFormat": "'%m/%d/%Y%T'",

"objectName": "MeterID",

"message": "Description",

"eventType": "EventType",

"eventCodeDescription": "AsiText",

"newValue": "NewValue",

"oldValue": "OldValue",

"newValueText": "NewValueText",

"oldValueText": "OldValueText",

"eventSeverityName" : "'Normal'"

},

"writeCombinedMtrConfigGQRecordBuffer": {

"MA_Column": "ACM_Column",

"objName": "MeterID"

}

},

"ACM_Configuration": {

"Database": "[ACM_Import]",

"Schema": "[dbo]",

"HistoryTable": "[tblAsiEFMHistoryRecords]",

"ConfigTable": "[tblAsiEFMConfigRecords]",

"EventTable": "[tblAsiEFMEventRecords]",

"AlarmTable": "[tblAsiEFMAlarmRecords]"

},

"ACM_HistoryIntervals": {

"Hy": "60",

"Dy": "1440"

}

}