Electricity Data Model 5.3

Public

Medium

Table trigger that is caused by the Insert or Update of data in the Ancillary Recovery Split.

<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports

Public

Medium

Table trigger that is caused by the Insert or Update of data in the Market fee.

<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports

The Energy Type for the Market Fees Calculation. E.g of Meter Types are CUSTOMER, GENERATOR, NREG, BDU etc. If Meter Type is mentioned as ALL then all the Meter Types for that Participant Category will be used in the Fee calculation

Private

Medium

Daily Billing Run & Posting a PRELIM/FINAL and REVISE Billing Run

<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports

The Settlement Date of the Billing Week

The Settlement Run No

The Period ID Identifier

The Participant Id Identifier

The Connection Point associated with the Energy Transaction reads.

The type of meter reads received. Eg Customer, Generator, BDU, NREG etc.

The NEM Region Id Identifier

The Regional Reference Price for the Region

The Transmission Loss Factor applied to the Connection Point Id. TLF is calculated based on the Net Flow at the TNI.

The Consumed Energy . Energy received in the meter reads (DLF Adjusted)

The UFE Allocation Amount applied to the Participant

The Adjusted Consumed Energy MWh ( CE_MWh + UFEA) for the ConnectionPointId

The Adjusted Sent Out Energy for the ConnectionPointId . Energy received in the meter reads adjusted by DLF.

The dollar amount for Adjusted Consumed Energy MWh (ACE_MWh * TLF * RRP)

The dollar amount for Adjusted Sent Out Energy MWh (ASOE_MWh * TLF * RRP)

The Total MWh Value for the Participant. ACE_MWh + ASOE_MWh

The Total Dollar Value for the Participant. ACE_Amount + ASOE_Amount

The Metering Case ID

The DME MWh (Distribution Connected) that is used in the UFEA Calculation.

The Flag is 1 if the meter data source is from Aggregate Reads Meter Data, Else 0

The Flag is 1 if the meter data source is from Individual Reads Meter Data, Else 0

Public

Medium

Daily Billing Run & Posting a PRELIM/FINAL and REVISE Billing Run

<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports

The Settlement Date of the Billing Week

The Settlement Run No

The Period ID Identifier

The NEM Region Id Identifier

The Consumed Energy summary for the Region Id

The UFEA Energy summary for the Region Id

The Adjusted Consumed Energy summary for the Region Id

The Adjusted Sent Out Energy summary for the Region Id

The Adjusted Consumed Energy Amount for the Region Id

The Adjusted Sent Out Energy Amount for the Region Id

The Total Energy summary for the Region Id

The Total Dollar Amount summary for the Region Id

Private

Medium

Daily Billing Run & Posting a PRELIM/FINAL and REVISE Billing Run

<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports

The Settlement Date of the Billing Week

The Settlement Run No

The Period ID Identifier

The Participant Id Identifier

The StationId identifier associated with the GensetId

The DUID for the meter associated with the GenSetId

The GensetId for the Meter Id received

The Region Id for the Connection Point associated with the DUID

The Connection Point associated with the DUID

The Regional Reference Price for the Settlement Period

The Transmission Loss Factor applied to the Connection Point Id. TLF is calculated based on the Net Flow at the TNI.

The Meter ID Identifier (NMI)

The Consumed Energy for the Meter Id . Energy received in the meter reads (DLF Adjusted)

The UFEA allocation amount applied to the Meter Data

The Adjusted Consumed Energy for the Meter Id (CE_MWh + UFEA)

The Adjusted Sent Out Energy for the Meter Id

The Total MWh for the Meter Id (ACE_MWh + ASOE_MWh)

The DME MWh value that is used to calculate the UFEA Allocation Amount

The Adjusted Consumed Energy Dollar Amount

The Adjusted Sent Out Energy Dollar Amount

The Total Amount for the Meter Id (ACE_Amount + ASOE_Amount)

Public

Medium

Daily Billing Run & Posting a PRELIM/FINAL and REVISE Billing Run

<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports

The Adjusted Consumed Energy Dollar Amount for the Region used in the calculation of IRSS (Intra Residue Amount). NULL for Settlement dates prior to the IESS rule effective date.

Energy payments to generators. NULL for Settlement dates post the IESS rule effective date

Public

Medium

Daily Billing Run & Posting a PRELIM/FINAL and REVISE Billing Run

<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports

The Regional ACE MWh value used for the FCAS Recovery. NULL for Settlement dates prior to the IESS rule effective date

The Regional ASOE MWh value used for the FCAS Recovery. NULL for Settlement dates prior to the IESS rule effective date

The Total Dollar Amount for the Region recovered using the ACE MWh Values. NULL for Settlement dates prior to the IESS rule effective date

The Total Dollar Amount for the Region recovered using the ASOE MWh Values. NULL for Settlement dates prior to the IESS rule effective date

Generator Regional Energy Amount. NULL for Settlement dates post the IESS rule effective date

Private

Medium

Daily Billing Run & Posting a PRELIM/FINAL and REVISE Billing Run

<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports

'The Lower Regulation FCAS Residue Recovery Amount using ACE MWh values excluding the MPF Connection Points. NULL Value for Settlement Dates prior to the IESS rule effective date.

