Table: BILLINGCUSTEXCESSGEN

BILLINGCUSTEXCESSGEN

Name

BILLINGCUSTEXCESSGEN

Comment

BILLINGCUSTEXCESSGEN shows excess generation payments for each participant cutover.


Description

Source

Obsolete; was updated with relevant settlement runs.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Private


Primary Key Columns

Name

BILLRUNNO

CONTRACTYEAR

PARTICIPANTID

PERIODID

REGIONID

SETTLEMENTDATE

WEEKNO


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

CONTRACTYEAR

NUMBER(4,0)

X

AEMO Contract Year number starting in week containing 1st January

WEEKNO

NUMBER(3,0)

X

Week no within the contract year. Week no 1 is the week containing 1st January

BILLRUNNO

NUMBER(3,0)

X

Unique run no within a given contract year and week no

PARTICIPANTID

VARCHAR2(10)

X

Unique participant identifier

SETTLEMENTDATE

DATE

X

Calendar Settlement Date

PERIODID

NUMBER(3,0)

X

Half hourly trading period that excess generation is for

EXCESSGENPAYMENT

NUMBER(16,6)

 

Payment by Customer for Excess Generation

LASTCHANGED

DATE

 

Last date and time record changed

REGIONID

VARCHAR2(10)

X

Region Identifier