Table: SETLSHEDRECOVERY

SETLSHEDRECOVERY

Name

SETLSHEDRECOVERY

Comment

SETLSHEDRECOVERY shows reimbursements for Load shed Ancillary Services to be recovered from participants. (Data no longer created for Settlement Days from 01/07/2012)


Description

SETLSHEDRECOVERY data is confidential to the relevant participant.

Source

SETLSHEDRECOVERY updates with each settlement run.

Note

Only the payment fields (LSEPAYMENT and CCPAYMENT) are on a regional basis. All other demand and recovery fields are on NEM basis rather than a regional basis.


Primary Key Columns

Name

PARTICIPANTID

PERIODID

REGIONID

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.

PARTICIPANTID

VARCHAR2(10)

X

Participant to pay recovery

CONTRACTID

VARCHAR2(10)

 

Contract Identifier for reserve, intervention, settlement and ancillary service contracts. Contracts are coded by type and unit.

PERIODID

NUMBER(3,0)

X

Settlements Trading Interval.

REGIONID

VARCHAR2(10)

X

Region Identifier

LSEPAYMENT

NUMBER(15,5)

 

Load Shed Enabling Payment

CCPAYMENT

NUMBER(15,5)

 

Compensation Payment

PARTICIPANTDEMAND

NUMBER(15,5)

 

Total Participant NEM Demand

REGIONDEMAND

NUMBER(15,5)

 

Total NEM Demand

LSERECOVERY

NUMBER(15,5)

 

Load Shed Enabling Recovery

CCRECOVERY

NUMBER(15,5)

 

Compensation Recovery

LASTCHANGED

DATE

 

Last date and time record changed

LSERECOVERY_GEN

NUMBER(15,5)

 

Load Shed Enabling Recovery for Generator

CCRECOVERY_GEN

NUMBER(15,5)

 

Compensation Recovery for Generator

PARTICIPANTDEMAND_GEN

NUMBER(15,5)

 

Total Participant NEM Demand for Generator

REGIONDEMAND_GEN

NUMBER(15,5)

 

Total NEM Demand for Generator

AVAILABILITYRECOVERY

NUMBER(16,6)

 

Recovery amount for the Load Shed Availability service attributable to customer connection points

AVAILABILITYRECOVERY_GEN

NUMBER(16,6)

 

Recovery amount for the Load Shed Availability service attributable to generator connection points