Electricity Data Model 5.2
This Release contains an updated version of the Electricity Data Model The Electricity Data Model is the definition of the interface to participants of data published by AEMO from National Electricity Market (NEM) systems. 5.2. This section describes the affected packages, tables, files, reports, and interfaces.
Data model changes summary
Table 1 MMS Data Model 5.2 modified packages and tables summary
|
Package |
Table name |
Change |
Details |
Project |
|---|---|---|---|---|
|
BIDS |
MTPASA_OFFERDATA |
Modified |
New columns: UNITSTATE1-7, RECALLTIME1-7 |
MT PASA |
|
BILLING |
BILLINGCPDATA |
Modified |
New columns: SOLDENERGY, SALES, and PURCHASEDENERGY Modified columns: PURCHASES |
SAPS |
|
BILLINGASPAYMENTS |
Modified |
New columns: RAISE1SEC and LOWER1SEC |
FFR |
|
|
BILLINGASRECOVERY |
Modified |
New columns: RAISE1SEC, LOWER1SEC, RAISE1SEC_GEN, LOWER1SEC_GEN |
FFR |
|
|
BILLING_DIR_PROV_AMOUNT |
New |
The Billing Provisional Directions Payment Amount for Directed/Affected/Eligible participants |
Direction and RERT Recovery Data Reconciliation |
|
|
BILLING_DIR_FINAL_AMOUNT |
New |
The Billing Final Directions Payment Amount for Directed/Affected/Eligible participants |
Direction and RERT Recovery Data Reconciliation |
|
|
BILLING_DIR_PROV_RECOVERY |
New |
The Billing Provisional Directions Recovery Amount for participants |
Direction and RERT Recovery Data Reconciliation |
|
|
BILLING_DIR_FINAL_RECOVERY |
New |
The Billing Final Directions Recovery Amount for participants |
Direction and RERT Recovery Data Reconciliation |
|
|
BILLING_DIR_RECOVERY_DETAIL |
New |
The Billing Directions Recovery Details for participants |
Direction and RERT Recovery Data Reconciliation |
|
|
BILLRESERVETRADERRECOVERY |
Modified |
New column: EXCLUDEDENERGY |
Direction and RERT Recovery Data Reconciliation |
|
|
BILLING_ENERGY_TRAN_SAPS |
New |
The SAPS Billing Transaction Details for participants |
SAPS |
|
|
DEMAND |
INTERMITTENT_GEN_FCST_DATA |
Modified |
Updated trigger information |
Forecasting |
|
INTERMITTENT_GEN_SCADA |
New |
The SCADA Availability for every Intermittent Generating Unit, including Elements Available (wind turbines/solar inverters) and Local Limit |
Forecasting |
|
|
DISPATCH |
DISPATCHLOAD |
Modified |
New columns: CONFORMANCE_MODE, UIGF, RAISE1SEC, RAISE1SECFLAGS, LOWER1SEC, LOWER1SECFLAGS, RAISE1SECACTUALAVAILABILITY, LOWER1SECACTUALAVAILABILITY Modified column: AVAILABILITY |
Forecasting FFR IESS |
|
DISPATCHREGIONSUM |
Modified |
New columns: SS_SOLAR_AVAILABILITY, SS_WIND_AVAILABILITY, RAISE1SECLOCALDISPATCH, LOWER1SECLOCALDISPATCH, RAISE1SECACTUALAVAILABILITY, LOWER1SECACTUALAVAILABILITY |
Forecasting |
|
|
DISPATCHPRICE |
Modified |
New columns: RAISE1SECRRP, RAISE1SECROP, RAISE1SECAPCFLAG, LOWER1SECRRP, LOWER1SECROP, LOWER1SECAPCFLAG, PRE_AP_RAISE1_PRICE, PRE_AP_LOWER1_PRICE, CUMUL_PRE_AP_RAISE1_PRICE, CUMUL_PRE_AP_LOWER1_PRICE |
FFR |
|
|
DISPATCH_UNIT_CONFORMANCE |
Modified |
New columns: ADG_ID, SEMIDISPATCHCAP, CONFORMANCE_MOD Modified description for DUID, ROC |
IESS |
|
|
FORCE |
APEVENTREGION |
Modified |
New columns: RAISE1SECAPFLAG, LOWER1SECAPFLAG |
FFR |
|
MARKET_SUSPEND_SCHEDULE |
Modified |
New columns: L1_RRP, R1_RRP |
FFR |
|
|
METER |
METERDATA_SAPS |
New |
The SAPS Meter data for MSRP and Retailer used in the Settlement Calculation |
SAPS |
|
MTPASA |
MTPASA_DUIDAVAILABILITY |
Modified |
New columns: UNIT state, recall time |
MT PASA |
|
P5MIN |
P5MIN_FCAS_REQUIREMENT |
New |
5-minute predispatch constraint tracking for regional FCAS recovery |
FFR |
|
P5MIN_UNITSOLUTION |
Modified |
New columns: CONFORMANCE_MODE, UIGF, RAISE1SEC, RAISE1SECFLAGS, LOWER1SEC, LOWER1SECFLAGS |
Forecasting IESS |
|
|
P5MIN_REGIONSOLUTION |
Modified |
New columns: SS_SOLAR_AVAILABILITY, SS_WIND_AVAILABILITY, RAISE1SECRRP, RAISE1SECROP, LOWER1SECRRP, LOWER1SECROP, RAISE1SECLOCALDISPATCH, LOWER1SECLOCALDISPATCH |
Forecasting |
|
|
PDPASA |
PDPASA_REGIONSOLUTION |
Modified |
Modified columns: SEMISCHEDULEDCAPACITY, LOR_ SEMISCHEDULEDCAPACITY, AGGREGATECAPACITYAVAILABLE, SS_SOLAR_UIGF, SS_SOLAR_CAPACITY, SS_SOLAR_CLEARED, SS_WIND_UIGF, SS_WIND_CAPACITY, SS_WIND_CLEARED |
Forecasting |
|
PRE |
PREDISPATCHLOAD |
Modified |
New columns: CONFORMANCE_MODE, UIGF, RAISE1SEC, RAISE1SECFLAGS, LOWER1SEC, LOWER1SECFLAGS, RAISE1SECACTUALAVAILABILITY, LOWER1SECACTUALAVAILABILITY Modified column: AVAILABILITY |
Forecasting IESS |
|
PREDISPATCHPRICE |
Modified |
New columns: RAISE1SECRRP, LOWER1SECRRP |
FFR |
|
|
PREDISPATCHREGIONSUM |
Modified |
New columns: SS_SOLAR_AVAILABILITY, SS_WIND_AVAILABILITY, RAISE1SECLOCALDISPATCH, LOWER1SECLOCALDISPATCH, RAISE1SECACTUALAVAILABILITY, LOWER1SECACTUALAVAILABILITY |
Forecasting |
|
|
PARTICIPANT_ |
AGGREGATE_DISPATCH_GROUP |
New |
Entity allowing for compliance monitoring over grouped DUIDs |
IESS |
|
ADG_DETAIL |
New |
Tracks evolving aggregate dispatch group attributes |
IESS |
|
|
DUDETAIL |
Modified |
New column: ADG_ID |
IESS |
|
|
DUDETAILSUMMARY |
Modified |
New column: ADG_ID Updated transaction type from INSERT-UPDATE to DELETE-INSERT. For details see modified table: DUDETAILSUMMARY |
Forecasting |
|
|
SETTLEMENT |
SETCFG_SAPS_SETT_PRICE |
New |
The Settlement Price for SAPS Energy in each Region |
SAPS |
|
SETTLEMENT |
SETCPDATA |
Modified |
New columns: IMPORTENERGYCOST, EXPORTENERGYCOST Modified column: AFE |
SAPS |
|
SET_FCAS_PAYMENT |
Modified |
New columns: RAISE1SEC_PAYMENT, LOWER1SEC_PAYMENT |
FFR |
|
|
SET_FCAS_RECOVERY |
Modified |
New columns: RAISE1SEC_RECOVERY, LOWER1SEC_RECOVERY, RAISE1SEC_RECOVERY_GEN, LOWER1SEC_RECOVERY_GEN |
FFR |
|
|
SET_ENERGY_TRAN_SAPS |
New |
The transaction details for the SAPS connection points |
SAPS |
|
|
STPASA |
STPASA_REGIONSOLUTION |
Modified |
Modified columns: UNCONSTRAINEDCAPACITY, CONSTRAINEDCAPACITY, SEMISCHEDULEDCAPACITY, LOR_ SEMISCHEDULEDCAPACITY, AGGREGATECAPACITYAVAILABLE, SS_SOLAR_UIGF, SS_SOLAR_CAPACITY, SS_SOLAR_CLEARED, SS_WIND_UIGF, SS_WIND_CAPACITY, SS_WIND_CLEARED |
Forecasting |
|
TRADING |
TRADINGPRICE |
Modified |
New columns: RAISE1SECRRP, RAISE1SECROP, LOWER1SECRRP, LOWER1SECROP |
FFR |
|
VOLTAGE_ |
VOLTAGE_INSTRUCTION |
Modified |
Modified target field |
BAU |
Package: BIDS
Energy The unit must be a generator for the service type: ‘energy’. Loads cannot bid for mandatory restrictions capacity. Bids/Offers, Market-based FCAS Frequency Controlled Ancillary Services. A service that balances, over short intervals (shorter than the dispatch interval), the power supplied by generating units and the power consumed by loads. Offers
Modified table: MTPASA_OFFERDATA
|
Comment |
Participant submitted Offers for the MTPASA process |
|
Visibility |
Private |
|
Data volume |
Medium |
|
Trigger |
Participant submitted MT PASA offer |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports |
|
Primary key (in order) |
EFFECTIVEDATE, OFFERDATETIME, PARTICIPANTID, UNITID |
New columns
|
Field name |
Data type |
Primary key |
Comment |
|
UNITSTATE1 |
VARCHAR2(20) |
No |
The unit state value for day 1 Sunday |
|
UNITSTATE2 |
VARCHAR2(20) |
No |
The unit state value for day 2 Monday |
|
UNITSTATE3 |
VARCHAR2(20) |
No |
The unit state value for day 3 Tuesday |
|
UNITSTATE4 |
VARCHAR2(20) |
No |
The unit state value for 4 Wednesday |
|
UNITSTATE5 |
VARCHAR2(20) |
No |
The unit state value for day 5 Thursday |
|
UNITSTATE6 |
VARCHAR2(20) |
No |
The unit state value for day 6 Friday |
|
UNITSTATE7 |
VARCHAR2(20) |
No |
The unit state value for day 7 Saturday |
|
RECALLTIME1 |
NUMBER(4) |
No |
The recall time associated with the unit state for day 1 Sunday |
|
RECALLTIME2 |
NUMBER(4) |
No |
The recall time associated with the unit state for day 2 Monday |
|
RECALLTIME3 |
NUMBER(4) |
No |
The recall time associated with the unit state for day 3 Tuesday |
|
RECALLTIME4 |
NUMBER(4) |
No |
The recall time associated with the unit state for day 4 Wednesday |
|
RECALLTIME5 |
NUMBER(4) |
No |
The recall time associated with the unit state for day 5 Thursday |
|
RECALLTIME6 |
NUMBER(4) |
No |
The recall time associated with the unit state for day 6 Friday |
|
RECALLTIME7 |
NUMBER(4) |
No |
The recall time associated with the unit state for day 7 Saturday |
Package: BILLING_RUN
Results from a published Billing Run. The settlement data and billing run data are updated daily Energy Rules Terms between 6 am and 8 am for AEMOs prudential processes. In a normal week, AEMO Australian Energy Market Operator publishes one PRELIM, one FINAL and two REVISION runs in addition to the daily runs. Each billing run is uniquely identified by contract year, week no and bill run no.
Modified table: BILLINGCPDATA
|
Comment |
BILLINGCPDATA shows energy quantity purchased/sold and $ value purchased/sold per participant connection point |
|
Visibility |
Private |
|
Trigger |
Populated by the posting of a billing run, being several times each week |
|
Data volume |
Small |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports |
|
Primary key (in order) |
BILLRUNNO, CONNECTIONPOINTID, CONTRACTYEAR, MDA, PARTICIPANTID, WEEKNO |
New columns
|
Field name |
Data type |
Primary key |
Comment |
|---|---|---|---|
|
SOLDENERGY |
NUMBER(18,8) |
No |
Energy sold at the connection point by the participant in this billing run |
|
SALES |
NUMBER(18,8) |
No |
The total cost of energy sold at the connection point by the participant in this billing run |
|
PURCHASEDENERGY |
NUMBER(18,8) |
No |
The energy consumed at the connection point by the participant in this billing run |
Modified column
|
Field name |
Data type |
Primary key |
Comment |
|---|---|---|---|
|
PURCHASES |
NUMBER(18,8) |
No |
The Purchase column has the dollar value of the Energy Purchased rather than Aggregate Energy Dollar |
Modified table: BILLINGASPAYMENTS
|
Comment |
BILLINGASPAYMENTS shows Ancillary Service payments for each billing period by each of the Ancillary Service types for each participant’s connection points |
|
Visibility |
Private |
|
Trigger |
Updated with each billing run |
|
Data volume |
Small |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports |
|
Primary key (in order) |
CONTRACTYEAR, PARTICIPANTID, WEEKNO, BILLRUNNO, CONNECTIONPOINTID |
New columns
|
Field name |
Data type |
Primary key |
Comment |
|---|---|---|---|
|
RAISE1SEC |
NUMBER(18,8) |
No |
Payment amount for the very fast raise service |
|
LOWER1SEC |
NUMBER(18,8) |
No |
Payment amount for the very fast lower service |
Modified table: BILLINGASRECOVERY
|
Comment |
BILLINGASRECOVERY shows participant charges for Ancillary Services for the billing period |
|
Visibility |
Private |
|
Trigger |
Updated with each billing run |
|
Data volume |
Small |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports |
|
Primary key (in order) |
CONTRACTYEAR, WEEKNO, BILLRUNNO, PARTICIPANTID, REGIONID |
New columns
|
Field name |
Data type |
Primary key |
Comment |
|
RAISE1SEC |
NUMBER(18,8) |
No |
Customer recovery amount for the very fast raise service |
|
LOWER1SEC |
NUMBER(18,8) |
No |
Customer recovery amount for the very fast lower service |
|
RAISE1SEC_GEN |
NUMBER(18,8) |
No |
Generator recovery amount for the very fast raise service |
|
LOWER1SEC_GEN |
NUMBER(18,8) |
No |
Generator recovery amount for the very fast lower service |
New table: BILLING_DIR_PROV_AMOUNT
|
Comment |
The Billing Provisional Directions Payment Amount for Directed/Affected/Eligible Participants |
|
Visibility |
Private |
|
Trigger |
Daily Run and Posting a PRELIM/FINAL and REVISE Billing Run |
|
Data volume |
Medium |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports |
|
Primary key (in order) |
CONTRACTYEAR, WEEKNO, BILLRUNNO, DIRECTION_ID, PARTICIPANTID, COMPENSATION_TYPE |
New columns
|
Field name |
Data type |
Primary key |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
Yes |
The Billing Contract Year |
|
WEEKNO |
NUMBER(3,0) |
Yes |
The Billing Week number |
|
BILLRUNNO |
NUMBER(3,0) |
Yes |
The Billing Run numbero |
|
DIRECTION_ID |
VARCHAR2(20) |
Yes |
The Direction Unique Identifier |
|
PARTICIPANTID |
VARCHAR2(20) |
Yes |
The Direction Payment Participant ID |
|
COMPENSATION_TYPE |
VARCHAR2(40) |
Yes |
The Direction Payment Type, Directed_Comp, Affected_Comp, Eligible_Comp |
|
COMPENSATION_AMOUNT |
NUMBER(18,8) |
No |
The Direction Payment Amount |
|
LASTCHANGED |
DATE |
No |
The Last datetime record is updated |
New table: BILLING_DIR_FINAL_AMOUNT
|
Comment |
The Billing Final Directions Payment Amount for Directed/Affected/Eligible participants |
|
Visibility |
Private |
|
Trigger |
Daily Run and Posting a PRELIM/FINAL and REVISE Billing Run |
|
Data volume |
Medium |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVREPORTS |
|
Primary key (in order) |
CONTRACTYEAR, WEEKNO, BILLRUNNO, DIRECTION_ID, PARTICIPANTID, COMPENSATION_TYPE |
New columns
|
Field name |
Data type |
Primary key |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
Yes |
The Billing Contract Year |
|
WEEKNO |
NUMBER(3,0) |
Yes |
The Billing WeekNo |
|
BILLRUNNO |
NUMBER(3,0) |
Yes |
The Billing RunNo |
|
DIRECTION_ID |
VARCHAR2(20) |
Yes |
The Direction Unique Identifier |
|
PARTICIPANTID |
VARCHAR2(20) |
Yes |
The Direction Payment Participant ID |
|
COMPENSATION_TYPE |
VARCHAR2(40) |
Yes |
The Direction Payment Type, Directed_Comp, Affected_Comp, Eligible_Comp |
|
PROVISIONAL_AMOUNT |
NUMBER(18,8) |
No |
The Direction Provisional Payment Amount |
|
FINAL_AMOUNT |
NUMBER(18,8) |
No |
The Direction Final Payment Amount |
|
LASTCHANGED |
DATE |
No |
The last datetime record is updated |
New table: BILLING_DIR_PROV_RECOVERY
|
Comment |
The Billing Provisional Directions Recovery Amount for the participants |
|
Visibility |
Private |
|
Trigger |
Daily Run and Posting a PRELIM/FINAL and REVISE Billing Run |
|
Data volume |
Medium |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVREPORTS |
|
Primary key (in order) |
CONTRACTYEAR, WEEKNO, BILLRUNNO, DIRECTION_ID, PARTICIPANTID |
New columns
|
Field name |
Data type |
Primary key |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
Yes |
The Billing Contract Year |
|
WEEKNO |
NUMBER(3,0) |
Yes |
The Billing Week number |
|
BILLRUNNO |
NUMBER(3,0) |
Yes |
The Billing Run number |
|
DIRECTION_ID |
VARCHAR2(20) |
Yes |
The Direction Unique Identifier |
|
PARTICIPANTID |
VARCHAR2(20) |
Yes |
The Direction Payment Participant ID |
|
CRA_AMOUNT |
NUMBER(18,8) |
No |
The Direction Compensation Recovery Amount |
|
RECOVERY_AMOUNT |
NUMBER(18,8) |
No |
The Direction Recovery Amount |
|
LASTCHANGED |
DATE |
No |
The Last datetime record is updated |
New table: BILLING_DIR_FINAL_RECOVERY
|
Comment |
The Billing Final Directions Recovery Amount for the participants |
|
Visibility |
Private |
|
Trigger |
Daily Run and Posting a PRELIM/FINAL and REVISE Billing Run |
|
Data volume |
Medium |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVREPORTS |
|
Primary key (in order) |
CONTRACTYEAR, WEEKNO, BILLRUNNO, DIRECTION_ID, PARTICIPANTID |
New columns
|
Field name |
Data type |
Primary key |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
Yes |
The Billing Contract Year |
|
WEEKNO |
NUMBER(3,0) |
Yes |
The Billing Week number |
|
BILLRUNNO |
NUMBER(3,0) |
Yes |
The Billing Run number |
|
DIRECTION_ID |
VARCHAR2(20) |
Yes |
The Direction Unique Identifier |
|
PARTICIPANTID |
VARCHAR2(20) |
Yes |
The Direction Payment Participant ID |
|
CRA_AMOUNT |
NUMBER(18,8) |
No |
The Direction Compensation Recovery Amount |
|
PROVISIONAL_AMOUNT |
NUMBER(18,8) |
No |
The Provisional Recovery Amount |
|
FINAL_AMOUNT |
NUMBER(18,8) |
No |
The Final Recovery Amount |
|
LASTCHANGED |
DATE |
No |
The Last datetime record is updated |
New table: BILLING_DIR_RECOVERY_DETAIL
|
Comment |
The Billing Directions Recovery Details for the participants |
|
Visibility |
Private |
|
Trigger |
Daily Run and Posting a PRELIM/FINAL and REVISE Billing Run |
|
Data volume |
Medium |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVREPORTS |
|
Primary key (in order) |
CONTRACTYEAR, WEEKNO, BILLRUNNO, DIRECTION_ID, PARTICIPANTID, PARTICIPANTCATEGORYID, REGIONID |
New columns
|
Field name |
Data type |
Primary key |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
Yes |
The Billing Contract Year |
|
WEEKNO |
NUMBER(3,0) |
Yes |
The Billing Week number |
|
BILLRUNNO |
NUMBER(3,0) |
Yes |
The Billing Run number |
|
DIRECTION_ID |
VARCHAR2(20) |
Yes |
The Direction Unique Identifier |
|
PARTICIPANTID |
VARCHAR2(20) |
Yes |
The Direction Payment Participant ID |
|
PARTICIPANTCATEGORYID |
VARCHAR2(20) |
Yes |
The Participant Category for recovery Customer/Generator/SmallGen |
|
REGIONID |
VARCHAR2(20) |
Yes |
The Region ID for the recovery |
|
RECOVERY_AMOUNT |
NUMBER(18,8) |
No |
The Direction Recovery Amount |
|
RECOVERY_ENERGY |
NUMBER(18,8) |
No |
The Energy Value used for the Recovery |
|
REGION_ENERGY |
NUMBER(18,8) |
No |
The total Energy at the Region ID |
|
EXCLUDED_ENERGY |
NUMBER(18,8) |
No |
The Energy Value (Scheduled Loads) that is excluded |
|
LASTCHANGED |
DATE |
No |
The Last datetime record is updated |
Modified table: BILLRESERVETRADERRECOVERY
|
Comment |
The Billing Reserve Trader Recovery Details for the participants |
|
Visibility |
Private |
|
Trigger |
Daily Run and Posting a PRELIM/FINAL and REVISE Billing Run |
|
Data volume |
Medium |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVREPORTS |
|
Primary key (in order) |
CONTRACTYEAR, WEEKNO, BILLRUNNO, PARTICIPANTID, REGIONID, PUBLICATION_ID, PAYMENT_ID |
New columns
|
Field name |
Data type |
Primary key |
Comment |
|
EXCLUDED_ENERGY |
NUMBER(18,8) |
No |
The Energy Value (Scheduled Loads) that is excluded |
New table: BILLING_ENERGY_TRAN_SAPS
|
Comment |
The SAP Billing Transaction Details for the participants |
|
Visibility |
Private |
|
Data volume |
Medium |
|
Trigger |
Daily Run and Posting a PRELIM/FINAL and REVISE Billing Run |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVREPORTS |
|
Primary key (in order) |
CONTRACTYEAR, WEEKNO, BILLRUNNO, PARTICIPANTID, TNI |
New columns
|
Field name |
Data type |
Primary key |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
Yes |
The billing contract year |
|
WEEKNO |
NUMBER(3,0) |
Yes |
The billing week number |
|
BILLRUNNO |
NUMBER(3,0) |
Yes |
The billing run number |
|
PARTICIPANTID |
VARCHAR2(20) |
Yes |
The SAPS Participant ID |
|
TNI |
VARCHAR2(20) |
Yes |
The SAPS Connection Point ID |
|
REGIONID |
VARCHAR2(20) |
No |
The Region ID associated with the TNI |
|
CONSUMED_ENERGY_MWH |
NUMBER(18,8) |
No |
The Energy MWh Consumed for that TNI for the Participant Id in that Billing Week |
|
SENTOUT_ENERGY_MWH |
NUMBER(18,8) |
No |
The Energy MWh Sent Out for the TNI for the Participant Id in that Billing Week |
|
CONSUMED_ENERGY_COST |
NUMBER(18,8) |
No |
The Cost of the Consumed Energy |
|
SENTOUT_ENERGY_COST |
NUMBER(18,8) |
No |
The Cost of the Sent Out Energy |
|
LASTCHANGED |
DATE |
No |
The Last datetime record is updated |
Package: DEMAND_FORECASTS
Regional See Relevant Rules or Procedures Demand The amount of power consumed at any time Forecasts and Intermittent Generation Energy Rules Terms forecasts.
Modified table: INTERMITTENT_GEN_FCST_DATA
Modifies the trigger information only. No change to the table structure.
|
Comment |
Stores the forecast generation (MW) for each interval within a given forecast of an intermittent generator. |
|
Visibility |
Private |
|
Data volume |
Medium |
|
Trigger |
INTERMITTENT_GEN_FCST_DATA updates every 30 minutes when AEMO issues a new 30-minute forecast of wind generation out to 8 days ahead. |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports |
|
Primary key (in order) |
DUID, INTERVAL_DATETIME, RUN_DATETIME |
New table: INTERMITTENT_GEN_SCADA
|
Comment |
INTERMITTENT_GEN_SCADA provides the SCADA Availability for every intermittent generating unit, including Elements Available (wind turbines/solar inverters) and Local Limit |
|
Visibility |
Private, public next day |
|
Data volume |
Large |
|
Trigger |
INTERMITTENT_GEN_SCADA shows data for every 5 minutes for all Intermittent Generating Units |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports |
|
Primary key (in order) |
RUN_DATETIME, DUID, SCADA_TYPE |
New columns
|
Field name |
Data type |
Primary key |
Comment |
|
RUN_DATETIME |
DATE |
Yes |
Date Time of the dispatch interval (interval ending) |
|
DUID |
VARCHAR2(20) |
Yes |
Dispatchable Unit Identifier |
|
SCADA_TYPE |
VARCHAR2(20) |
Yes |
SCADA snapshot for intermittent generating unit at start of interval for a specified SCADA signal type. ELAV = Total Elements Available (# turbines for wind farms, # inverters for solar farms); LOCL = Local Limit (MW). |
|
SCADA_VALUE |
NUMBER(15,5) |
No |
SCADA value snapshot for intermittent generating unit at start of interval for a specified SCADA signal type. |
|
SCADA_QUALITY |
VARCHAR2(20) |
No |
SCADA quality snapshot for intermittent generating unit at start of interval for a specified SCADA signal type. |
Package: DISPATCH
Results from a published Dispatch See National Electricity Rules Run.
Modified table: DISPATCHLOAD
|
Comment |
DISPATCHLOAD set out the current SCADA MW and target MW for each dispatchable unit, including relevant Frequency Control Ancillary Services (FCAS) enabling targets for each five minutes and additional fields to handle the new Ancillary Services functionality. Fast Start Plant status is indicated by dispatch mode |
|
Visibility |
Private, public next day |
|
Data volume |
Large |
|
Trigger |
DISPATCHLOAD shows data for every 5 minutes for all units, even zero targets |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports |
|
Primary key (in order) |
DUID, INTERVENTION, RUNNO, SETTLEMENTDATE |
New columns
|
Field name |
Data type |
Primary key |
Comment |
|
CONFORMANCE_MODE |
NUMBER(6,0) |
No |
Mode specific to units within an aggregate. 0 no monitoring, 1 aggregate monitoring, 2 individual monitoring due to constraint |
|
UIGF |
NUMBER(15,5) |
No |
For Semi-Scheduled units. Unconstrained Intermittent Generation Forecast value provided to NEMDE |
|
RAISE1SEC |
NUMBER(15,5) |
No |
Dispatched Raise1Sec TraderSolution element R1Target attribute |
|
RAISE1SECFLAGS |
NUMBER(3,0) |
No |
TraderSolution element R1Flags attribute |
|
LOWER1SEC |
NUMBER(15,5) |
No |
Dispatched Lower1Sec TraderSolution element L1Target attribute |
|
LOWER1SECFLAGS |
NUMBER(3,0) |
No |
TraderSolution element L1Flags attribute |
|
RAISE1SECACTUALAVAILABILITY |
NUMBER(16,6) |
No |
Trapezium adjusted Raise 1Sec Availability |
|
LOWER1SECACTUALAVAILABILITY |
NUMBER(16,6) |
No |
Trapezium adjusted Lower 1Sec Availability |
Modified columns
|
Field name |
Data type |
Primary key |
Comment |
|
AVAILABILITY |
NUMBER(15,5) |
No |
For Scheduled units, this is the MAXAVAIL bid availability. For Semi-scheduled units, this is the lower of MAXAVAIL bid availability and UIGF |
Modified table: DISPATCHPRICE
|
Comment |
DISPATCHPRICE records 5-minute dispatch prices for energy and FCAS, including whether an intervention has occurred, or price override (e.g. for Administered Price Cap). DISPATCHPRICE updates when price adjustments occur, in which case the new price is written to the RRP field, and the old price to the ROP field as an audit trail |
|
Visibility |
Public |
|
Data volume |
Large |
|
Trigger |
DISPATCHPRICE updates every 5 minutes |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports |
|
Primary key (in order) |
DISPATCHINTERVAL, INTERVENTION, REGIONID, RUNNO, SETTLEMENTDATE |
New columns
|
Field name |
Data type |
Primary key |
Comment |
|
RAISE1SECRRP |
NUMBER(15,5) |
No |
Regional Raise 1Sec Price R1Price attribute after capping/flooring |
|
RAISE1SECROP |
NUMBER(15,5) |
No |
Raise1Sec Regional Original Price uncapped/unfloored and unscaled |
|
RAISE1SECAPCFLAG |
NUMBER(3,0) |
No |
BitFlag field for Price adjustments 1 = Voll_Override; 4 = Floor_VoLL; 8 = Manual_Override; 16 = Price_Scaled |
|
LOWER1SECRRP |
NUMBER(15,5) |
No |
Regional Lower 1Sec Price RegionSolution element L1Price attribute |
|
LOWER1SECROP |
NUMBER(15,5) |
No |
Lower1Sec Regional Original Price uncapped/unfloored and unscaled |
|
LOWER1SECAPCFLAG |
NUMBER(3,0) |
No |
BitFlag field for Price adjustments 1 = Voll_Override; 4 = Floor_VoLL; 8 = Manual_Override; 16 = Price_Scaled |
|
PRE_AP_RAISE1_PRICE |
NUMBER(15,5) |
No |
Price before AP capping or scaling for Rolling Sum Price monitoring |
|
PRE_AP_LOWER1_PRICE |
NUMBER(15,5) |
No |
Price before AP capping or scaling for Rolling Sum Price monitoring |
|
CUMUL_PRE_AP_RAISE1_PRICE |
NUMBER(15,5) |
No |
Cumulative price that triggers administered pricing event if above the threshold |
|
CUMUL_PRE_AP_LOWER1_PRICE |
NUMBER(15,5) |
No |
Cumulative price that triggers administered pricing event if above the threshold |
Modified table: DISPATCHREGIONSUM
|
Comment |
DISPATCHREGIONSUM sets out the 5-minute solution for each dispatch run for each region, including the Frequency Control Ancillary Services (FCAS) services provided. Additional fields are for the Raise Regulation and Lower Regulation Ancillary Services plus improvements to demand calculations |
|
Visibility |
Public |
|
Data volume |
Large |
|
Trigger |
DISPATCHREGIONSUM updates every 5 minutes |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports |
|
Primary key (in order) |
DISPATCHINTERVAL, INTERVENTION, REGIONID, RUNNO, SETTLEMENTDATE |
New columns
|
Field name |
Data type |
Primary key |
Comment |
|
SS_SOLAR_AVAILABILITY |
NUMBER(15,5) |
No |
For Semi-Scheduled units. Aggregate Energy Availability from Solar units in that region |
|
SS_WIND_AVAILABILITY |
NUMBER(15,5) |
No |
For Semi-Scheduled units. Aggregate Energy Availability from Wind units in that region |
|
RAISE1SECLOCALDISPATCH |
NUMBER(15,5) |
No |
Total Raise1Sec Dispatched in Region RegionSolution element R1Dispatch attribute |
|
LOWER1SECLOCALDISPATCH |
NUMBER(15,5) |
No |
Total Lower1Sec Dispatched in Region RegionSolution element L1Dispatch attribute |
|
RAISE1SECACTUALAVAILABILITY |
NUMBER(16,6) |
No |
Trapezium adjusted Raise1Sec availability (summated from UnitSolution) |
|
LOWER1SECACTUALAVAILABILITY |
NUMBER(16,6) |
No |
Trapezium adjusted Lower1Sec availability (summated from UnitSolution) |
Modified table: DISPATCH_UNIT_CONFORMANCE
|
Comment |
DISPATCH_UNIT_CONFORMANCE details the conformance of a scheduled units operation with respect to a cleared target on dispatch interval basis. Data is confidential |
|
Visibility |
Private |
|
Data volume |
Medium |
|
Trigger |
DISPATCH_UNIT_CONFORMANCE shows data for every 5 minutes for all scheduled units |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports |
|
Primary key (in order) |
DUID, INTERVAL_DATETIME |
New columns
|
Field name |
Data type |
Primary key |
Comment |
|
ADG_ID |
VARCHAR2(20) |
No |
Aggregate Dispatch Group to which this dispatch unit belongs |
|
SEMIDISPATCHCAP |
NUMBER(3,0) |
No |
Boolean representation flagging if the Target is capped |
|
CONFORMANCE_MODE |
NUMBER(6,0) |
No |
For an individual unit in an aggregate dispatch group (where DUID <> ADG_ID), Mode specific to that unit. 0 no monitoring, 1 aggregate monitoring, 2 individual monitoring due to constraint. |
Modified columns
Comment changes only.
|
Field name |
Data type |
Primary key |
Comment |
|
DUID |
VARCHAR2(20) |
Yes |
Dispatchable Unit Identifier, or Aggregate Dispatch Group identifier |
|
ROC |
NUMBER(16,6) |
No |
Rate of Change in direction of error MW per minute |
Package: FORCE_MAJEURE
Market Suspensions and administer pricing event data.
6.6.1 Modified table: APEVENTREGION
|
Comment |
APEVENTREGION is the region detail for an administered pricing event defined through APEVENT |
|
Visibility |
Public |
|
Data volume |
Small |
|
Trigger |
Administered pricing event |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports |
|
Primary key (in order) |
APEVENTID, REGIONID |
New columns
|
Field name |
Data type |
Primary key |
Comment |
|
RAISE1SECAPFLAG |
NUMBER(3,0) |
No |
Flag indicating if the APEvent covers a Raise1Sec AP |
|
LOWER1SECAPFLAG |
NUMBER(3,0) |
No |
Flag indicating if the APEvent covers a Lower1Sec AP |
Modified table: MARKET_SUSPEND_SCHEDULE
|
Comment |
Trading prices applying in the event of a market suspension event updated weekly |
|
Visibility |
Public |
|
Data volume |
Small |
|
Trigger |
Weekly and ad hoc |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports |
|
Primary key (in order) |
DAY_TYPE, EFFECTIVEDATE, PERIODID, REGIONID |
New columns
|
Field name |
Data type |
Primary key |
Comment |
|
L1_RRP |
NUMBER(15,5) |
No |
Lower 1Sec contingency Price applied for this period for this Day Type |
|
R1_RRP |
NUMBER(15,5) |
No |
Raise 1Sec contingency Price applied for this period for this Day Type |
Package: METER_DATA
The Customer and Generator Metering Data used in the calculation of Settlements See Relevant Rules or Procedures.
New table: METERDATA_SAPS
|
Comment |
The SAPS Meter data for MSRP and Retailer used in the Settlement Calculation |
|
Visibility |
Public |
|
Data volume |
Large |
|
Trigger |
Posting a Prelim/Final or Revise Billing Run |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVREPORTS |
|
Primary key (in order) |
CASE_ID, SETTLEMENTDATE, CONNECTIONPOINT_ID, METER_TYPE, FRMP, LR, PERIODID |
New columns
|
Field name |
Data type |
Primary key |
Comment |
|
CASE_ID |
NUMBER(15,0) |
Yes |
The Metering Case ID used for Settlements |
|
SETTLEMENTDATE |
DATE |
Yes |
The Settlement Date for that week |
|
CONNECTIONPOINT_ID |
VARCHAR2(20) |
Yes |
The SAPS Connection Point Id |
|
METER_TYPE |
VARCHAR2(20) |
Yes |
The Meter Type Identifier, CUSTOMER or MSRP |
|
FRMP |
VARCHAR2(20) |
Yes |
The Financial Responsible Market Participant |
|
LR |
VARCHAR2(20) |
Yes |
The Local Retailer |
|
PERIODID |
NUMBER(4,0) |
Yes |
The Period ID Identifier |
|
IMPORTVALUE |
NUMBER(18,8) |
No |
The Sent Out Energy in MWh |
|
EXPORTVALUE |
NUMBER(18,8) |
No |
The Consumed Energy in MWh |
|
LASTCHANGED |
DATE |
No |
The Date time of the record last updated or inserted |
Package: MTPASA
Results from a published Medium Term PASA Projected Assessment of System Adequacy. except executable files e.g., .DLLs, .LIBs and .EXEs with the user mentioned. See National Energy Rules Run and region Energy Rules Terms-aggregate offered PASA Availability PASA Availability For a scheduled generating unit, scheduled bidirectional unit, scheduled load or scheduled network service in a given period, its available physical plant capability (taking ambient weather conditions into account) and any additional physical plant capability that can be made available during that period within a given recall period in accordance with the reliability standard implementation guidelines of Scheduled GeneratorsPackage.
Modified table: MTPASA_DUIDAVAILABILITY
|
Comment |
Offered PASA Availability of the scheduled generator DUID for each day over the Medium Term PASA period. The data in this table is input data to the MT PASA process. It is not part of the MTPASA solution. The availability does not reflect any energy limitations in the MT PASA offers |
|
Visibility |
Public |
|
Data volume |
Large |
|
Trigger |
After each MT PASA run (approximately every three hours) |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\CSV\REPORTS |
|
Primary key (in order) |
DAY, DUID, PUBLISH_DATETIME, REGIONID |
New columns
|
Field name |
Data type |
Primary key |
Comment |
|
PASAUNITSTATE |
VARCHAR2(20) |
No |
The unit state value |
|
PASARECALLTIME |
NUMBER(4) |
No |
The recall time value |
Package: P5MIN
Results from a published Five-minute Predispatch Run.
Modified table: P5MIN_FCAS_REQUIREMENT
|
Comment |
5-minute Predispatch constraint tracking for Regional FCAS recovery |
|
Visibility |
Private, public next day |
|
Trigger |
Updates against each 5-minute pre-dispatch run |
|
Data volume |
Large |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports |
|
Primary key (in order) |
RUN_DATETIME, INTERVAL_DATETIME, CONSTRAINTID, BIDTYPE, REGIONID |
New columns
|
Field name |
Data type |
Primary key |
Comment |
|
RUN_DATETIME |
DATE |
Yes |
First interval of the 5-minute Predispatch case |
|
INTERVAL_DATETIME |
DATE |
Yes |
Datetime of the 5-minute Predispatch interval |
|
CONSTRAINTID |
VARCHAR2(20) |
Yes |
ConstraintID – Join to table GenConData |
|
REGIONID |
VARCHAR2(20) |
Yes |
Region Identifier |
|
BIDTYPE |
VARCHAR2(10) |
Yes |
DUID offered type |
|
INTERVENTION |
NUMBER(2,0) |
No |
Intervention flag |
|
CONSTRAINT_EFFECTIVEDATE |
DATE |
No |
Constraint EffectiveDate – Join to table GenConData |
|
CONSTRAINT_VERSIONNO |
NUMBER(18,8) |
No |
Constraint Version number – Join to table GenConData |
|
MARGINALVALUE |
NUMBER(18,8) |
No |
Marginal $ value for energy |
|
BASE_COST |
NUMBER(18,8) |
No |
The base cost of the constraint for this service, before the regulation/contingency split |
|
ADJUSTED_COST |
NUMBER(18,8) |
No |
The adjusted cost of the constraint for this service, after the regulation/contingency split |
|
ESTIMATED_CMPF |
NUMBER(18,8) |
No |
An estimated value for the constraint CMPF, based on 5-minute Predispatch data |
|
ESTIMATED_CRMPF |
NUMBER(18,8) |
No |
An estimated value for the constraint CRMPF, based on 5-minute Predispatch data |
|
RECOVERY_FACTOR_CMPF |
NUMBER(18,8) |
No |
Estimated recovery factor for CMPF based recovery |
|
RECOVERY_FACTOR_CRMPF |
NUMBER(18,8) |
No |
Estimated recovery for CRMPF based recovery |
|
LASTCHANGED |
DATE |
No |
Last changed date for the record |
Modified table: P5MIN_UNITSOLUTION
|
Comment |
The five-minute predispatch (P5Min) is a MMS system providing projected dispatch for 12 Dispatch cycles (one hour). The 5-minute Predispatch cycle runs every 5-minutes to produce a dispatch and pricing schedule to a 5-minute resolution covering the next hour, a total of twelve periods P5MIN_UNITSOLUTION shows the Unit results from the capacity evaluations for each period of the study |
|
Visibility |
Private |
|
Data volume |
Large |
|
Trigger |
P5MIN_UNITSOLUTION updates every 5 minutes for all units, even zero targets |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVREPORTS |
|
Primary key (in order) |
DUID, INTERVAL_DATETIME, RUN_DATETIME |
New columns
|
Field name |
Data type |
Primary key |
Comment |
|
CONFORMANCE_MODE |
NUMBER(6,0) |
No |
Mode specific to units within an aggregate. 0 no monitoring, 1 aggregate monitoring, 2 individual monitoring due to constraint |
|
UIGF |
NUMBER(15,5) |
No |
For Semi-Scheduled units. Unconstrained Intermittent Generation Forecast value provided to NEMDE |
|
RAISE1SEC |
NUMBER(15,5) |
No |
Dispatched Raise1Sec TraderSolution element R1Target attribute |
|
RAISE1SECFLAGS |
NUMBER(3,0) |
No |
TraderSolution element R1Flags attribute |
|
LOWER1SEC |
NUMBER(15,5) |
No |
Dispatched Lower1Sec TraderSolution element L1Target attribute |
|
LOWER1SECFLAGS |
NUMBER(3,0) |
No |
TraderSolution element L1Flags attribute |
Modified columns
|
Field name |
Data type |
Primary key |
Comment |
|
AVAILABILITY |
NUMBER(15,5) |
No |
For Scheduled units, this is the MAXAVAIL bid availability For Semi-scheduled units, this is the lower of MAXAVAIL bid availability and UIGF |
Modified table: P5MIN_REGIONSOLUTION
|
Comment |
The five-minute predispatch (P5Min) is a MMS system providing projected dispatch for 12 Dispatch cycles (one hour). The 5-minute Predispatch cycle runs every 5-minutes to produce a dispatch and pricing schedule to a 5-minute resolution covering the next hour, a total of twelve periods P5MIN_REGIONSOLUTION shows the results of the regional capacity, maximum surplus reserve and maximum spare capacity evaluations for each period of the study |
|
Visibility |
Public |
|
Data volume |
Medium |
|
Trigger |
P5MIN_REGIONSOLUTION updates every 5 minutes |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVREPORTS |
|
Primary key (in order) |
INTERVAL_DATETIME, REGIONID, RUN_DATETIME |
New columns
|
Field name |
Data type |
Primary key |
Comment |
|
SS_SOLAR_AVAILABILITY |
NUMBER(15,5) |
No |
For Semi-Scheduled units. Aggregate Energy Availability from Solar units in that region |
|
SS_WIND_AVAILABILITY |
NUMBER(15,5) |
No |
For Semi-Scheduled units. Aggregate Energy Availability from Wind units in that region |
|
RAISE1SECRRP |
NUMBER(15,5) |
No |
Regional Raise 1Sec Price R1Price attribute after capping/flooring |
|
RAISE1SECROP |
NUMBER(15,5) |
No |
Raise1Sec Regional Original Price uncapped/unfloored and unscaled |
|
LOWER1SECRRP |
NUMBER(15,5) |
No |
Regional Lower 1Sec Price RegionSolution element L1Price attribute |
|
LOWER1SECROP |
NUMBER(15,5) |
No |
Lower1Sec Regional Original Price uncapped/unfloored and unscaled |
|
RAISE1SECLOCALDISPATCH |
NUMBER(15,5) |
No |
Total Raise1Sec Dispatched in Region RegionSolution element R1Dispatch attribute |
|
LOWER1SECLOCALDISPATCH |
NUMBER(15,5) |
No |
Total Lower1Sec Dispatched in Region RegionSolution element L1Dispatch attribute |
Package: PARTICIPANT_REGISTRATION
Participant registration data.
New table: AGGREGATE_DISPATCH_GROUP
|
Comment |
Entity allowing for compliance monitoring over grouped DUIDs |
|
Visibility |
Private, public next day |
|
Data volume |
Small |
|
Trigger |
TBC |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports |
|
Primary key (in order) |
ADG_ID |
New columns
|
Field name |
Data type |
Primary key |
Comment |
|
ADG_ID |
VARCHAR2(20) |
Yes |
Aggregate Dispatch Group ID |
|
COMMENTS |
VARCHAR2(100) |
No |
A participant provided comment |
|
LASTCHANGED |
DATE |
No |
Last date and time record changed |
New table: ADG_DETAIL
|
Comment |
Table for tracking evolving Aggregate Dispatch Group attributes |
|
Visibility |
Private, public next day |
|
Data volume |
Small |
|
Trigger |
TBC |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports |
|
Primary key (in order) |
ADG_ID, EFFECTIVEDATE, VERSION_DATETIME |
New columns
|
Field name |
Data type |
Primary key |
Comment |
|
ADG_ID |
VARCHAR2(20) |
Yes |
Identifies the Aggregate Dispatch Group |
|
EFFECTIVEDATE |
DATE |
Yes |
Effective calendar date of record |
|
VERSION_DATETIME |
DATE |
Yes |
Date and time of the version of Dispatchable Unit details |
|
ADG_TYPE |
VARCHAR2(20) |
No |
Conformance Type for the Aggregate Dispatch Group. One of the following: ‘CAP’, ’MIXED’, ‘TARGET’ |
|
AUTHORISEDDATE |
DATE |
No |
Date record authorised |
|
AUTHORISEDBY |
VARCHAR2(15) |
No |
User authorising record |
|
LASTCHANGED |
DATE |
No |
Last date and time record changed |
Modified table: DUDETAIL
|
Comment |
DUDETAIL sets out records specific details for each unit including start type and whether normally on or offload. Much of this data is information only and is not used in dispatch or settlements |
|
Visibility |
Public |
|
Data volume |
Medium |
|
Trigger |
DUDETAILSUMMARY updates only when registration details change |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVREPORTS |
|
Primary key (in order) |
DUID, EFFECTIVEDATE, VERSIONNO |
New columns
|
Field name |
Data type |
Primary key |
Comment |
|
ADG_ID |
VARCHAR2(20) |
No |
Aggregate Dispatch Group to which this dispatch unit belongs |
Modified table: DUDETAILSUMMARY
|
Important table changes |
See Introduction
|
|
Comment |
DUDETAILSUMMARY sets out a single summary unit table so reducing the need for participants to use the various dispatchable unit detail and owner tables to establish generating unit-specific details |
|
Visibility |
Public |
|
Data volume |
Medium |
|
Trigger |
DUDETAILSUMMARY updates only when registration details change |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVREPORTS |
|
Primary key (in order) |
DUID, START_DATE |
New columns
|
Field name |
Data type |
Primary key |
Comment |
|
VARCHAR2(20) |
No |
Aggregate Dispatch Group to which this dispatch unit belongs |
Package: PDPASA
The PDPASA package provides a 30-minute solving process to the Market systems. The current methodology for calculating reserves in the PreDispatch timeframe is determined in a post-processing step using a heuristic calculation based the results and Interconnector See Relevant Rules or Procedures limits from the PreDispatch run. The calculation is a reserve assessment based on the PASA solver similar to existing ST and MT PASA Medium Term Projected Assessment of System Adequacy. A 24-month supply demand forecast, published weekly, with daily resolution. business processes. The process reflects all intra-regional See Relevant Rules or Procedures and inter-regional network constraints as an input to the process.
Modified table: PDPASA_REGIONSOLUTION
|
Comment |
The PDPASA region solution data |
|
Visibility |
Public |
|
Data volume |
Medium |
|
Trigger |
PDPASA_REGIONSOLUTION is updated each PDPASA run (i.e. half-hourly). |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports |
|
Primary key (in order) |
INTERVAL_DATETIME, REGIONID, RUN_DATETIME, RUNTYPE |
Modified columns
|
Field name |
Data type |
Primary key |
Comment |
|
NUMBER(15,5) |
No |
Aggregate Regional availability of Semi-scheduled units limited by MAXAVAIL bid |
|
|
NUMBER(15,5) |
No |
Aggregate Regional availability of Semi-scheduled units limited by MAXAVAIL bid for LOR |
|
|
NUMBER(15,5) |
No |
Sum of MAXAVAIL quantities offered by all Scheduled units and Availability of all semi-scheduled units limited by MAXAVAIL in a given Region for a given PERIODID |
|
|
NUMBER(12,2) |
No |
Unconstrained Intermittent Generation Forecast for solar for the region. For RELIABILITY_LRC and OUTAGE_LRC run this is the POE90 forecast (determined by LRCUIGFOption in CaseSolution). For LOR run this is the POE50 forecast |
|
|
NUMBER(12,2) |
No |
Constrained generation forecast for solar for the region. For RELIABILITY_LRC run solar generation is constrained only by System Normal constraints. For OUTAGE_LRC run and LOR run solar generation is constrained by both System Normal and Outage constraints. All three run types (RELIABILITY_LRC, OUTAGE_LRC, LOR) incorporate MAXAVAIL limits. |
|
|
NUMBER(12,2) |
No |
Constrained generation forecast for solar for the region. For RELIABILITY_LRC run solar generation is constrained only by System Normal constraints. For OUTAGE_LRC run and LOR run solar generation is constrained by both System Normal and Outage constraints. All three run types (RELIABILITY_LRC, OUTAGE_LRC, LOR) incorporate MAXAVAIL limits. |
|
|
NUMBER(12,2) |
No |
Unconstrained Intermittent Generation Forecast for wind for the region. For RELIABILITY_LRC and OUTAGE_LRC run this is the POE90 forecast (determined by LRCUIGFOption in CaseSolution). For LOR run this is the POE50 forecast |
|
|
NUMBER(12,2) |
No |
Constrained generation forecast for wind for the region. For RELIABILITY_LRC run wind generation is constrained only by System Normal constraints. For OUTAGE_LRC run and LOR run wind generation is constrained by both System Normal and Outage constraints. All three run types (RELIABILITY_LRC, OUTAGE_LRC, LOR) incorporate MAXAVAIL limits. |
|
|
NUMBER(12,2) |
No |
Constrained generation forecast for wind for the region. For RELIABILITY_LRC run wind generation is constrained only by System Normal constraints. For OUTAGE_LRC run and LOR run wind generation is constrained by both System Normal and Outage constraints. All three run types (RELIABILITY_LRC, OUTAGE_LRC, LOR) incorporate MAXAVAIL limits. |
Package: PRE_DISPATCH
Results from a published Predispatch Run.
Modified table: PREDISPATCHLOAD
|
Comment |
PREDISPATCHLOAD shows pre-dispatch targets for each dispatchable unit, including additional fields to handle the Ancillary Services functionality. No record is written where a unit is not dispatched. PREDISPATCHLOAD shows all the results for each period. |
|
Visibility |
Private, public next day |
|
Data volume |
Large |
|
Trigger |
Own (confidential) data updates every thirty minutes, with whole market data for the day before available as part of next day market data |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports |
|
Primary key (in order) |
DATETIME, DUID |
New columns
|
Field name |
Data type |
Primary key |
Comment |
|
NUMBER(6,0) |
No |
Mode specific to units within an aggregate. 0 - no monitoring, 1 - aggregate monitoring, 2 - individual monitoring due to constraint. |
|
|
NUMBER(15,5) |
No |
For Semi-Scheduled units. Unconstrained Intermittent Generation Forecast value provided to NEMDE |
|
|
NUMBER(15,5) |
No |
Dispatched Raise1Sec - TraderSolution element R1Target attribute |
|
|
NUMBER(3,0) |
No |
TraderSolution element R1Flags attribute |
|
|
NUMBER(15,5) |
No |
Dispatched Lower1Sec - TraderSolution element L1Target attribute |
|
|
NUMBER(3,0) |
No |
TraderSolution element L1Flags attribute |
|
|
NUMBER(16,6) |
No |
Trapezium adjusted Raise 1Sec Availability |
|
|
NUMBER(16,6) |
No |
Trapezium adjusted Lower 1Sec Availability |
Modified columns
|
Field name |
Data type |
Primary key |
Comment |
|
NUMBER(15,5) |
No |
For Scheduled units, this is the MAXAVAIL bid availability. For Semi-scheduled units, this is the lower of MAXAVAIL bid availability and UIGF |
Modified table: PREDISPATCHREGIONSUM
|
Comment |
PREDISPATCHREGIONSUM sets out the overall regional Pre-Dispatch results for base case details (excluding price) PREDISPATCHREGIONSUM includes the forecast demand (total demand) and Frequency Control Ancillary Services (FCAS) requirements (specifically, for the Raise Regulation and Lower Regulation Ancillary Services plus improvements to demand calculations). PREDISPATCHREGIONSUM updates each half-hour with the latest Pre-dispatch details for the remaining period. Regional demand can be calculated as total demand plus dispatchable load (i.e. Regional demand = Total Demand + Dispatchable Load) |
|
Visibility |
Public |
|
Data volume |
Medium |
|
Trigger |
PREDISPATCHREGIONSUM updates every thirty minutes |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports |
|
Primary key (in order) |
DATETIME, REGIONID |
New columns
|
Field name |
Data type |
Primary key |
Comment |
|
NUMBER(15,5) |
No |
For Semi-Scheduled units. Aggregate Energy Availability from Solar units in that region |
|
|
NUMBER(15,5) |
No |
For Semi-Scheduled units. Aggregate Energy Availability from Wind units in that region |
|
|
NUMBER(15,5) |
No |
Total Raise1Sec Dispatched in Region - RegionSolution element R1Dispatch attribute |
|
|
NUMBER(15,5) |
No |
Total Lower1Sec Dispatched in Region - RegionSolution element L1Dispatch attribute |
|
|
NUMBER(16,6) |
No |
Trapezium adjusted Raise1Sec availability (summated from UnitSolution) |
|
|
NUMBER(16,6) |
No |
Trapezium adjusted Lower1Sec availability (summated from UnitSolution) |
Modified table: PREDISPATCHPRICE
|
Comment |
The PDPASA region solution data |
|
Visibility |
Public |
|
Data volume |
Medium |
|
Trigger |
PREDISPATCHPRICE updates with every thirty-minute predispatch run |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports |
|
Primary key (in order) |
DATETIME, REGIONID |
New columns
|
Field name |
Data type |
Primary key |
Comment |
|
NUMBER(15,5) |
No |
Regional Raise 1Sec Price - R1Price attribute after capping/flooring |
|
|
NUMBER(15,5) |
No |
Regional Lower 1Sec Price - RegionSolution element L1Price attribute |
Package: SETTLEMENT_CONFIG
The configuration data needed for the Settlement Run.
New table: SETCFG_SAPS_SETT_PRICE
|
Comment |
The Settlement Price for SAPS Energy in each Region |
|
Visibility |
Public |
|
Data volume |
Small |
|
Trigger |
Triggering of a new SAPS Pricing Calculation for the Eligible Application Period in Settlements |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVREPORTS |
|
Primary key (in order) |
FROMDATE, TODATE, REGIONID, VERSION_DATETIME |
New columns
|
Field name |
Data type |
Primary key |
Comment |
|
DATE |
Yes |
The From Date of the SAPS Pricing Application Period |
|
|
DATE |
Yes |
The To Date of the SAPS Pricing Application Period |
|
|
VARCHAR2(20) |
Yes |
The Region ID for which the calculated SAPS Price is applicable |
|
|
DATE |
Yes |
The Date time of the record generation |
|
|
NUMBER(18,8) |
No |
The Region Reference Price for SAPS in the Region |
|
|
NUMBER(3,0) |
No |
Whether the SAPS Price is Firm or Non-firm |
|
|
DATE |
No |
The Last Changed Date time of the record |
Package: SETTLEMENT_DATA
Results from a published Settlements Run. The settlement data and billing run data are updated daily between 6 am and 8 am for AEMO's prudential processes. In a normal week, AEMO publishes one PRELIM, one FINAL and two REVISION runs in addition to the daily runs.
Modified table: SETCPDATA
|
Comment |
SETCPDATA shows meter settlement data for each connection point. This is the key view for retailers to verify energy charges. A regional summary view is also provided. As the view has values for each connection point by period, for each meter data file, it is a very large view. |
|
Visibility |
Private |
|
Trigger |
SETCPDATA updates with each Settlement run |
|
Data volume |
Medium |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports |
|
Primary key (in order) |
MDA, PARTICIPANTID, PERIODID, SETTLEMENTDATE, TCPID, VERSIONNO |
New columns
|
Field name |
Data type |
Primary key |
Comment |
|
NUMBER(18,8) |
No |
The total cost of energy sold at the connection point by the participant in this settlement interval |
|
|
NUMBER(18,8) |
No |
The total cost of energy purchased at the connection point by the participant in this settlement interval |
Modified columns
|
Field name |
Data type |
Primary key |
Comment |
|
AFE |
NUMBER(18,8) |
No |
Accounted For Energy for this Market Customer FRMP and TNI in the Settlements Trading Interval, excluding any UFEA component |
Modified table: SET_FCAS_PAYMENT
|
Comment |
SET_FCAS_PAYMENT sets out the enabling payment details for frequency controlled Ancillary Services |
|
Visibility |
Private |
|
Trigger |
Posting of a billing run |
|
Data volume |
Large |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports |
|
Primary key (in order) |
DUID, PERIODID, SETTLEMENTDATE, VERSIONNO |
New columns
|
Field name |
Data type |
Primary key |
Comment |
|
NUMBER(18,8) |
No |
Payment amount for the very fast raise service |
|
|
NUMBER(18,8) |
No |
Payment amount for the very fast lower service |
Modified table: SET_FCAS_RECOVERY
|
Comment |
SET_FCAS_RECOVERY shows reimbursements for the Frequency Control Ancillary Services (FCAS) to be recovered from participants. Beware of potential confusion with the table SETFCASRECOVERY, which reports reimbursements for Frequency Control Ancillary Services Compensation (now unused). |
|
Visibility |
Private |
|
Trigger |
TBC |
|
Data volume |
Large |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports |
|
Primary key (in order) |
PARTICIPANTID, PERIODID, REGIONID, SETTLEMENTDATE, VERSIONNO |
New columns
|
Field name |
Data type |
Primary key |
Comment |
|
NUMBER(18,8) |
No |
Customer recovery amount for the very fast raise service |
|
|
NUMBER(18,8) |
No |
Customer recovery amount for the very fast lower service |
|
|
NUMBER(18,8) |
No |
Generator recovery amount for the very fast raise service |
|
|
NUMBER(18,8) |
No |
Generator recovery amount for the very fast lower service |
New table: SET_ENERGY_TRAN_SAPS
|
Comment |
The table shows the Transaction Details for the SAPS Connection Points. The table contains both the MSRPs and Retailers data |
|
Visibility |
Private |
|
Data volume |
Medium |
|
Trigger |
Daily Billing Run & Posting a PRELIM/FINAL and REVISE Billing Run |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports |
|
Primary key (in order) |
SETTLEMENTDATE, VERSIONNO, PERIODID, PARTICIPANTID, TNI |
New columns
|
Field name |
Data type |
Primary key |
Comment |
|
DATE |
Yes |
The Settlement Date of the Billing Week |
|
|
NUMBER(3,0) |
Yes |
The Settlement Run number |
|
|
NUMBER(3,0) |
Yes |
The Period Id identifier |
|
|
VARCHAR2(20) |
Yes |
The Participant ID for the SAPS TNI |
|
|
VARCHAR2(20) |
Yes |
The SAPS Connection Point Identifier |
|
|
VARCHAR2(20) |
No |
The SAPS Region ID |
|
|
NUMBER(18,8) |
No |
The SAPS Settlement Price for the Region |
|
|
NUMBER(18,8) |
No |
The Energy MWh Consumed for that TNI for the Participant ID |
|
|
NUMBER(18,8) |
No |
The Energy MWh Sent Out for the TNI for the Participant Id |
|
|
NUMBER(18,8) |
No |
The Cost of the Consumed Energy |
|
|
NUMBER(18,8) |
No |
The Cost of the Sent Out Energy |
|
|
DATE |
No |
The Last changed Date time of the record |
Package: STPASA_SOLUTION
Results from a published Short Term PASA run.
Modified table: STPASA_REGIONSOLUTION
|
Comment |
STPASA_REGIONSOLUTION shows the results of the regional capacity, maximum surplus reserve and maximum spare capacity evaluations for each period of the study |
|
Visibility |
Public |
|
Data volume |
Large |
|
Trigger |
STPASA_REGIONSOLUTION is updated each STPASA run (approximately every 2 hours) |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports |
|
Primary key (in order) |
INTERVAL_DATETIME, REGIONID, RUN_DATETIME, RUNTYPE |
Modified columns
|
Field name |
Data type |
Primary key |
Comment |
|
UNCONSTRAINEDCAPACITY |
NUMBER(12,0) |
No |
In a Region, capacity from generation/Load with no Daily Energy Constraint, subject to network security constraints |
|
CONSTRAINEDCAPACITY |
NUMBER(12,0) |
No |
In a Region, capacity from generation/Load with non-zero Daily Energy Constraint, subject to network security constraints |
|
SEMISCHEDULEDCAPACITY |
NUMBER(15,5) |
No |
Aggregate Regional availability of Semi-scheduled units limited by MAXAVAIL bid |
|
LOR_ SEMISCHEDULEDCAPACITY |
NUMBER(15,5) |
No |
Aggregate Regional availability of Semi-scheduled units limited by MAXAVAIL bid for LOR |
|
AGGREGATECAPACITYAVAILABLE |
NUMBER(15,5) |
No |
Sum of MAXAVAIL quantities offered by all Scheduled units and Availability of all semi-scheduled units limited by MAXAVAIL in a given Region for a given PERIODID |
|
SS_SOLAR_UIGF |
NUMBER(12,2) |
No |
Unconstrained Intermittent Generation Forecast for solar for the region. For RELIABILITY_LRC and OUTAGE_LRC run this is the POE90 forecast (determined by LRCUIGFOption in CaseSolution). For LOR run this is the POE50 forecast |
|
SS_SOLAR_CAPACITY |
NUMBER(12,2) |
No |
Constrained generation forecast for solar for the region. For RELIABILITY_LRC run solar generation is constrained only by System Normal constraints. For OUTAGE_LRC run and LOR run solar generation is constrained by both System Normal and Outage constraints. All three run types (RELIABILITY_LRC, OUTAGE_LRC, LOR) incorporate MAXAVAIL limits. |
|
SS_SOLAR_CLEARED |
NUMBER(12,2) |
No |
Constrained generation forecast for solar for the region. For RELIABILITY_LRC run solar generation is constrained only by System Normal constraints. For OUTAGE_LRC run and LOR run solar generation is constrained by both System Normal and Outage constraints. All three run types (RELIABILITY_LRC, OUTAGE_LRC, LOR) incorporate MAXAVAIL limits. |
|
SS_WIND_UIGF |
NUMBER(12,2) |
No |
Unconstrained Intermittent Generation Forecast for wind for the region. For RELIABILITY_LRC and OUTAGE_LRC run this is the POE90 forecast (determined by LRCUIGFOption in CaseSolution). For LOR run this is the POE50 forecast |
|
SS_WIND_CAPACITY |
NUMBER(12,2) |
No |
Constrained generation forecast for wind for the region. For RELIABILITY_LRC run wind generation is constrained only by System Normal constraints. For OUTAGE_LRC run and LOR run wind generation is constrained by both System Normal and Outage constraints. All three run types (RELIABILITY_LRC, OUTAGE_LRC, LOR) incorporate MAXAVAIL limits. |
|
SS_WIND_CLEARED |
NUMBER(12,2) |
No |
Constrained generation forecast for wind for the region. For RELIABILITY_LRC run wind generation is constrained only by System Normal constraints. For OUTAGE_LRC run and LOR run wind generation is constrained by both System Normal and Outage constraints. All three run types (RELIABILITY_LRC, OUTAGE_LRC, LOR) incorporate MAXAVAIL limits. |
Package: TRADING_DATA
30-minute Trading interval results.
Modified table: TRADINGPRICE
|
Comment |
TRADINGPRICE sets out 5 minutes spot market price, including fields to handle the Ancillary Services functionality. If prices are adjusted, the final price is recorded in the regional reference price (RRP) field with price before adjustment recorded in the regional original price (ROP) field. Prior to 5 Minute Settlements, this was half-hourly spot market values, which was calculated as the average of the six 5-minute dispatch intervals within the 30 minute period |
|
Visibility |
Public |
|
Data volume |
Medium |
|
Trigger |
TRADINGPRICE updates every 30 minutes |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports |
|
Primary key (in order) |
PERIODID, REGIONID, RUNNO, SETTLEMENTDATE |
New columns
|
Field name |
Data type |
Primary key |
Comment |
|
NUMBER(15,5) |
No |
Regional Raise 1Sec Price - R1Price attribute after capping/flooring |
|
|
NUMBER(15,5) |
No |
Raise1Sec Regional Original Price - uncapped/unfloored and unscaled |
|
|
NUMBER(15,5) |
No |
Regional Lower 1Sec Price - RegionSolution element L1Price attribute |
|
|
NUMBER(15,5) |
No |
Lower1Sec Regional Original Price - uncapped/unfloored and unscaled |
Package: VOLTAGE_INSTRUCTIONS
Instructions for MVAr Dispatch.
Modified table: VOLTAGE_INSTRUCTION
|
Comment |
Child record for Voltage Instructions (MVAr Dispatch) |
|
Visibility |
Public |
|
Data volume |
Large |
|
Trigger |
Signal or instructions issued |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports |
|
Primary key (in order) |
EMS_ID, VERSION_DATETIME, EMS_ID |
Modified columns
|
Field name |
Data type |
Primary key |
Comment |
|
NUMBER(20,5) |
No |
Instruction for the device, for this interval – null denotes no instruction |
File interface changes
|
Package |
File ID |
Description |
Batcher file masks |
Frequency |
Modification |
Auto-subscription |
|
BIDS |
MTPASA_OFFERFILETRK |
Participant submitted offers for the MT PASA process |
*_BID_*.CSV |
Participant submitted MT PASA offer |
Modified |
No |
|
BILLING |
BILLING |
Results from a published Billing Run |
*_BILLING_*.CSV |
Weekly |
Modified |
No |
|
DEMAND |
INTERMITTENT_GEN_FCST |
Regional Demand and Intermittent Generation forecasts |
*_INTERMITTENT_GEN_FCST_*.CSV |
Ad hoc |
Modified |
No |
|
DISPATCH |
DISPATCHIS |
Results from a published dispatch run |
*_DISPATCHIS_*.CSV |
Every 5 minutes |
Modified |
No |
|
FORCE_MAJEURE |
APEVENTREGION |
Market suspensions and administer pricing event data |
*_AP_EVENT_*.CSV |
On participant submission |
Modified |
No |
|
MARKET_SUSPEND_SCHEDULE |
*_MARKET_*_*.CSV |
On suspension |
Modified |
No |
||
|
METER_DATA |
METER_DATA |
The Customer and Generator meter data used in the calculation of Settlements |
*_METER_DATA_*.CSV |
After a Billing Run |
Modified |
No |
|
MTPASA |
MTPASADUIDAVAILABILITY |
Offered MT PASA availability for each day over the MT PASA period |
*_MTPASADUIDAVAILABILITY_*.CSV |
Weekly |
Modified |
No |
|
P5MIN |
P5MIN |
Results from a published five-minute pre-dispatch run |
*_P5MIN_*.CSV |
Every 5 minutes |
Modified |
No |
|
PARTICIPANT |
DUDETAIL DUDETAILSUMMARY |
Modifies the DUDETAIL, DUDETAILSUMMART tables to add Aggregate Dispatch Group. |
*_PARTICIPANT_REGISTRATION_*.CSV |
When registration details change |
Modified |
No |
|
AGGREGATE_DISPATCH_GROUP |
Entity allowing for compliance monitoring over grouped DUIDs |
*_AGGREGATE_DISPATCH_GROUP_* |
When registration details change |
New |
Yes |
|
|
ADG_DETAIL |
Table for tracking evolving Aggregate Dispatch Group attributes |
*_AGGREGATE_DISPATCH_GROUP_* |
When registration details change |
New |
Yes |
|
|
PDPASA |
PDPASA |
Provides a 30-minute solving process to the market systems |
*_PDPASA_*.CSV |
Every 30 minutes |
Modified |
No |
|
PRE |
PREDISPATCHIS |
Results from a published pre-dispatch run |
*_PREDISPATCHIS_*.CSV |
After a pre-dispatch run |
Modified |
No |
|
SETTLEMENT |
SETTLEMENT_CONFIG |
Configuration and input data for the settlements process |
*_SETTLEMENT_CONFIG_*.CSV |
After a settlement run |
Modified |
No |
|
SETTLEMENT |
SETTLEMENTS |
Results from a published settlements run |
*_SETTLEMENTS_*.CSV |
Daily |
Modified |
No |
|
STPASA |
STPASA |
Results from a published short term PASA run |
*_STPASA_*.CSV |
Every 2 hours |
Modified |
No |
|
TRADING_DATA |
TRADINGPRICE |
30-minute trading interval results |
*_TRADINGPRICE_*.CSV |
Every dispatch interval |
Modified |
No |
|
VOLTAGE |
VOLTAGE_INSTRUCTION |
Instructions for MVAr Dispatch |
*_VOLTAGE_INSTRUCTIONS_*.CSV |
Approx. every 15 mins and as required |
Modified |
No |
Participant interfaces changes
|
Package |
Data model table |
File ID |
CSV report type |
Change |
|
BIDS |
MTPASA_OFFERDATA |
MTPASA_OFFERFILETRK |
MTPASA_OFFERFILETRK,MTPASA_OFFERDATA,1 |
Modified |
|
BILLING |
BILLINGCPDATA |
BILLING |
BILLING,BILLINGCPDATA,7 |
Modified |
|
BILLINGASPAYMENTS |
BILLING |
BILLING,BILLINGASPAYMENTS,7 |
Modified |
|
|
BILLINGASRECOVERY |
BILLING |
BILLING,BILLINGASRECOVERY,8 |
Modified |
|
|
BILLING_DIR_PROV_AMOUNT |
BILLING |
BILLING,BILLING_DIR_PROV_AMOUNT,1 |
New |
|
|
BILLING_DIR_FINAL_AMOUNT |
BILLING |
BILLING, BILLING_DIR_FINAL_AMOUNT,1 |
New |
|
|
BILLING_DIR_PROV_RECOVERY |
BILLING |
BILLING, BILLING_DIR_PROV_RECOVERY,1 |
New |
|
|
BILLING_DIR_FINAL_RECOVERY |
BILLING |
BILLING, BILLING_DIR_FINAL_RECOVERY,1 |
New |
|
|
BILLING_DIR_RECOVERY_DETAIL |
BILLING |
BILLING, BILLING_DIR_ RECOVERY_DETAIL,1 |
New |
|
|
BILLRESERVETRADERRECOVERY |
BILLING |
BILLING,BILLING_RES_TRADER_RECOVERY,2 |
Modified |
|
|
BILLING_ENERGY_TRAN_SAPS |
BILLING |
BILLING,BILLING_ENERGY_TRAN_SAPS,1 |
New |
|
|
DEMAND |
INTERMITTENT_GEN_FCST_DATA |
INTERMITTENT_GEN_FCST |
INTERMITTENT_GEN_FCST,INTERMITTENT_GEN_FCST_DATA,1 |
Modified |
|
INTERMITTENT_GEN_SCADA |
INTERMITTENT_GEN_FCST |
INTERMITTENT_GEN_FCST,INTERMITTENT_GEN_SCADA,1 |
New |
|
|
SET_ENERGY_TRAN_SAPS |
INTERMITTENT_GEN_FCST |
INTERMITTENT_GEN_FCST,SET_ENERGY_TRAN_SAPS,1 |
New |
|
|
DISPATCH |
DISPATCHLOAD |
DISPATCHIS |
DISPATCHIS,DISPATCHLOAD,4 |
Modified |
|
DISPATCHLOAD |
NEXT_DAY_DISPATCH |
NEXT_DAY_DISPATCH,DISPATCHLOAD,4 |
Modified |
|
|
DISPATCHPRICE |
DISPATCHIS |
DISPATCHIS,DISPATCHPRICE,5 |
Modified |
|
|
DISPATCHPRICE |
PRICE_REVISION_DISPATCHIS |
PRICE_REVISION_DISPATCHIS,DISPATCHPRICE,5 |
Modified |
|
|
DISPATCHREGIONSUM |
DISPATCHIS |
DISPATCHIS,DISPATCHREGIONSUM,7 |
Modified |
|
|
DISPATCH_UNIT_CONFORMANCE |
DISPATCH_CONFORMANCE |
DISPATCH_CONFORMANCE,DISPATCH_CONFORMANCE,2 |
Modified |
|
|
FORCE |
APEVENTREGION |
AP_EVENT |
AP_EVENT,APEVENTREGION,2 |
Modified |
|
MARKET_SUSPEND_SCHEDULE |
SUSPENSION_SCHEDULE |
SUSPENSION_SCHEDULE,MARKET_SUSPEND_SCHEDULE,2 |
Modified |
|
|
METER |
METERDATA_SAPS |
METER_DATA |
METER_DATA,METERDATA_SAPS,1 |
New |
|
MTPASA |
MTPASA_DUIDAVAILABILITY |
MTPASADUIDAVAILABILITY |
MTPASA,MTPASA_DUIDAVAILABILITY,2 |
Modified |
|
P5MIN |
P5MIN_FCAS_REQUIREMENT |
P5MIN |
P5MIN,P5MIN_FCAS_REQUIREMENT,1 |
New |
|
P5MIN_UNITSOLUTION |
P5MIN |
P5MIN,P5MIN_UNITSOLUTION,5 |
Modified |
|
|
P5MIN_REGIONSOLUTION |
P5MIN |
P5MIN,P5MIN_REGIONSOLUTION,8 |
Modified |
|
|
P5MIN_FCAS_REQUIREMENT |
P5MIN |
P5MIN,P5MIN_FCAS_REQUIREMENT,1 |
New |
|
|
PARTICIPANT |
AGGREGATE_DISPATCH_GROUP |
AGGREGATE_DISPATCH_GROUP |
AGGREGATE_DISPATCH_GROUP,AGGREGATE_DISPATCH_GROUP,1 |
New |
|
ADG_DETAIL |
AGGREGATE_DISPATCH_GROUP |
AGGREGATE_DISPATCH_GROUP,ADG_DETAIL,1 |
New |
|
|
DUDETAIL |
DUDETAIL |
PARTICIPANT_REGISTRATION,DUDETAIL,5 |
Modified |
|
|
DUDETAILSUMMARY |
DUDETAIL SUMMARY |
PARTICIPANT_REGISTRATION,DUDETAIL_SUMMARY,6 |
Modified |
|
|
PDPASA |
PSPASA_REGIONSOLUTION |
PDPASA |
PDPASA,PSPASA_REGIONSOLUTION,8 |
Modified |
|
PRE |
PREDISPATCHLOAD |
PREDISPATCH |
PREDISPATCH,PREDISPATCHLOAD,3 |
Modified |
|
PREDISPATCHLOAD |
NEXT_DAY_PREDISPATCH_D |
NEXT_DAY_PREDISPATCH_D,PREDISPATCHLOAD,3 |
Modified |
|
|
PREDISPATCHPRICE |
PREDISPATCHIS |
PREDISPATCHIS, PREDISPATCHPRICE,2 |
Modified |
|
|
PREDISPATCHREGIONSUM |
PREDISPATCH |
PREDISPATCH,PREDISPATCHREGIONSUM,7 |
Modified |
|
|
SETTLEMENT |
SETCFG_SAPS_SETT_PRICE |
SETTLEMENT_CONFIG |
SETTLEMENT_CONFIG,SETCFG_SAPS_SETT_PRICE,1 |
New |
|
SETTLEMENT |
SETCPDATA |
SETTLEMENTS |
SETTLEMENTS,SETCPDATA,7 |
Modified |
|
SET_FCAS_PAYMENT |
SETTLEMENTS |
SETTLEMENTS,FCAS_RECOVERY,7 |
Modified |
|
|
SET_FCAS_RECOVERY |
SETTLEMENTS |
SETTLEMENTS,FCAS_PAYMENT,6 |
Modified |
|
|
SET_ENERGY_TRAN_SAPS |
SETTLEMENTS |
SETTLEMENTS,SET_ENERGY_TRAN_SAPS,1 |
New |
|
|
STPASA |
STPASA_REGIONSOLUTION |
STPASA |
STPASA,STPASA_REGIONSOLUTION,8 |
Modified |
|
TRADING |
TRADINGPRICE |
PRICE_REVISION_TRADINGIS |
TRADINGIS,TRADINGPRICE,3 |
Modified |
|
VOLTAGE |
VOLTAGE_INSTRUCTIONS |
VOLTAGE_INSTRUCTIONS |
VOLTAGE_INSTRUCTIONS,VOLTAGE_INSTRUCTIONS,3 |
Modified |
Discontinued reports
|
Data model table |
File ID |
Delivered in file |
CSV report type |
Replaced by |
|
BILLING_APC_COMPENSATION |
BILLING |
*_BILLING_LEGACY_*.CSV |
BILLING,BILLING_APC_COMPENSATION,1 |
BILLING,BILLING_APC_COMPENSATION,2 |
|
BILLING_APC_RECOVERY |
BILLING |
*_BILLING_LEGACY_*.CSV |
BILLING,BILLING_APC_RECOVERY,1 |
BILLING,BILLING_APC_RECOVERY,2 |
|
BILLING_GST_DETAIL |
BILLING |
*_BILLING_LEGACY_*.CSV |
BILLING,BILLING_GST_DETAIL,4 |
BILLING,BILLING_GST_DETAIL,5 |
|
BILLING_GST_SUMMARY |
BILLING |
*_BILLING_LEGACY_*.CSV |
BILLING,BILLING_GST_SUMMARY,4 |
BILLING,BILLING_GST_SUMMARY,5 |
|
BILLINGASPAYMENTS |
BILLING |
*_BILLING_LEGACY_*.CSV |
BILLING,BILLINGASPAYMENTS,5 |
BILLING,BILLINGASPAYMENTS,6 |
|
BILLINGASRECOVERY |
BILLING |
*_BILLING_LEGACY_*.CSV |
BILLING,BILLINGASRECOVERY,6 |
BILLING,BILLINGASRECOVERY,7 |
|
BILLINGCPDATA |
BILLING |
*_BILLING_LEGACY_*.CSV |
BILLING,BILLINGCPDATA,5 |
BILLING,BILLINGCPDATA,6 |
|
BILLINGDAYTRK |
BILLING |
*_BILLING_LEGACY_*.CSV |
BILLING,BILLINGDAYTRK,4 |
BILLING,BILLINGDAYTRK,5 |
|
BILLINGFEES |
BILLING |
*_BILLING_LEGACY_*.CSV |
BILLING,BILLINGFEES,4 |
BILLING,BILLINGFEES,5 |
|
BILLINGFINANCIALADJUSTMENTS |
BILLING |
*_BILLING_LEGACY_*.CSV |
BILLING,BILLINGFINANCIALADJUSTMENTS,4 |
BILLING,BILLINGFINANCIALADJUSTMENTS,5 |
|
BILLINGGENDATA |
BILLING |
*_BILLING_LEGACY_*.CSV |
BILLING,BILLINGGENDATA,4 |
BILLING,BILLINGGENDATA,5 |
|
BILLINGINTERRESIDUES |
BILLING |
*_BILLING_LEGACY_*.CSV |
BILLING,BILLINGINTERRESIDUES,4 |
BILLING,BILLINGINTERRESIDUES,5 |
|
BILLINGINTRARESIDUES |
BILLING |
*_BILLING_LEGACY_*.CSV |
BILLING,BILLINGINTRARESIDUES,4 |
BILLING,BILLINGINTRARESIDUES,5 |
|
BILLINGIRAUCSURPLUS |
BILLING |
*_BILLING_LEGACY_*.CSV |
BILLING,BILLINGIRAUCSURPLUS,4 |
BILLING,BILLINGIRAUCSURPLUS,5 |
|
BILLINGIRAUCSURPLUSSUM |
BILLING |
*_BILLING_LEGACY_*.CSV |
BILLING,BILLINGIRAUCSURPLUSSUM,6 |
BILLING,BILLINGIRAUCSURPLUSSUM,7 |
|
BILLINGIRNSPSURPLUS |
BILLING |
*_BILLING_LEGACY_*.CSV |
BILLING,BILLINGIRNSPSURPLUS,4 |
BILLING,BILLINGIRNSPSURPLUS,5 |
|
BILLINGIRNSPSURPLUSSUM |
BILLING |
*_BILLING_LEGACY_*.CSV |
BILLING,BILLINGIRNSPSURPLUSSUM,5 |
BILLING,BILLINGIRNSPSURPLUSSUM,6 |
|
BILLINGIRPARTSURPLUS |
BILLING |
*_BILLING_LEGACY_*.CSV |
BILLING,BILLINGIRPARTSURPLUS,4 |
BILLING,BILLINGIRPARTSURPLUS,5 |
|
BILLINGIRPARTSURPLUSSUM |
BILLING |
*_BILLING_LEGACY_*.CSV |
BILLING,BILLINGIRPARTSURPLUSSUM,6 |
BILLING,BILLINGIRPARTSURPLUSSUM,7 |
|
BILLINGPRIORADJUSTMENTS |
BILLING |
*_BILLING_LEGACY_*.CSV |
BILLING,BILLINGPRIORADJUSTMENTS,4 |
BILLING,BILLINGPRIORADJUSTMENTS,5 |
|
BILLINGREALLOC |
BILLING |
*_BILLING_LEGACY_*.CSV |
BILLING,BILLINGREALLOC,4 |
BILLING,BILLINGREALLOC,5 |
|
BILLINGREALLOC_DETAIL |
BILLING |
*_BILLING_LEGACY_*.CSV |
BILLING,BILLINGREALLOC_DETAIL,4 |
BILLING,BILLINGREALLOC_DETAIL,5 |
|
BILLINGREGIONEXPORTS |
BILLING |
*_BILLING_LEGACY_*.CSV |
BILLING,BILLINGREGIONEXPORTS,4 |
BILLING,BILLINGREGIONEXPORTS,5 |
|
BILLINGREGIONFIGURES |
BILLING |
*_BILLING_LEGACY_*.CSV |
BILLING,BILLINGREGIONFIGURES,5 |
BILLING,BILLINGREGIONFIGURES,6 |
|
BILLINGREGIONIMPORTS |
BILLING |
*_BILLING_LEGACY_*.CSV |
BILLING,BILLINGREGIONIMPORTS,4 |
BILLING,BILLINGREGIONIMPORTS,5 |
|
BILLINGRUNTRK |
BILLING |
*_BILLING_LEGACY_*.CSV |
BILLING,BILLINGRUNTRK,4 |
BILLING,BILLINGRUNTRK,5 |
|
DAYTRACK |
SETTLEMENTS |
*_SETTLEMENTS_LEGACY_*.CSV |
SETTLEMENTS,DAYTRACK,5 |
SETTLEMENTS,DAYTRACK,6 |
|
DISPATCHCASESOLUTION |
DISPATCHIS |
*_DISPATCHIS_LEGACY_*.CSV |
DISPATCHIS,DISPATCHCASESOLUTION,1 |
DISPATCHIS,DISPATCHCASESOLUTION,2 |
|
DISPATCHCONSTRAINT |
DISPATCHIS |
*_DISPATCHIS_LEGACY_*.CSV |
DISPATCHIS,DISPATCHCONSTRAINT,4 |
DISPATCHIS,DISPATCHCONSTRAINT,5 |
|
DISPATCHINTERCONNECTORRES |
DISPATCHIS |
*_DISPATCHIS_LEGACY_*.CSV |
DISPATCHIS,DISPATCHINTERCONNECTORRES,2 |
DISPATCHIS,DISPATCHINTERCONNECTORRES,3 |
|
DISPATCHLOAD |
DISPATCHIS |
*_DISPATCHIS_LEGACY_*.CSV |
DISPATCHIS,DISPATCHLOAD,2 |
DISPATCHIS,DISPATCHLOAD,3 |
|
DISPATCHPRICE |
DISPATCHIS |
*_DISPATCHIS_LEGACY_*.CSV |
DISPATCHIS,DISPATCHPRICE,3 |
DISPATCHIS,DISPATCHPRICE,4 |
|
DISPATCHREGIONSUM |
DISPATCHIS |
*_DISPATCHIS_LEGACY_*.CSV |
DISPATCHIS,DISPATCHREGIONSUM,5 |
DISPATCHIS,DISPATCHREGIONSUM,6 |
|
DUDETAIL |
DUDETAIL |
*_PARTICIPANT_REGISTRATION__LEGACY_*.CSV |
DUDETAIL,DUDETAIL,3 |
DUDETAIL,DUDETAIL,4 |
|
DUDETAILSUMMARY |
DUDETAILSUMMARY |
*_PARTICIPANT_REGISTRATION__LEGACY_*.CSV |
DUDETAILSUMMARY,DUDETAILSUMMARY,4 |
DUDETAILSUMMARY,DUDETAILSUMMARY,5 |
|
MTPASA_DUIDAVAILABILITY |
MTPASADUIDAVAILABILITY |
*_MTPASADUIDAVAILABILITY_LEGACY*.CSV |
MTPASA,MTPASA_DUIDAVAILABILITY,1 |
MTPASA,MTPASA_DUIDAVAILABILITY,2 |
|
P5MIN_CASESOLUTION |
P5MIN |
*_P5MIN__LEGACY_*.CSV |
P5MIN,P5MIN_CASESOLUTION,1 |
P5MIN,P5MIN_CASESOLUTION,2 |
|
P5MIN_CONSTRAINTSOLUTION |
P5MIN |
*_P5MIN__LEGACY_*.CSV |
P5MIN,P5MIN_CONSTRAINTSOLUTION,5 |
P5MIN,P5MIN_CONSTRAINTSOLUTION,6 |
|
P5MIN_INTERCONNECTORSOLN |
P5MIN |
*_P5MIN__LEGACY_*.CSV |
P5MIN,P5MIN_INTERCONNECTORSOLN,3 |
P5MIN,P5MIN_INTERCONNECTORSOLN,4 |
|
P5MIN_REGIONSOLUTION |
P5MIN |
*_P5MIN__LEGACY_*.CSV |
P5MIN,P5MIN_REGIONSOLUTION,6 |
P5MIN,P5MIN_REGIONSOLUTION,7 |
|
P5MIN_UNITSOLUTION |
P5MIN |
*_P5MIN__LEGACY_*.CSV |
P5MIN,P5MIN_UNITSOLUTION,3 |
P5MIN,P5MIN_UNITSOLUTION,4 |
|
PDPASA_CASESOLUTION |
PDPASA |
*_PDPASA__LEGACY_*.CSV |
PDPASA,PDPASA_CASESOLUTION,2 |
PDPASA,PDPASA_CASESOLUTION,3 |
|
PDPASA_REGIONSOLUTION |
PDPASA |
*_PDPASA__LEGACY_*.CSV |
PDPASA,PDPASA_REGIONSOLUTION,6 |
PDPASA,PDPASA_REGIONSOLUTION,7 |
|
PREDISPATCHCONSTRAINT |
PREDISPATCHIS |
*_PREDISPATCHIS_LEGACY_*.CSV |
REDISPATCHIS,PREDISPATCHCONSTRAINT,4 |
REDISPATCHIS,PREDISPATCHCONSTRAINT,5 |
|
PREDISPATCHINTERCONNECTORRES |
PREDISPATCHIS |
*_PREDISPATCHIS_LEGACY_*.CSV |
REDISPATCHIS,PREDISPATCHINTERCONNECTORRES,2 |
REDISPATCHIS,PREDISPATCHINTERCONNECTORRES,3 |
|
PREDISPATCHLOAD |
PREDISPATCHIS |
*_PREDISPATCHIS_LEGACY_*.CSV |
REDISPATCHIS,PREDISPATCHLOAD,1 |
REDISPATCHIS,PREDISPATCHLOAD,2 |
|
PREDISPATCHREGIONSUM |
PREDISPATCHIS |
*_PREDISPATCHIS_LEGACY_*.CSV |
PREDISPATCHIS,PREDISPATCHREGIONSUM,5 |
REDISPATCHIS,PREDISPATCHREGIONSUM,6 |
|
SET_ANCILLARY_SUMMARY |
SETTLEMENTS |
*_SETTLEMENTS_LEGACY_*.CSV |
SETTLEMENTS,SET_ANCILLARY_SUMMARY,4 |
SETTLEMENTS,SET_ANCILLARY_SUMMARY,5 |
|
SET_FCAS_PAYMENT |
SETTLEMENTS |
*_SETTLEMENTS_LEGACY_*.CSV |
SETTLEMENTS,SET_FCAS_PAYMENT,4 |
SETTLEMENTS,SET_FCAS_PAYMENT,5 |
|
SET_FCAS_RECOVERY |
SETTLEMENTS |
*_SETTLEMENTS_LEGACY_*.CSV |
SETTLEMENTS,SET_FCAS_RECOVERY,5 |
SETTLEMENTS,SET_FCAS_RECOVERY,6 |
|
SET_FCAS_REGULATION_TRK |
SETTLEMENTS |
*_SETTLEMENTS_LEGACY_*.CSV |
SETTLEMENTS,SET_FCAS_REGULATION_TRK,1 |
SETTLEMENTS,SET_FCAS_REGULATION_TRK,2 |
|
SET_MR_PAYMENT |
SETTLEMENTS |
*_SETTLEMENTS_LEGACY_*.CSV |
SETTLEMENTS,SET_MR_PAYMENT,4 |
SETTLEMENTS,SET_MR_PAYMENT,5 |
|
SET_MR_RECOVERY |
SETTLEMENTS |
*_SETTLEMENTS_LEGACY_*.CSV |
SETTLEMENTS,SET_MR_RECOVERY,4 |
SETTLEMENTS,SET_MR_RECOVERY,5 |
|
SET_NMAS_RECOVERY |
SETTLEMENTS |
*_SETTLEMENTS_LEGACY_*.CSV |
SETTLEMENTS,SET_NMAS_RECOVERY,1 |
SETTLEMENTS,SET_NMAS_RECOVERY,2 |
|
SET_RUN_PARAMETER |
SETTLEMENTS |
*_SETTLEMENTS_LEGACY_*.CSV |
SETTLEMENTS,SET_RUN_PARAMETER,4 |
SETTLEMENTS,SET_RUN_PARAMETER,5 |
|
SETCPDATA |
SETTLEMENTS |
*_SETTLEMENTS_LEGACY_*.CSV |
SETTLEMENTS,SETCPDATA,5 |
SETTLEMENTS,SETCPDATA,6 |
|
SETCPDATAREGION |
SETTLEMENTS |
*_SETTLEMENTS_LEGACY_*.CSV |
SETTLEMENTS,SETCPDATAREGION,4 |
SETTLEMENTS,SETCPDATAREGION,5 |
|
SETFCASCOMP |
SETTLEMENTS |
*_SETTLEMENTS_LEGACY_*.CSV |
SETTLEMENTS,SETFCASCOMP,4 |
SETTLEMENTS,SETFCASCOMP,5 |
|
SETFCASREGIONRECOVERY |
SETTLEMENTS |
*_SETTLEMENTS_LEGACY_*.CSV |
SETTLEMENTS,SETFCASREGIONRECOVERY,4 |
SETTLEMENTS,SETFCASREGIONRECOVERY,5 |
|
SETGENDATA |
SETTLEMENTS |
*_SETTLEMENTS_LEGACY_*.CSV |
SETTLEMENTS,SETGENDATA,4 |
SETTLEMENTS,SETGENDATA,5 |
|
SETGENDATAREGION |
SETTLEMENTS |
*_SETTLEMENTS_LEGACY_*.CSV |
SETTLEMENTS,SETGENDATAREGION,4 |
SETTLEMENTS,SETGENDATAREGION,5 |
|
SETINTERVENTION |
SETTLEMENTS |
*_SETTLEMENTS_LEGACY_*.CSV |
SETTLEMENTS,SETINTERVENTION,4 |
SETTLEMENTS,SETINTERVENTION,5 |
|
SETINTERVENTIONRECOVERY |
SETTLEMENTS |
*_SETTLEMENTS_LEGACY_*.CSV |
SETTLEMENTS,SETINTERVENTIONRECOVERY,4 |
SETTLEMENTS,SETINTERVENTIONRECOVERY,5 |
|
SETINTRAREGIONRESIDUES |
SETTLEMENTS |
*_SETTLEMENTS_LEGACY_*.CSV |
SETTLEMENTS,SETINTRAREGIONRESIDUES,4 |
SETTLEMENTS,SETINTRAREGIONRESIDUES,5 |
|
SETIRAUCSURPLUS |
SETTLEMENTS |
*_SETTLEMENTS_LEGACY_*.CSV |
SETTLEMENTS,SETIRAUCSURPLUS,4 |
SETTLEMENTS,SETIRAUCSURPLUS,5 |
|
SETIRNSPSURPLUS |
SETTLEMENTS |
*_SETTLEMENTS_LEGACY_*.CSV |
SETTLEMENTS,SETIRNSPSURPLUS,4 |
SETTLEMENTS,SETIRNSPSURPLUS,5 |
|
SETIRPARTSURPLUS |
SETTLEMENTS |
*_SETTLEMENTS_LEGACY_*.CSV |
SETTLEMENTS,SETIRPARTSURPLUS,4 |
SETTLEMENTS,SETIRPARTSURPLUS,5 |
|
SETIRSURPLUS |
SETTLEMENTS |
*_SETTLEMENTS_LEGACY_*.CSV |
SETTLEMENTS,SETIRSURPLUS,4 |
SETTLEMENTS,SETIRSURPLUS,5 |
|
SETLSHEDPAYMENT |
SETTLEMENTS |
*_SETTLEMENTS_LEGACY_*.CSV |
SETTLEMENTS,SETLSHEDPAYMENT,4 |
SETTLEMENTS,SETLSHEDPAYMENT,5 |
|
SETMARKETFEES |
SETTLEMENTS |
*_SETTLEMENTS_LEGACY_*.CSV |
SETTLEMENTS,SETMARKETFEES,4 |
SETTLEMENTS,SETMARKETFEES,5 |
|
SETREALLOCATIONS |
SETTLEMENTS |
*_SETTLEMENTS_LEGACY_*.CSV |
SETTLEMENTS,SETREALLOCATIONS,4 |
SETTLEMENTS,SETREALLOCATIONS,5 |
|
SETRESERVERECOVERY |
SETTLEMENTS |
*_SETTLEMENTS_LEGACY_*.CSV |
SETTLEMENTS,SETRESERVERECOVERY,5 |
Discontinued - moved to historic package |
|
SETRESTARTPAYMENT |
SETTLEMENTS |
*_SETTLEMENTS_LEGACY_*.CSV |
SETTLEMENTS,SETRESTARTPAYMENT,5 |
SETTLEMENTS,SETRESTARTPAYMENT,6 |
|
SETRESTARTRECOVERY |
SETTLEMENTS |
*_SETTLEMENTS_LEGACY_*.CSV |
SETTLEMENTS,SETRESTARTRECOVERY,5 |
SETTLEMENTS,SETRESTARTRECOVERY,6 |
|
SETRPOWERPAYMENT |
SETTLEMENTS |
*_SETTLEMENTS_LEGACY_*.CSV |
SETTLEMENTS,SETRPOWERPAYMENT,5 |
SETTLEMENTS,SETRPOWERPAYMENT,6 |
|
STPASA_CASESOLUTION |
STPASA |
*_STPASA__LEGACY_*.CSV |
STPASA,STPASA_CASESOLUTION,2 |
STPASA,STPASA_CASESOLUTION,3 |
|
STPASA_CONSTRAINTSOLUTION |
STPASA |
*_STPASA__LEGACY_*.CSV |
STPASA,STPASA_CONSTRAINTSOLUTION,2 |
STPASA,STPASA_CONSTRAINTSOLUTION,3 |
|
STPASA_INTERCONNECTORSOLN |
STPASA |
*_STPASA__LEGACY_*.CSV |
STPASA,STPASA_INTERCONNECTORSOLN,2 |
STPASA,STPASA_INTERCONNECTORSOLN,3 |
|
STPASA_REGIONSOLUTION |
STPASA |
*_STPASA__LEGACY_*.CSV |
STPASA,STPASA_REGIONSOLUTION,6 |
STPASA,STPASA_REGIONSOLUTION,7 |
|
TRADINGPRICE |
PRICE_REVISION_TRADINGIS |
*_PRICE_REVISION_TRADINGIS__LEGACY_*.CSV |
PRICE_REVISION_TRADINGIS,TRADINGPRICE,1 |
PRICE_REVISION_TRADINGIS,TRADINGPRICE,2 |
|
VOLTAGE_INSTRUCTIONS |
VOLTAGE_INSTRUCTIONS |
*_VOLTAGE_INSTRUCTIONS__LEGACY_*.CSV |
VOLTAGE_INSTRUCTIONS,VOLTAGE_INSTRUCTIONS,1 |
VOLTAGE_INSTRUCTIONS,VOLTAGE_INSTRUCTIONS,2 |