Name |
|
Comment |
Describe the services a group provides and its relation to a market |
Name |
GROUPSERVICEID |
Name |
ENTITYID |
GROUPID |
Name |
Data Type |
Mandatory |
Comment |
GROUPSERVICEID |
NUMBER(20,0) |
X |
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 |
NUMBER(20,0) |
|
Group id of the Group where the Service is attached to. |
VERSIONFROM |
TIMESTAMP(3) |
|
Date for which this version is effective from. |
VERSIONTO |
TIMESTAMP(3) |
|
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 |
TIMESTAMP(3) |
|
Effective date of when this service started operation |
ENDDATE |
TIMESTAMP(3) |
|
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 |
VARCHAR2(50) |
|
Market that this group is operating its service in. Will only be NEM initially. |
SERVICETYPE |
VARCHAR2(50) |
|
Service that this group is operating. Will be only be ENERGY initially |
ENTITYTYPE |
VARCHAR2(50) |
|
Describes the entity that is operating. Will only be WDRU initially. |
ENTITYID |
VARCHAR2(50) |
|
Describe the entity ID in the market that it will be operating in. Will only contain the DUID of the group initially. |
MRC |
NUMBER(10,3) |
|
Maximum responsive component for the service offering |
MRCREASON |
VARCHAR2(500) |
|
Reason for the MRC. |
MAXIMUMRAMPRATEPERMIN |
NUMBER(10,0) |
|
Maximum ramp rate MW per minute of the service. |
REGION |
VARCHAR2(20) |
|
Region the group is operating this service in One of NSW1, QLD1, VIC1, SA1 or TAS1 |
APPROVEDDATE |
TIMESTAMP(3) |
|
Date which this record was approved |
LASTCHANGED |
TIMESTAMP(3) |
|
Date time which record was last changed |
|
|
|