Next Day Reporting
What is introduced?
We will introduce 2 new Sparse reports, coexisting with the existing fully qualified NEXT_DAY_OFFER_ENERGY and NEXT_DAY_OFFER_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. reports for a transition period:
- NEXT_DAY_OFFER_ENERGY_SPARSE
- NEXT_DAY_OFFER_FCAS_SPARSE
The Sparse reports introduce new report records, allowing participant systems to easily distinguish between the 2 representations:
|
File ID |
CSV report type |
Change |
Sparse representation |
|---|---|---|---|
|
NEXT_DAY_OFFER_ENERGY_SPARSE
|
BIDS,BIDDAYOFFER,1 |
Unchanged |
None |
|
BIDS,BIDOFFERPREIOD_SPARSE,1 |
New |
_SPARSE new column PERIODIDTO |
|
|
BIDS,MNSP_DAYOFFER,1 |
Unchanged |
None |
|
|
BIDS,NSP_BIDOFFERPERIOD,1 |
Unchanged |
None |
|
|
NEXT_DAY_OFFER_FCAS_SPARSE
|
BIDS,BIDDAYOFFER,1 |
Unchanged |
None |
|
BIDS,BIDOFFERPERIOD_SPARSE,1 |
New |
_SPARSE new column PERIODIDTO |
The BIDOFFERPERIOD.PERIODIDTO column is not currently in the Data Model v5.2 release. It is added to ensure participants can validate the completeness of offer data with contiguous start and end periods from 1 to 288 within any one single offer. AEMO will add the PERIODIDTO column to the next Data Model release.
What participants need to do for the new PeriodIdTo column?
Participants wanting to add this new column to their Data Model The definition of the interface to participants of data published by AEMO for gas or electricity. A database conforming to the Data Model can contain a local copy of all current participant-specific data recorded in the main database. The Data Model includes database tables, indexes, and primary keys. installation can adapt the following SQL to their specific RDBMS platform:
- alter table BIDOFFERPERIOD add PERIODIDTO NUMBER(3,0)
- comment on column BIDOFFERPERIOD.PERIODIDTO is 'Period ID The value for each trading interval (1-288) Ending'
What is changing with the existing NEXT_DAY_OFFER_* reports ?
We will migrate participants subscribed to the NEXT_DAY_OFFER_ENERGY and NEXT_DAY_OFFER_FCAS reports to NEXT_DAY_OFFER_ENERGY_LEGACY and NEXT_DAY_OFFER_FCAS_LEGACY reports respectively.
Because we propose to transition to the Sparse Data Model representations as the standard delivery for this data, there will be no LATEST report version for NEXT_DAY_OFFER_ENERGY and NEXT_DAY_OFFER_FCAS. The LEGACY label is intended as an indicator that these reports are now deprecated.
In the event that a functional change to NEXT_DAY_OFFER_* reports is required within the transition window then LATEST versions of these reports will be reintroduced.
How do I transition to Sparse NEXT_DAY_OFFER reporting ?
Participants can opt into the _SPARSE reports in their own time within the transition window.
You can subscribe to the new _SPARSE reports in the Markets Portal Web applications for registered participants only. Requires access to MarketNet. > Data Interchange A set of cooperating applications used to replicate data between AEMO's energy market systems and a participant's DBMS conforming to the MMS Data Model. > Data Subscription A web application in the Markets Portal used to subscribe to Data Interchange files and to obtain the latest MMS Data Model. These files are typically csv files containing public data and participant’s private data. AEMO recommends participant use of the Data Interchange suite of products, supplied by AEMO, to automate receiving and storage of the files to their systems. AEMO provides working sample software for FTP access (Participant Batcher) to MarketNet and working sample software for Data Interchange. service.
While these reports are designated NON-DATA MODEL this is just a reflection of their status as an opt in during the transition window.