'The Raise Regulation FCAS Residue Recovery Amount using ACE MWh values excluding the MPF Connection Points. NULL Value for Settlement Dates prior to the IESS rule effective date

The Raise1Sec FCAS Recovery Amount for the Participant and Region from ACE MWh Portion. NULL for Settlement dates prior to the IESS rule effective date.

The Raise1Sec FCAS Recovery Amount for the Participant and Region from ASOE MWh Portion. NULL for Settlement dates prior to the IESS rule effective date.

The Lower1Sec FCAS Recovery Amount for the Participant and Region from ACE MWh Portion. NULL for Settlement dates prior to the IESS rule effective date.

The Lower1Sec FCAS Recovery Amount for the Participant and Region from ASOE MWh Portion. NULL for Settlement dates prior to the IESS rule effective date.

The Raise6Sec FCAS Recovery Amount for the Participant and Region from ACE MWh Portion. NULL for Settlement dates prior to the IESS rule effective date.

The Raise6Sec FCAS Recovery Amount for the Participant and Region from ASOE MWh Portion. NULL for Settlement dates prior to the IESS rule effective date.

The Lower6Sec FCAS Recovery Amount for the Participant and Region from ACE MWh Portion. NULL for Settlement dates prior to the IESS rule effective date.

The Lower6Sec FCAS Recovery Amount for the Participant and Region from ASOE MWh Portion. NULL for Settlement dates prior to the IESS rule effective date.

The Raise60Sec FCAS Recovery Amount for the Participant and Region from ACE MWh Portion. NULL for Settlement dates prior to the IESS rule effective date.

The Raise60Sec FCAS Recovery Amount for the Participant and Region from ASOE MWh Portion. NULL for Settlement dates prior to the IESS rule effective date.

The Lower60Sec FCAS Recovery Amount for the Participant and Region from ACE MWh Portion. NULL for Settlement dates prior to the IESS rule effective date.

The Lower60Sec FCAS Recovery Amount for the Participant and Region from ASOE MWh Portion. NULL for Settlement dates prior to the IESS rule effective date.

The Raise5Min FCAS Recovery Amount for the Participant and Region from ACE MWh Portion. NULL for Settlement dates prior to the IESS rule effective date.

The Raise5Min FCAS Recovery Amount for the Participant and Region from ASOE MWh Portion. NULL for Settlement dates prior to the IESS rule effective date.

The Lower5Min FCAS Recovery Amount for the Participant and Region from ACE MWh Portion. NULL for Settlement dates prior to the IESS rule effective date.

For Settlement date prior to the IESS rule effective date, the column represent Sum of MPF Lower Regulation recovery amount from Customer Connection Points and the Residue Recovery amount from Customers excluding the MPF Connection Points. For Settlement Date Past IESS Rule Change the column represent the Lower Regulation FCAS MPF Recovery Amount from Customer and Generator Connection Point MPFs only. Residue Recovery Amount is not included in this amount.

For Settlement date prior to the IESS rule effective date, the column represent Sum of MPF Raise Regulation recovery amount from Customer Connection Points and the Residue Recovery amount from Customers excluding the MPF Connection Points. For Settlement Date Past IESS Rule Change the column represent the Raise Regulation FCAS MPF Recovery Amount from Customer and Generator Connection Point MPFs only. Residue Recovery Amount is not included in this amount.

Recovery amount for the Lower 6 Second service attributable to customer connection points. NULL for Settlement dates post the IESS rule effective date

Recovery amount for the Raise 6 Second service attributable to customer connection points. NULL for Settlement dates post the IESS rule effective date

Recovery amount for the Lower 60 Second service attributable to customer connection points. NULL for Settlement dates post the IESS rule effective date

Recovery amount for the Raise 60 Second service attributable to customer connection points. NULL for Settlement dates post the IESS rule effective date

Recovery amount for the Lower 5 Minute service attributable to customer connection points. NULL for Settlement dates post the IESS rule effective date

Recovery amount for the Raise 5 Minute service attributable to customer connection points. NULL for Settlement dates post the IESS rule effective date

For Settlement date prior to the IESS rule effective date, the column represent Sum of MPF Lower Regulation recovery amount from Generator Connection Points. NULL for Settlement dates post the IESS rule effective date

For Settlement date prior to the IESS rule effective date, the column represent Sum of MPF Raise Regulation recovery amount from Generator Connection Points. NULL for Settlement dates post the IESS rule effective date

Recovery amount for the Lower 6 Second service attributable to generator connection points. NULL for Settlement dates post the IESS rule effective date

Recovery amount for the Raise 6 Second service attributable to generator connection points. NULL for Settlement dates post the IESS rule effective date

Recovery amount for the Lower 60 Second service attributable to generator connection points. NULL for Settlement dates post the IESS rule effective date

Recovery amount for the Raise 60 Second service attributable to generator connection points. NULL for Settlement dates post the IESS rule effective date

Recovery amount for the Lower 5 Minute service attributable to generator connection points. NULL for Settlement dates post the IESS rule effective date

