Table: PMS_GROUPSERVICE

PMS_GROUPSERVICE

Name

PMS_GROUPSERVICE

Comment

Describe the services a group provides and its relation to a market


Primary Key Columns

Name

GROUPSERVICEID


Index Columns

Name

ENTITYID

GROUPID


Content

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