Table: SETINTERVENTIONRECOVERY

SETINTERVENTIONRECOVERY

Name

SETINTERVENTIONRECOVERY

Comment

SETINTERVENTIONRECOVERY shows intervention recovery details by participant.


Description

Status

SETINTERVENTIONRECOVERY became unused when Ancillary Services Review was implemented. For more details, see Change Notice 126.

Confidential to participant

Source

Unused; was updating when intervention occurred in a billing run.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Private


Primary Key Columns

Name

CONTRACTID

PARTICIPANTID

PERIODID

SETTLEMENTDATE

VERSIONNO


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

SETTLEMENTDATE

DATE

X

Calendar Settlement Date

VERSIONNO

NUMBER(3,0)

X

Settlement Run No.

PERIODID

NUMBER(3,0)

X

Settlement Period identifier

CONTRACTID

VARCHAR2(10)

X

Intervention Contract Identifier

RCF

CHAR(1)

 

Regional Recovery Flag

PARTICIPANTID

VARCHAR2(10)

X

Unique participant identifier

PARTICIPANTDEMAND

NUMBER(12,5)

 

Demand of Participant in Region/Market

TOTALDEMAND

NUMBER(12,5)

 

Total Demand of Region/Market

INTERVENTIONPAYMENT

NUMBER(12,5)

 

Payment to Generator for Intervention

INTERVENTIONAMOUNT

NUMBER(12,5)

 

Retailer Payment to Pool for Intervention

LASTCHANGED

DATE

 

Last date and time record changed

REGIONID

VARCHAR2(10)

 

Region Identifier