Table: PERDEMAND

PERDEMAND

Name

PERDEMAND

Comment

PERDEMAND sets out the regional demands and MR schedule data for each half-hour period. PERDEMAND is a child table to RESDEMANDTRK.


Description

The RESDEMANDTRK and PERDEMAND tables have a parent/child relationship, and define forecast regional demands since market start. RESDEMANDTRK defines the existence and versioning information of a forecast for a specific region and trading date. PERDEMAND defines the numerical forecast values for each trading interval of a the trading day for that region. A complete trading day forecast for one region consists of one RESDEMANDTRK record and 48 PERDEMAND records.

Source

PERDEMAND updates whenever AEMO issues a new or revised forecast. ST PASA forecasts update seven days at a time. Predispatch updates one date.

Volume

1296000 rows per year

Note

In the context of a mandatory restrictions event the forecast schedule (MW) of restrictions are reported through the RESDEMANDTRK and PERDEMAND tables using the new field PerDemand.MR_Schedule. The relationship between fields and mandatory restriction terms for the 50% probability of exceedence forecast are:

· UnRestricted Profile = ResDemand + MR_Schedule

· Restricted Profile = ResDemand


Notes

Name

Comment

Value

Visibility

Data in this table is:

Public


Primary Key Columns

Name

OFFERDATE

PERIODID

REGIONID

SETTLEMENTDATE

VERSIONNO


Index Columns

Name

LASTCHANGED


Content

Name

Data Type

Mandatory

Comment

EFFECTIVEDATE

DATE

 

Market date the forecast is made for. First date of the 7 days.

SETTLEMENTDATE

DATE

X

Market date of forecast up to 7 days ahead.

REGIONID

VARCHAR2(10)

X

Differentiates this region from all other regions

OFFERDATE

DATE

X

Date record issued

PERIODID

NUMBER(3,0)

X

Half hourly trading intervals from 04:30.

VERSIONNO

NUMBER(3,0)

X

The version of the RESDEMAND file for this date

RESDEMAND

NUMBER(10,0)

 

Base Demand forecast for period

DEMAND90PROBABILITY

NUMBER(10,0)

 

Demand at 90% probability of exceedance

DEMAND10PROBABILITY

NUMBER(10,0)

 

Demand level for a 10% probability of exceedance

LASTCHANGED

DATE

 

Last date and time record changed

MR_SCHEDULE

NUMBER(6,0)

 

MR_Schedule = Unrestricted Demand - POE