|
Name |
|
|
Comment |
APEVENT is the driving data defining the existence and timeframes of an administered pricing event. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
APEVENTID |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
APEVENTID |
NUMBER(22,0) |
X |
Unique identifier for this administered pricing event |
|
EFFECTIVEFROMINTERVAL |
DATE |
|
Date Time of the first Dispatch Interval to which the administered event applies |
|
EFFECTIVETOINTERVAL |
DATE |
|
Date Time of the final Dispatch Interval to which the administered event applies |
|
REASON |
VARCHAR2(2000) |
|
Description of the driver for the Event |
|
STARTAUTHORISEDBY |
VARCHAR2(15) |
|
Authorising staff for start of AP event |
|
STARTAUTHORISEDDATE |
DATE |
|
Date-Time start authorised |
|
ENDAUTHORISEDBY |
VARCHAR2(15) |
|
Authorising staff for end of AP event |
|
ENDAUTHORISEDDATE |
DATE |
|
Date Time end authorised |
|
LASTCHANGED |
DATE |
|
Date-Time the record was last modified |
|
Name |
|
|
Comment |
APEVENTREGION is the Region detail for an administered pricing event defined through APEVENT. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
APEVENTID |
|
REGIONID |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
APEVENTID |
NUMBER(22,0) |
X |
Unique identifier for this administered pricing event |
|
REGIONID |
VARCHAR2(10) |
X |
Date-Time of the first Dispatch Interval to which the administered event applies |
|
LASTCHANGED |
DATE |
|
Date Time of the final Dispatch Interval to which the administered event applies |
|
ENERGYAPFLAG |
NUMBER(1,0) |
|
flag indicating if the apevent covers an energy AP |
|
RAISE6SECAPFLAG |
NUMBER(1,0) |
|
flag indicating if the apevent covers a raise6sec AP |
|
RAISE60SECAPFLAG |
NUMBER(1,0) |
|
flag indicating if the apevent covers a raise60sec AP |
|
RAISE5MINAPFLAG |
NUMBER(1,0) |
|
flag indicating if the apevent covers a raise5min AP |
|
RAISEREGAPFLAG |
NUMBER(1,0) |
|
flag indicating if the apevent covers a raisereg AP |
|
LOWER6SECAPFLAG |
NUMBER(1,0) |
|
flag indicating if the apevent covers a lower6sec AP |
|
LOWER60SECAPFLAG |
NUMBER(1,0) |
|
flag indicating if the apevent covers a lower60sec AP |
|
LOWER5MINAPFLAG |
NUMBER(1,0) |
|
flag indicating if the apevent covers a lower5min AP |
|
LOWERREGAPFLAG |
NUMBER(1,0) |
|
flag indicating if the apevent covers a lowerreg AP |
|
RAISE1SECAPFLAG |
NUMBER(3,0) |
|
Flag indicating if the APEvent covers a Raise1Sec AP |
|
LOWER1SECAPFLAG |
NUMBER(3,0) |
|
Flag indicating if the APEvent covers a Lower1Sec AP |
|
Name |
|
|
Comment |
IRFMAMOUNT sets out settlement amounts associated with Industrial Relations Forced Majeure events. |
|
IRFMAMOUNTis public data. Source IRFMAMOUNT is obsolete; was updated with each settlement run as required. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
IRFMID |
|
PERIODID |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
IRFMID |
VARCHAR2(10) |
X |
Unique Industrial Relations Force Majeure event |
|
EFFECTIVEDATE |
DATE |
|
Date of event |
|
VERSIONNO |
NUMBER(3,0) |
X |
Version number of record of event |
|
PERIODID |
NUMBER(4,0) |
X |
Settlement period |
|
AMOUNT |
NUMBER(15,5) |
|
Total settlement amount in $ |
|
AUTHORISEDBY |
VARCHAR2(15) |
|
Person authorising amount |
|
AUTHORISEDDATE |
DATE |
|
Authorised date |
|
LASTCHANGED |
DATE |
|
last changed |
|
Name |
|
|
Comment |
IRFMEVENTS sets out specific Industrial Relations Forced Majeure events. |
|
IRFMEVENTS is public data. Source IRFMEVENTS updates with the occurrence of any such events. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
IRFMID |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
IRFMID |
VARCHAR2(10) |
X |
|
|
STARTDATE |
DATE |
|
|
|
STARTPERIOD |
NUMBER(3,0) |
|
|
|
ENDDATE |
DATE |
|
|
|
ENDPERIOD |
NUMBER(3,0) |
|
|
|
LASTCHANGED |
DATE |
|
|
|
Name |
|
|
Comment |
Tracks the evolution of pricing regimes applied to the suspended region and from which Dispatch Interval |
|
MARKET_SUSPEND_REGIME_SUM is public data, so is available to all participants. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
REGIONID |
|
START_INTERVAL |
|
SUSPENSION_ID |
|
Name |
Data Type |
Mandatory |
Comment |
|
SUSPENSION_ID |
VARCHAR2(20) |
X |
Unique identifier for this suspension event |
|
REGIONID |
VARCHAR2(20) |
X |
Region(s) covered by this evolution of the event |
|
START_INTERVAL |
DATE |
X |
First Dispatch interval from which this regime applies |
|
END_INTERVAL |
DATE |
|
Last Dispatch interval for which this regime applies |
|
PRICING_REGIME |
VARCHAR2(20) |
|
Pricing Regime applied |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
Summary of Market Suspension timings |
|
MARKET_SUSPEND is public data, so is available to all participants. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
REGIONID |
|
SUSPENSION_ID |
|
Name |
Data Type |
Mandatory |
Comment |
|
SUSPENSION_ID |
VARCHAR2(20) |
X |
Unique identifier for this suspension event |
|
REGIONID |
VARCHAR2(20) |
X |
Region(s) covered by the Suspension event |
|
INITIAL_INTERVAL |
DATE |
|
Initial interval of the Suspension event |
|
END_REGION_INTERVAL |
DATE |
|
Last Dispatch interval for the Suspension event for this Region |
|
END_SUSPENSION_INTERVAL |
DATE |
|
Last Dispatch interval for the Suspension event |
|
LASTCHANGED |
DATE |
|
Last DateTime the Suspension was administered |
|
Name |
|
|
Comment |
Trading prices that will apply in the event of a market suspension event updated weekly. |
|
MARKET_SUSPEND_SCHEDULE is public data, so is available to all participants. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
DAY_TYPE |
|
EFFECTIVEDATE |
|
PERIODID |
|
REGIONID |
|
Name |
Data Type |
Mandatory |
Comment |
|
EFFECTIVEDATE |
DATE |
X |
Calendar date from when this record set is effective |
|
DAY_TYPE |
VARCHAR2(20) |
X |
Distinguishes which record set to apply - at time of writing this was Business or Non-business day but may change in the future depending on outcome of consultation |
|
REGIONID |
VARCHAR2(20) |
X |
Region affected. |
|
PERIODID |
NUMBER(3,0) |
X |
48 intervals for a day, midnight base (equates to 00:30 - 00:00) |
|
ENERGY_RRP |
NUMBER(15,5) |
|
Energy Price applied for this period for this Day Type |
|
R6_RRP |
NUMBER(15,5) |
|
Raise 6Sec contingency Price applied for this period for this Day Type |
|
R60_RRP |
NUMBER(15,5) |
|
Raise 60Sec contingency Price applied for this period for this Day Type |
|
R5_RRP |
NUMBER(15,5) |
|
Raise 5Min contingency Price applied for this period for this Day Type |
|
RREG_RRP |
NUMBER(15,5) |
|
Raise Regulation contingency Price applied for this period for this Day Type |
|
L6_RRP |
NUMBER(15,5) |
|
Lower 6Sec contingency Price applied for this period for this Day Type |
|
L60_RRP |
NUMBER(15,5) |
|
Lower 60Sec contingency Price applied for this period for this Day Type |
|
L5_RRP |
NUMBER(15,5) |
|
Lower 5Min contingency Price applied for this period for this Day Type |
|
LREG_RRP |
NUMBER(15,5) |
|
Lower Regulation Price applied for this period for this Day Type |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
L1_RRP |
NUMBER(15,5) |
|
Lower 1Sec contingency Price applied for this period for this Day Type |
|
R1_RRP |
NUMBER(15,5) |
|
Raise 1Sec contingency Price applied for this period for this Day Type |
|
Name |
|
|
Comment |
Parent table for pricing regimes used in suspensions |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
EFFECTIVEDATE |
|
Name |
Data Type |
Mandatory |
Comment |
|
EFFECTIVEDATE |
DATE |
X |
Calendar date from when this record set is effective |
|
SOURCE_START_DATE |
DATE |
|
Start Date of the date range for the source data |
|
SOURCE_END_DATE |
DATE |
|
End Date of the date range for the source data |
|
COMMENTS |
VARCHAR2(1000) |
|
Reason why this regime was applied |
|
AUTHORISEDDATE |
DATE |
|
DateTime this record set was loaded |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
OVERRIDERRP shows details of override price periods. |
|
OVERRIDERRP data is public, so is available to all participants. Source OVERRIDERRP updates every five minutes when override prices apply for the period. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
REGIONID |
|
STARTDATE |
|
STARTPERIOD |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
REGIONID |
VARCHAR2(10) |
X |
Region Identifier |
|
STARTDATE |
DATE |
X |
Starting date of override |
|
STARTPERIOD |
NUMBER(3,0) |
X |
Starting period of override |
|
ENDDATE |
DATE |
|
Termination date of override |
|
ENDPERIOD |
NUMBER(3,0) |
|
Terminate period of override |
|
RRP |
NUMBER(15,0) |
|
Dispatch Price |
|
DESCRIPTION |
VARCHAR2(128) |
|
Description of reason for override |
|
AUTHORISESTART |
VARCHAR2(15) |
|
Authorise Start of Override |
|
AUTHORISEEND |
VARCHAR2(15) |
|
Authorise End of Override |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
REGIONAPC defines Administered Price profiles (Energy and FCAS) for a region. |
|
REGIONAPC data is public, so is available to all participants. Source REGIONAPC updates when a change is ever made to the Administered Price Cap details. Changes to this table are infrequent. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
EFFECTIVEDATE |
|
REGIONID |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
REGIONID |
VARCHAR2(10) |
X |
Region Identifier |
|
EFFECTIVEDATE |
DATE |
X |
Date the APC profile applies from |
|
VERSIONNO |
NUMBER(3,0) |
X |
Version number for the same date |
|
AUTHORISEDDATE |
DATE |
|
Authorised date |
|
AUTHORISEDBY |
VARCHAR2(10) |
|
Authorised by |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
REGIONAPCINTERVALS contains Administered Price profiles (Energy and FCAS) applicable to each interval for a region. |
|
REGIONAPCINTERVALS data is public, so is available to all participants. Source REGIONAPCINTERVALS is updated whenever an Administered Price Cap occurs. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
EFFECTIVEDATE |
|
PERIODID |
|
REGIONID |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
REGIONID |
VARCHAR2(10) |
X |
Region Identifier |
|
EFFECTIVEDATE |
DATE |
X |
Date the APC profile applies from |
|
VERSIONNO |
NUMBER(3,0) |
X |
Version number for the same date |
|
PERIODID |
NUMBER(3,0) |
X |
30-minute period |
|
APCVALUE |
NUMBER(16,6) |
|
Administered price cap in $ |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
APCTYPE |
NUMBER(3,0) |
|
not used |
|
FCASAPCVALUE |
NUMBER(16,6) |
|
FCAS Administered price cap in $ |
|
APFVALUE |
NUMBER(16,6) |
|
Administered price floor in $ |
|
|
|