'Plain' XML to IMD Mapping

The following table outlines how data from the "plain" XML format is mapped to the InitialLoadIMD format when the Landis+Gyr record type is set to "MEPMD01" (interval usage).

"Plain" XML element InitialLoadIMD element Note

Record Type

N/A

RecordVersion

N/A

Premise ID

N/A

ESIID

N/A

Provisioned

N/A

Meter ID

dvcIdN

as is

Purpose

N/A

Commodity

N/A

Units externalUOM

as is

CalcConst mcm

as is

Interval spi

Transform from DDHHMM to SPI

Count

N/A

FirstIntervalDateTime stDt

Convert to OUAF date/time format

Data msrs

Value -> msrs/mL/q

Status -> msrs/mL/sts/stsL/st

 

N/A

imdType

'D1IL

Origin externalId

the origin attribute in "Plain" XML (incoming file name)

N/A

serviceProviderExternalId

L+G

RawData rawData

Vendor-specific "raw" data