PMS_GROUPSERVICE
Describe the services a group provides and its relation to a market.
Package
PARTICIPANT_REGISTRATION
Visibility
Public
Table schema
| Column |
Official MMS Datatype |
GR-MMS Datatype |
Comment |
| GROUPSERVICEID |
numeric(20, 0)  |
bigint |
Record identifier of the Service allocated to the 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 where the Service is attached to. |
| 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 max date 9999/12/31 23:59:59.999 until this version ends or a change to the version is required. |
| STARTDATE |
datetime(3) |
datetime2(0) |
Effective date of when this service started operation |
| ENDDATE |
datetime(3) |
datetime2(0) |
Effective date of when this service ended operation. Will be set to max date 9999/12/31 23:59:59.999 until its service ends or a change to the service is required. |
| MARKET |
varchar(50) |
varchar(50) |
Market that this group is operating its service in. Will only be NEM initially. |
| SERVICETYPE |
varchar(50) |
varchar(50) |
Service that this group is operating. Will be only be ENERGY initially |
| ENTITYTYPE |
varchar(50) |
varchar(50) |
Describes the entity that is operating. Will only be WDRU initially. |
| ENTITYID |
varchar(50) |
varchar(50) |
Describe the entity ID in the market that it will be operating in. Will only contain the DUID of the group initially. |
| MRC |
numeric(10, 3) |
numeric(10, 3) |
Maximum responsive component for the service offering |
| MRCREASON |
varchar(500) |
varchar(500) |
Reason for the MRC. |
| MAXIMUMRAMPRATEPERMIN |
numeric(10, 0) |
int |
Maximum ramp rate MW per minute of the service. |
| REGION |
varchar(20) |
varchar(20) |
Region the group is operating this service in One of NSW1, QLD1, VIC1, SA1 or TAS1 |
| 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_GROUPSERVICE_IDX |
nonclustered |
ENTITYID, GROUPID |
| PMS_GROUPSERVICE_PK |
clustered, unique, primary key |
GROUPSERVICEID |
GR-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PK_PMS_GROUPSERVICE |
clustered, unique, primary key |
GROUPSERVICEID |
| PMS_GROUPSERVICE_IDX |
nonclustered |
ENTITYID, GROUPID |
Historical-MMS data model indexes
| Index name |
Index type |
Index columns (in order) |
| PMS_GROUPSERVICE_IDX |
nonclustered |
ENTITYID, GROUPID |
| PMS_GROUPSERVICE_PK |
clustered, unique, primary key |
GROUPSERVICEID |