Table: GENUNITMTRINPERIOD

GENUNITMTRINPERIOD

Name

GENUNITMTRINPERIOD

Comment

GENUNITMTRINPERIOD shows meter reading by period for each generator meter. GENUNITMTRINPERIOD covers generated power flowing into the system. It is used to calculate settlement values.


Description

GENUNITMTRINPERIOD data is confidential to the relevant participant.

Source

GENUNITMTRINPERIOD updated only when new meter reading files are submitted by MDAs.


Primary Key Columns

Name

CONNECTIONPOINTID

LOCAL_RETAILER

MDA

PARTICIPANTID

PERIODID

SETTLEMENTDATE

VERSIONNO


Index Columns

Name

LASTCHANGED


Index Columns

Name

STATIONID


Content

Name

Data Type

Mandatory

Comment

PARTICIPANTID

VARCHAR2(10)

X

Unique participant identifier

SETTLEMENTDATE

DATE

X

Trading date of meter data submitted

VERSIONNO

NUMBER(6,0)

X

Version no of the record for the given effective date

CONNECTIONPOINTID

VARCHAR2(10)

X

Connection Point NMI

PERIODID

NUMBER(3,0)

X

Period number where 1 period ending 00:30 EST

GENUNITID

VARCHAR2(10)

 

Physical unit ID

STATIONID

VARCHAR2(10)

 

Station Identifier

IMPORTENERGYVALUE

NUMBER(16,6)

 

Energy sent to the pool (MWh)

EXPORTENERGYVALUE

NUMBER(16,6)

 

Energy received from the pool (MWh)

IMPORTREACTIVEVALUE

NUMBER(16,6)

 

Reactive power sent to the network

EXPORTREACTIVEVALUE

NUMBER(16,6)

 

Reactive power received from the network

LASTCHANGED

DATE

 

Last date and time record changed

MDA

VARCHAR2(10)

X

Relevant Metering Data Agent

LOCAL_RETAILER

VARCHAR2(10)

X

Local Retailer for this NMI