GENUNITS_UNIT
Physical units within a Gen Unit Set.
Package
PARTICIPANT_REGISTRATION
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| GENSETID |
varchar(20)  |
varchar(20) |
System wide unique Generating Set ID |
| EFFECTIVEDATE |
datetime(3) |
datetime2(0) |
Effective Date of this detail record |
| VERSIONNO |
numeric(6, 0) |
smallint |
Version with respect to the effective date |
| UNIT_GROUPING_LABEL |
varchar(20) |
varchar(20) |
Label of Physical Units within the station |
| UNIT_COUNT |
numeric(10, 0) |
int |
Number of units in this Gen Unit grouping |
| UNIT_SIZE |
numeric(8, 3) |
numeric(8, 3) |
Nameplate Capacity for each unit in this grouping |
| UNIT_MAX_SIZE |
numeric(8, 3) |
numeric(8, 3) |
Maximum Capacity for each unit in this grouping |
| AGGREGATION_FLAG |
numeric(1, 0) |
tinyint |
Deprecated as this flag is moved to DUDETAIL table with IESS release. |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Date/Time when record was changed |
| MAXSTORAGECAPACITY |
numeric(15, 5) |
numeric(15, 5) |
The rated storage capacity (MWh), information only |
| REGISTEREDCAPACITY |
numeric(8, 3) |
numeric(8, 3) |
Registered capacity for normal operations |
| REGISTEREDMINCAPACITY |
numeric(8, 3) |
numeric(8, 3) |
Only applicable for the LOAD side of BDU (MW) |
| UNITMINSIZE |
numeric(8, 3) |
numeric(8, 3) |
Only applicable for the LOAD side of BDU (MW) |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| GENUNITS_UNIT_PK |
clustered, unique, primary key |
GENSETID, EFFECTIVEDATE, VERSIONNO, UNIT_GROUPING_LABEL |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_GENUNITS_UNIT |
clustered, unique, primary key |
GENSETID, EFFECTIVEDATE, VERSIONNO, UNIT_GROUPING_LABEL |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| GENUNITS_UNIT_PK |
clustered, unique, primary key |
GENSETID, EFFECTIVEDATE, VERSIONNO, UNIT_GROUPING_LABEL |