Recovery amount for the Raise 5 Minute service attributable to generator connection points NULL for Settlement dates post the IESS rule effective date

Customer recovery amount for the very fast raise service. NULL for Settlement dates post the IESS rule effective date

Customer recovery amount for the very fast lower service. NULL for Settlement dates post the IESS rule effective date

Generator recovery amount for the very fast raise service. NULL for Settlement dates post the IESS rule effective date

Private

Medium

Daily Billing Run & Posting a PRELIM/FINAL and REVISE Billing Run

<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports

The Energy Type for the Market Fees Calculation. E.g of Meter Types are CUSTOMER, GENERATOR, NREG, BDU etc. If Meter Type is mentioned as ALL then all the Meter Types for that Participant Category will be used in the Fee calculation

Private

Medium

Daily Billing Run & Posting a PRELIM/FINAL and REVISE Billing Run

<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports

The ACE MWh value for the Participant used in the Recovery Amount Calculation. NULL for Settlement dates prior to the IESS rule effective date.

The Regional ACE MWh value used in the Recovery Amount Calculation. NULL for Settlement dates prior to the IESS rule effective date.

The ASOE MWh value for the Participant used in the Recovery Amount Calculation. NULL for Settlement dates prior to the IESS rule effective date.

The Regional ASOE MWh value used in the Recovery Amount Calculation. NULL for Settlement dates prior to the IESS rule effective date.

The Recovery dollar amount for the Participant for the NMAS Contract Id calculated using the ACE MWh values for eligible services. NULL for Settlement dates prior to the IESS rule effective date.

The Participant energy in MWh for the period. NULL for Settlement dates post the IESS rule effective date

'The RegionId energy in MWh for the period. NULL Value for Settlement Dates post IESS rule effective date

The Total recovery amount for the period for the PARTICIPANTID and REGIONID. For Settlement dates prior to the IESS rule effective date Sum of RECOVERY_AMOUNT_CUSTOMER + RECOVERY_AMOUNT_GENERATOR  and Post IESS it is sum of RECOVERYAMOUNT_ACE + RECOVERYAMOUNT_ASOE.

Participant Generator Energy in the benefitting region. NULL for Settlement dates post the IESS rule effective date

The generator energy in the benefitting region. NULL for Settlement dates post the IESS rule effective date

The recovery amount allocated to customers. NULL for Settlement dates post the IESS rule effective date

Private

Medium

Daily Billing Run & Posting a PRELIM/FINAL and REVISE Billing Run

<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports

The Actual ACE MWh Value for the Recovery Calculation. NULL for Settlement dates prior to the IESS rule effective date.

The Actual ACE MWh Value excluding the MPF Connection Points for the Recovery Calculation. This is used only in FCAS Residue Recovery Calculation. NULL for Settlement dates prior to the IESS rule effective date.

The Substitute ACE MWh Value for the Recovery Calculation. There is no substitute demand post IESS Rule Change. Hence this column will have same value as ACE_MWh_Actual. NULL for Settlement dates prior to the IESS rule effective date.

The Substitute ACE MWh Value excluding the MPF Connection Points for the Recovery Calculation. This is used only in FCAS Residue Recovery Calculation. There is no substitute demand post IESS Rule Change. Hence this column will have same value as ACE_MWh_MPFExActual. NULL for Settlement dates prior to the IESS rule effective date.

The Actual ASOE MWh Value for the Recovery Calculation. NULL for Settlement dates prior to the IESS rule effective date.

The Region total of Actual ACE MWh Value. NULL for Settlement dates prior to the IESS rule effective date.

The Region total of Actual ACE MWh Value excluding the MPF Connection Points. NULL for Settlement dates prior to the IESS rule effective date.

The Region total of Substitute ACE MWh Value. NULL for Settlement dates prior to the IESS rule effective date.

The Region total of Substitute ACE MWh Value excluding the MPF Connection Points. NULL for Settlement dates prior to the IESS rule effective date.

Actual Customer Demand. NULL for Settlement dates post the IESS rule effective date.

Actual Customer Demand excluding TNIs that have a causer pays MPF. NULL for Settlement dates post the IESS rule effective date.

Substitute Customer Demand. NULL for Settlement dates post the IESS rule effective date.

Substitute Customer Demand excluding TNIs that have a causer pays MPF. NULL for Settlement dates post the IESS rule effective date.

Actual Generator Output. NULL for Settlement dates post the IESS rule effective date.

Region Total of Actual Customer Demand. NULL for Settlement dates post the IESS rule effective date.

Region Total of Actual Customer Demand excluding TNIs that have a causer pays MPF. NULL for Settlement dates post the IESS rule effective date.

Region Total of Substitute Customer Demand. NULL for Settlement dates post the IESS rule effective date.

Region total of Substitute Customer Demand excluding TNIs that have a causer pays MPF. NULL for Settlement dates post the IESS rule effective date.

Private

Medium

Populated by the posting of a billing run, being several times each week

<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports

The Billing Contract Year

The Billing WeekNo

The Billing RunNo

The Participant Id Identifier

The ConnectionPoint Id for the Billing Aggregation for the Participant Id.

The Region Id Identifier

