|
Name |
|
|
Comment |
DAYTRACK identifies the actual settlement run processed for each settlement day. Settlement run is in the column EXPOSTRUNNO. Generally the number of the settlement run used in the latest statement is the maximum number. |
|
DAYTRACK is a public data, and is available to all participants. Source DAYTRACK is populated by the posting of a billing run. Volume Daily billing runs insert one row per day. A non-interim statement has seven records inserted per week. An indicative maximum is 35 records inserted per week. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
EXPOSTRUNNO |
|
SETTLEMENTDATE |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Calendar Settlement Date |
|
REGIONID |
VARCHAR2(10) |
|
Not Used |
|
EXANTERUNSTATUS |
VARCHAR2(15) |
|
Not Used |
|
EXANTERUNNO |
NUMBER(3,0) |
|
Not Used |
|
EXPOSTRUNSTATUS |
VARCHAR2(15) |
|
Not Used |
|
EXPOSTRUNNO |
NUMBER(3,0) |
X |
Settlement Run No |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
SETTLEMENTINTERVALLENGTH |
NUMBER(3,0) |
|
Length of a settlement interval, in minutes (was 30 minutes, will be 5 minutes starting the commencement of 5MS rule change date). |
|
Name |
|
|
Comment |
APC Compensation payment amounts in the Settlements timeframe |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
APEVENTID |
|
CLAIMID |
|
PARTICIPANTID |
|
PERIODID |
|
SETTLEMENTDATE |
|
VERSIONNO |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Settlement run date |
|
VERSIONNO |
NUMBER(3) |
X |
Settlement run number |
|
APEVENTID |
NUMBER(6) |
X |
AP Event Id |
|
CLAIMID |
NUMBER(6) |
X |
AP Event Claim Id |
|
PARTICIPANTID |
VARCHAR2(20) |
X |
Participant identifier |
|
PERIODID |
NUMBER(3) |
X |
Trading interval identifier |
|
COMPENSATION_AMOUNT |
NUMBER(18,8) |
|
Compensation amount for the event claim in this interval |
|
Name |
|
|
Comment |
APC Compensation recovery amounts in the Settlements timeframe |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
APEVENTID |
|
CLAIMID |
|
PARTICIPANTID |
|
PERIODID |
|
REGIONID |
|
SETTLEMENTDATE |
|
VERSIONNO |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Settlement run date |
|
VERSIONNO |
NUMBER(3) |
X |
Settlement run number |
|
APEVENTID |
NUMBER(6) |
X |
AP Event Id |
|
CLAIMID |
NUMBER(6) |
X |
AP Event Claim Id |
|
PARTICIPANTID |
VARCHAR2(20) |
X |
Participant identifier |
|
PERIODID |
NUMBER(3) |
X |
Settlements Trading Interval. |
|
REGIONID |
VARCHAR2(20) |
X |
Region id for the recovery amount |
|
RECOVERY_AMOUNT |
NUMBER(18,8) |
|
Recovery amount in the region attributable to the participant for the event claim in this interval |
|
REGION_RECOVERY_ |
NUMBER(18,8) |
|
Total Recovery amount in the region for the event claim in this interval |
|
Name |
|
|
Comment |
SET_ANCILLARY_SUMMARY summarises payments for all Ancillary Services to participants on the basis of regions and trading intervals. |
|
SET_ANCILLARY_SUMMARY data is available to all participants. Volume Approximately 30, 000 per week. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
PAYMENTTYPE |
|
PERIODID |
|
REGIONID |
|
SERVICE |
|
SETTLEMENTDATE |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Settlement Date |
|
VERSIONNO |
NUMBER(3,0) |
X |
Settlement Run No |
|
SERVICE |
VARCHAR2(20) |
X |
Ancillary service identifier (e.g. REACTIVE_POWER) |
|
PAYMENTTYPE |
VARCHAR2(20) |
X |
Payment type identifier (e.g. COMPENSATION) |
|
REGIONID |
VARCHAR2(10) |
X |
Region Identifier |
|
PERIODID |
NUMBER(3,0) |
X |
Trading interval |
|
PAYMENTAMOUNT |
NUMBER(18,8) |
|
The NEM ancillary summary regional payment amount ($) |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
The Settlement Energy Genset report contains the Energy Transactions data for each generation meter point. This report is produced only for Settlement Date post the IESS rule effective date. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
DUID |
|
GENSETID |
|
PERIODID |
|
SETTLEMENTDATE |
|
STATIONID |
|
VERSIONNO |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
The Settlement Date of the Billing Week |
|
VERSIONNO |
NUMBER(3,0) |
X |
The Settlement Run No |
|
PERIODID |
NUMBER(3,0) |
X |
The Period ID Identifier |
|
PARTICIPANTID |
VARCHAR2(20) |
|
The Participant Id Identifier |
|
STATIONID |
VARCHAR2(20) |
X |
The StationId identifier associated with the GensetId |
|
DUID |
VARCHAR2(20) |
X |
The DUID for the meter associated with the GensetId |
|
GENSETID |
VARCHAR2(20) |
X |
The GensetId for the Meter Id received |
|
REGIONID |
VARCHAR2(20) |
|
The Region Id for the Connection Point associated with the DUID |
|
CONNECTIONPOINTID |
VARCHAR2(20) |
|
The Connection Point associated with the DUID |
|
RRP |
NUMBER(18,8) |
|
The Regional Reference Price for the Settlement Period |
|
TLF |
NUMBER(18,8) |
|
The Transmission Loss Factor applied to the Connection Point Id. TLF is calculated based on the Net Flow at the TNI. |
|
METERID |
VARCHAR2(20) |
|
The Meter ID Identifier (NMI) |
|
CE_MWH |
NUMBER(18,8) |
|
The Consumed Energy for the Meter Id . Energy received in the meter reads (DLF Adjusted) |
|
UFEA_MWH |
NUMBER(18,8) |
|
The UFEA allocation amount applied to the Meter Data |
|
ACE_MWH |
NUMBER(18,8) |
|
The Adjusted Consumed Energy for the Meter Id (CE_MWh + UFEA) |
|
ASOE_MWH |
NUMBER(18,8) |
|
The Adjusted Sent Out Energy for the Meter Id. |
|
TOTAL_MWH |
NUMBER(18,8) |
|
The Total MWh for the Meter Id (ACE_MWh + ASOE_MWh) |
|
DME_MWH |
NUMBER(18,8) |
|
The DME MWh value that is used to calculate the UFEA Allocation Amount |
|
ACE_AMOUNT |
NUMBER(18,8) |
|
The Adjusted Consumed Energy Dollar Amount |
|
ASOE_AMOUNT |
NUMBER(18,8) |
|
The Adjusted Sent Out Energy Dollar Amount |
|
TOTAL_AMOUNT |
NUMBER(18,8) |
|
The Total Amount for the Meter Id (ACE_Amount + ASOE_Amount) |
|
LASTCHANGED |
DATE |
|
The Last changed Date time of the record |
|
Name |
|
|
Comment |
The Settlement Energy Region Summary report contains the Energy Transactions Summary for all the NEM regions. This report is produced only for Settlement Date post the IESS rule effective date. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
PERIODID |
|
REGIONID |
|
SETTLEMENTDATE |
|
VERSIONNO |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
The Settlement Date of the Billing Week |
|
VERSIONNO |
NUMBER(3,0) |
X |
The Settlement Run No |
|
PERIODID |
NUMBER(3,0) |
X |
The Period ID Identifier |
|
REGIONID |
VARCHAR2(20) |
X |
The NEM Region Id Identifier |
|
CE_MWH |
NUMBER(18,8) |
|
The Consumed Energy summary for the Region Id |
|
UFEA_MWH |
NUMBER(18,8) |
|
The UFEA Energy summary for the Region Id |
|
ACE_MWH |
NUMBER(18,8) |
|
The Adjusted Consumed Energy summary for the Region Id |
|
ASOE_MWH |
NUMBER(18,8) |
|
The Adjusted Sent Out Energy summary for the Region Id |
|
ACE_AMOUNT |
NUMBER(18,8) |
|
The Adjusted Consumed Energy Amount for the Region Id |
|
ASOE_AMOUNT |
NUMBER(18,8) |
|
The Adjusted Sent Out Energy Amount for the Region Id |
|
TOTAL_MWH |
NUMBER(18,8) |
|
The Total Energy summary for the Region Id |
|
TOTAL_AMOUNT |
NUMBER(18,8) |
|
The Total Dollar Amount summary for the Region Id |
|
LASTCHANGED |
DATE |
|
The Last changed Date time of the record |
|
Name |
|
|
Comment |
The table shows the Transaction Details for the SAPS Connection Points. The table contains both the MSRPs and Retailers data |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
PARTICIPANTID |
|
PERIODID |
|
SETTLEMENTDATE |
|
TNI |
|
VERSIONNO |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
The Settlement Date of the Billing Week |
|
VERSIONNO |
NUMBER(3,0) |
X |
The Settlement Run No |
|
PERIODID |
NUMBER(3,0) |
X |
The Period Id identifier |
|
PARTICIPANTID |
VARCHAR2(20) |
X |
The Participant ID for the SAPS TNI |
|
TNI |
VARCHAR2(20) |
X |
The SAPS Connection Point Identifier |
|
REGIONID |
VARCHAR2(20) |
|
The SAPS Region ID |
|
SAPS_RRP |
NUMBER(18,8) |
|
The SAPS Settlement Price for the Region |
|
CONSUMED_ENERGY_MWH |
NUMBER(18,8) |
|
The Energy MWh Consumed for that TNI for the Participant ID |
|
SENTOUT_ENERGY_MWH |
NUMBER(18,8) |
|
The Energy MWh Sent Out for the TNI for the Participant Id |
|
CONSUMED_ENERGY_COST |
NUMBER(18,8) |
|
The Cost of the Consumed Energy |
|
SENTOUT_ENERGY_COST |
NUMBER(18,8) |
|
The Cost of the Sent Out Energy |
|
LASTCHANGED |
DATE |
|
The Last changed Date time of the record |
|
Name |
|
|
Comment |
The Settlement Energy Transactions report contains the Energy Transactions data for all the Participants based on their ACE and ASOE at each customer and generator Connection Point ID. This table is populated The Settlement Energy Transactions report contains the Energy Transactions data for all the Participants based on their ACE and ASOE at each customer and generator Connection Point ID. This table is populated only if Settlement Date is post the IESS rule effective date. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
CONNECTIONPOINTID |
|
METER_TYPE |
|
PARTICIPANTID |
|
PERIODID |
|
SETTLEMENTDATE |
|
VERSIONNO |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
The Settlement Date of the Billing Week |
|
VERSIONNO |
NUMBER(3,0) |
X |
The Settlement Run No |
|
PERIODID |
NUMBER(3,0) |
X |
The Period ID Identifier |
|
PARTICIPANTID |
VARCHAR2(20) |
X |
The Participant Id Identifier |
|
CONNECTIONPOINTID |
VARCHAR2(20) |
X |
The Connection Point associated with the Energy Transaction reads. |
|
METER_TYPE |
VARCHAR2(20) |
X |
The type of meter reads received. Eg Customer, Generator, BDU, NREG etc. |
|
REGIONID |
VARCHAR2(20) |
|
The NEM Region Id Identifier |
|
RRP |
NUMBER(18,8) |
|
The Regional Reference Price for the Region |
|
TLF |
NUMBER(18,8) |
|
The Transmission Loss Factor applied to the Connection Point Id. TLF is calculated based on the Net Flow at the TNI. |
|
CE_MWH |
NUMBER(18,8) |
|
The Consumed Energy . Energy received in the meter reads (DLF Adjusted) |
|
UFEA_MWH |
NUMBER(18,8) |
|
The UFE Allocation Amount applied to the Participant |
|
ACE_MWH |
NUMBER(18,8) |
|
The Adjusted Consumed Energy MWh ( CE_MWh + UFEA) for the ConnectionPointId |
|
ASOE_MWH |
NUMBER(18,8) |
|
The Adjusted Sent Out Energy for the ConnectionPointId . Energy received in the meter reads adjusted by DLF. |
|
TOTAL_MWH |
NUMBER(18,8) |
|
The Total MWh Value for the Participant. ACE_MWh + ASOE_MWh |
|
ACE_AMOUNT |
NUMBER(18,8) |
|
The dollar amount for Adjusted Consumed Energy MWh (ACE_MWh * TLF * RRP) |
|
ASOE_AMOUNT |
NUMBER(18,8) |
|
The dollar amount for Adjusted Sent Out Energy MWh (ASOE_MWh * TLF * RRP) |
|
TOTAL_AMOUNT |
NUMBER(18,8) |
|
The Total Dollar Value for the Participant. ACE_Amount + ASOE_Amount |
|
CASE_ID |
NUMBER(10,0) |
|
The Metering Case ID |
|
DME_MWH |
NUMBER(18,8) |
|
The DME MWh (Distribution Connected) that is used in the UFEA Calculation. |
|
AGGREGATE_READ_FLAG |
NUMBER(3,0) |
|
The Flag is 1 if the meter data source is from Aggregate Reads Meter Data, Else 0 |
|
INDIVIDUAL_READ_FLAG |
NUMBER(3,0) |
|
The Flag is 1 if the meter data source is from Individual Reads Meter Data, Else 0 |
|
LASTCHANGED |
DATE |
|
The Last changed Date time of the record |
|
Name |
|
|
Comment |
SET_FCAS_PAYMENT sets out the enabling payment details for frequency controlled Ancillary Services. |
|
SET_FCAS_PAYMENT data is confidential to the relevant participant. Volume Approximately 150,000 per week. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
DUID |
|
PERIODID |
|
SETTLEMENTDATE |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Settlement Date |
|
VERSIONNO |
NUMBER(3,0) |
X |
Settlement Run No |
|
PARTICIPANTID |
VARCHAR2(10) |
|
Participant identifier |
|
DUID |
VARCHAR2(10) |
X |
Dispatchable unit identifier |
|
REGIONID |
VARCHAR2(10) |
|
Region Identifier |
|
PERIODID |
NUMBER(3,0) |
X |
Settlements Trading Interval. |
|
LOWER6SEC_PAYMENT |
NUMBER(18,8) |
|
Lower 6 Second Payment |
|
RAISE6SEC_PAYMENT |
NUMBER(18,8) |
|
Raise 6 Second Payment |
|
LOWER60SEC_PAYMENT |
NUMBER(18,8) |
|
Lower 60 Second Payment |
|
RAISE60SEC_PAYMENT |
NUMBER(18,8) |
|
Raise 60 Second Payment |
|
LOWER5MIN_PAYMENT |
NUMBER(18,8) |
|
Lower 5 Minute Payment |
|
RAISE5MIN_PAYMENT |
NUMBER(18,8) |
|
Raise 5 Minute Payment |
|
LOWERREG_PAYMENT |
NUMBER(18,8) |
|
Lower 5 Minute Regulation Payment |
|
RAISEREG_PAYMENT |
NUMBER(18,8) |
|
Raise 5 Minute Regulation Payment |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
RAISE1SEC_PAYMENT |
NUMBER(18,8) |
|
Payment amount for the very fast raise service |
|
LOWER1SEC_PAYMENT |
NUMBER(18,8) |
|
Payment amount for the very fast lower service |
|
Name |
|
|
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). |
|
SET_FCAS_RECOVERY data is confidential to the relevant participant. Volume Approximately 1, 500, 000 per week. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
PARTICIPANTID |
|
PERIODID |
|
REGIONID |
|
SETTLEMENTDATE |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Settlement Date |
|
VERSIONNO |
VARCHAR2(3) |
X |
Settlement Run No |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Participant identifier |
|
REGIONID |
VARCHAR2(10) |
X |
Region Identifier |
|
PERIODID |
NUMBER(3,0) |
X |
Settlements Trading Interval. |
|
LOWER6SEC_RECOVERY |
NUMBER(18,8) |
|
Recovery amount for the Lower 6 Second service attributable to customer connection points. NULL for Settlement date post the IESS rule effective date |
|
RAISE6SEC_RECOVERY |
NUMBER(18,8) |
|
Recovery amount for the Raise 6 Second service attributable to customer connection points. NULL for Settlement dates post the IESS rule effective date |
|
LOWER60SEC_RECOVERY |
NUMBER(18,8) |
|
Recovery amount for the Lower 60 Second service attributable to customer connection points. NULL for Settlement dates post the IESS rule effective date |
|
RAISE60SEC_RECOVERY |
NUMBER(18,8) |
|
Recovery amount for the Raise 60 Second service attributable to customer connection points. NULL for Settlement dates post the IESS rule effective date |
|
LOWER5MIN_RECOVERY |
NUMBER(18,8) |
|
Recovery amount for the Lower 5 Minute service attributable to customer connection points. NULL for Settlement dates post the IESS rule effective date |
|
RAISE5MIN_RECOVERY |
NUMBER(18,8) |
|
Recovery amount for the Raise 5 Minute service attributable to customer connection points. NULL for Settlement dates post the IESS rule effective date |
|
LOWERREG_RECOVERY |
NUMBER(18,8) |
|
For a 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 post the IESS rule effective date 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. |
|
RAISEREG_RECOVERY |
NUMBER(18,8) |
|
For a 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 post the IESS rule effective date 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. |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
LOWER6SEC_RECOVERY_GEN |
NUMBER(18,8) |
|
Recovery amount for the Lower 6 Second service attributable to generator connection points. NULL for Settlement dates post the IESS rule effective date |
|
RAISE6SEC_RECOVERY_GEN |
NUMBER(18,8) |
|
Recovery amount for the Raise 6 Second service attributable to generator connection points. NULL for Settlement dates post the IESS rule effective date |
|
LOWER60SEC_RECOVERY_GEN |
NUMBER(18,8) |
|
Recovery amount for the Lower 60 Second service attributable to generator connection points. NULL for Settlement dates post the IESS rule effective date |
|
RAISE60SEC_RECOVERY_GEN |
NUMBER(18,8) |
|
Recovery amount for the Raise 60 Second service attributable to generator connection points. NULL for Settlement dates post the IESS rule effective date |
|
LOWER5MIN_RECOVERY_GEN |
NUMBER(18,8) |
|
Recovery amount for the Lower 5 Minute service attributable to generator connection points. NULL for Settlement dates post the IESS rule effective date |
|
RAISE5MIN_RECOVERY_GEN |
NUMBER(18,8) |
|
Recovery amount for the Raise 5 Minute service attributable to generator connection points. NULL for Settlement dates post the IESS rule effective date |
|
LOWERREG_RECOVERY_GEN |
NUMBER(18,8) |
|
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. |
|
RAISEREG_RECOVERY_GEN |
NUMBER(18,8) |
|
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. |
|
RAISE1SEC_RECOVERY |
NUMBER(18,8) |
|
Customer recovery amount for the very fast raise service. NULL for Settlement dates post the IESS rule effective date |
|
LOWER1SEC_RECOVERY |
NUMBER(18,8) |
|
Customer recovery amount for the very fast lower service. NULL for Settlement dates post the IESS rule effective date |
|
RAISE1SEC_RECOVERY_GEN |
NUMBER(18,8) |
|
Generator recovery amount for the very fast raise service. NULL for Settlement dates post the IESS rule effective date |
|
LOWER1SEC_RECOVERY_GEN |
NUMBER(18,8) |
|
Generator recovery amount for the very fast lower service. NULL for Settlement dates post the IESS rule effective date |
|
LOWERREG_ACE |
NUMBER(18,8) |
|
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. |
|
RAISEREG_ACE |
NUMBER(18,8) |
|
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. |
|
RAISE1SEC_ACE |
NUMBER(18,8) |
|
The Raise1Sec FCAS Recovery Amount for the Participant and Region from ACE MWh Portion. NULL Value for Settlement Dates prior to the IESS rule effective date. |
|
RAISE1SEC_ASOE |
NUMBER(18,8) |
|
The Raise1Sec FCAS Recovery Amount for the Participant and Region from ASOE MWh Portion. NULL Value for Settlement Dates prior to the IESS rule effective date. |
|
LOWER1SEC_ACE |
NUMBER(18,8) |
|
The Lower1Sec FCAS Recovery Amount for the Participant and Region from ACE MWh Portion. NULL Value for Settlement Dates prior to the IESS rule effective date. |
|
LOWER1SEC_ASOE |
NUMBER(18,8) |
|
The Lower1Sec FCAS Recovery Amount for the Participant and Region from ASOE MWh Portion. NULL Value for Settlement Dates prior to the IESS rule effective date. |
|
RAISE6SEC_ACE |
NUMBER(18,8) |
|
The Raise6Sec FCAS Recovery Amount for the Participant and Region from ACE MWh Portion. NULL Value for Settlement Dates prior to the IESS rule effective date. |
|
RAISE6SEC_ASOE |
NUMBER(18,8) |
|
The Raise6Sec FCAS Recovery Amount for the Participant and Region from ASOE MWh Portion. NULL Value for Settlement Dates prior to the IESS rule effective date. |
|
LOWER6SEC_ACE |
NUMBER(18,8) |
|
The Lower6Sec FCAS Recovery Amount for the Participant and Region from ACE MWh Portion. NULL Value for Settlement Dates prior to the IESS rule effective date. |
|
LOWER6SEC_ASOE |
NUMBER(18,8) |
|
The Lower6Sec FCAS Recovery Amount for the Participant and Region from ASOE MWh Portion. NULL Value for Settlement Dates prior to the IESS rule effective date. |
|
RAISE60SEC_ACE |
NUMBER(18,8) |
|
The Raise60Sec FCAS Recovery Amount for the Participant and Region from ACE MWh Portion. NULL Value for Settlement Dates prior to the IESS rule effective date. |
|
RAISE60SEC_ASOE |
NUMBER(18,8) |
|
The Raise60Sec FCAS Recovery Amount for the Participant and Region from ASOE MWh Portion. NULL Value for Settlement Dates prior to the IESS rule effective date. |
|
LOWER60SEC_ACE |
NUMBER(18,8) |
|
The Lower60Sec FCAS Recovery Amount for the Participant and Region from ACE MWh Portion. NULL Value for Settlement Dates prior to the IESS rule effective date. |
|
LOWER60SEC_ASOE |
NUMBER(18,8) |
|
The Lower60Sec FCAS Recovery Amount for the Participant and Region from ASOE MWh Portion. NULL Value for Settlement Dates prior to the IESS rule effective date. |
|
RAISE5MIN_ACE |
NUMBER(18,8) |
|
The Raise5Min FCAS Recovery Amount for the Participant and Region from ACE MWh Portion. NULL Value for Settlement Dates prior to the IESS rule effective date. |
|
RAISE5MIN_ASOE |
NUMBER(18,8) |
|
The Raise5Min FCAS Recovery Amount for the Participant and Region from ASOE MWh Portion. NULL Value for Settlement Dates prior to the IESS rule effective date. |
|
LOWER5MIN_ACE |
NUMBER(18,8) |
|
The Lower5Min FCAS Recovery Amount for the Participant and Region from ACE MWh Portion. NULL Value for Settlement Dates prior to the IESS rule effective date. |
|
LOWER5MIN_ASOE |
NUMBER(18,8) |
|
The Lower5Min FCAS Recovery Amount for the Participant and Region from ASOE MWh Portion. NULL Value for Settlement Dates prior to the IESS rule effective date. |
|
Name |
|
|
Comment |
SET_FCAS_REGULATION_TRK shows FCAS Regulation Service Constraint tracking for Regional FCAS Regulation recovery |
|
SET_FCAS_REGULATION_TRK contains public data and is available to all participants. Volume Approximately 350,000 per week. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
CONSTRAINTID |
|
INTERVAL_DATETIME |
|
SETTLEMENTDATE |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Settlement Date |
|
VERSIONNO |
NUMBER(3,0) |
X |
Settlement Run No |
|
INTERVAL_DATETIME |
DATE |
X |
Dispatch Interval Date Time |
|
CONSTRAINTID |
VARCHAR2(20) |
X |
Generic Constraint ID |
|
CMPF |
NUMBER(18,8) |
|
Constraint Market Participant Factor |
|
CRMPF |
NUMBER(18,8) |
|
Constraint Residual Market Participant Factor |
|
RECOVERY_FACTOR_CMPF |
NUMBER(18,8) |
|
Recovery factor for CMPF based recovery |
|
RECOVERY_FACTOR_CRMPF |
NUMBER(18,8) |
|
Recovery factor for CRMPF based recovery |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
USESUBSTITUTEDEMAND |
NUMBER(1,0) |
|
Flag to indication that substitute demand was used to recover this requirement |
|
REQUIREMENTDEMAND |
NUMBER(18,8) |
|
the aggregate customer demand value used to recover the cost of this requirement |
|
Name |
|
|
Comment |
SET_NMAS_RECOVERY sets out the NSCAS recovery data for payments other than testing. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
CONTRACTID |
|
PARTICIPANTID |
|
PAYMENTTYPE |
|
PERIODID |
|
REGIONID |
|
SERVICE |
|
SETTLEMENTDATE |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Settlement Date |
|
VERSIONNO |
NUMBER(3,0) |
X |
Settlement run number |
|
PERIODID |
NUMBER(3,0) |
X |
Settlements Trading Interval. |
|
PARTICIPANTID |
VARCHAR(20) |
X |
The Participant from whom the amount is recovered |
|
SERVICE |
VARCHAR(10) |
X |
The type of NSCAS service. Current value values are: |
|
CONTRACTID |
VARCHAR(10) |
X |
The NMAS Contract Id |
|
PAYMENTTYPE |
VARCHAR(20) |
X |
The type of payment being recovered. Valid values are: |
|
REGIONID |
VARCHAR(10) |
X |
The region from where the amount is recovered |
|
RBF |
NUMBER(18,8) |
|
The Benefitting Factor for the RegionId |
|
PAYMENT_AMOUNT |
NUMBER(18,8) |
|
The total Payment Amount to recover from all benefitting regions |
|
PARTICIPANT_ENERGY |
NUMBER(18,8) |
|
The Participant energy in MWh for the period. NULL Value for Settlement Dates post IESS rule effective date. |
|
REGION_ENERGY |
NUMBER(18,8) |
|
The RegionId energy in MWh for the period. NULL Value for Settlement Dates post IESS rule effective date. |
|
RECOVERY_AMOUNT |
NUMBER(18,8) |
|
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. |
|
LASTCHANGED |
DATE |
|
The Last Updated date and time |
|
PARTICIPANT_GENERATION |
NUMBER(18,8) |
|
Participant Generator Energy in the benefitting region. NULL Value for Settlement Dates post IESS rule effective date. |
|
REGION_GENERATION |
NUMBER(18,8) |
|
The generator energy in the benefitting region. NULL Value for Settlement Dates post IESS rule effective date. |
|
RECOVERY_AMOUNT_CUSTOMER |
NUMBER(18,8) |
|
The recovery amount allocated to customers. NULL Value for Settlement Dates post IESS rule effective date. |
|
RECOVERY_AMOUNT_GENERATOR |
NUMBER(18,8) |
|
The recovery amount allocated to generators. NULL Value for Settlement Dates post IESS rule effective date. |
|
PARTICIPANT_ACE_MWH |
NUMBER(18,8) |
|
The ACE MWh value for the Participant used in the Recovery Amount Calculation. NULL Value for Settlement Dates prior to the IESS rule effective date. |
|
REGION_ACE_MWH |
NUMBER(18,8) |
|
The Regional ACE MWh value used in the Recovery Amount Calculation. NULL Value for Settlement Dates prior to the IESS rule effective date. |
|
PARTICIPANT_ASOE_MWH |
NUMBER(18,8) |
|
The ASOE MWh value for the Participant used in the Recovery Amount Calculation. NULL Value for Settlement Dates prior to the IESS rule effective date. |
|
REGION_ASOE_MWH |
NUMBER(18,8) |
|
The Regional ASOE MWh value used in the Recovery Amount Calculation. NULL Value for Settlement Dates prior to the IESS rule effective date. |
|
RECOVERYAMOUNT_ACE |
NUMBER(18,8) |
|
The Recovery dollar amount for the Participant for the NMAS Contract Id calculated using the ACE MWh values for eligible services. NULL Value for Settlement Dates prior to the IESS rule effective date. |
|
RECOVERYAMOUNT_ASOE |
NUMBER(18,8) |
|
The Recovery dollar amount for the Participant for the NMAS Contract Id calculated using the ASOE_MWh values for eligible services. NULL Value for Settlement Dates prior to the IESS rule effective date. |
|
Name |
|
|
Comment |
SET_NMAS_RECOVERY_RBF publishes the RBF for NSCAS non testing payments on a half hourly basis. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
CONTRACTID |
|
PAYMENTTYPE |
|
PERIODID |
|
REGIONID |
|
SERVICE |
|
SETTLEMENTDATE |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Settlement Date |
|
VERSIONNO |
NUMBER(3,0) |
X |
Settlement run number |
|
PERIODID |
NUMBER(3,0) |
X |
Settlements Trading Interval. |
|
SERVICE |
VARCHAR(10) |
X |
The type of NSCAS service. Current value values are: |
|
CONTRACTID |
VARCHAR(10) |
X |
The NMAS Contract Id |
|
PAYMENTTYPE |
VARCHAR(20) |
X |
The type of payment being recovered. Valid values are: |
|
REGIONID |
VARCHAR(10) |
X |
The region from where the amount is recovered |
|
RBF |
NUMBER(18,8) |
|
The Benefitting Factor for the RegionId |
|
PAYMENT_AMOUNT |
NUMBER(18,8) |
|
The total Payment Amount to recover from all benefitting regions |
|
RECOVERY_AMOUNT |
NUMBER(18,8) |
|
The Total recovery amount for the period for the REGIONID |
|
LASTCHANGED |
DATE |
|
The Last Updated date and time |
|
Name |
|
|
Comment |
Settlements substitution recovery energy used |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
PARTICIPANTID |
|
PERIODID |
|
REGIONID |
|
SETTLEMENTDATE |
|
SETTLEMENTRUNNO |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Settlement date |
|
SETTLEMENTRUNNO |
NUMBER(3,0) |
X |
Settlement run number |
|
PARTICIPANTID |
VARCHAR2(20) |
X |
Unique identifier for the participant |
|
REGIONID |
VARCHAR2(20) |
X |
Unique Identifier for the Region to which the TNI belongs on this settlement date |
|
PERIODID |
NUMBER(3,0) |
X |
Trading interval identifier, with Period 1 being the first TI for the calendar day, i.e interval ending 00:05 for 5MS or 00:30 for 30MS. |
|
CUSTOMERENERGYACTUAL |
NUMBER(18,8) |
|
Actual Customer Demand. NULL for Settlement dates post the IESS rule effective date. |
|
CUSTOMERENERGYMPFEXACTUAL |
NUMBER(18,8) |
|
Actual Customer Demand excluding TNIs that have a causer pays MPF. NULL for Settlement dates post the IESS rule effective date. |
|
CUSTOMERENERGYSUBSTITUTE |
NUMBER(18,8) |
|
Substitute Customer Demand. NULL for Settlement dates post the IESS rule effective date. |
|
CUSTOMERENERGYMPFEXSUBSTITUTE |
NUMBER(18,8) |
|
Substitute Customer Demand excluding TNIs that have a causer pays MPF. NULL for Settlement dates post the IESS rule effective date. |
|
GENERATORENERGYACTUAL |
NUMBER(18,8) |
|
Actual Generator Output. NULL for Settlement dates post the IESS rule effective date. |
|
REGIONCUSTENERGYACTUAL |
NUMBER(18,8) |
|
Region Total of Actual Customer Demand. NULL for Settlement dates post the IESS rule effective date. |
|
REGIONCUSTENERGYMPFEXACTUAL |
NUMBER(18,8) |
|
Region Total of Actual Customer Demand excluding TNIs that have a causer pays MPF. NULL for Settlement dates post the IESS rule effective date. |
|
REGIONCUSTENERGYSUBST |
NUMBER(18,8) |
|
Region Total of Substitute Customer Demand. NULL for Settlement dates post the IESS rule effective date. |
|
REGIONCUSTENERGYMPFEXSUBST |
NUMBER(18,8) |
|
Region total of Substitute Customer Demand excluding TNIs that have a causer pays MPF. NULL for Settlement dates post the IESS rule effective date. |
|
REGIONGENENERGYACTUAL |
NUMBER(18,8) |
|
Region Total of Actual Generator Output. NULL for Settlement dates post the IESS rule effective date. |
|
ACE_MWH_ACTUAL |
NUMBER(18,8) |
|
Actual ACE MWh Value for the Recovery Calculation. NULL Value for Settlement date prior to the IESS rule effective date |
|
ACE_MWH_MPFEX_ACTUAL |
NUMBER(18,8) |
|
The Actual ACE MWh Value excluding the MPF Connection Points for the Recovery Calculation. This is used only in FCAS Residue Recovery Calculation. NULL Value for Settlement date prior to the IESS rule effective date. |
|
ACE_MWH_SUBSTITUTE |
NUMBER(18,8) |
|
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 Value for Settlement date prior to the IESS rule effective date. |
|
ACE_MWH_MPFEX_SUBSTITUTE |
NUMBER(18,8) |
|
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 Value for Settlement date prior to the IESS rule effective date. |
|
ASOE_MWH_ACTUAL |
NUMBER(18,8) |
|
The Actual ASOE MWh Value for the Recovery Calculation. NULL Value for Settlement date prior to the IESS rule effective date. |
|
REGION_ACE_MWH_ACTUAL |
NUMBER(18,8) |
|
The Region total of Actual ACE MWh Value. NULL Value for Settlement date prior to the IESS rule effective date. |
|
REGION_ACE_MWH_MPFEX_ACTUAL |
NUMBER(18,8) |
|
The Region total of Actual ACE MWh Value excluding the MPF Connection Points. NULL Value for Settlement date prior to the IESS rule effective date. |
|
REGION_ACE_MWH_SUBST |
NUMBER(18,8) |
|
The Region total of Substitute ACE MWh Value. NULL Value for Settlement date prior to the IESS rule effective date. |
|
REGION_ACE_MWH_MPFEX_SUBST |
NUMBER(18,8) |
|
The Region total of Substitute ACE MWh Value excluding the MPF Connection Points . NULL Value for Settlement date prior to the IESS rule effective date. |
|
REGION_ASOE_MWH_ACTUAL |
NUMBER(18,8) |
|
The Region total of Actual ASOE MWh Value. NULL Value for Settlement date prior to the IESS rule effective date. |
|
Name |
|
|
Comment |
SET_RUN_PARAMETER shows the input parameters and value associated with each settlement run (e.g. Residual System Load Causer Pays Factor). |
|
Change History 19 August 2005 for 4.5.0: Changed index name again to have suffix of _LCX Note: primary key shows PK_ as prefix in Oracle SQL script, even though name of key has _PK as suffix - but cannot change since would not improve participant systems .
17 August 2005 for v4.5.0 Added tablespace (02) for recently added index, and gave index a better name |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
PARAMETERID |
|
SETTLEMENTDATE |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Settlement Date (Calendar) |
|
VERSIONNO |
NUMBER(3) |
X |
Settlement Run Number for this date |
|
PARAMETERID |
VARCHAR2(20) |
X |
Parameter Identifier |
|
NUMVALUE |
NUMBER(18,8) |
|
Settlement Run Amount for the Constant Identifier |
|
LASTCHANGED |
DATE |
|
Last date the record changed |
|
Name |
|
|
Comment |
Settlements substitution demand run version numbers |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
REFERENCESETTLEMENTDATE |
|
REFERENCESETTLEMENTRUNNO |
|
SETTLEMENTDATE |
|
SETTLEMENTRUNNO |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Settlement date |
|
SETTLEMENTRUNNO |
NUMBER(3,0) |
X |
Settlement run number |
|
REFERENCESETTLEMENTDATE |
DATE |
X |
The settlement date of a settlement run included in the reference period |
|
REFERENCESETTLEMENTRUNNO |
NUMBER(3,0) |
X |
The settlement run number matching the settlement date for a settlement run included in the reference period |
|
Name |
|
|
Comment |
Settlements substitution demand for Zero Demand figures |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
PARTICIPANTID |
|
SETTLEMENTDATE |
|
SETTLEMENTRUNNO |
|
TNI |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Settlement date |
|
SETTLEMENTRUNNO |
NUMBER(3,0) |
X |
Settlement run number |
|
TNI |
VARCHAR2(20) |
X |
Unique identifier for the connection point |
|
PARTICIPANTID |
VARCHAR2(20) |
X |
Unique identifier for the participant |
|
REGIONID |
VARCHAR2(20) |
|
Unique identifier for the region to which the TNI belongs to on this settlement date |
|
SUBSTITUTEDEMAND |
NUMBER(18,8) |
|
Substitute metered quantity for non-energy recovery in MWh for the TNI and participant in the trading interval. A negative value indicates net consumption and a positive value indicates net generation |
|
Name |
|
|
Comment |
Settlements WDR reconciliation details |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
NMI |
|
PERIODID |
|
SETTLEMENTDATE |
|
SETTLEMENTRUNNO |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Settlement date |
|
SETTLEMENTRUNNO |
NUMBER(3,0) |
X |
Settlement run number |
|
NMI |
VARCHAR2(20) |
X |
Unique identifier for the meter to which the metering records applies |
|
TNI |
VARCHAR2(20) |
|
Unique identifier for the transmission node to which this meter belongs on the settlement date |
|
REGIONID |
VARCHAR2(20) |
|
Unique identifier for the region to which the TNI belongs on the settlement date |
|
FRMP |
VARCHAR2(20) |
|
Unique identifier for the participant acting as the FRMP for this NMI on the settlement date |
|
DRSP |
VARCHAR2(20) |
|
Unique identifier for the participant acting as the DRSP for this NMI on the settlement date |
|
PERIODID |
NUMBER(3,0) |
X |
Trading interval identifier with Period 1 being the first TI for the calendar day, that is the interval ending 00:05 |
|
WDRSQ_UNCAPPED |
NUMBER(18,8) |
|
WDR settlement quantity before any capping or flooring (MWh) |
|
WDRSQ_CAPPED |
NUMBER(18,8) |
|
WDR settlement quantity after capping or flooring (MWh) |
|
MRC |
NUMBER(18,8) |
|
Maximum responsive component for the NMI (MW) |
|
MRCSQ |
NUMBER(18,8) |
|
Maximum responsive component settlement quantity for the NMI (MWh) |
|
WDRRR |
NUMBER(18,8) |
|
WDR reimbursement rate for the region ($/MWh) |
|
RRP |
NUMBER(18,8) |
|
Regional reference price for the region in the settlement interval ($/MWh) |
|
TLF |
NUMBER(18,8) |
|
Transmission loss factor for the wholesale connection point associated with the NMI |
|
ME_DLFADJUSTED |
NUMBER(18,8) |
|
Metered quantity in MWh for the NMI trading interval. A negative value indicates net consumption and a positive value indicates net generation |
|
BQ_DLFADJUSTED |
NUMBER(18,8) |
|
Baseline quantity in MWh for the NMI in the trading interval. A negative quantity indicates net consumption, while a positive value indicates net generation |
|
ISNONCOMPLIANT |
NUMBER(1,0) |
|
A value of TRUE (indicated by 1) for this column indicates that financial settlement of WDR transactions for this NMI should not proceed for the settlement date and trading interval. Possible values are 1 and 0. |
|
QUALITYFLAG |
VARCHAR2(20) |
|
Quality flag for the meter read. Where multiple datastreams exist against the NMI with different quality flags for each read, the lowest quality flag will be published against the NMI for the interval |
|
TRANSACTIONAMOUNT |
NUMBER(18,8) |
|
WDR transaction amount for this NMI in the settlement interval ($) |
|
BASELINECALCULATIONID |
VARCHAR2(100) |
|
A reference to the baseline run that produced the baseline quantity for this NMI and interval |
|
Name |
|
|
Comment |
Settlements WDR transactions summary |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
COUNTERPARTYPARTICIPANTID |
|
PARTICIPANTID |
|
PARTICIPANTROLEID |
|
PERIODID |
|
REGIONID |
|
SETTLEMENTDATE |
|
SETTLEMENTRUNNO |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Settlement date |
|
SETTLEMENTRUNNO |
NUMBER(3,0) |
X |
Settlement run number |
|
PERIODID |
NUMBER(3,0) |
X |
Trading interval identifier with Period 1 being the first TI for the calendar day, that is the interval ending 00:05 |
|
REGIONID |
VARCHAR2(20) |
X |
Unique identifier for the region to which the TNI belongs on the settlement date |
|
PARTICIPANTID |
VARCHAR2(20) |
X |
Unique identifier for a participant |
|
PARTICIPANTROLEID |
VARCHAR2(20) |
X |
Participant role identifier - FRMP or DRSP |
|
COUNTERPARTYPARTICIPANTID |
VARCHAR2(20) |
X |
Unique identifier for the counter participant id. |
|
TRANSACTIONAMOUNT |
NUMBER(18,8) |
|
Aggregate WDR transaction amount for the participant and counterparty in the settlement interval |
|
Name |
|
|
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. |
|
The Connection point details (in SETCPDATA) are confidential to the participant and host retailer that the connection points relate to. By comparison, the regional data (SETCPDATAREGION) is publically available. Source SETCPDATA updates with each Settlement run. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
MDA |
|
PARTICIPANTID |
|
PERIODID |
|
SETTLEMENTDATE |
|
TCPID |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
|
PARTICIPANTID |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Calendar Settlement Date |
|
VERSIONNO |
NUMBER(10,0) |
X |
Settlement run no |
|
PERIODID |
NUMBER(10,0) |
X |
Settlements Trading Interval. |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Unique participant identifier |
|
TCPID |
VARCHAR2(10) |
X |
Connection point identifier |
|
REGIONID |
VARCHAR2(10) |
|
Region Identifier |
|
IGENERGY |
NUMBER(16,6) |
|
Import Gross energy into the pool - MWh |
|
XGENERGY |
NUMBER(16,6) |
|
Export Gross energy from the pool - MWh |
|
INENERGY |
NUMBER(16,6) |
|
Import Nett energy into the pool - MWh, plus UFEA if the UFEA amount is positive. When GS commences, this includes the UFEA amount in the settlement runs. |
|
XNENERGY |
NUMBER(16,6) |
|
Export Nett energy from the pool - MWh, plus (UFEA * -1) if the UFEA amount is negative. When GS commences, this includes the UFEA amount in the settlement runs. |
|
IPOWER |
NUMBER(16,6) |
|
Import reactive power |
|
XPOWER |
NUMBER(16,6) |
|
Export reactive power |
|
RRP |
NUMBER(20,5) |
|
Regional Reference Price |
|
EEP |
NUMBER(16,6) |
|
Excess Energy Price |
|
TLF |
NUMBER(7,5) |
|
Transmission Loss Factor |
|
CPRRP |
NUMBER(16,6) |
|
Connection Point Price = RRP * TLF |
|
CPEEP |
NUMBER(16,6) |
|
Connection Point Excess Energy Price = EEP * TLF |
|
TA |
NUMBER(16,6) |
|
Export - Import of Net energy (MWh) |
|
EP |
NUMBER(16,6) |
|
settlement amount in $ for trading period |
|
APC |
NUMBER(16,6) |
|
Not used |
|
RESC |
NUMBER(16,6) |
|
Not used |
|
RESP |
NUMBER(16,6) |
|
Not used |
|
METERRUNNO |
NUMBER(10,0) |
|
Meter Run Number = version number of the meter file |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
HOSTDISTRIBUTOR |
VARCHAR2(10) |
|
Not used |
|
MDA |
VARCHAR2(10) |
X |
Metering Data Agent |
|
AFE |
NUMBER(18,8) |
|
Accounted For Energy for this Market Customer FRMP and TNI in the Settlements Trading Interval, excluding any UFEA component |
|
DME |
NUMBER(18,8) |
|
Sum of ME- for all NMIs at this Market Customer FRMP and TNI in the Settlements Trading Interval. |
|
UFEA |
NUMBER (18,8) |
|
Share of UFE allocated to this FRMP and TNI in the Settlements Trading Interval. |
|
AGE |
NUMBER (18,8) |
|
Adjusted Gross Energy for this Market Customer FRMP and TNI in the Settlements Trading Interval. When GS commences, this includes the UFEA amount in the settlement runs. |
|
IMPORTENERGYCOST |
NUMBER(18,8) |
|
The total cost of energy sold at the connection point by the participant in this settlement interval |
|
EXPORTENERGYCOST |
NUMBER(18,8) |
|
The total cost of energy purchased at the connection point by the participant in this settlement interval |
|
Name |
|
|
Comment |
SETCPDATAREGION sets out summary meter settlement data for each region. |
|
SETCPDATAREGION data is public, so is available to all participants. Source SETCPDATAREGION is a summary based on grouping on SETCPDATA and is updated with each settlement run. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
PERIODID |
|
REGIONID |
|
SETTLEMENTDATE |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Calendar Settlement Date |
|
VERSIONNO |
NUMBER(22,10) |
X |
Settlement run no |
|
PERIODID |
NUMBER(22,10) |
X |
Settlements Trading Interval. |
|
REGIONID |
VARCHAR2(10) |
X |
Region Identifier |
|
SUMIGENERGY |
NUMBER(27,5) |
|
Import Gross energy into the pool - MWh |
|
SUMXGENERGY |
NUMBER(27,5) |
|
Export Gross energy from the pool - MWh |
|
SUMINENERGY |
NUMBER(27,5) |
|
Import Nett energy into the pool - MWh |
|
SUMXNENERGY |
NUMBER(27,5) |
|
Export Nett energy from the pool - MWh |
|
SUMIPOWER |
NUMBER(22,0) |
|
Not used |
|
SUMXPOWER |
NUMBER(22,0) |
|
Not used |
|
LASTCHANGED |
DATE |
|
current system date, to enable automatic replication |
|
SUMEP |
NUMBER(15,5) |
|
Sum of energy price across the region |
|
Name |
|
|
Comment |
The FCAS Recovery amount from each NEM Region and the Energy MWh used for the FCAS Recovery calculation from Participants |
|
SETFCASREGIONRECOVERY contains public data and is available to all participants. Source SETFCASREGIONRECOVERY updates with each settlements run. Volume Approximately 10,000 rows per day |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
BIDTYPE |
|
PERIODID |
|
REGIONID |
|
SETTLEMENTDATE |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Settlement Date of trading interval |
|
VERSIONNO |
NUMBER(3,0) |
X |
Settlement run no |
|
BIDTYPE |
VARCHAR2(10) |
X |
FCAS Service Type |
|
REGIONID |
VARCHAR2(10) |
X |
RegionID |
|
PERIODID |
NUMBER(3,0) |
X |
Settlements Trading Interval. |
|
GENERATORREGIONENERGY |
NUMBER(16,6) |
|
Generator Regional Energy Amount. NULL for Settlement dates post the IESS rule effective date |
|
CUSTOMERREGIONENERGY |
NUMBER(16,6) |
|
Customer Region Energy Amount. NULL for Settlement dates post the IESS rule effective date |
|
REGIONRECOVERY |
NUMBER(18,8) |
|
The NEM Regional Recovery Amount for FCAS |
|
LASTCHANGED |
DATE |
|
Last Date record changed |
|
REGION_ACE_MWH |
NUMBER(18,8) |
|
The Regional ACE MWh value used for the FCAS Recovery. NULL for Settlement dates prior to the IESS rule effective date |
|
REGION_ASOE_MWH |
NUMBER(18,8) |
|
The Regional ASOE MWh value used for the FCAS Recovery. NULL for Settlement dates prior to the IESS rule effective date |
|
REGIONRECOVERYAMOUNT_ACE |
NUMBER(18,8) |
|
The Total Dollar Amount for the Region recovered using the ACE MWh Values. NULL for Settlement dates prior to the IESS rule effective date |
|
REGIONRECOVERYAMOUNT_ASOE |
NUMBER(18,8) |
|
The Total Dollar Amount for the Region recovered using the ASOE MWh Values. NULL for Settlement dates prior to the IESS rule effective date |
|
REGIONRECOVERYAMOUNT |
NUMBER(18,8) |
|
The Total Dollar Amount for the Region (RegionRecoveryAmountACE + RegionRecoveryAmountASOE). NULL for Settlement dates prior to the IESS rule effective date |
|
Name |
|
|
Comment |
SETGENDATA shows meter settlement data for each generation meter point. A regional summary is also provided. |
|
SETGENDATA shows generator meter details, and SETGENDATA data is confidential to the participant. By comparison, the regional summary (SETGENDATAREGION) is public data. Source SETGENDATA updates with each Settlement run. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
DUID |
|
GENSETID |
|
PERIODID |
|
REGIONID |
|
SETTLEMENTDATE |
|
STATIONID |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
|
PARTICIPANTID |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Calendar Settlement Date |
|
VERSIONNO |
NUMBER(10,0) |
X |
Settlement run no |
|
PERIODID |
NUMBER(10,0) |
X |
Settlements Trading Interval. |
|
PARTICIPANTID |
VARCHAR2(10) |
|
Unique participant identifier |
|
STATIONID |
VARCHAR2(10) |
X |
Station Identifier |
|
DUID |
VARCHAR2(10) |
X |
Dispatchable Unit identifier |
|
GENSETID |
VARCHAR2(10) |
X |
Physical unit identifier |
|
REGIONID |
VARCHAR2(10) |
X |
Region Identifier |
|
GENERGY |
NUMBER(16,6) |
|
Generated energy |
|
AENERGY |
NUMBER(16,6) |
|
Purchased Energy |
|
GPOWER |
NUMBER(16,6) |
|
Not used |
|
APOWER |
NUMBER(16,6) |
|
Not used |
|
RRP |
NUMBER(20,5) |
|
Regional Reference Price |
|
EEP |
NUMBER(16,6) |
|
Excess Energy Price |
|
TLF |
NUMBER(7,5) |
|
Transmission Loss Factor |
|
CPRRP |
NUMBER(16,6) |
|
Connection Point Price = RRP * TLF |
|
CPEEP |
NUMBER(16,6) |
|
Connection Point Excess Energy Price = EEP * TLF |
|
NETENERGY |
NUMBER(16,6) |
|
Generated energy |
|
ENERGYCOST |
NUMBER(16,6) |
|
Cost of net energy $ |
|
EXCESSENERGYCOST |
NUMBER(16,6) |
|
Cost of excess energy $ |
|
APC |
NUMBER(16,6) |
|
Administered Price Compensation |
|
RESC |
NUMBER(16,6) |
|
Not used |
|
RESP |
NUMBER(16,6) |
|
Not used |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
EXPENERGY |
NUMBER(15,6) |
|
Export Energy (Generator Purchases) (MWh) |
|
EXPENERGYCOST |
NUMBER(15,6) |
|
Export Energy Cost ($) |
|
METERRUNNO |
NUMBER(6,0) |
|
Identifier of the meter run used in this settlement calculation |
|
MDA |
VARCHAR2(10) |
|
Metering Data Agent |
|
SECONDARY_TLF |
NUMBER(7,5) |
|
Secondary Transmission Loss Factor |
|
Name |
|
|
Comment |
SETGENDATAREGION sets out summary settlement data for generation within the specified region. |
|
SETGENDATAREGION shows the regional summary. SETGENDATAREGION is public data. Source SETGENDATAREGION updates with each Settlement run. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
PERIODID |
|
REGIONID |
|
SETTLEMENTDATE |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Calendar Settlement Date |
|
VERSIONNO |
NUMBER(22,10) |
X |
Settlement run no |
|
PERIODID |
NUMBER(22,10) |
X |
Settlements Trading Interval. |
|
REGIONID |
VARCHAR2(10) |
X |
Region Identifier |
|
GENERGY |
NUMBER(22,0) |
|
Generated energy - Not used in MMS Data Model |
|
AENERGY |
NUMBER(22,0) |
|
Purchased Energy - Not used in MMS Data Model |
|
GPOWER |
NUMBER(22,0) |
|
Not used in MMS Data Model |
|
APOWER |
NUMBER(22,0) |
|
Not used in MMS Data Model |
|
NETENERGY |
NUMBER(27,5) |
|
Net energy MW/hours |
|
ENERGYCOST |
NUMBER(27,5) |
|
Cost of net energy $ |
|
EXCESSENERGYCOST |
NUMBER(27,5) |
|
Cost of excess energy $ |
|
EXPENERGY |
NUMBER(27,6) |
|
Export Energy (Generator Purchases) |
|
EXPENERGYCOST |
NUMBER(27,6) |
|
Export Energy Cost |
|
LASTCHANGED |
DATE |
|
current system date, to enable automatic replication |
|
Name |
|
|
Comment |
The Settlement Intra Region Residues Result. |
|
SETINTRAREGIONRESIDUES data is public to all participants. Source SETINTRAREGIONRESIDUES updates with each settlement run. Note The relationship between the data columns for each key is expressed in the following formula: EP + EC + (EXP * RRP) = IRSS |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
PERIODID |
|
REGIONID |
|
RUNNO |
|
SETTLEMENTDATE |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Settlement Date |
|
RUNNO |
NUMBER(3) |
X |
Settlement run number |
|
PERIODID |
NUMBER(3) |
X |
Settlements Trading Interval. |
|
REGIONID |
VARCHAR2(10) |
X |
Region Identifier |
|
EP |
NUMBER(15,5) |
|
Energy payments to generators. NULL for Settlement dates post the IESS rule effective date |
|
EC |
NUMBER(15,5) |
|
Energy purchased by customers. NULL for Settlement dates post the IESS rule effective date |
|
RRP |
NUMBER(15,5) |
|
Regional price |
|
EXP |
NUMBER(15,5) |
|
Net import in MWh into the region calculated at the regional reference node (export is negative) |
|
IRSS |
NUMBER(15,5) |
|
Intra-regional surplus (a negative sign indicates surplus, and a positive sign indicates a deficiency) |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
ACE_AMOUNT |
NUMBER(18,8) |
|
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 |
|
ASOE_AMOUNT |
NUMBER(18,8) |
|
The Adjusted Sent Out 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 |
|
Name |
|
|
Comment |
This view supports the Settlements Residue Auction, by holding the NSP participant allocations of IRSurplus arising as a result of the unsold units for a quarter. |
|
SETIRAUCSURPLUS data is confidential to the relevant participant. Source SETIRAUCSURPLUS updates with each settlement run. Volume SETIRAUCSURPLUS contains a maximum of 10 million records per year. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
CONTRACTID |
|
FROMREGIONID |
|
INTERCONNECTORID |
|
PARTICIPANTID |
|
PERIODID |
|
SETTLEMENTDATE |
|
SETTLEMENTRUNNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Calendar Settlement Date |
|
SETTLEMENTRUNNO |
NUMBER(3,0) |
X |
Settlement run number |
|
CONTRACTID |
VARCHAR2(10) |
X |
SRA Contract unique identifier |
|
PERIODID |
NUMBER(3,0) |
X |
Settlements Trading Interval. |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Unique participant identifier |
|
INTERCONNECTORID |
VARCHAR2(10) |
X |
Contracted Interconnector identifier |
|
FROMREGIONID |
VARCHAR2(10) |
X |
Nominated source region for Interconnector |
|
TOTALSURPLUS |
NUMBER(15,5) |
|
Total value of surplus before allocation |
|
CONTRACTALLOCATION |
NUMBER(8,5) |
|
Percentage allocated to participant |
|
SURPLUSVALUE |
NUMBER(15,5) |
|
Amount NSP is paid for Inter/intra-Regional surplus energy produced |
|
LASTCHANGED |
DATE |
|
Date and time this record was last modified |
|
CSP_DEROGATION_AMOUNT |
NUMBER(18,8) |
|
The CSP derogation amount applied as an adjustment to SRA |
|
UNADJUSTED_IRSR |
NUMBER(18,8) |
|
The SRA amount unadjusted by CSP |
|
Name |
|
|
Comment |
This view supports the Settlements Residue Auction, by showing the TNSP participant allocations of Interconnector Residue (IR) Surplus (i.e. derogated amounts) arising as a result of the sold units for a quarter. |
|
SETIRNSPSURPLUS data is confidential to the relevant participant. Source SETIRNSPSURPLUS updates with each settlement run. Volume SETIRNSPSURPLUS contains a maximum of 10 million records per year. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
CONTRACTID |
|
FROMREGIONID |
|
INTERCONNECTORID |
|
PARTICIPANTID |
|
PERIODID |
|
SETTLEMENTDATE |
|
SETTLEMENTRUNNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Settlement date |
|
SETTLEMENTRUNNO |
NUMBER(3,0) |
X |
Settlement run number |
|
CONTRACTID |
VARCHAR2(10) |
X |
SRA Contract unique identifier |
|
PERIODID |
NUMBER(3,0) |
X |
Settlements Trading Interval. |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Participant unique identifier |
|
INTERCONNECTORID |
VARCHAR2(10) |
X |
Identifier of Contracted Interconnector |
|
FROMREGIONID |
VARCHAR2(10) |
X |
Nominated source region for Interconnector |
|
TOTALSURPLUS |
NUMBER(15,5) |
|
Total value of surplus |
|
CONTRACTALLOCATION |
NUMBER(8,5) |
|
Percentage of total surplus allocated to participant |
|
SURPLUSVALUE |
NUMBER(15,5) |
|
Amount NSP is paid for Inter/intra-Regional surplus energy produced by the participant |
|
LASTCHANGED |
DATE |
|
Date and time this record was last modified |
|
CSP_DEROGATION_AMOUNT |
NUMBER(18,8) |
|
The CSP derogation amount applied as an adjustment to SRA |
|
UNADJUSTED_IRSR |
NUMBER(18,8) |
|
The SRA amount unadjusted by CSP |
|
Name |
|
|
Comment |
This view supports the Settlements Residue Auction, holding the participant allocations of IRSurplus. |
|
SETIRPARTSURPLUS data is confidential to each participant. Source SETIRPARTSURPLUS updates with each settlement run. Volume SETIRPARTSURPLUS contains a maximum of 20 million records per year. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
CONTRACTID |
|
FROMREGIONID |
|
INTERCONNECTORID |
|
PARTICIPANTID |
|
PERIODID |
|
SETTLEMENTDATE |
|
SETTLEMENTRUNNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Settlement date |
|
SETTLEMENTRUNNO |
NUMBER(3,0) |
X |
Settlement run number |
|
CONTRACTID |
VARCHAR2(10) |
X |
Ancillary Service Contract |
|
PERIODID |
NUMBER(3,0) |
X |
Settlements Trading Interval. |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Participant unique identifier |
|
INTERCONNECTORID |
VARCHAR2(10) |
X |
Identifier of the Contracted Interconnector |
|
FROMREGIONID |
VARCHAR2(10) |
X |
Nominated source region for Interconnector |
|
TOTALSURPLUS |
NUMBER(15,5) |
|
Total value of surplus before allocation |
|
CONTRACTALLOCATION |
NUMBER(8,5) |
|
Allocated percentage to participant |
|
SURPLUSVALUE |
NUMBER(15,5) |
|
Amount NSP is paid for Inter/intra-Regional surplus energy produced |
|
LASTCHANGED |
DATE |
|
Date and time this record was last updated |
|
CSP_DEROGATION_AMOUNT |
NUMBER(18,8) |
|
The CSP derogation amount applied as an adjustment to SRA |
|
UNADJUSTED_IRSR |
NUMBER(18,8) |
|
The SRA amount unadjusted by CSP |
|
Name |
|
|
Comment |
SETIRSURPLUS records the interregional residue calculation for each interconnector and each side of the interconnector. |
|
SETIRSURPLUS data is public, so is available to all participants. Source SETIRSURPLUS updates once a day at 8am. Note MWFLOW and LOSSFACTOR are now both calculated as MWh (energy) values for the half hour, and not MW (average demand) values. By way of clarification, the MWFLOW value is derived from half-hour revenue class metering, adjusted by a fixed fraction of the LOSSFACTOR value. The LOSSFACTOR value is taken to be exactly half of the MWLOSSES value in the TRADINGINTERCONNECT table. The METEREDMWFLOW field in the TRADINGINTERCONNECT table contains averaged SCADA metering demand values available in “real time”, whereas the MWFLOW field in the SETIRSURPLUS table contains settlement energy metering values available only after a settlement run is posted. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
INTERCONNECTORID |
|
PERIODID |
|
REGIONID |
|
SETTLEMENTDATE |
|
SETTLEMENTRUNNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Settlement date |
|
SETTLEMENTRUNNO |
NUMBER(3,0) |
X |
Settlement run number |
|
PERIODID |
NUMBER(3,0) |
X |
Settlements Trading Interval. |
|
INTERCONNECTORID |
VARCHAR2(10) |
X |
Interconnector |
|
REGIONID |
VARCHAR2(10) |
X |
Side of interconnector |
|
MWFLOW |
NUMBER(15,6) |
|
Net flow at the regional node (MWh), including losses |
|
LOSSFACTOR |
NUMBER(15,5) |
|
MW losses along interconnector NOTE: This is not a loss factor, but a loss figure expressed in MWH |
|
SURPLUSVALUE |
NUMBER(15,5) |
|
Amount of surplus in $ |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
CSP_DEROGATION_AMOUNT |
NUMBER(18,8) |
|
The CSP derogation amount applied as an adjustment to SRA |
|
UNADJUSTED_IRSR |
NUMBER(18,8) |
|
The SRA amount unadjusted by CSP |
|
Name |
|
|
Comment |
SETLOCALAREAENERGY shows the UFE, AGE and associated values for each local area and trading interval in a settlement run. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
LOCALAREAID |
|
PERIODID |
|
SETTLEMENTDATE |
|
SETTLEMENTRUNNO |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Settlement date of the settlement run |
|
SETTLEMENTRUNNO |
NUMBER(3,0) |
X |
Settlement run number of the settlement run |
|
LOCALAREAID |
VARCHAR2(30) |
X |
Unique identifier for the local area |
|
PERIODID |
NUMBER(3,0) |
X |
Settlement Trading Interval |
|
UFE |
NUMBER(18,8) |
|
Total unaccounted-for energy for the local area in this trading interval, in MWh |
|
DDME |
NUMBER(18,8) |
|
DDME component of UFE for the local area in this trading interval, in MWh. |
|
TME |
NUMBER(18,8) |
|
TME component of UFE for the local area in this trading interval, in MWh. |
|
ADME |
NUMBER(18,8) |
|
ADME component of UFE for the local area in this trading interval, in MWh. |
|
ADMELA |
NUMBER(18,8) |
|
The sum of all DME amounts for each Market Customer FRMP and TNI in the local area, in this trading interval. |
|
LASTCHANGED |
DATE |
|
Last changed date time for the record |
|
Name |
|
|
Comment |
SETLOCALAREATNI shows the list of TNIs constituent to a local area in a settlement run. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
LOCALAREAID |
|
SETTLEMENTDATE |
|
SETTLEMENTRUNNO |
|
TNI |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Settlement date of the settlement run |
|
SETTLEMENTRUNNO |
NUMBER(3,0) |
X |
Settlement run number of the settlement run |
|
LOCALAREAID |
VARCHAR2(30) |
X |
Unique identifier for the local area |
|
TNI |
VARCHAR2(30) |
X |
Unique identifier for a TNI constituent to the local area as at the settlement run |
|
LASTCHANGED |
DATE |
|
Last changed date time for the record |
|
Name |
|
|
Comment |
SETLSHEDPAYMENT shows specific payment details for load shed services by period. |
|
SETLSHEDPAYMENT data is confidential to the relevant participant. Source SETLSHEDPAYMENT updates with each settlement run. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
CONTRACTID |
|
PARTICIPANTID |
|
PERIODID |
|
SETTLEMENTDATE |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
|
PARTICIPANTID |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Settlement Date |
|
VERSIONNO |
NUMBER(3,0) |
X |
Settlement Run No. |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Participant Identifier |
|
CONTRACTID |
VARCHAR2(10) |
X |
AS Contract Identifier |
|
PERIODID |
NUMBER(3,0) |
X |
Settlements Trading Interval. |
|
DUID |
VARCHAR2(10) |
|
Dispatchable Unit Identifier |
|
REGIONID |
VARCHAR2(10) |
|
Region Identifier |
|
TLF |
NUMBER(7,5) |
|
Transmission Loss Factor |
|
RRP |
NUMBER(15,5) |
|
Regional Reference Price |
|
LSEPRICE |
NUMBER(15,5) |
|
Load Shed Enabling Price |
|
MCPPRICE |
NUMBER(15,5) |
|
Minimum Compensation Price |
|
LSCR |
NUMBER(4,0) |
|
Load Shed Control Range |
|
LSEPAYMENT |
NUMBER(15,5) |
|
Load Shed Enabling Payment |
|
CCPAYMENT |
NUMBER(15,5) |
|
Compensation Payment |
|
CONSTRAINEDMW |
NUMBER(15,5) |
|
Cleared MW of unit at time of load shed usage |
|
UNCONSTRAINEDMW |
NUMBER(15,5) |
|
Unconstrained MW of unit at time of load shed usage |
|
ALS |
NUMBER(15,5) |
|
Amount of load shed |
|
INITIALDEMAND |
NUMBER(15,5) |
|
Initial demand of unit at time of load shed usage |
|
FINALDEMAND |
NUMBER(15,5) |
|
Final demand of unit at time of load shed usage |
|
CONTRACTVERSIONNO |
NUMBER(3,0) |
|
AS Contract Version No. |
|
OFFERDATE |
DATE |
|
Re-offer offer date |
|
OFFERVERSIONNO |
NUMBER(3,0) |
|
Re-Offer Version No. |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
AVAILABILITYPAYMENT |
NUMBER(16,6) |
|
Payment amount for the Load Shed Availability service |
|
Name |
|
|
Comment |
SETLSHEDRECOVERY shows reimbursements for Load shed Ancillary Services to be recovered from participants. (Data no longer created for Settlement Days from 01/07/2012) |
|
SETLSHEDRECOVERY data is confidential to the relevant participant. Source SETLSHEDRECOVERY updates with each settlement run. Note Only the payment fields (LSEPAYMENT and CCPAYMENT) are on a regional basis. All other demand and recovery fields are on NEM basis rather than a regional basis. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
PARTICIPANTID |
|
PERIODID |
|
REGIONID |
|
SETTLEMENTDATE |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Settlement Date |
|
VERSIONNO |
NUMBER(3,0) |
X |
Settlement Run No. |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Participant to pay recovery |
|
CONTRACTID |
VARCHAR2(10) |
|
Contract Identifier for reserve, intervention, settlement and ancillary service contracts. Contracts are coded by type and unit. |
|
PERIODID |
NUMBER(3,0) |
X |
Settlements Trading Interval. |
|
REGIONID |
VARCHAR2(10) |
X |
Region Identifier |
|
LSEPAYMENT |
NUMBER(15,5) |
|
Load Shed Enabling Payment |
|
CCPAYMENT |
NUMBER(15,5) |
|
Compensation Payment |
|
PARTICIPANTDEMAND |
NUMBER(15,5) |
|
Total Participant NEM Demand |
|
REGIONDEMAND |
NUMBER(15,5) |
|
Total NEM Demand |
|
LSERECOVERY |
NUMBER(15,5) |
|
Load Shed Enabling Recovery |
|
CCRECOVERY |
NUMBER(15,5) |
|
Compensation Recovery |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
LSERECOVERY_GEN |
NUMBER(15,5) |
|
Load Shed Enabling Recovery for Generator |
|
CCRECOVERY_GEN |
NUMBER(15,5) |
|
Compensation Recovery for Generator |
|
PARTICIPANTDEMAND_GEN |
NUMBER(15,5) |
|
Total Participant NEM Demand for Generator |
|
REGIONDEMAND_GEN |
NUMBER(15,5) |
|
Total NEM Demand for Generator |
|
AVAILABILITYRECOVERY |
NUMBER(16,6) |
|
Recovery amount for the Load Shed Availability service attributable to customer connection points |
|
AVAILABILITYRECOVERY_GEN |
NUMBER(16,6) |
|
Recovery amount for the Load Shed Availability service attributable to generator connection points |
|
Name |
|
|
Comment |
SETMARKETFEES shows payments for market fees for each settlement date. |
|
SETMARKETFEES is confidential data. Source SETMARKETFEES updates with each settlement run. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
MARKETFEEID |
|
PARTICIPANTCATEGORYID |
|
PARTICIPANTID |
|
PERIODID |
|
RUNNO |
|
SETTLEMENTDATE |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Settlement date |
|
RUNNO |
NUMBER(3,0) |
X |
Settlement run no |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Unique participant identifier |
|
PERIODID |
NUMBER(3,0) |
X |
Settlements Trading Interval. |
|
MARKETFEEID |
VARCHAR2(10) |
X |
Market fee identifier (e.g. V_EST) |
|
MARKETFEEVALUE |
NUMBER(15,5) |
|
Fee charge |
|
ENERGY |
NUMBER(16,6) |
|
Energy amount for variable fees |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
PARTICIPANTCATEGORYID |
VARCHAR2(10) |
X |
The participant category that the market fee recovery pertains to. Corresponds to the PARTICIPANTCATEGORYID column of the PARTICIPANT_BANDFEE_CATEGORYALLOC_C_V view for BAND$ type fees, or to the MARKETFEETYPE column of the MARKETFEE_P_V view for all other fee types. |
|
FEERATE |
NUMBER(18,8) |
|
The rate applied to this fee for the participant at the settlement date |
|
FEEUNITS |
NUMBER(18,8) |
|
The number of units applicable to this fee for the participant, in the trading interval. |
|
METER_TYPE |
VARCHAR2(20) |
|
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 |
|
METER_SUBTYPE |
VARCHAR2(20) |
|
The Meter Sub Type values are ACE, ASOE or ALL. ACE represent ACE_MWH value or ASOE represent ASOE_MWH value and ALL represent sum of ACE_MWh and ASOE_MWh |
|
Name |
|
|
Comment |
SETREALLOCATIONS shows the trading interval value of reallocations processed, for those participants whose reallocation submissions have been accepted by AEMO. |
|
SETREALLOCATIONS data is confidential to participants party to the reallocation. Source SETREALLOCATIONS updates by the posting of a billing run. Volume Generally, there are approximately 550 records inserted per week. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
PARTICIPANTID |
|
PERIODID |
|
REALLOCATIONID |
|
RUNNO |
|
SETTLEMENTDATE |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Calendar Settlement Date |
|
RUNNO |
NUMBER(3,0) |
X |
Settlement run no |
|
PERIODID |
NUMBER(3,0) |
X |
Settlements Trading Interval. |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Unique participant identifier |
|
REALLOCATIONID |
VARCHAR2(20) |
X |
Reallocation contract identifier |
|
REALLOCATIONVALUE |
NUMBER(15,5) |
|
Reallocation value in $ |
|
ENERGY |
NUMBER(15,5) |
|
Energy in MWh if reallocation agreement type is MWh |
|
RRP |
NUMBER(15,5) |
|
Regional Reference Price |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
SETRESERVERECOVERY shows reserve recovery details. |
|
SETRESERVERECOVERY is unused. Source Unused; was updated when reserve recovery occurred in a billing run. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
CONTRACTID |
|
PARTICIPANTID |
|
PERIODID |
|
SETTLEMENTDATE |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Settlement Date |
|
VERSIONNO |
NUMBER(3,0) |
X |
Settlement Run No. |
|
PERIODID |
NUMBER(3,0) |
X |
Settlements Trading Interval. |
|
CONTRACTID |
VARCHAR2(10) |
X |
|
|
RCF |
CHAR(1) |
|
Regional Recovery Flag |
|
SPOTPAYMENT |
NUMBER(12,5) |
|
Cap difference for generator |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Unique participant identifier |
|
PARTICIPANTDEMAND |
NUMBER(12,5) |
|
Demand of Participant in Region/Market |
|
TOTALDEMAND |
NUMBER(12,5) |
|
Total Demand of Region/Market |
|
RESERVEPAYMENT |
NUMBER(12,5) |
|
Payment made to generator for Reserve Trader Contract |
|
RESERVEAMOUNT |
NUMBER(12,5) |
|
Payment owed by Retailer to pool for Reserve Trader Contract |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
REGIONID |
VARCHAR2(10) |
|
Region Identifier |
|
Name |
|
|
Comment |
SETRESTARTPAYMENT shows specific payment details for System Restart services by period. |
|
SETRESTARTPAYMENT data is confidential to the relevant participant. Source SETRESTARTPAYMENT updates with each settlement run. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
CONTRACTID |
|
PARTICIPANTID |
|
PERIODID |
|
SETTLEMENTDATE |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
|
PARTICIPANTID |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Settlement Date |
|
VERSIONNO |
NUMBER(3,0) |
X |
Settlement Run No. |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Participant Identifier |
|
CONTRACTID |
VARCHAR2(10) |
X |
Contract Identifier |
|
PERIODID |
NUMBER(3,0) |
X |
Settlements Trading Interval. |
|
REGIONID |
VARCHAR2(10) |
|
Region Identifier |
|
RESTARTTYPE |
NUMBER(1,0) |
|
System Restart Type (0 = FRC, 1 = GRC, 2 = TTH) |
|
AVAFLAG |
NUMBER(1,0) |
|
Availability Flag |
|
AVAILABILITYPRICE |
NUMBER(15,5) |
|
Availability Price |
|
TCF |
NUMBER(1,0) |
|
Service Test Flag |
|
AVAILABILITYPAYMENT |
NUMBER(15,5) |
|
Availability Payment |
|
CONTRACTVERSIONNO |
NUMBER(3,0) |
|
Contract Version No. |
|
OFFERDATE |
DATE |
|
Re-offer offer date |
|
OFFERVERSIONNO |
NUMBER(3,0) |
|
Re-Offer Version No. |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
ENABLINGPAYMENT |
NUMBER(18,8) |
|
The enabling payment made for system restart in this half-hour interval |
|
Name |
|
|
Comment |
SETRESTARTRECOVERY shows reimbursements for system restart Ancillary Services to be recovered from participants. (Data no longer created for Settlement Days from 01/07/2012) |
|
SETRESTARTRECOVERY data is confidential to the relevant participant. Source SETRESTARTRECOVERY updates with each settlement run. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
PARTICIPANTID |
|
PERIODID |
|
REGIONID |
|
SETTLEMENTDATE |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Settlement Date |
|
VERSIONNO |
NUMBER(3,0) |
X |
Settlement Run No. |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Participant to pay recovery |
|
CONTRACTID |
VARCHAR2(10) |
|
Contract Identifier |
|
PERIODID |
NUMBER(3,0) |
X |
Settlements Trading Interval. |
|
REGIONID |
VARCHAR2(10) |
X |
Region Identifier |
|
AVAILABILITYPAYMENT |
NUMBER(15,5) |
|
Availability Payment |
|
PARTICIPANTDEMAND |
NUMBER(15,5) |
|
Participant Demand in Region |
|
REGIONDEMAND |
NUMBER(15,5) |
|
NEM Demand (NB sum of ALL Regions) |
|
AVAILABILITYRECOVERY |
NUMBER(15,5) |
|
Availability Recovery |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
AVAILABILITYRECOVERY_GEN |
NUMBER(15,5) |
|
Availability Recovery for Generator |
|
PARTICIPANTDEMAND_GEN |
NUMBER(15,5) |
|
Participant Demand in Region for Generator |
|
REGIONDEMAND_GEN |
NUMBER(15,5) |
|
Sum of all generation including SGA generation across all regions of the NEM and floored to zero |
|
ENABLINGPAYMENT |
NUMBER(18,8) |
|
The enabling payment made for system restart in this half-hour interval |
|
ENABLINGRECOVERY |
NUMBER(18,8) |
|
The enabling recovery amount for system restart in this half-hour interval attributable to customer activity |
|
ENABLINGRECOVERY_GEN |
NUMBER(18,8) |
|
The enabling recovery amount for system restart in this half-hour interval attributable to generator activity |
|
Name |
|
|
Comment |
SETRPOWERPAYMENT shows specific payment details for Reactive power services by period. |
|
SETRPOWERPAYMENT data is confidential to the relevant participant. Source SETRPOWERPAYMENT updates with each settlement run. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
CONTRACTID |
|
PARTICIPANTID |
|
PERIODID |
|
SETTLEMENTDATE |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Settlement Date |
|
VERSIONNO |
NUMBER(3,0) |
X |
Settlement Run No. |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Participant Identifier |
|
CONTRACTID |
VARCHAR2(10) |
X |
AS Contract Identifier |
|
PERIODID |
NUMBER(3,0) |
X |
Settlements Trading Interval. |
|
DUID |
VARCHAR2(10) |
|
Dispatchable Unit Identifier |
|
REGIONID |
VARCHAR2(10) |
|
Region Identifier |
|
TLF |
NUMBER(7,5) |
|
Transmission Loss Factor |
|
EBP |
NUMBER(15,5) |
|
Eligible Bid Price |
|
RRP |
NUMBER(15,5) |
|
Regional Reference Price |
|
MVARAPRICE |
NUMBER(15,5) |
|
Availability price per MVAr of RP absorption capability |
|
MVAREPRICE |
NUMBER(15,5) |
|
Enabling Price |
|
MVARGPRICE |
NUMBER(15,5) |
|
Availability price per MVAr of RP generation capability |
|
CCPRICE |
NUMBER(15,5) |
|
Compensation Cap |
|
SYNCCOMPENSATION |
NUMBER(1,0) |
|
Sync Compensation Flag |
|
MTA |
NUMBER(15,5) |
|
Reactive Power Absorption Capability (MVAr) |
|
MTG |
NUMBER(15,5) |
|
Reactive Power Generation Capability (MVAr) |
|
BLOCKSIZE |
NUMBER(4,0) |
|
Block size of unit |
|
AVAFLAG |
NUMBER(1,0) |
|
Availability Flag |
|
CLEAREDMW |
NUMBER(15,5) |
|
Cleared MW of unit |
|
UNCONSTRAINEDMW |
NUMBER(15,5) |
|
Unconstrained MW of unit |
|
AVAILABILITYPAYMENT |
NUMBER(15,5) |
|
Availability Payment |
|
ENABLINGPAYMENT |
NUMBER(15,5) |
|
Enabling Payment |
|
CCPAYMENT |
NUMBER(15,5) |
|
Compensation Payment |
|
CONTRACTVERSIONNO |
NUMBER(3,0) |
|
AS Contract Version No. |
|
OFFERDATE |
DATE |
|
Re-offer offer date |
|
OFFERVERSIONNO |
NUMBER(3,0) |
|
Re-Offer Version No. |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
AVAILABILITYPAYMENT_REBATE |
NUMBER(18,8) |
|
The rebate amount if MegaVar (MVAr) is below the threshold. |
|
Name |
|
|
Comment |
SETRPOWERRECOVERY shows reimbursements for Reactive Power Ancillary Services to be recovered from participants. (Data no longer created for Settlement Days from 01/07/2012) |
|
SETRPOWERRECOVERY data is confidential to the relevant participant. Source SETRPOWERRECOVERY updates with each settlement run. Note Only the payment fields (AVAILABILITYPAYMENT, ENABLINGPAYMENT and CCPAYMENT) are on a regional basis. All other demand and recovery fields are on NEM basis rather than a regional basis. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
PARTICIPANTID |
|
PERIODID |
|
REGIONID |
|
SETTLEMENTDATE |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Settlement Date |
|
VERSIONNO |
NUMBER(3,0) |
X |
Settlement Run No. |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Participant to pay recovery |
|
CONTRACTID |
VARCHAR2(10) |
|
AS Contract Identifier |
|
PERIODID |
NUMBER(3,0) |
X |
Settlements Trading Interval. |
|
REGIONID |
VARCHAR2(10) |
X |
Region Identifier |
|
AVAILABILITYPAYMENT |
NUMBER(15,5) |
|
Availability Payment |
|
ENABLINGPAYMENT |
NUMBER(15,5) |
|
Enabling Payment |
|
CCPAYMENT |
NUMBER(15,5) |
|
Compensation payment |
|
PARTICIPANTDEMAND |
NUMBER(15,5) |
|
Total Participant NEM Demand |
|
REGIONDEMAND |
NUMBER(15,5) |
|
Total NEM Demand |
|
AVAILABILITYRECOVERY |
NUMBER(15,5) |
|
Availability Recovery |
|
ENABLINGRECOVERY |
NUMBER(15,5) |
|
Enabling Recovery |
|
CCRECOVERY |
NUMBER(15,5) |
|
Compensation Recovery |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
AVAILABILITYRECOVERY_GEN |
NUMBER(15,5) |
|
Availability Recovery for Generator |
|
ENABLINGRECOVERY_GEN |
NUMBER(15,5) |
|
Enabling Recovery for Generator |
|
CCRECOVERY_GEN |
NUMBER(15,5) |
|
Compensation Recovery for Generator |
|
PARTICIPANTDEMAND_GEN |
NUMBER(15,5) |
|
Total Participant NEM Demand for Generator |
|
REGIONDEMAND_GEN |
NUMBER(15,5) |
|
Total NEM Demand for Generator |
|
Name |
|
|
Comment |
Publishes metering data and associated settlement values for with a registered Small Generator Aggregator participants connection points. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
CONNECTIONPOINTID |
|
PARTICIPANTID |
|
PERIODID |
|
SETTLEMENTDATE |
|
VERSIONNO |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Settlement date |
|
VERSIONNO |
NUMBER(3,0) |
X |
Version number of the record for the settlement date |
|
CONNECTIONPOINTID |
VARCHAR2(20) |
X |
Transmission Node Identifier (TNI) |
|
PERIODID |
NUMBER(3,0) |
X |
Settlements Trading Interval. |
|
PARTICIPANTID |
VARCHAR2(20) |
X |
Unique participant identifier |
|
REGIONID |
VARCHAR2(20) |
|
Region Identifier |
|
IMPORTENERGY |
NUMBER(18,8) |
|
The import direction value for the meter read (MWh) |
|
EXPORTENERGY |
NUMBER(18,8) |
|
The export direction value for the meter read (MWh) |
|
RRP |
NUMBER(18,8) |
|
Regional Reference Price |
|
TLF |
NUMBER(18,8) |
|
Transmission Loss Factor |
|
IMPENERGYCOST |
NUMBER(18,8) |
|
Import Energy Cost ($) |
|
EXPENERGYCOST |
NUMBER(18,8) |
|
Export Energy Cost ($) |
|
LASTCHANGED |
DATE |
|
Last date and time the record changed |
|
|
|