PMS_GROUPNMI
Describe the NMIs that a group uses to provide its service.
Package
PARTICIPANT_REGISTRATION
Visibility
Private
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| GROUPNMIID |
numeric(20, 0)  |
bigint |
Record Identifier of the NMI within a Group. When data is updated, existing record identifier is terminated, and new record identifier(s) are allocated. |
| GROUPID |
numeric(20, 0) |
bigint |
Group id of the Group which the NMI belongs in. |
| VERSIONFROM |
datetime(3) |
datetime2(0) |
Date for which this version is effective from |
| VERSIONTO |
datetime(3) |
datetime2(0) |
Date for which this version is effective to. Will be set to current day plus one if it is the current active record or past date if the record has been superseded/ended. |
| STARTDATE |
datetime(3) |
datetime2(0) |
Effective date of when this service started operation |
| ENDDATE |
datetime(3) |
datetime2(0) |
Date for which this version is effective to. Will be set to current day plus one if it is the current active record or past date if the record has been superseded/ended. |
| NMI |
varchar(20) |
varchar(20) |
National Meter Identifier linked to the group. |
| SITENAME |
varchar(50) |
varchar(50) |
Site name |
| NERRGROUPPREMISES |
numeric(1, 0) |
tinyint |
Specifies whether NMI is in a NERR aggregated premises (TRUE = 1/FALSE = 0) |
| BASELINEMETHODOLOGYID |
varchar(50) |
varchar(50) |
Baseline methodology to be used for the PoL and Baseline assessment of the NMI |
| MRC |
numeric(10, 3) |
numeric(10, 3) |
Maximum responsive component for the NMI |
| MRCREASON |
varchar(500) |
varchar(500) |
Reason for the MRC |
| RETAILCUSTOMER |
varchar(50) |
varchar(50) |
Retail customer of the NMI |
| SUSPENDED |
numeric(1, 0) |
tinyint |
Indicates whether the NMI has been suspended from use. (TRUE = 1/FALSE = 0) |
| UNAVAILABLE |
numeric(1, 0) |
tinyint |
Indicates whether the NMI is unavailable for use. (TRUE = 1/FALSE = 0) |
| APPROVEDDATE |
datetime(3) |
datetime2(0) |
Date which this record was approved |
| LASTCHANGED |
datetime(3) |
datetime2(0) |
Date time which record was last changed |
Official MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PMS_GROUPNMI_IDX |
nonclustered |
GROUPID, NMI |
| PMS_GROUPNMI_PK |
clustered, unique, primary key |
GROUPNMIID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_PMS_GROUPNMI |
clustered, unique, primary key |
GROUPNMIID |
| PMS_GROUPNMI_IDX |
nonclustered |
GROUPID, NMI |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_PMS_GROUPNMI |
clustered, unique, primary key |
GROUPNMIID |
| PMS_GROUPNMI_IDX |
nonclustered |
GROUPID, NMI |