The Consumed Energy MWh Consumed for that Connection Point for the Participant Id in that Billing Week

The UFEA Energy MWh Consumed for that Connection Point for the Participant Id in that Billing Week

The Adjusted Consumed Energy MWh Consumed for that Connection Point for the Participant Id in that Billing Week

The Adjusted Sent Out Energy MWh Consumed for that Connection Point for the Participant Id in that Billing Week

The Adjusted Consumed Energy Dollar Amount for that Connection Point for the Participant Id in that Billing Week

The Adjusted Sent Out Energy Dollar Amount for that Connection Point for the Participant Id in that Billing Week

The Total MWh(ACE_MWh + ASOE_MWh) for that Connection Point for the Participant Id in that Billing Week

The Total Amount(ACE_Amount + ASOE_Amount) for that Connection Point for the Participant Id in that Billing Week

The DME MWh for that Connection Point for the Participant Id in that Billing Week. This is the MWh value that is used for the UFEA Allocation.

Private

Medium

Daily Billing Run & Posting a PRELIM/FINAL and REVISE Billing Run

<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports

The Billing Contract Year

The Billing Week No

The Billing Run No

The Participant Id Identifier

The StationId identifier associated with the GensetId

The DUID for the meter associated with the GensetId

The GensetId for the Meter Id received

The Region Id for the Connection Point associated with the DUID

The Connection Point associated with the DUID

The Meter ID Identifier (NMI)

The Consumed Energy for the Meter Id . Energy received in the meter reads (DLF Adjusted) in that Billing Week

The UFEA Energy MWh Consumed for that Connection Point for the Participant Id in that Billing Week

The Adjusted Consumed Energy MWh Consumed for that Connection Point for the Participant Id in that Billing Week

The Adjusted Sent Out Energy MWh Consumed for that Connection Point for the Participant Id in that Billing Week

The Total MWh(ACE_MWh + ASOE_MWh) for that Connection Point for the Participant Id in that Billing Week

The DME MWh for that Connection Point for the Participant Id in that Billing Week. This is the MWh value that is used for the UFEA Allocation

The Adjusted Consumed Energy Dollar Amount for that Connection Point for the Participant Id in that Billing Week

The Adjusted Sent Out Energy Dollar Amount for that Connection Point for the Participant Id in that Billing Week

The Total Amount(ACE_Amount + ASOE_Amount) for that Connection Point for the Participant Id in that Billing Week

Private

Small

Populated by the posting of a billing run, being several times each week

<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports

The ACE MWh value of the participant from the Eligibility Interval used for the APC Recovery Calculation. If the Billing Week is prior to the IESS rule effective date, then value is NULL.

Private

Medium

Populated by the posting of a billing run, being several times each week

<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports

The Lower Regulation FCAS Residue Recovery Amount using ACE MWh values. NULL for Billing week prior to the IESS rule effective date.

The Raise Regulation FCAS Residue Recovery Amount using ACE MWh values. NULL for Billing week prior to the IESS rule effective date.

The Raise1Sec FCAS Recovery Amount for the Participant and Region from ACE MWh Portion. NULL for Billing week prior to the IESS rule effective date.

The Raise1Sec FCAS Recovery Amount for the Participant and Region from ASOE MWh Portion. NULL for Billing week prior to the IESS rule effective date.

The Lower1Sec FCAS Recovery Amount for the Participant and Region from ACE MWh Portion. NULL for Billing week prior to the IESS rule effective date.

The Lower1Sec FCAS Recovery Amount for the Participant and Region from ASOE MWh Portion. NULL for Billing week prior to the IESS rule effective date.

The Raise6Sec FCAS Recovery Amount for the Participant and Region from ACE MWh Portion. NULL for Billing week prior to the IESS rule effective date.

The Raise6Sec FCAS Recovery Amount for the Participant and Region from ASOE MWh Portion. NULL for Billing week prior to the IESS rule effective date.

The Lower6Sec FCAS Recovery Amount for the Participant and Region from ACE MWh Portion. NULL for Billing week prior to the IESS rule effective date.

The Lower6Sec FCAS Recovery Amount for the Participant and Region from ASOE MWh Portion. NULL for Billing week prior to the IESS rule effective date.

The Raise60Sec FCAS Recovery Amount for the Participant and Region from ACE MWh Portion. NULL for Billing week prior to the IESS rule effective date.

The Raise60Sec FCAS Recovery Amount for the Participant and Region from ASOE MWh Portion. NULL for Billing week prior to the IESS rule effective date.

The Lower60Sec FCAS Recovery Amount for the Participant and Region from ACE MWh Portion. NULL for Billing week prior to the IESS rule effective date.

The Lower60Sec FCAS Recovery Amount for the Participant and Region from ASOE MWh Portion. NULL for Billing week prior to the IESS rule effective date.

The Raise5Min FCAS Recovery Amount for the Participant and Region from ACE MWh Portion. NULL for Billing week prior to the IESS rule effective date.

The Raise5Min FCAS Recovery Amount for the Participant and Region from ASOE MWh Portion. NULL for Billing week prior to the IESS rule effective date.

