Table: SETINTERVENTION

SETINTERVENTION

Name

SETINTERVENTION

Comment

SETINTERVENTION shows intervention settlement payment details by unit.


Description

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

SETINTERVENTION data is confidential to each participant.

Source

SETINTERVENTION is unused; was updating when intervention occurred in a billing run.


Primary Key Columns

Name

DUID

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)

 

Intervention Contract Identifier

CONTRACTVERSION

NUMBER(3,0)

 

Intervention Contract Version

PARTICIPANTID

VARCHAR2(10)

 

Unique participant identifier

REGIONID

VARCHAR2(10)

 

Region Identifier

DUID

VARCHAR2(10)

X

Dispatchable Unit ID

RCF

CHAR(1)

 

Regional Recovery Flag

INTERVENTIONPAYMENT

NUMBER(12,5)

 

Payment to Generator for Intervention

LASTCHANGED

DATE

 

Last date and time record changed