Table: BILLINGASPAYMENTS

BILLINGASPAYMENTS

Name

BILLINGASPAYMENTS

Comment

BILLINGASPAYMENTS shows Ancillary Service payments for each billing period by each of the Ancillary Service types for each participant’s connection points.


Description

BILLINGASPAYMENTS data is confidential to relevant participant.

Source

Updated with each billing run.

Volume

The volume is according to the number of Transmission ConnectionPointIDs a Participant may have subject to ancillary payment per billrunno. An indicative maximum is approximately 20 records are inserted per billrunno, or about 220 records inserted per week.


Primary Key Columns

Name

BILLRUNNO

CONNECTIONPOINTID

CONTRACTYEAR

PARTICIPANTID

WEEKNO


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

REGIONID

VARCHAR2(10)

 

Region Identifier

CONTRACTYEAR

NUMBER(4,0)

X

Contract Year

WEEKNO

NUMBER(3,0)

X

Week No

BILLRUNNO

NUMBER(3,0)

X

Billing Run No.

PARTICIPANTID

VARCHAR2(10)

X

Participant Identifier

CONNECTIONPOINTID

VARCHAR2(10)

X

Connection point identifier

RAISE6SEC

NUMBER(15,5)

 

Raise 6 Sec Payments

LOWER6SEC

NUMBER(15,5)

 

Lower 6 Sec Payments

RAISE60SEC

NUMBER(15,5)

 

Raise 60 Sec Payments

LOWER60SEC

NUMBER(15,5)

 

Lower 60 Sec Payments

AGC

NUMBER(15,5)

 

AGC Payments

FCASCOMP

NUMBER(15,5)

 

Frequency Control Compensation Payments

LOADSHED

NUMBER(15,5)

 

Load Shed Payments

RGUL

NUMBER(15,5)

 

Rapid Generator unit Loading Payments

RGUU

NUMBER(15,5)

 

Rapid Generator Unit Unloading Payments

REACTIVEPOWER

NUMBER(15,5)

 

Reactive Power Payments

SYSTEMRESTART

NUMBER(15,5)

 

System Restart Payments

LASTCHANGED

DATE

 

The latest date and time that a file was updated or inserted

LOWER5MIN

NUMBER(15,5)

 

Lower 5 Minute Payment

RAISE5MIN

NUMBER(15,5)

 

Raise 5 Minute Payment

LOWERREG

NUMBER(15,5)

 

Lower 5 Minute Regulation Payment

RAISEREG

NUMBER(15,5)

 

Raise 5 Minute Regulation Payment

AVAILABILITY_REACTIVE

NUMBER(18,8)

 

The total availability payment

AVAILABILITY_REACTIVE_RBT

NUMBER(18,8)

 

The total availability payment rebate

RAISE1SEC

NUMBER(18,8)

 

Payment amount for the very fast raise service

LOWER1SEC

NUMBER(18,8)

 

Payment amount for the very fast lower service