The Lower5Min FCAS Recovery Amount for the Participant and Region from ACE MWh Portion. NULL for Billing week prior to the IESS rule effective date.

The Lower5Min FCAS Recovery Amount for the Participant and Region from ASOE MWh Portion. NULL for Billing week prior to the IESS rule effective date.

The Reactive Power Ancillary Service Recovery Amount for for the Participant and Region from ACE MWh Portion. NULL for Billing week prior to the IESS rule effective date.

The Reactive Power Ancillary Service Recovery Amount for for the Participant and Region from ASOE MWh Portion. NULL for Billing week prior to the IESS rule effective date.

The Load Shed Ancillary Service Recovery Amount for for the Participant and Region from ACE MWh Portion. NULL for Billing week prior to the IESS rule effective date.

The Load Shed Ancillary Service Recovery Amount for for the Participant and Region from ASOE MWh Portion. NULL for Billing week prior to the IESS rule effective date.

The System Restart Ancillary Service Recovery Amount for for the Participant and Region from ACE MWh Portion. NULL for Billing week prior to the IESS rule effective date.

The System Restart Ancillary Service Recovery Amount for for the Participant and Region from ASOE MWh Portion. NULL for Billing week prior to the IESS rule effective date.

The Reactive Power Ancillary Service Availability Payment Recovery Amount for the Participant and Region from ACE MWh Portion. NULL for Billing week prior to the IESS rule effective date.

The Reactive Power Ancillary Service Availability Payment Recovery Amount for the Participant and Region from ASOE MWh Portion. NULL for Billing week prior to the IESS rule effective date.

The Reactive Power Ancillary Service Availability Rebate Payment Recovery Amount for the Participant and Region from ACE MWh Portion. NULL for Billing week prior to the IESS rule effective date.

Pre-IESS - Recovery amount for the Lower Regulation service attributable to customer connection points(MPF + Residue). Post-IESS the amount in this column represent only the Lower Regulation FCAS MPF Recovery Amount from Customer and Generator Connection Point MPFs, no Residue Amounts are added to this column value.

Pre-IESS - Recovery amount for the Raise Regulation service attributable to customer connection points(MPF + Residue). Post-IESS the amount in this column represent only the Raise Regulation FCAS MPF Recovery Amount from Customer and Generator Connection Point MPFs, no Residue Amounts are added to this column value.

Raise 6 Sec Recovery. NULL for Billing Week post the IESS rule effective date

Lower 6 Sec Recovery. NULL for Billing Week post the IESS rule effective date

Raise 60 Sec Recovery. NULL for Billing Week post the IESS rule effective date

Lower 60 Sec Recovery. NULL for Billing Week post the IESS rule effective date

Lower 60 Sec Recovery. NULL for Billing Week post the IESS rule effective date

Load Shed Recovery. Post-IESS the value in this column only represent the Testing Payment Recovery from Customers. 0 if no testing payment exists.

Reactive Power Recovery. Post-IESS the value in this column only represent the Testing Payment Recovery from Customers. 0 if no testing payment exists.

System Restart Recovery. Post-IESS the value in this column only represent the Testing Payment Recovery from Customers. 0 if no testing payment exists

Raise 6 Sec Recovery for Generator. NULL for Billing Week post the IESS rule effective date

Lower 6 Sec Recovery for Generator. NULL for Billing Week post the IESS rule effective date

Raise 60 Sec Recovery for Generator. NULL for Billing Week post the IESS rule effective date

Lower 60 Sec Recovery for Generator. NULL for Billing Week post the IESS rule effective date

Load Shed Recovery for Generator. Post-IESS the value in this column only represent the Testing Payment Recovery from Generators. 0 if no testing payment exists.

Reactive Power Recovery for Generator. Post-IESS the value in this column only represent the Testing Payment Recovery from Generators. 0 if no testing payment exists.

System Restart Recovery for Generator. Post-IESS the value in this column only represent the Testing Payment Recovery from Generators. 0 if no testing payment exists.

Recovery amount for the Lower 5 Minute service attributable to customer connection points. NULL for Billing Week post the IESS rule effective date

Recovery amount for the Raise 5 Minute service attributable to customer connection points. NULL for Billing Week post the IESS rule effective date

Recovery amount for the Lower 5 Minute service attributable to generator connection points. NULL for Billing Week post the IESS rule effective date

Recovery amount for the Raise 5 Minute service attributable to generator connection points. NULL for Billing Week post the IESS rule effective date

Recovery amount for the Lower Regulation service attributable to generator connection points. NULL for Billing Week post the IESS rule effective date

Recovery amount for the Raise Regulation Second service attributable to generator connection points. NULL for Billing Week post the IESS rule effective date. NULL for Billing Week post the IESS rule effective date

The total availability payment recovery amount (customer).. NULL for Billing Week post the IESS rule effective date

The total availability payment rebate recovery amount (customer).. NULL for Billing Week post the IESS rule effective date

The total availability payment recovery amount (Generator).. NULL for Billing Week post the IESS rule effective date

The total availability payment rebate recovery amount (Generator).. NULL for Billing Week post the IESS rule effective date

Customer recovery amount for the very fast raise service. NULL for Billing Week post the IESS rule effective date

