GENUNITMTRINPERIOD (Historical table)
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.
Package
HISTORICAL_TABLES
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| PARTICIPANTID |
varchar(10)  |
varchar(10) |
Unique participant identifier |
| SETTLEMENTDATE |
datetime(3) |
datetime2(0) |
Trading date of meter data submitted |
| VERSIONNO |
numeric(6, 0) |
smallint |
Version no of the record for the given effective date |
| CONNECTIONPOINTID |
varchar(10) |
varchar(10) |
Connection Point NMI |
| PERIODID |
numeric(3, 0) |
smallint |
Period number where 1 period ending 00:30 EST |
| MDA |
varchar(10) |
varchar(10) |
Relevant Metering Data Agent |
| LOCAL_RETAILER |
varchar(10) |
varchar(10) |
Local Retailer for this NMI |
| GENUNITID |
varchar(10) |
varchar(10) |
Physical unit ID |
| STATIONID |
varchar(10) |
varchar(10) |
Station Identifier |
| IMPORTENERGYVALUE |
numeric(16, 6) |
numeric(16, 6) |
Energy sent to the pool (MWh) |
| EXPORTENERGYVALUE |
numeric(16, 6) |
numeric(16, 6) |
Energy received from the pool (MWh) |
| IMPORTREACTIVEVALUE |
numeric(16, 6) |
numeric(16, 6) |
Reactive power sent to the network |
| EXPORTREACTIVEVALUE |
numeric(16, 6) |
numeric(16, 6) |
Reactive power received from the network |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| GENUNITMTRINPERD_PK |
clustered, unique, primary key |
SETTLEMENTDATE, MDA, VERSIONNO, CONNECTIONPOINTID, PARTICIPANTID, LOCAL_RETAILER, PERIODID |
| GENUNITMTRINPERIOD_LCX |
nonclustered |
LASTCHANGED |
| GENUNITMTRINPERIOD_NDX2 |
nonclustered |
STATIONID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_GENUNITMTRINPERIOD_LASTCHANGED |
nonclustered |
LASTCHANGED |
| IX_GENUNITMTRINPERIOD_STATIONID |
nonclustered |
STATIONID |
| PK_GENUNITMTRINPERIOD |
clustered, unique, primary key |
SETTLEMENTDATE, MDA, VERSIONNO, CONNECTIONPOINTID, PARTICIPANTID, LOCAL_RETAILER, PERIODID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| GENUNITMTRINPERD_PK |
clustered, unique, primary key |
SETTLEMENTDATE, MDA, VERSIONNO, CONNECTIONPOINTID, PARTICIPANTID, LOCAL_RETAILER, PERIODID |
| GENUNITMTRINPERIOD_LCX |
nonclustered |
LASTCHANGED |
| GENUNITMTRINPERIOD_NDX2 |
nonclustered |
STATIONID |