|
Name |
|
|
Comment |
This report contains the the FCAS Regulation Amounts that include FPP Amounts, Used Amounts and Unused Amounts calculated using the Contribution Factors |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
CONSTRAINTID |
|
PERIODID |
|
SETTLEMENTDATE |
|
UNITID |
|
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 |
|
UNITID |
VARCHAR2(20) |
X |
The UNITID with CF factor assigned. This is a DUID or a TNI. Refer table FPP_CONTRIBUTION_FACTOR |
|
CONSTRAINTID |
VARCHAR2(20) |
X |
The FCAS Regulation Constraint ID |
|
PERIODID |
NUMBER(3,0) |
X |
The Period ID Identifier |
|
PARTICIPANTID |
VARCHAR2(20) |
|
The Participant Id Identifier |
|
BIDTYPE |
VARCHAR2(10) |
|
The BidType LOWERREG or RAISEREG for the Constraint ID |
|
FPP_AMOUNT |
NUMBER(18,8) |
|
The FPP Amount calculated for the Constraint and UNITID using the FPP Contribution Factor |
|
USED_AMOUNT |
NUMBER(18,8) |
|
The Regulation Used Recovery Amount from the eligible Units using Negative CF Value |
|
UNUSED_AMOUNT |
NUMBER(18,8) |
|
The Regulation Unused Recovery Amount from Eligible Units using DCF Value |
|
LASTCHANGED |
DATE |
|
The Last Changed Date time of the record. |
|
Name |
|
|
Comment |
This report contains the the FCAS Regulation Amounts that include FPP Amounts, Used Amounts and Unused Amounts calculated using the Default Contribution Factors. This is when FPP Factors are not available for a particular interval and system used DCF in the calculation. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
CONSTRAINTID |
|
PERIODID |
|
SETTLEMENTDATE |
|
UNITID |
|
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 |
|
UNITID |
VARCHAR2(20) |
X |
The UnitId with CF factor assigned. This is a DUID or a TNI. Refer table FPP_CONTRIBUTION_FACTOR |
|
CONSTRAINTID |
VARCHAR2(20) |
X |
The FCAS Regulation Constraint ID |
|
PERIODID |
NUMBER(3,0) |
X |
The Period ID Identifier |
|
PARTICIPANTID |
VARCHAR2(20) |
|
The Participant Id Identifier |
|
BIDTYPE |
VARCHAR2(10) |
|
The BidType LOWERREG or RAISEREG for the Constraint ID |
|
UNUSED_AMOUNT |
NUMBER(18,8) |
|
The Regulation Unused Recovery Amount from Eligible Units using DCF Value |
|
LASTCHANGED |
DATE |
|
The Last Changed Date time of the record. |
|
Name |
|
|
Comment |
This report contains the the FCAS Regulation Residue Amounts that include FPP Residual Amounts, Used Residual Amounts and Unused Residual Amounts calculated using the Energy Ratio for each Requirement Region and the Default Residual CF |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
CONSTRAINTID |
|
PARTICIPANTID |
|
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 |
|
PARTICIPANTID |
VARCHAR2(20) |
X |
The Participant Id Identifier |
|
CONSTRAINTID |
VARCHAR2(20) |
X |
The FCAS Regulation Constraint ID |
|
PERIODID |
NUMBER(3,0) |
X |
The Period ID Identifier |
|
REGIONID |
VARCHAR2(20) |
X |
The RegionId used for the residual calculation. This is the Constraint Requirement Region. |
|
BIDTYPE |
VARCHAR2(10) |
|
The BidType LOWERREG or RAISEREG for the Constraint ID |
|
ACE_MWH |
NUMBER(18,8) |
|
The ACE MWh value that is used for the Residual Calculation.(Excluding CPID with CF) |
|
ASOE_MWH |
NUMBER(18,8) |
|
The ASOE MWh value that is used for the Residual Calculation.(Excluding CPID with CF) |
|
RESIDUAL_MWH |
NUMBER(18,8) |
|
Sum of ABS(ACE_MWh) + ASOE_MWh. The MWh is not netted for residual calculation. This is not used in calculation at the moment. This is only used for FPP Residual |
|
UNUSED_ACE_AMOUNT |
NUMBER(18,8) |
|
The Unused Recovery ACE Amount calculated using the ACE MWh value of the requirement regions. |
|
UNUSED_ASOE_AMOUNT |
NUMBER(18,8) |
|
The Unused Recovery ASOE Amount is always 0 as FCAS Reg Residual is recovered from ACE MWh Only |
|
UNUSED_RESIDUAL_AMOUNT |
NUMBER(18,8) |
|
The Unused Residual Amount is same as Unused ACE Amount. |
|
LASTCHANGED |
DATE |
|
The Last Changed Date time of the record. |
|
Name |
|
|
Comment |
This report contains the the FCAS Regulation Residue Amounts that include FPP Residual Amounts, Used Residual Amounts and Unused Residual Amounts calculated using the Energy Ratio for each Requirement Region |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
CONSTRAINTID |
|
PARTICIPANTID |
|
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 |
|
PARTICIPANTID |
VARCHAR2(20) |
X |
The Participant Id Identifier |
|
CONSTRAINTID |
VARCHAR2(20) |
X |
The FCAS Regulation Constraint ID |
|
PERIODID |
NUMBER(3,0) |
X |
The Period ID Identifier |
|
REGIONID |
VARCHAR2(20) |
X |
The RegionId used for the residual calculation. This is the Constraint Requirement Region. |
|
BIDTYPE |
VARCHAR2(10) |
|
The BidType LOWERREG or RAISEREG for the Constraint ID |
|
ACE_MWH |
NUMBER(18,8) |
|
The ACE MWh value that is used for the Residual Calculation.(Excluding CPID with CF) |
|
ASOE_MWH |
NUMBER(18,8) |
|
The ASOE MWh value that is used for the Residual Calculation.(Excluding CPID with CF). ASOE MWh is only used for FPP Residual. |
|
RESIDUAL_MWH |
NUMBER(18,8) |
|
Sum of ABS(ACE_MWh) + ASOE_MWh. The MWh is not netted for residual calculation. This is only used for FPP Residual |
|
FPP_ACE_AMOUNT |
NUMBER(18,8) |
|
The FPP ACE Amount calculated using the portion of ACE MWh value against the Total residual MWh of the requirement regions. |
|
FPP_ASOE_AMOUNT |
NUMBER(18,8) |
|
The FPP ASOE Amount calculated using the portion of ASOE MWh value against the Total residual MWh of the requirement regions. |
|
FPP_RESIDUAL_AMOUNT |
NUMBER(18,8) |
|
Sum of FPP_ACE_Amount + FPP_ASOE_Amount |
|
USED_ACE_AMOUNT |
NUMBER(18,8) |
|
The Used Recovery ACE Amount calculated using the ACE MWh value of the requirement regions. |
|
USED_ASOE_AMOUNT |
NUMBER(18,8) |
|
The Used Recovery ASOE Amount is always 0 as FCAS Regulation Residual is calculated using ACE MWh values only. |
|
USED_RESIDUAL_AMOUNT |
NUMBER(18,8) |
|
The Used Residual Amount is Same as Used_ACE_Amount |
|
UNUSED_ACE_AMOUNT |
NUMBER(18,8) |
|
The Unused Recovery ACE Amount calculated using the portion of ACE MWh value against the Total residual MWh of the requirement regions. |
|
UNUSED_ASOE_AMOUNT |
NUMBER(18,8) |
|
The Unused Recovery ASOE Amount is always 0 as as FCAS Regulation Residual is calculated using ACE MWh values only. |
|
UNUSED_RESIDUAL_AMOUNT |
NUMBER(18,8) |
|
The Unused Residual Amount is Same as Unused_ACE_Amount |
|
LASTCHANGED |
DATE |
|
The Last Changed Date time of the record. |
|
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. This column is NULL for Settlement Dates past FPP Rule Effective Date |
|
CRMPF |
NUMBER(18,8) |
|
Constraint Residual Market Participant Factor. This column is NULL for Settlement Dates past FPP Rule Effective Date |
|
RECOVERY_FACTOR_CMPF |
NUMBER(18,8) |
|
Recovery factor for CMPF based recovery. This column is NULL for Settlement Dates past FPP Rule Effective Date |
|
RECOVERY_FACTOR_CRMPF |
NUMBER(18,8) |
|
Recovery factor for CRMPF based recovery. This column is NULL for Settlement Dates past FPP Rule Effective Date. |
|
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 |
|
FPP_AMOUNT |
NUMBER(18,8) |
|
The total FPP Amount from Eligible Units for the Constraint Id |
|
FPP_RESIDUAL_AMOUNT |
NUMBER(18,8) |
|
The total FPP Residual Amount for the Constraint Id |
|
USED_AMOUNT |
NUMBER(18,8) |
|
The total Reg Used Amount from Eligible Units for the Constraint Id |
|
USED_RESIDUAL_AMOUNT |
NUMBER(18,8) |
|
The total Reg Used Residual Amount for the Constraint Id |
|
UNUSED_AMOUNT |
NUMBER(18,8) |
|
The total Reg Unused Amount from Eligible Units for the Constraint Id |
|
UNUSED_RESIDUAL_AMOUNT |
NUMBER(18,8) |
|
The total Reg Unused Residual Amount for the Constraint Id |
|
P_REGULATION |
NUMBER(18,8) |
|
The PRegulation Value from Constraints FCAS Requirement data |
|
TSFCAS |
NUMBER(18,8) |
|
The Adjusted Cost Value from Constraints FCAS Requirement data |
|
RCR |
NUMBER(18,8) |
|
The RCR Value from the FPP Inputs for the Constraint Id used to calculate FPP Amount |
|
USAGE_VALUE |
NUMBER(18,8) |
|
The Usage Value from the FPP Inputs for the Constraint Id used to calculate Used Amount |
|
RCF |
NUMBER(18,8) |
|
The RCF Value from the FPP Inputs for the Constraint Id used to calculate FPP Residual |
|
NRCF |
NUMBER(18,8) |
|
The NRCF Value from the FPP Inputs for the Constraint Id used to calculate Used Residual Amount |
|
DRCF |
NUMBER(18,8) |
|
The DRCF Value from the FPP Inputs for the Constraint Id used to calculate Unused Residual Amount |
|
RESIDUALTOTAL_MWH |
NUMBER(18,8) |
|
The total residual MWh(ABS(ACE_MWh) + ASOE(MWh)) of the requirement regions. |
|
Name |
|
|
Comment |
This report contains the summary of FPP Amounts for each ParticipantId in each region |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
PARTICIPANTID |
|
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 |
|
PARTICIPANTID |
VARCHAR2(20) |
X |
The Participant Id Identifier |
|
REGIONID |
VARCHAR2(20) |
X |
The RegionId used for the residual calculation. This is the Constraint Requirement Region. |
|
PERIODID |
NUMBER(3,0) |
X |
The Period ID Identifier |
|
LOWERREG_AMOUNT |
NUMBER(18,8) |
|
The LowerReg Amount from the Eligible Units. |
|
LOWERREG_ACE_AMOUNT |
NUMBER(18,8) |
|
The LowerReg Amount from the ACE Portion of the Residual amount |
|
LOWERREG_ASOE_AMOUNT |
NUMBER(18,8) |
|
The LowerReg Amount from the ASOE Portion of the Residual amount |
|
LOWERREG_RESIDUAL_AMOUNT |
NUMBER(18,8) |
|
The Lower Reg Residual Amount which is also LowerReg_ACE_Amount + LowerReg_ASOE_Amount |
|
RAISEREG_AMOUNT |
NUMBER(18,8) |
|
The RaiseReg Amount from the Eligible Units. |
|
RAISEREG_ACE_AMOUNT |
NUMBER(18,8) |
|
The RaiseReg Amount from the ACE Portion of the Residual amount |
|
RAISEREG_ASOE_AMOUNT |
NUMBER(18,8) |
|
The RaiseReg Amount from the ASOE Portion of the Residual amount |
|
RAISEREG_RESIDUAL_AMOUNT |
NUMBER(18,8) |
|
The Raise Reg Residual Amount which is also RaiseReg_ACE_Amount + RaiseReg_ASOE_Amount |
|
LASTCHANGED |
DATE |
|
The Last Changed Date time of the record. |
|
Name |
|
|
Comment |
SET_NMAS_RECOVERY sets out the NSCAS recovery data for payments other than testing This Table may also be used for NSCAS and Type 1 transitional services procured by AEMO under the ISF framework during 2025 and prior to the implementation of all system changes. During this time descriptions in these tables may not be correct. |
|
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. This Table may also be used for NSCAS and Type 1 transitional services procured by AEMO under the ISF framework during 2025 and prior to the implementation of all system changes. During this time descriptions in these tables may not be correct. |
|
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 |
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 |
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. This Table may also be used for NSCAS and Type 1 transitional services procured by AEMO under the ISF framework during 2025 and prior to the implementation of all system changes. During this time descriptions in these tables may not be correct. |
|
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. This Table may also be used for NSCAS and Type 1 transitional services procured by AEMO under the ISF framework during 2025 and prior to the implementation of all system changes. During this time descriptions in these tables may not be correct. |
|
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 |
|
|
|