Customer recovery amount for the very fast lower service. NULL for Billing Week post the IESS rule effective date

Generator recovery amount for the very fast raise service. NULL for Billing Week post the IESS rule effective date

Private

Medium

Populated by the posting of a billing run, being several times each week

<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports

The Sum of CE MWh value for the Participant and region for the Settlement Date. NULL for Billing Week prior to the IESS rule effective date

The Sum of UFEA MWh value for the Participant and region for the Settlement Date. NULL for Billing Week prior to the IESS rule effective date

The Sum of ACE MWh value for the Participant and region for the Settlement Date. NULL for Billing Week prior to the IESS rule effective date

The Sum of ASOE MWh value for the Participant and region for the Settlement Date

The Sum of ACE Amount value for the Participant and region for the Settlement Date

The Sum of ASOE Amount value for the Participant and region for the Settlement Date

The Sum of Total MWh value for the Participant and region for the Settlement Date. NULL for Billing Week prior to the IESS rule effective date

Customer energy amount purchased on this settlement day by the participant in the region. NULL for Billing Week post the IESS rule effective date.

Generator energy amount sold on this settlement day by the participant in the region. NULL for Billing Week post the IESS rule effective date.

Public

Medium

Populated by the posting of a billing run, being several times each week

<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports

The Sum of ACE MWh value for the Region used in the Direction Recovery Calculation

The Sum of ASOE MWh value for the Region used in the Direction Recovery Calculation

The total customer energy for this region, over the duration of the direction. NULL for Billing Week post the IESS rule effective date.

Private

Small

Populated by the posting of a billing run, being several times each week

<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports

The Participant ACE MWh Value used in the Recovery of the RERT Amount

Participant Demand Value used for RERT Recovery. NULL for Billing Week post the IESS rule effective date.

Private

Medium

Populated by the posting of a billing run, being several times each week

<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports

The Participant ACE MWh Value used in the Recovery of the Testing Payment Amount if the service is recovered from ACE. NULL for Billing Week prior to the IESS rule effective date

The Region ACE MWh Value used in the Recovery of the Testing Payment Amount if the service is recovered from ACE. NULL for Billing Week prior to the IESS rule effective date

The Portion of ACE MWh Value used in the Recovery Calculation. NULL for Billing Week prior to the IESS rule effective date

The Portion of ASOE MWh Value used in the Recovery Calculation (100 - ACE_Portion). NULL for Billing Week prior to the IESS rule effective date

The Participant ASOE MWh Value used in the Recovery of the Testing Payment Amount if the service is recovered from ASOE. NULL for Billing Week prior to the IESS rule effective date

The Region ASOE MWh Value used in the Recovery of the Testing Payment Amount if the service is recovered from ASOE. NULL for Billing Week prior to the IESS rule effective date

The Participant Recovery Amount based on ACE MWh Value if the service is recovered from ACE. NULL for Billing Week prior to the IESS rule effective date

 Public

Medium

 PDPASA_REGIONSOLUTION is updated each PDPASA run (i.e. half-hourly)

<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports

Constrained generation forecast for semi-scheduled units for the region. For RELIABILITY_LRC run semi-scheduled generation is constrained only by System Normal constraints. For OUTAGE_LRC run and LOR run semi-scheduled generation is constrained by both System Normal and Outage constraints. All three run types (RELIABILITY_LRC, OUTAGE_LRC, LOR) incorporate MAXAVAIL limits.

Constrained generation forecast for semi-scheduled units for the region for the LOR run. Semi-scheduled generation is constrained by both System Normal, Outage constraints, and incorporate MAXAVAIL limits.

Public

Large

STPASA_REGIONSOLUTION is updated each STPASA run (approximately every 2 hours)

<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports

Constrained generation forecast for semi-scheduled units for the region. For RELIABILITY_LRC run semi-scheduled generation is constrained only by System Normal constraints. For OUTAGE_LRC run and LOR run semi-scheduled generation is constrained by both System Normal and Outage constraints. All three run types (RELIABILITY_LRC, OUTAGE_LRC, LOR) incorporate MAXAVAIL limits.

Constrained generation forecast for semi-scheduled units for the region for the LOR run type. Semi-scheduled generation is constrained by both System Normal, Outage constraints, and incorporate MAXAVAIL limits.

Public

Medium

DUDETAIL updates only when registration details change.

<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports

Minimum capacity only for load side of BDU, otherwise 0 (MW)

Registered minimum capacity only for load side of BDU, otherwise 0 (MW)

Raise Ramp rate applied to BDU Load component (MW/min)

Lower Ramp rate applied to BDU Load component (MW/min)

The rated storage capacity (MWh), ),information only'

The storage energy import conversion efficiency. Number from 0 to 1 where 1 is lossless. Calculated as (increase in stored energy / increase in imported energy)

The storage energy export conversion efficiency. Number from 0 to 1 where 1 is lossless. Calculated as (decrease in exported energy / decrease in stored energy)

Calculated Minimum Ramp Rate Up value accepted for Energy Offers or Bids with explanation for energy imports (all DUID types and BDU Generation side) (MW/min)

