|
Name |
|
|
Comment |
MT PASA input table defining a MT PASA Reserve Requirement within a single set. An MT PASA Reserve Requirement can span more than one region. |
|
Source MTPASA_RESERVELIMIT is updated on an ad hoc basis when a new Reserve Requirement is published. Volume ~20 rows per year |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
EFFECTIVEDATE |
|
RESERVELIMITID |
|
VERSION_DATETIME |
|
Name |
Data Type |
Mandatory |
Comment |
|
EFFECTIVEDATE |
DATE |
X |
Trade date when the set of reserve requirements become effective |
|
VERSION_DATETIME |
DATE |
X |
Timestamp when the set of reserve requirements become effective |
|
RESERVELIMITID |
VARCHAR2(20) |
X |
MT PASA Reserve Requirement identifier |
|
DESCRIPTION |
VARCHAR2(200) |
|
Description of this Reserve Requirement |
|
RHS |
NUMBER(16,6) |
|
Right hand side value for this Reserve requirement |
|
LASTCHANGED |
DATE |
|
Timestamp the record was last modified. |
|
Name |
|
|
Comment |
MT PASA input table to define the regions that are part of a single MT PASA Reserve Requirement |
|
Source MTPASA_RESERVELIMIT_REGION is updated on an ad hoc basis when a new Reserve Requirement is published. Volume ~50 rows per year |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
EFFECTIVEDATE |
|
REGIONID |
|
RESERVELIMITID |
|
VERSION_DATETIME |
|
Name |
Data Type |
Mandatory |
Comment |
|
EFFECTIVEDATE |
DATE |
X |
Trade date when the set of reserve requirements become effective |
|
VERSION_DATETIME |
DATE |
X |
Timestamp when the set of reserve requirements become effective |
|
RESERVELIMITID |
VARCHAR2(20) |
X |
MT PASA Reserve requirement identifier |
|
REGIONID |
VARCHAR2(20) |
X |
Region ID - identifier of a NEM region included in this requirement |
|
COEF |
NUMBER(16,6) |
|
Coefficient for the region in this reserve requirement |
|
LASTCHANGED |
DATE |
|
Timestamp the record was last modified |
|
Name |
|
|
Comment |
MT PASA input table defining a set of MT PASA Reserve Requirements. Note only one set can be active on a given date. |
|
Source MTPASA_RESERVELIMIT_SET is updated on an ad hoc basis when a new Reserve Requirement is published. Volume ~2 rows per year |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
EFFECTIVEDATE |
|
VERSION_DATETIME |
|
Name |
Data Type |
Mandatory |
Comment |
|
EFFECTIVEDATE |
DATE |
X |
Trade date when the set of reserve requirements become effective |
|
VERSION_DATETIME |
DATE |
X |
Timestamp when the set of reserve requirements become effective |
|
RESERVELIMIT_SET_ID |
VARCHAR2(20) |
|
MT PASA LRC Reserve Requirement Set Identifier |
|
DESCRIPTION |
VARCHAR2(200) |
|
Description of this set of Reserve Requirements |
|
AUTHORISEDDATE |
DATE |
|
Date the requirement set was authorised |
|
AUTHORISEDBY |
VARCHAR2(20) |
|
User authorising this requirement set |
|
LASTCHANGED |
DATE |
|
Timestamp the record was last modified |
|
Name |
|
|
Comment |
RESERVE sets out specific reserve requirements for dispatch, predispatch and STPASA, for each half-hour interval by region. Updates show as new versions for a date. |
|
Two fields specify Frequency Controlled Ancillary Services requirements for the regulation ancillary services. Another two fields specify the Lack of Reserve levels to be applied in the ST PASA solver. Change Notice 324 (for the FCAS Constraint enhancements project) means that Dispatch no longer utilises the static FCAS requirements defined in the DELTAMW and RESERVE tables. These tables are replaced with constraint data as a source of FCAS requirements. RESERVE data is public, so is available to all participants. Source RESERVE updates as AEMO updates forecasts, daily. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
PERIODID |
|
REGIONID |
|
SETTLEMENTDATE |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Market date starting at 04:00am |
|
VERSIONNO |
NUMBER(3,0) |
X |
Version No of record for this date, the version of the file loaded to produce these reserve figures |
|
REGIONID |
VARCHAR2(12) |
X |
Differentiates this region from all other regions |
|
PERIODID |
NUMBER(2,0) |
X |
Market Trading Interval |
|
LOWER5MIN |
NUMBER(6,0) |
|
Lower 5 minute reserve requirement |
|
LOWER60SEC |
NUMBER(6,0) |
|
Lower 60 second reserve requirement |
|
LOWER6SEC |
NUMBER(6,0) |
|
Lower 6 second reserve requirement |
|
RAISE5MIN |
NUMBER(6,0) |
|
Raise 5 minute reserve requirement |
|
RAISE60SEC |
NUMBER(6,0) |
|
Raise 60 second reserve requirement |
|
RAISE6SEC |
NUMBER(6,0) |
|
Raise 6 second reserve requirement |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
PASARESERVE |
NUMBER(6,0) |
|
PASA reserve requirement |
|
LOADREJECTIONRESERVEREQ |
NUMBER(10,0) |
|
PASA Load rejection reserve requirement |
|
RAISEREG |
NUMBER(6,0) |
|
Raise Regulation reserve requirement |
|
LOWERREG |
NUMBER(6,0) |
|
Lower Regulation reserve requirement |
|
LOR1LEVEL |
NUMBER(6,0) |
|
PASA Lack of Reserve 1 Level |
|
LOR2LEVEL |
NUMBER(6,0) |
|
PASA Lack of Reserve 1 Level |
|
|
|