Table: METERDATA

METERDATA

Name

METERDATA

Comment

METERDATA sets out a meter data for each customer connection point. METERDATA covers market load. Use the field METERRUNNO to match the meter data version for each settlement run.


Description

METERDATA data is confidential to the relevant participant.

Source

METERDATA updates whenever meter files are processed from MSATS.

Volume

Depends on number of TNI, FRMP, LR combinations and number of data file loads (versions) from MSATS per settlement run.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Private


Primary Key Columns

Name

CONNECTIONPOINTID

HOSTDISTRIBUTOR

MDA

METERRUNNO

PARTICIPANTID

PERIODID

SETTLEMENTDATE


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

PARTICIPANTID

VARCHAR2(10)

X

Unique participant identifier

PERIODID

NUMBER(3,0)

X

Settlement period identifier (half hour period)

SETTLEMENTDATE

DATE

X

Settlement date

METERRUNNO

NUMBER(6,0)

X

Data version no

CONNECTIONPOINTID

VARCHAR2(10)

X

Transmission Node Identifier (TNI). Identifies a Transmission NetworkConnection Point.

IMPORTENERGYVALUE

NUMBER(9,6)

 

Imported energy value (MWh)

EXPORTENERGYVALUE

NUMBER(9,6)

 

Exported energy value (MWh)

IMPORTREACTIVEVALUE

NUMBER(9,6)

 

Not used

EXPORTREACTIVEVALUE

NUMBER(9,6)

 

Not used

HOSTDISTRIBUTOR

VARCHAR2(10)

X

Local Retailer participant identifier

LASTCHANGED

DATE

 

Last date and time record changed

MDA

VARCHAR2(10)

X

Defaults to MSATS