Calculated Minimum Ramp Rate Down value accepted for Energy Offers or Bids with explanation for energy imports (all DUID types and BDU Generation side) (MW/min)

Calculated Minimum Ramp Rate Up value accepted for Energy Offers or Bids on BDU Load component with explanation for energy imports (MW/min)

Public

Medium

GENUNITS updates whenever plant details change.

<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports

Minimum capacity only for load side of BDU, otherwise 0 (MW)

Registered minimum capacity only for load side of BDU, otherwise 0 (MW)

Public

Medium

GENUNITS_UNIT updates whenever plant details change.

<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports

Only applicable for the LOAD side of BDU (MW)

The rated storage capacity (MWh), information only

Registered capacity for normal operations

Public

Medium

DUDETAILSUMMARY updates only when registration details change.

<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports

BDU only. Floored Offer/Bid Energy Price adjusted for TLF, DLF and MPF for energy imports

BDU only. Capped Offer/Bid Energy Price adjusted for TLF, DLF and VoLL for energy imports

BDU only. MW/Min. Calculated Minimum Ramp Rate Up value accepted for Energy Offers or Bids with explanation for energy imports

BDU only. MW/Min. Calculated Minimum Ramp Rate Down value accepted for Energy Offers or Bids with explanation for energy imports

BDU only. MW/Min. Registered Maximum Ramp Rate Up value accepted for Energy Offers or Bids for energy imports

BDU only. MW/Min. Registered Maximum Ramp Rate Down value accepted for Energy Offers or Bids for energy imports

Aggregate Dispatch Group. Group into which the DUID is aggregated for Conformance. Null if DUID not aggregated for Conformance

Public

Medium

DISPATCHABLEUNIT pdates as new units added or names changed.

<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports

Public

Medium

FCAS_REGU_USAGE_FACTORS updates whenever FCAS_REGU_USAGE_FACTORS data is updated.

<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports

The effective date for this regulation FCAS usage factor

Version of the date with respect to effective date

The date time that this set of usage factors was authorised

Public

Medium

FCAS_REGU_USAGE_FACTORS updates whenever FCAS_REGU_USAGE_FACTORS data is updated.

<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports

The effective date for this regulation FCAS usage factor

Version with respect to effective date

Unique RegionID

The type of regulation FCAS service [RAISEREG,LOWERREG]

The Period ID (1 - 48) within the calendar day to which this usage factor applies

The proportion of cleared regulation FCAS that is assumed to be used within a dispatch interval. Expressed as a fractional amount between 0 and 1

Public

Medium

TRANSMISSIONLOSSFACTOR updates when new connection points are created or loss factors change.

<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports

Used in Bidding, Dispatch and Settlements. For Bidding and Dispatch, where the DUID is a BDU with DISPATCHTYPE of BIDIRECTIONAL, the TLF for the load component of the BDU. For Settlements, where dual TLFs apply, the primary TLF is applied to all energy (load and generation) when the Net Energy Flow of the ConnectionPointID in the interval is negative (net load).

Public

Medium

BIDDAYOFFER data is published whenever new bid data arrives.

<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVREPORTS

Public

Medium

BIDDAYOFFER_D data is published daily.

<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVREPORTS

Public

Medium

BIDPEROFFER_D data is published daily.

<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVREPORTS

The power flow direction to which this offer applies: GEN, LOAD or BIDIRECTIONAL

Public

Large

BIDOFFERPERIOD data is published whenever new bid data arrives.

<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVREPORTS

The power flow direction to which this offer applies: GEN, LOAD or BIDIRECTIONAL

The Energy limit applying at the end of this dispatch interval in MWh. For GEN this is a lower energy limit. For LOAD this is an upper energy limit

Public

Medium

DISPATCHREGIONSUM updates every 5 minutes

<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVREPORTS

Regional aggregated energy storage where the DUID type is BDU (MWh)

Total available load side BDU summated for region (MW)

Total available generation side BDU summated for region (MW)

Regional aggregated cleared MW where the DUID type is BDU. Net of export (Generation)

Private, Public Next-Day

Medium

DISPATCHLOAD shows data for every 5 minutes for all units, even zero targets.

<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVREPORTS

Target MW for end of period. Negative values when Bi-directional Unit is importing power, otherwise positive.

BDU only. The energy storage at the start of this dispatch interval (MWh)

BDU only. The projected energy storage based on cleared energy and regulation FCAS dispatch (MWh)

Public

Medium

P5MIN_REGIONSOLUTION updates every 5 minutes

<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVREPORTS

Regional aggregated energy storage where the DUID type is BDU (MWh)

Total available load side BDU summated for region (MW)

Total available generation side BDU summated for region (MW)

Regional aggregated cleared MW where the DUID type is BDU. Net of export (Generation)

Private

Medium

P5MIN_UNITSOLUTION updates every 5 minutes for all units, even zero targets.

<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVREPORTS

BDU only. The energy storage at the start of this dispatch interval (MWh)

BDU only. The projected energy storage based on cleared energy and regulation FCAS dispatch (MWh)

BDU only - Minimum Energy Storage constraint limit (MWh)

BDU only - Maximum Energy Storage constraint limit (MWh)

