Table: REALLOCATIONINTERVALS

REALLOCATIONINTERVALS

Name

REALLOCATIONINTERVALS

Comment

REALLOCATIONINTERVALS identifies the the reallocation agreement and provides the corresponding reallocation profiles submitted by the participant and accepted by AEMO


Description

Not in Use - discontinued 10/06/2004

Source

Only populated if a reallocation contract has been submitted and accepted by AEMO.

Volume

Generally 144 rows are inserted by week.


Primary Key Columns

Name

EFFECTIVEDATE

PERIODID

REALLOCATIONID

VERSIONNO


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

REALLOCATIONID

VARCHAR2(20)

X

Identification of the reallocation agreement

EFFECTIVEDATE

DATE

X

Date the agreement starts from

VERSIONNO

NUMBER(3,0)

X

Version number on the effective date, highest is the reallocation used on that date

PERIODID

NUMBER(3,0)

X

Period number where period 1 use the half hour ended 00:30 EST

REALLOCATIONVALUE

NUMBER(6,2)

 

Either $ or MWh depending on agreement type

LASTCHANGED

DATE

 

Last date and time record changed