Table: SET_ANCILLARY_SUMMARY

SET_ANCILLARY_SUMMARY

Name

SET_ANCILLARY_SUMMARY

Comment

SET_ANCILLARY_SUMMARY summarises payments for all Ancillary Services to participants on the basis of regions and trading intervals.


Description

SET_ANCILLARY_SUMMARY data is available to all participants.

Volume

Approximately 30, 000 per week.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Public


Primary Key Columns

Name

PAYMENTTYPE

PERIODID

REGIONID

SERVICE

SETTLEMENTDATE

VERSIONNO


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

SETTLEMENTDATE

DATE

X

Settlement Date

VERSIONNO

NUMBER(3,0)

X

Settlement Run No

SERVICE

VARCHAR2(20)

X

Ancillary service identifier (e.g. REACTIVE_POWER)

PAYMENTTYPE

VARCHAR2(20)

X

Payment type identifier (e.g. COMPENSATION)

REGIONID

VARCHAR2(10)

X

Region Identifier

PERIODID

NUMBER(3,0)

X

Trading interval

PAYMENTAMOUNT

NUMBER(18,8)

 

The NEM ancillary summary regional payment amount ($)

LASTCHANGED

DATE

 

Last date and time record changed