GENUNITS
GENUNITS shows Genset details for each physical unit with the relevant station.
Package
PARTICIPANT_REGISTRATION
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| GENSETID |
varchar(20)  |
varchar(20) |
Physical Unit identifier |
| STATIONID |
varchar(10) |
varchar(10) |
Station Identifier |
| SETLOSSFACTOR |
numeric(16, 6) |
numeric(16, 6) |
Not used |
| CDINDICATOR |
varchar(10) |
varchar(10) |
Centrally dispatched Indicator |
| AGCFLAG |
varchar(2) |
varchar(2) |
AGC Available flag |
| SPINNINGFLAG |
varchar(2) |
varchar(2) |
Not used |
| VOLTLEVEL |
numeric(6, 0) |
smallint |
Voltage level |
| REGISTEREDCAPACITY |
numeric(6, 0) |
smallint |
Registered capacity |
| DISPATCHTYPE |
varchar(20) |
varchar(20) |
Identifies LOAD, GENERATOR or BIDIRECTIONAL. This will likely expand to more generic models as new technology types are integrated into the NEM. |
| STARTTYPE |
varchar(20) |
varchar(20) |
Fast / Slow / Not Dispatched |
| MKTGENERATORIND |
varchar(10) |
varchar(10) |
Market Generator Indicator Flag |
| NORMALSTATUS |
varchar(10) |
varchar(10) |
On / Off for load |
| MAXCAPACITY |
numeric(6, 0) |
smallint |
Maximum capacity |
| GENSETTYPE |
varchar(15) |
varchar(15) |
Genset type |
| GENSETNAME |
varchar(40) |
varchar(40) |
Genset name |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Last date and time record changed |
| CO2E_EMISSIONS_FACTOR |
numeric(18, 8) |
numeric(18, 8) |
The emissions factor for the generating unit, as calculated by Settlements staff members |
| CO2E_ENERGY_SOURCE |
varchar(100) |
varchar(100) |
The energy source for the generating unit, as used in the calculation of the CO2-e emissions factor. Distinct from the Energy Source for a generating unit published as part of the Registration Master List |
| CO2E_DATA_SOURCE |
varchar(20) |
varchar(20) |
An indicator as to the source of the emission factor used in the calculation of the index. The applicable values for this field would be NTNDP which indicates the emission factor is quoted from the National Transmission Network Development Plan or Estimated to indicate the emission factor has been calculated using an internal AEMO procedure based upon the Department of Climate Change and Energy Efficiency NGA factors |
| MAXSTORAGECAPACITY |
numeric(15, 5) |
numeric(15, 5) |
The rated storage capacity (MWh), information only |
| MINCAPACITY |
numeric(6, 0) |
numeric(6, 0) |
Minimum capacity only for load side of BDU, otherwise 0 (MW) |
| REGISTEREDMINCAPACITY |
numeric(6, 0) |
numeric(6, 0) |
Registered minimum capacity only for load side of BDU, otherwise 0 (MW) |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| GENUNIT_PK |
clustered, unique, primary key |
GENSETID |
| GENUNITS_LCX |
nonclustered |
LASTCHANGED |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| IX_GENUNITS_LASTCHANGED |
nonclustered |
LASTCHANGED |
| PK_GENUNITS |
clustered, unique, primary key |
GENSETID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| GENUNIT_PK |
clustered, unique, primary key |
GENSETID |
| GENUNITS_LCX |
nonclustered |
LASTCHANGED |