Target MW for end of period. Negative values when Bi-directional Unit is importing power, otherwise positive.

Public

Medium

PREDISPATCHREGIONSUM updates every thirty minutes.

<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVREPORTS

Regional aggregated energy storage where the DUID type is BDU (MWh)

Total available load side BDU summated for region (MW)

Total available generation side BDU summated for region (MW)

Regional aggregated cleared MW where the DUID type is BDU. Net of export (Generation)

Private, Public Next-Day

Medium

Own (confidential) data updates every thirty minutes, with whole market data for the day before available as part of next day market data.

<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVREPORTS

BDU only. The energy storage at the start of this dispatch interval (MWh)

BDU only. The projected energy storage based on cleared energy and regulation FCAS dispatch (MWh)

Participants may use negative values as an indicator of the relative error in profiling Max Availability to reflect energy limits.

BDU only - Minimum Energy Storage constraint limit (MWh)

BDU only - Maximum Energy Storage constraint limit (MWh)

Target MW for end of period. Negative values when Bi-directional Unit is importing power, otherwise positive.

Public

Medium

PD7DAY publishes few times per day

<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVREPORTS

Unique Timestamp Identifier for this study

Flag to indicate if this Predispatch case includes an intervention pricing run: 0 = case does not include an intervention pricing run, 1 = case does include an intervention pricing run.

Public

Medium

PD7DAY publishes few times per day

<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVREPORTS

Unique Timestamp Identifier for this study

The unique identifier for the interval within this study

Public

Medium

PD7DAY publishes few times per day

<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVREPORTS

Unique Timestamp Identifier for this study

Flag to indicate if this Predispatch case includes an intervention pricing run: 0 = case does not include an intervention pricing run, 1 = case does include an intervention pricing run.

The unique identifier for the interval within this study

Constraint identifier (synonymous with GenConID)

Right Hand Side value in the capacity evaluation in MW

Marginal cost of constraint (>0 if binding) in $/MW

Amount of Violation (>0 if violating) in MW

Aggregation of the constraints LHS term solution values in MW

Public

Medium

PD7DAY publishes few times per day

<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVREPORTS

Unique Timestamp Identifier for this study

Flag to indicate if this Predispatch case includes an intervention pricing run: 0 = case does not include an intervention pricing run, 1 = case does include an intervention pricing run.

The unique identifier for the interval within this study

Interconnector identifier

'SCADA MW Flow measured at Run start. For periods subsequent to the first period of a PD7DAY run, this value represents the cleared target for the previous period of that PD7DAY run.

Cleared Interconnector loading level (MW)

Interconnector Losses at cleared flow

Marginal cost of Interconnector standing data limits (if binding)

Violation of Interconnector standing data limits

Calculated Interconnector limit of exporting energy on the basis of invoked constraints and static interconnector export limit

Calculated Interconnector limit of importing energy on the basis of invoked constraints and static interconnector import limit. Note unlike the input interconnector import limit this is a directional quantity and should be defined with respect to the interconnector flow.

Marginal loss factor at the cleared flow

Generic Constraint setting the export limit

Generic Constraint setting the import limit

Calculated export limit applying to energy + Frequency Controlled Ancillary Services.

Calculated import limit applying to energy + Frequency Controlled Ancillary Services.

Aggregate Constraint contribution cost of this Interconnector: Sum(MarginalValue x Factor) for all relevant Constraints, for Export (Factor >= 0)

Key for Local_Price_Adjustment_Export: 2 = at least one Outage Constraint; 1 = at least 1 System Normal Constraint (and no Outage Constraint); 0 = No System Normal or Outage Constraints

Aggregate Constraint contribution cost of this Interconnector: Sum(MarginalValue x Factor) for all relevant Constraints, for Import (Factor >= 0)

Key for Local_Price_Adjustment_Import: 2 = at least one Outage Constraint; 1 = at least 1 System Normal Constraint (and no Outage Constraint); 0 = No System Normal or Outage Constraints

Public

Medium

PD7DAY publishes few times per day

<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVREPORTS

Unique Timestamp Identifier for this study

Flag to indicate if this Predispatch case includes an intervention pricing run: 0 = case does not include an intervention pricing run, 1 = case does include an intervention pricing run.

The unique identifier for the interval within this study

Region Identifier

Region Reference Price (Energy)

Regional Lower 1Sec Price - RegionSolution element L1Price attribute

Region Reference Price (Lower6Sec)

Region Reference Price (Lower60Sec)

Region Reference Price (Lower5Min)

Region Reference Price (LowerReg)

Regional Raise 1Sec Price - R1Price attribute after capping/flooring

Region Reference Price (Raise6Sec)

Region Reference Price (Raise60Sec)

Region Reference Price (Raise5Min)

Region Reference Price (RaiseReg)

New

New

Modified

Modified

Modified

Modified

Modified

Modified

Modified

Modified

New

New

New

Modified

Modified

Modified

Modified

Modified

Modified

Modified

Modified

Modified

Modified

Modified

Modified

Modified

New

New

Modified

Modified

Modified

Modified

Modified

Modified

Modified

Modified

Modified

Modified

New

New

New

New