GENMETER
GENMETER shows details of generator meter sets.
Package
PARTICIPANT_REGISTRATION
Visibility
Private
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| METERID |
varchar(12)  |
varchar(12) |
Meter Id |
| APPLYDATE |
datetime(3) |
datetime2(0) |
Application date |
| VERSIONNO |
numeric(3, 0) |
smallint |
Version no of the record for the given effective date |
| GENSETID |
varchar(20) |
varchar(20) |
Generator Set ID |
| CONNECTIONPOINTID |
varchar(10) |
varchar(10) |
Not used |
| STATIONID |
varchar(10) |
varchar(10) |
Station Identifier |
| METERTYPE |
varchar(20) |
varchar(20) |
LOAD |
| METERCLASS |
varchar(10) |
varchar(10) |
WATT or AUXILARY |
| VOLTAGELEVEL |
numeric(6, 0) |
smallint |
Voltage |
| AUTHORISEDBY |
varchar(10) |
varchar(10) |
AEMO user authorising |
| AUTHORISEDDATE |
datetime(3) |
datetime2(0) |
Date authorised |
| COMDATE |
datetime(3) |
datetime2(0) |
Not used |
| DECOMDATE |
datetime(3) |
datetime2(0) |
Not used |
| ENDDATE |
datetime(3) |
datetime2(0) |
Not used |
| STARTDATE |
datetime(3) |
datetime2(0) |
Not used |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| GENMETER_LCX |
nonclustered |
LASTCHANGED |
| GENMETER_NDX2 |
nonclustered |
STATIONID |
| GENMETERS_PK |
clustered, unique, primary key |
METERID, APPLYDATE, VERSIONNO |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_GENMETER_LASTCHANGED |
nonclustered |
LASTCHANGED |
| IX_GENMETER_STATIONID |
nonclustered |
STATIONID |
| PK_GENMETER |
clustered, unique, primary key |
METERID, APPLYDATE, VERSIONNO |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| GENMETER_LCX |
nonclustered |
LASTCHANGED |
| GENMETER_NDX2 |
nonclustered |
STATIONID |
| GENMETERS_PK |
clustered, unique, primary key |
METERID, APPLYDATE, VERSIONNO |