Table: FPP_CONSTRAINT_FREQ_MEASURE

FPP_CONSTRAINT_FREQ_MEASURE

Name

FPP_CONSTRAINT_FREQ_MEASURE

Comment

This report delivers the weighted 4 second frequency measure data for each constraint


Notes

Name

Comment

Value

Visibility

 

Public


Primary Key Columns

Name

CONSTRAINTID

INTERVAL_DATETIME

MEASUREMENT_DATETIME

VERSIONNO


Content

Name

Data Type

Mandatory

Comment

INTERVAL_DATETIME

DATE

X

Date and time of the trading interval (DD/MM/YYYY HH24:MI:SS) fixed to the UTC+10 time zone (NEM time)

MEASUREMENT_DATETIME

DATE

X

Date and time of the SCADA data (DD/MM/YYYY HH24:MI:SS) fixed to the UTC+10 time zone (NEM time)

CONSTRAINTID

VARCHAR2(20)

X

Constraint ID (binding constraint ID from FCAS data used in FPP calculations)

VERSIONNO

NUMBER(5)

X

Version (FPP run number from the FPP database)

BIDTYPE

VARCHAR2(10)

 

Bid type (the bid type saved in relation to constraint ID from FCAS data used in FPP calculations)

FM_RAISE_HZ

NUMBER(18,8)

 

Calculated 4 second Frequency Measure in Hz for that constraint from the FPP database. Frequency Measure data is split across these two raise and lower columns in the following ways: >0 = Allocated to the FM_RAISE_HZ column <0 = Allocated to the FM_LOWER_HZ column 0 = To fill any gaps where the alternative column is not applicable (or no deviation from 50 Hz)

FM_LOWER_HZ

NUMBER(18,8)

 

Calculated 4 second Frequency Measure in Hz for that constraint from the FPP database. Frequency Measure data is split across these two raise and lower columns in the following ways: >0 = Allocated to the FM_RAISE_HZ column <0 = Allocated to the FM_LOWER_HZ column 0 = To fill any gaps where the alternative column is not applicable (or no deviation from 50 Hz)

USED_IN_RCR_FLAG

NUMBER(5)

 

Flag to indicate the result of the Frequency Measure alignment check between Mainland and Tasmania for global constraints. Supported values are: 0 = Not used in RCR calculation as the signs for the frequency measures between Mainland and Tasmania do not align 1 = Used in the RCR calculation as the signs for the frequency measures between Mainland and Tasmania do align in the case of global constraints. For non-global constraints this flag is set to 1

CORRELATION_FLAG

NUMBER(5)

 

Flag to indicate the result of the Frequency Measure correlation check between regions in the same constraint. Supported values are: 0 = Frequency measures in this constraint are not correlated (e.g. system separation between two regions) 1 = Frequency measures in this constraint are correlated


Table: FPP_CONTRIBUTION_FACTOR

FPP_CONTRIBUTION_FACTOR

Name

FPP_CONTRIBUTION_FACTOR

Comment

This report delivers the calculated contribution factor value for each 5 minute trading interval for each constraint and FPP unit


Notes

Name

Comment

Value

Visibility

 

Private & Public Next-Day


Primary Key Columns

Name

CONSTRAINTID

FPP_UNITID

INTERVAL_DATETIME

VERSIONNO


Content

Name

Data Type

Mandatory

Comment

INTERVAL_DATETIME

DATE

X

Date and time of the trading interval (DD/MM/YYYY HH24:MI:SS) fixed to the UTC+10 time zone (NEM time)

CONSTRAINTID

VARCHAR2(20)

X

Constraint ID (binding constraint ID from FCAS data used in FPP calculations)

FPP_UNITID

VARCHAR2(20)

X

FPP Unit ID (registered DUID/ TNI)

VERSIONNO

NUMBER(5)

X

Version (FPP run number from the FPP database)

BIDTYPE

VARCHAR2(10)

 

Bid type (the bid type saved in relation to constraint ID from FCAS data used in FPP calculations)

CONTRIBUTION_FACTOR

NUMBER(18,8)

 

Contribution Factor (the calculated contribution factor for the FPP unit and constraint ID for that trading interval) - for further details please see the FPP procedure document

NEGATIVE_CONTRIBUTION_FACTOR

NUMBER(18,8)

 

Negative Contribution Factor (the calculated negative contribution factor for the FPP unit and constraint ID for that trading interval) - for further details please see the FPP procedure document

DEFAULT_CONTRIBUTION_FACTOR

NUMBER(18,8)

 

The Default Contribution Factor (the calculated default contribution factor based on historical performance for the FPP unit and constraint ID for that trading interval) that is effective for this trading interval, which joins back to FPP_FORECAST_DEFAULT_CF - for further details please see the FPP procedure document

CF_REASON_FLAG

NUMBER(5)

 

The reason flag showing the decision matrix for the contribution factor (CF) Supported values are: 0 = CF is calculated based on good input data 1 = CF is 0 because it is not primary in the group 2 = CF is not for the DUID but for the whole group 4 = CF is calculated based on substitute performance 8 = CF is 0 because FM is unreliable. 16 = CF is 0 because more than 50 percent input is bad or not available.

CF_ABS_POSITIVE_PERF_TOTAL

NUMBER(18,8)

 

The sum of absolute positive performance in MWHz for the combination of constraint / bid type (raise or lower). This is used as the denominator in normalising contribution factors (CF) where a units performance is positive. For further details please see the FPP procedure document. >0 = Performance was calculated for the units NULL = Performance for the units was unavailable

CF_ABS_NEGATIVE_PERF_TOTAL

NUMBER(18,8)

 

The sum of absolute negative performance in MWHz for the combination of constraint / bid type (raise or lower). This is used as the denominator in normalising contribution factors (CF) where a units performance is negative. For further details please see the FPP procedure document. >0 = Performance was calculated for the units NULL = Performance for the units was unavailable

NCF_ABS_NEGATIVE_PERF_TOTAL

NUMBER(18,8)

 

The sum of absolute negative performance in MWHz for the combination of constraint / bid type (raise or lower). This is used as the denominator in normalising negative contribution factors (NCF). For further details please see the FPP procedure document. >0 = Performance was calculated for the units NULL = Performance for the units was unavailable 0 = When NCF is zero (i.e. CF is positive), then this total will be represented as zero

PARTICIPANTID

VARCHAR2(20)

 

Participant ID

SETTLEMENTS_UNITID

VARCHAR2(20)

 

The Settlements Unit ID (registered DUID / TNI) Note that this SETTLEMENTS_UNITID is what is sent and used by the Settlements system, and may be different from the FPP_UNITID for non- scheduled loads where the FPP_UNITID may be a descriptive key, whereas what will be sent to Settlements as the SETTLEMENTS_UNITID will be the TNI code.


Table: FPP_EST_COST

FPP_EST_COST

Name

FPP_EST_COST

Comment

This report delivers the estimated cost for each FPP unit for each constraint for each 5 minute trading interval


Notes

Name

Comment

Value

Visibility

 

Private


Primary Key Columns

Name

CONSTRAINTID

FPP_UNITID

INTERVAL_DATETIME

VERSIONNO


Content

Name

Data Type

Mandatory

Comment

INTERVAL_DATETIME

DATE

X

Date and time of the trading interval (DD/MM/YYYY HH24:MI:SS) fixed to the UTC+10 time zone (NEM time)

CONSTRAINTID

VARCHAR2(20)

X

Constraint ID (binding constraint ID from FCAS data used in FPP calculations)

FPP_UNITID

VARCHAR2(20)

X

FPP Unit ID (registered DUID / TNI)

VERSIONNO

NUMBER(10)

X

The version number. In most cases this version will be the FPP run number from the FPP database, however there are some cases (like a new pricing run of the constraint FCAS processor received by the FPP system) where the version number listed here will be the financial estimate run number from the FPP database (this number is a different sequence from the FPP run number because there is no recalculation of performance or contribution, just changes to pricing / p regulation hence only the financial estimation is performed).

BIDTYPE

VARCHAR2(10)

 

Bid type (the bid type saved in relation to constraint ID from FCAS data used in FPP calculations)

RELEVANT_REGIONS

VARCHAR2(200)

 

Relevant regions (a comma separated list of the relevant regions for the constraint from FCAS data)

FPP

NUMBER(18,8)

 

FPP in AUD (the financial estimate of frequency performance payment calculated for the constraint / bid type / unit). This value can be either positive (credit) or negative (debit). For details on the calculation, please see FPP procedure and supporting documentation.

USED_FCAS

NUMBER(18,8)

 

Used recovery FCAS in AUD (the financial estimate of the recovery of used FCAS calculated for the constraint / bid type / unit). This value will be either 0 (nil), or a negative value (debit) only. For details on the calculation, please see FPP procedure and supporting documentation.

UNUSED_FCAS

NUMBER(18,8)

 

Unused recovery FCAS in AUD (the financial estimate of the recovery of unused FCAS calculated for the constraint / bid type / unit). This value will be either 0 (nil), or a negative value (debit) only. For details on the calculation, please see FPP procedure and supporting documentation.

PARTICIPANTID

VARCHAR2(20)

 

Participant ID


Table: FPP_EST_PERF_COST_RATE

FPP_EST_PERF_COST_RATE

Name

FPP_EST_PERF_COST_RATE

Comment

This report delivers the estimated performance cost rate for each constraint for each 5 minute trading interval


Notes

Name

Comment

Value

Visibility

 

Public


Primary Key Columns

Name

CONSTRAINTID

INTERVAL_DATETIME

VERSIONNO


Content

Name

Data Type

Mandatory

Comment

INTERVAL_DATETIME

DATE

X

Date and time of the trading interval (DD/MM/YYYY HH24:MI:SS) fixed to the UTC+10 time zone (NEM time)

CONSTRAINTID

VARCHAR2(20)

X

Constraint ID (binding constraint ID from FCAS data used in FPP calculations)

VERSIONNO

NUMBER(10)

X

The version number. In most cases this version will be the FPP run number from the FPP database, however there are some cases (like a new pricing run of the constraint FCAS processor received by the FPP system) where the version number listed here will be the financial estimate run number from the FPP database (this number is a different sequence from the FPP run number because there is no recalculation of performance or contribution, just changes to pricing / p regulation hence only the financial estimation is performed).

BIDTYPE

VARCHAR2(10)

 

Bid type (the bid type saved in relation to constraint ID from FCAS data used in FPP calculations)

RELEVANT_REGIONS

VARCHAR2(200)

 

Relevant regions (a comma separated list of the relevant regions for the constraint from FCAS data)

FPP_PAYMENT_RATE

NUMBER(18,8)

 

The payment rate for FPP in AUD / MWHz (the denominator used is the sum of positive performance for the constraint calculated by contribution factor calculation). This value will be either 0 (nil), or a positive value (credit) only. For details on the calculation, please see FPP procedure and supporting documentation.

FPP_RECOVERY_RATE

NUMBER(18,8)

 

The recovery rate for FPP in AUD / MWHz (the denominator used is the absolute sum of negative performance for the constraint calculated by the contribution factor calculation). This value will be either 0 (nil), or a negative value (debit) only. For details on the calculation, please see FPP procedure and supporting documentation.

USED_FCAS_RATE

NUMBER(18,8)

 

The rate for used FCAS in AUD / MWHz (the denominator used is the absolute sum of negative performance for the constraint calculated by the negative contribution factor calculation). This value will be either 0 (nil), or a negative value (debit) only. For details on the calculation, please see FPP procedure and supporting documentation.

UNUSED_FCAS_RATE

NUMBER(18,8)

 

The rate for unused FCAS in AUD / MWHz (the denominator used is the absolute sum of negative performance for the constraint calculated by the default contribution factor calculation). This value will be either 0 (nil), or a negative value (debit) only. For details on the calculation, please see FPP procedure and supporting documentation.


Table: FPP_EST_RESIDUAL_COST_RATE

FPP_EST_RESIDUAL_COST_RATE

Name

FPP_EST_RESIDUAL_COST_RATE

Comment

This report delivers the estimated residual cost rate for each constraint for each 5 minute trading interval


Notes

Name

Comment

Value

Visibility

 

Public


Primary Key Columns

Name

CONSTRAINTID

INTERVAL_DATETIME

VERSIONNO


Content

Name

Data Type

Mandatory

Comment

INTERVAL_DATETIME

DATE

X

Date and time of the trading interval (DD/MM/YYYY HH24:MI:SS) fixed to the UTC+10 time zone (NEM time)

CONSTRAINTID

VARCHAR2(20)

X

Constraint ID (binding constraint ID from FCAS data used in FPP calculations)

VERSIONNO

NUMBER(10)

X

The version number. In most cases this version will be the FPP run number from the FPP database, however there are some cases (like a new pricing run of the constraint FCAS processor received by the FPP system) where the version number listed here will be the financial estimate run number from the FPP database (this number is a different sequence from the FPP run number because there is no recalculation of performance or contribution, just changes to pricing / p regulation hence only the financial estimation is performed).

BIDTYPE

VARCHAR2(10)

 

Bid type (the bid type saved in relation to constraint ID from FCAS data used in FPP calculations)

RELEVANT_REGIONS

VARCHAR2(200)

 

Relevant regions (a comma separated list of the relevant regions for the constraint from FCAS data)

FPP

NUMBER(18,8)

 

FPP in AUD/MWh (the financial estimate of frequency performance payment calculated). This value can be either positive (credit) or negative (debit). For details on the calculation, please see FPP procedure and supporting documentation.

USED_FCAS

NUMBER(18,8)

 

Used recovery FCAS in AUD/MWh (the financial estimate of the recovery of used FCAS calculated). This value will be either 0 (nil), or a negative value (debit) only. For details on the calculation, please see FPP procedure and supporting documentation.

UNUSED_FCAS

NUMBER(18,8)

 

Unused recovery FCAS in AUD/MWh (the financial estimate of the recovery of unused FCAS calculated). This value will be either 0 (nil), or a negative value (debit) only. For details on the calculation, please see FPP procedure and supporting documentation.


Table: FPP_FCAS_SUMMARY

FPP_FCAS_SUMMARY

Name

FPP_FCAS_SUMMARY

Comment

This report delivers a summary of FCAS requirements as used by the FPP calculation (i.e. only RAISEREG / LOWERREG bid types)


Notes

Name

Comment

Value

Visibility

 

Public


Primary Key Columns

Name

CONSTRAINTID

INTERVAL_DATETIME

RUN_DATETIME

RUNNO

VERSIONNO


Content

Name

Data Type

Mandatory

Comment

RUN_DATETIME

DATE

X

The run date and time of the dispatch case that was the trigger for the constraint FCAS processor execution

RUNNO

NUMBER(5)

X

The dispatch case run number that was the trigger for the constraint FCAS processor execution

INTERVAL_DATETIME

DATE

X

Date and time of the trading interval (DD/MM/YYYY HH24:MI:SS) fixed to the UTC+10 time zone (NEM time)

CONSTRAINTID

VARCHAR2(20)

X

Constraint ID (binding constraint ID from FCAS data used in FPP calculations)

VERSIONNO

NUMBER(10)

X

The version number. In most cases this version will be the FPP run number from the FPP database, however there are some cases (like a new pricing run of the constraint FCAS processor received by the FPP system) where the version number listed here will be the financial estimate run number from the FPP database (this number is a different sequence from the FPP run number because there is no recalculation of performance or contribution, just changes to pricing / p regulation hence only the financial estimation is performed).

BIDTYPE

VARCHAR2(10)

 

Bid type (the bid type saved in relation to constraint ID from FCAS data used in FPP calculations, i.e. RAISEREG or LOWERREG)

RELEVANT_REGIONS

VARCHAR2(200)

 

Relevant regions (a comma separated list of the relevant regions for the constraint from FCAS data)

REGULATION_MW

NUMBER(18,8)

 

Enabled regulation MW used in the FPP calculation (from FPP database)

CONSTRAINT_MARGINAL_VALUE

NUMBER(18,8)

 

Marginal value in AUD/MW per hour related to the constraint (from FCAS data used for FPP calculations)

P_REGULATION

NUMBER(18,8)

 

P regulation value in AUD/MW per hour related to the constraint (from FCAS data used for FPP calculations also known as adjusted marginal value)

BASE_COST

NUMBER(18,8)

 

Base cost in AUD related to the constraint (from FCAS data used for FPP calculations)

TSFCAS

NUMBER(18,8)

 

TSFCAS in AUD related to the constraint (FCAS recovery amount related to the constraint also known as adjusted cost)

TOTAL_FPP

NUMBER(18,8)

 

Total amount of FPP in AUD changing hands related to the constraint (note that this is not the sum of FPP)

RCR

NUMBER(18,5)

 

RCR MW (the calculated requirement for corrective response from FPP database). Note that this is a join back to the FPP_RCR table.

USAGE

NUMBER(18,8)

 

Usage (calculation of the proportion of regulation FCAS that was calculated to be used). Note that this is a join back to the FPP_USAGE table.


Table: FPP_FORECAST_DEFAULT_CF

FPP_FORECAST_DEFAULT_CF

Name

FPP_FORECAST_DEFAULT_CF

Comment

This report delivers the forecast default contribution factors (DCF) effective for a billing period (aligned to the settlement week)


Notes

Name

Comment

Value

Visibility

 

Public


Primary Key Columns

Name

CONSTRAINTID

EFFECTIVE_END_DATETIME

EFFECTIVE_START_DATETIME

FPP_UNITID

VERSIONNO


Content

Name

Data Type

Mandatory

Comment

FPP_UNITID

VARCHAR2(20)

X

FPP Unit ID (registered DUID/ TNI)

CONSTRAINTID

VARCHAR2(20)

X

Constraint ID (binding constraint ID from FCAS data used in FPP calculations)

EFFECTIVE_START_DATETIME

DATE

X

Effective period start date and time (DD/MM/YYYY HH24:MI:SS) fixed to the UTC+10 time zone (NEM time) of the effective period for this default contribution factor related to the combination of FPP unit ID / constraint. This is the billing period over which these default contribution factors will be effective / applied. In most cases this will align to the settlement week, however there are some cases (like a new constraint) where the effective start date will be prorated to align with the change.

EFFECTIVE_END_DATETIME

DATE

X

Effective period end date and time (DD/MM/YYYY HH24:MI:SS) fixed to the UTC+10 time zone (NEM time) of the effective period for this default contribution factor related to the combination of FPP unit ID / constraint. This is the billing period over which these default contribution factors will be effective / applied. Effective end date will align with the end of a settlement week.

VERSIONNO

NUMBER(10)

X

The version number. In most cases this version will be the historical performance calculation run number from the FPP database (which is different from the FPP run number), however there are some cases (like a new constraint) where the version number listed here will be the FPP run number from the FPP database (this will be where the effective start date time will be prorated to align with the detection of this change).

BIDTYPE

VARCHAR2(10)

 

Bid type (the bid type saved in relation to constraint ID from FCAS data used in FPP calculations)

REGIONID

VARCHAR2(20)

 

Region ID of the frequency deviation / frequency measure

DEFAULT_CONTRIBUTION_FACTOR

NUMBER(18,8)

 

Calculated default contribution factor from the historical performance period. For further details please see the FPP procedure document.

DCF_REASON_FLAG

NUMBER(5)

 

The reason flag showing the decision matrix for the default contribution factor (DCF)

DCF_ABS_NEGATIVE_PERF_TOTAL

NUMBER(18,8)

 

The sum of absolute negative performance in MWHz for the combination of constraint (raise or lower). This is used as the denominator in normalising default contribution factors (DCF) as the historical performance is always negative for DCF. For further details please see the FPP procedure document. >0 = Performance was calculated for the units NULL = Performance for the units was unavailable

SETTLEMENTS_UNITID

VARCHAR2(20)

 

The Settlements Unit ID (registered DUID / TNI) Note that this SETTLEMENTS_UNITID is what is sent and used by the Settlements system, and may be different from the FPP_UNITID for non- scheduled loads where the FPP_UNITID may be a descriptive key, whereas what will be sent to Settlements as the SETTLEMENTS_UNITID will be the TNI code.


Table: FPP_FORECAST_RESIDUAL_DCF

FPP_FORECAST_RESIDUAL_DCF

Name

FPP_FORECAST_RESIDUAL_DCF

Comment

This report delivers the forecast residual default contribution factors (DCF) effective for a billing period (aligned to the settlement week)


Notes

Name

Comment

Value

Visibility

 

Public


Primary Key Columns

Name

CONSTRAINTID

EFFECTIVE_END_DATETIME

EFFECTIVE_START_DATETIME

VERSIONNO


Content

Name

Data Type

Mandatory

Comment

CONSTRAINTID

VARCHAR2(20)

X

Constraint ID (binding constraint ID from FCAS data used in FPP calculations)

EFFECTIVE_START_DATETIME

DATE

X

Effective period start date and time (DD/MM/YYYY HH24:MI:SS) fixed to the UTC+10 time zone (NEM time) of the effective period for this residual default contribution factor related to the constraint. This is the billing period over which these default contribution factors will be effective / applied. In most cases this will align to the settlement week, however there are some cases (like a new constraint) where the effective start date will be prorated to align with the change.

EFFECTIVE_END_DATETIME

DATE

X

Effective period end date and time (DD/MM/YYYY HH24:MI:SS) fixed to the UTC+10 time zone (NEM time) of the effective period for this residual default contribution factor related to the constraint. This is the billing period over which these default contribution factors will be effective / applied. Effective end date will align with the end of a settlement week.

VERSIONNO

NUMBER(10)

X

The version number. In most cases this version will be the historical performance calculation run number from the FPP database (which is different from the FPP run number), however there are some cases (like a new constraint) where the version number listed here will be the FPP run number from the FPP database (this will be where the effective start date time will be prorated to align with the detection of this change).

BIDTYPE

VARCHAR2(10)

 

Bid type (the bid type saved in relation to constraint ID from FCAS data used in FPP calculations)

RESIDUAL_DCF

NUMBER(18,8)

 

Calculated residual default contribution factor from the historical performance period. For further details please see the FPP procedure document.

RESIDUAL_DCF_REASON_FLAG

NUMBER(5)

 

The reason flag showing the decision matrix for the residual default contribution factor (DCF)

DCF_ABS_NEGATIVE_PERF_TOTAL

NUMBER(18,8)

 

The sum of absolute negative performance in MWHz for the combination of constraint (raise or lower). This is used as the denominator in normalising default contribution factors (DCF). For further details please see the FPP procedure document. >0 = Performance was calculated for the units NULL = Performance for the units was unavailable


Table: FPP_HIST_PERFORMANCE

FPP_HIST_PERFORMANCE

Name

FPP_HIST_PERFORMANCE

Comment

This report delivers the historical performance calculated based on a historical period and effective for a billing period (aligned to the settlement week)


Notes

Name

Comment

Value

Visibility

 

Public


Primary Key Columns

Name

EFFECTIVE_END_DATETIME

EFFECTIVE_START_DATETIME

FPP_UNITID

VERSIONNO


Content

Name

Data Type

Mandatory

Comment

FPP_UNITID

VARCHAR2(20)

X

FPP Unit ID (registered DUID/ TNI)

EFFECTIVE_START_DATETIME

DATE

X

Effective period start date and time (DD/MM/YYYY HH24:MI:SS) fixed to the UTC+10 time zone (NEM time) of the effective period for this historical performance values related to the FPP unit ID. This is the billing period over which these historical performance values will be effective / applied over. This will align to the settlement week.

EFFECTIVE_END_DATETIME

DATE

X

Effective period end date and time (DD/MM/YYYY HH24:MI:SS) fixed to the UTC+10 time zone (NEM time) of the effective period for this historical performance values related to the FPP unit ID. This is the billing period over which these historical performance values will be effective / applied over. This will align to the settlement week.

VERSIONNO

NUMBER(10)

X

Version (FPP historical performance calculation run number from the FPP database) Note that due to the these historical calculations, the version numbers listed here are different to the normal FPP run number version for trading interval calculations.

HIST_PERIOD_START_DATETIME

DATE

 

Historical period start date and time (DD/MM/YYYY HH24:MI:SS) fixed to the UTC+10 time zone (NEM time) of the historical period for this historical performance calculation related to the FPP unit ID. This is the historical period of trading intervals that feed into the historical performance calculation. This will align to the settlement week.

HIST_PERIOD_END_DATETIME

DATE

 

Historical period end date and time (DD/MM/YYYY HH24:MI:SS) fixed to the UTC+10 time zone (NEM time) of the historical period for this historical performance calculation related to the FPP unit ID. This is the historical period of trading intervals that feed into the historical performance calculation. This will align to the settlement week.

REG_HIST_RAISE_PERFORMANCE

NUMBER(18,5)

 

Calculated regulation historical raise performance from the historical performance period (substitute raise performance when live performance is unavailable and default raise performance used for default contribution factor calculation) - please see the NER and FPP procedure documents for further information

REG_HIST_LOWER_PERFORMANCE

NUMBER(18,5)

 

Calculated regulation historical lower performance from the historical performance period (substitute lower performance when live performance is unavailable and default lower performance used for default contribution factor calculation) - please see the NER and FPP procedure documents for further information

FPP_HIST_RAISE_PERFORMANCE

NUMBER(18,5)

 

Calculated FPP historical raise performance from the historical performance period (substitute raise performance calculated used for negative contribution factor calculation when live performance is unavailable) - please see the NER and FPP procedure documents for further information

FPP_HIST_LOWER_PERFORMANCE

NUMBER(18,5)

 

Calculated FPP historical lower performance from the historical performance period (substitute lower performance calculated used for negative contribution factor calculation when live performance is unavailable) - please see the NER and FPP procedure documents for further information


Table: FPP_P5_FWD_EST_COST

FPP_P5_FWD_EST_COST

Name

FPP_P5_FWD_EST_COST

Comment

This report delivers the forward estimated unit cost based on P5min runs. These high-level estimates (i.e. assuming that all is unused FCAS) will be provided for each constraint for each 5 minute pre-dispatch interval.


Notes

Name

Comment

Value

Visibility

 

Private


Primary Key Columns

Name

CONSTRAINTID

FPP_UNITID

INTERVAL_DATETIME

RUN_DATETIME

RUNNO

VERSIONNO


Content

Name

Data Type

Mandatory

Comment

RUN_DATETIME

DATE

X

The run date and time of the 5 minute predispatch case that was the trigger for the constraint FCAS processor execution (as the FCAS requirement data is the basis of these forward estimates)

RUNNO

NUMBER(5)

X

The 5 minute predispatch case run number that was the trigger for the constraint FCAS processor execution (as the FCAS requirement data is the basis for these forward estimates)

INTERVAL_DATETIME

DATE

X

Date and time of the trading interval (DD/MM/YYYY HH24:MI:SS) fixed to the UTC+10 time zone (NEM time)

CONSTRAINTID

VARCHAR2(20)

X

Constraint ID (binding constraint ID from FCAS data used in FPP calculations)

FPP_UNITID

VARCHAR2(20)

X

FPP Unit ID (registered DUID / TNI)

VERSIONNO

NUMBER(5)

X

The version number of the effective default contribution factor for the unit / constraint combination taken from the FPP_FORECAST_DEFAULT_CF table

BIDTYPE

VARCHAR2(10)

 

Bid type (the bid type saved in relation to constraint ID from FCAS data used in FPP calculations)

RELEVANT_REGIONS

VARCHAR2(200)

 

Relevant regions (a comma separated list of the relevant regions for the constraint from FCAS data)

EST_UNUSED_FCAS

NUMBER(18,8)

 

Estimated unused recovery FCAS in AUD (the forward financial estimate of the recovery of unused FCAS, assuming that all is unused FCAS). This value will be either 0 (nil), or a negative value (debit) only. For details on the calculation, please see FPP procedure and supporting documentation.

PARTICIPANTID

VARCHAR2(20)

 

Participant ID


Table: FPP_P5_FWD_EST_RESIDUALRATE

FPP_P5_FWD_EST_RESIDUALRATE

Name

FPP_P5_FWD_EST_RESIDUALRATE

Comment

This report delivers the forward estimated residual cost rate based on P5min runs. These high-level estimates (i.e. assuming that all is unused FCAS) will be provided for each constraint for each 5 minute pre-dispatch interval.


Notes

Name

Comment

Value

Visibility

 

Public


Primary Key Columns

Name

CONSTRAINTID

INTERVAL_DATETIME

RUN_DATETIME

RUNNO

VERSIONNO


Content

Name

Data Type

Mandatory

Comment

RUN_DATETIME

DATE

X

The run date and time of the 5 minute predispatch case that was the trigger for the constraint FCAS processor execution (as the FCAS requirement data is the basis of these forward estimates)

RUNNO

NUMBER(5)

X

The 5 minute predispatch case run number that was the trigger for the constraint FCAS processor execution (as the FCAS requirement data is the basis for these forward estimates)

INTERVAL_DATETIME

DATE

X

Date and time of the trading interval (DD/MM/YYYY HH24:MI:SS) fixed to the UTC+10 time zone (NEM time)

CONSTRAINTID

VARCHAR2(20)

X

Constraint ID (binding constraint ID from FCAS data used in FPP calculations)

VERSIONNO

NUMBER(5)

X

The version number of the effective default contribution factor for the unit / constraint combination taken from the FPP_FORECAST_DEFAULT_CF table

BIDTYPE

VARCHAR2(10)

 

Bid type (the bid type saved in relation to constraint ID from FCAS data used in FPP calculations)

RELEVANT_REGIONS

VARCHAR2(200)

 

Relevant regions (a comma separated list of the relevant regions for the constraint from FCAS data)

EST_UNUSED_FCAS

NUMBER(18,8)

 

Estimated unused recovery FCAS in AUD/MWh (the forward financial estimate of the recovery of unused FCAS, assuming that all is unused FCAS). This value will be either 0 (nil), or a negative value (debit) only. For details on the calculation, please see FPP procedure and supporting documentation.


Table: FPP_PD_FWD_EST_COST

FPP_PD_FWD_EST_COST

Name

FPP_PD_FWD_EST_COST

Comment

This report delivers the forward estimated unit cost based on PREDISPATCH runs. These high-level estimates (i.e. assuming that all is unused FCAS) will be provided for each constraint for each 30 minute pre-dispatch interval.


Notes

Name

Comment

Value

Visibility

 

Private


Primary Key Columns

Name

CONSTRAINTID

FPP_UNITID

INTERVAL_DATETIME

PREDISPATCHSEQNO

RUN_DATETIME

RUNNO

VERSIONNO


Content

Name

Data Type

Mandatory

Comment

PREDISPATCHSEQNO

VARCHAR2(20)

X

Predispatch sequence number for the 30 minute predispatch case that triggers the constraint FCAS processor run

RUN_DATETIME

DATE

X

The run date and time of the 30 minute predispatch case that was the trigger for the constraint FCAS processor execution (as the FCAS requirement data is the basis of these forward estimates)

RUNNO

NUMBER(5)

X

The 30 minute predispatch case run number that was the trigger for the constraint FCAS processor execution (as the FCAS requirement data is the basis for these forward estimates)

INTERVAL_DATETIME

DATE

X

Date and time of the 30 minute predispatch interval (DD/MM/YYYY HH24:MI:SS) fixed to the UTC+10 time zone (NEM time)

CONSTRAINTID

VARCHAR2(20)

X

Constraint ID (binding constraint ID from FCAS data used in FPP calculations)

FPP_UNITID

VARCHAR2(20)

X

FPP Unit ID (registered DUID / TNI)

VERSIONNO

NUMBER(5)

X

The version number of the effective default contribution factor for the unit / constraint combination taken from the FPP_FORECAST_DEFAULT_CF table

BIDTYPE

VARCHAR2(10)

 

Bid type (the bid type saved in relation to constraint ID from FCAS data used in FPP calculations)

RELEVANT_REGIONS

VARCHAR2(200)

 

Relevant regions (a comma separated list of the relevant regions for the constraint from FCAS data)

EST_UNUSED_FCAS

NUMBER(18,8)

 

Estimated unused recovery FCAS in AUD (the forward financial estimate of the recovery of unused FCAS, assuming that all is unused FCAS). This value will be either 0 (nil), or a negative value (debit) only. For details on the calculation, please see FPP procedure and supporting documentation.

PARTICIPANTID

VARCHAR2(20)

 

Participant ID


Table: FPP_PD_FWD_EST_RESIDUALRATE

FPP_PD_FWD_EST_RESIDUALRATE

Name

FPP_PD_FWD_EST_RESIDUALRATE

Comment

This report delivers the forward estimated residual cost rate based on PREDISPATCH runs. These high-level estimates (i.e. assuming that all is unused FCAS) will be provided for each constraint for each 30 minute pre- dispatch interval.


Notes

Name

Comment

Value

Visibility

 

Public


Primary Key Columns

Name

CONSTRAINTID

INTERVAL_DATETIME

PREDISPATCHSEQNO

RUN_DATETIME

RUNNO

VERSIONNO


Content

Name

Data Type

Mandatory

Comment

PREDISPATCHSEQNO

VARCHAR2(20)

X

Predispatch sequence number for the 30 minute predispatch case that triggers the constraint FCAS processor run

RUN_DATETIME

DATE

X

The run date and time of the 30 minute predispatch case that was the trigger for the constraint FCAS processor execution (as the FCAS requirement data is the basis of these forward estimates)

RUNNO

NUMBER(5)

X

The 30 minute predispatch case run number that was the trigger for the constraint FCAS processor execution (as the FCAS requirement data is the basis for these forward estimates)

INTERVAL_DATETIME

DATE

X

Date and time of the 30 minute predispatch interval (DD/MM/YYYY HH24:MI:SS) fixed to the UTC+10 time zone (NEM time)

CONSTRAINTID

VARCHAR2(20)

X

Constraint ID (binding constraint ID from FCAS data used in FPP calculations)

VERSIONNO

NUMBER(5)

X

The version number of the effective default contribution factor for the unit / constraint combination taken from the FPP_FORECAST_DEFAULT_CF table

BIDTYPE

VARCHAR2(10)

 

Bid type (the bid type saved in relation to constraint ID from FCAS data used in FPP calculations)

RELEVANT_REGIONS

VARCHAR2(200)

 

Relevant regions (a comma separated list of the relevant regions for the constraint from FCAS data)

EST_UNUSED_FCAS

NUMBER(18,8)

 

Estimated unused recovery FCAS in AUD/MWh (the forward financial estimate of the recovery of unused FCAS, assuming that all is unused FCAS). This value will be either 0 (nil), or a negative value (debit) only. For details on the calculation, please see FPP procedure and supporting documentation.


Table: FPP_PERFORMANCE

FPP_PERFORMANCE

Name

FPP_PERFORMANCE

Comment

This report delivers the calculated performance value for each 5 minute trading interval for each FPP unit


Notes

Name

Comment

Value

Visibility

 

Private & Public Next-Day


Primary Key Columns

Name

FPP_UNITID

INTERVAL_DATETIME

VERSIONNO


Content

Name

Data Type

Mandatory

Comment

INTERVAL_DATETIME

DATE

X

Date and time of the trading interval (DD/MM/YYYY HH24:MI:SS) fixed to the UTC+10 time zone (NEM time)

FPP_UNITID

VARCHAR2(20)

X

FPP Unit ID (registered DUID/ TNI)

VERSIONNO

NUMBER(5)

X

Version (FPP run number from the FPP database)

RAISE_PERFORMANCE

NUMBER(18,5)

 

Raise performance value in MWHz units (calculated by FPP for that trading interval taken from FPP database)

RAISE_REASON_FLAG

NUMBER(5)

 

The reason flag showing the decision matrix for the raise performance value Supported values are: 0 = Performance is calculated based on good input data 1 = Performance is Null as unit is a Non Primary DUID in the group 2 = Performance against the Primary DUID representing the group 4 = Performance is Null as Input data is bad or unavailable 8 = Performance is Null as FM is unreliable 12 = Performance is Null as Input data is bad or unavailable and FM is unreliable 6 = Performance against the Primary DUID representing the group is Null as Input data is bad or unavailable 10 = Performance against the Primary DUID representing the group is Null as FM is unreliable 14 = Performance against the Primary DUID representing the group is Null as Input data is bad or unavailable and FM is unreliable

LOWER_PERFORMANCE

NUMBER(18,5)

 

Lower performance value in MWHz units (calculated by FPP for that trading interval taken from FPP database)

LOWER_REASON_FLAG

NUMBER(5)

 

The reason flag showing the decision matrix for the lower performance value Supported values are: 0 = Performance is calculated based on good input data 1 = Performance is Null as unit is a Non Primary DUID in the group 2 = Performance against the Primary DUID representing the group 4 = Performance is Null as Input data is bad or unavailable 8 = Performance is Null as FM is unreliable 12 = Performance is Null as Input data is bad or unavailable and FM is unreliable 6 = Performance against the Primary DUID representing the group is Null as Input data is bad or unavailable 10 = Performance against the Primary DUID representing the group is Null as FM is unreliable 14 = Performance against the Primary DUID representing the group is Null as Input data is bad or unavailable and FM is unreliable

PARTICIPANTID

VARCHAR2(20)

 

Participant ID


Table: FPP_RCR

FPP_RCR

Name

FPP_RCR

Comment

This report delivers the calculated RCR for each constraint for each 5 minute trading interval


Notes

Name

Comment

Value

Visibility

 

Public


Primary Key Columns

Name

CONSTRAINTID

INTERVAL_DATETIME

VERSIONNO


Content

Name

Data Type

Mandatory

Comment

INTERVAL_DATETIME

DATE

X

Date and time of the trading interval (DD/MM/YYYY HH24:MI:SS) fixed to the UTC+10 time zone (NEM time)

CONSTRAINTID

VARCHAR2(20)

X

Constraint ID (binding constraint ID from FCAS data used in FPP calculations)

VERSIONNO

NUMBER(5)

X

Version (FPP run number from the FPP database)

BIDTYPE

VARCHAR2(10)

 

Bid type (the bid type saved in relation to constraint ID from FCAS data used in FPP calculations)

RCR

NUMBER(18,5)

 

RCR (the calculated requirement for corrective response from FPP database)

RCR_REASON_FLAG

NUMBER(5)

 

The reason flag showing the decision matrix for the requirement for corrective response (RCR) calculation Supported values are: 0 = RCR is calculated based on good input data 1 = RCR is 0 as FM is unreliable 2 = RCR is 0 as the percentage of units with unavailable input or bad data is greater than the threshold percentage


Table: FPP_REGION_FREQ_MEASURE

FPP_REGION_FREQ_MEASURE

Name

FPP_REGION_FREQ_MEASURE

Comment

This report delivers the curated 4 second frequency deviation and frequency measure data for each region


Notes

Name

Comment

Value

Visibility

 

Public


Primary Key Columns

Name

INTERVAL_DATETIME

MEASUREMENT_DATETIME

REGIONID

VERSIONNO


Content

Name

Data Type

Mandatory

Comment

INTERVAL_DATETIME

DATE

X

Date and time of the trading interval (DD/MM/YYYY HH24:MI:SS) fixed to the UTC+10 time zone (NEM time)

MEASUREMENT_DATETIME

DATE

X

Date and time of the SCADA data (DD/MM/YYYY HH24:MI:SS) fixed to the UTC+10 time zone (NEM time)

REGIONID

VARCHAR2(20)

X

Region ID of the frequency deviation / frequency measure

VERSIONNO

NUMBER(5)

X

Version (FPP run number from the FPP database)

FREQ_DEVIATION_HZ

NUMBER(18,8)

 

Frequency Deviation (4 second frequency deviation in Hz for that region)

HZ_QUALITY_FLAG

NUMBER(5)

 

Frequency Quality (4 second frequency deviation quality for that region) Supported values are: 0 = Bad Quality 1 = Good Quality 2 = Suspect Quality

FREQ_MEASURE_HZ

NUMBER(18,8)

 

Calculated 4 second Frequency Measure for that region from FPP database

FM_ALIGNMENT_FLAG

NUMBER(5)

 

Alignment Flag (4 second frequency deviation is aligned with 4 second frequency measure for that region) Supported values are: 0 = Misaligned 1 = Aligned


Table: FPP_RESIDUAL_CF

FPP_RESIDUAL_CF

Name

FPP_RESIDUAL_CF

Comment

This report delivers the calculated residual contribution factor value for each 5 minute trading interval for each constraint


Notes

Name

Comment

Value

Visibility

 

Public


Primary Key Columns

Name

CONSTRAINTID

INTERVAL_DATETIME

VERSIONNO


Content

Name

Data Type

Mandatory

Comment

INTERVAL_DATETIME

DATE

X

Date and time of the trading interval (DD/MM/YYYY HH24:MI:SS) fixed to the UTC+10 time zone (NEM time)

CONSTRAINTID

VARCHAR2(20)

X

Constraint ID (binding constraint ID from FCAS data used in FPP calculations)

VERSIONNO

NUMBER(5)

X

Version (FPP run number from the FPP database)

BIDTYPE

VARCHAR2(10)

 

Bid type (the bid type saved in relation to constraint ID from FCAS data used in FPP calculations)

RESIDUAL_CF

NUMBER(18,8)

 

Residual Contribution Factor (the calculated residual contribution factor for the constraint ID for that trading interval) - for further details please see the FPP procedure document

NEGATIVE_RESIDUAL_CF

NUMBER(18,8)

 

Negative Residual Contribution Factor (the calculated negative residual contribution factor for the constraint ID for that trading interval) - for further details please see the FPP procedure document

RESIDUAL_DCF

NUMBER(18,8)

 

The Residual Default Contribution Factor (the calculated residual default contribution factor based on historical performance for the constraint ID for that trading interval) that is effective for this trading interval, which joins back to FPP_FORECAST_RESIDUAL_DCF - for further details please see the FPP procedure document

RESIDUAL_CF_REASON_FLAG

NUMBER(5)

 

The reason flag showing the decision matrix for the residual contribution factor (CF) Supported values are: 0 = CF is calculated based on good input data 8 = CF is 0 because FM is unreliable. 16 = CF is 0 because more than 50 percent input is bad or not available.

CF_ABS_POSITIVE_PERF_TOTAL

NUMBER(18,8)

 

The sum of absolute positive performance in MWHz for the combination of constraint / bid type (raise or lower). This is used as the denominator in normalising contribution factors (CF) where a units performance is positive. For further details please see the FPP procedure document. >0 = Performance was calculated for the units NULL = Performance for the units was unavailable

CF_ABS_NEGATIVE_PERF_TOTAL

NUMBER(18,8)

 

The sum of absolute negative performance in MWHz for the combination of constraint / bid type (raise or lower). This is used as the denominator in normalising contribution factors (CF) where a units performance is negative. For further details please see the FPP procedure document. >0 = Performance was calculated for the units NULL = Performance for the units was unavailable

NCF_ABS_NEGATIVE_PERF_TOTAL

NUMBER(18,8)

 

The sum of absolute negative performance in MWHz for the combination of constraint / bid type (raise or lower). This is used as the denominator in normalising negative contribution factors (NCF). For further details please see the FPP procedure document. >0 = Performance was calculated for the units NULL = Performance for the units was unavailable 0 = When NCF is zero (i.e. CF is positive), then this total will be represented as zero


Table: FPP_RESIDUAL_PERFORMANCE

FPP_RESIDUAL_PERFORMANCE

Name

FPP_RESIDUAL_PERFORMANCE

Comment

This report delivers the calculated residual performance value for each 5 minute trading interval


Notes

Name

Comment

Value

Visibility

 

Public


Primary Key Columns

Name

INTERVAL_DATETIME

REGIONID

VERSIONNO


Content

Name

Data Type

Mandatory

Comment

INTERVAL_DATETIME

DATE

X

Date and time of the trading interval (DD/MM/YYYY HH24:MI:SS) fixed to the UTC+10 time zone (NEM time)

REGIONID

VARCHAR2(20)

X

Region ID of the residual performance

VERSIONNO

NUMBER(5)

X

Version (FPP run number from the FPP database)

RAISE_PERFORMANCE

NUMBER(18,5)

 

Raise performance value in MWHz units (calculated by FPP for that trading interval taken from FPP database)

RAISE_REASON_FLAG

NUMBER(5)

 

The reason flag showing the decision matrix for the raise performance value Supported values are: 0 = Performance is calculated based on good input data 4 = Performance is Null as Input data is bad or unavailable 8 = Performance is Null as FM is unreliable 12 = Performance is Null as Input data is bad or unavailable and FM is unreliable

LOWER_PERFORMANCE

NUMBER(18,5)

 

Lower performance value in MWHz units (calculated by FPP for that trading interval taken from FPP database)

LOWER_REASON_FLAG

NUMBER(5)

 

The reason flag showing the decision matrix for the lower performance value Supported values are: 0 = Performance is calculated based on good input data 4 = Performance is Null as Input data is bad or unavailable 8 = Performance is Null as FM is unreliable 12 = Performance is Null as Input data is bad or unavailable and FM is unreliable


Table: FPP_RUN

FPP_RUN

Name

FPP_RUN

Comment

This report delivers details of the 5-minute FPP calculation engine success failure outcome saved in FPP database


Notes

Name

Comment

Value

Visibility

 

Public


Primary Key Columns

Name

INTERVAL_DATETIME

VERSIONNO


Content

Name

Data Type

Mandatory

Comment

INTERVAL_DATETIME

DATE

X

Date and time of the trading interval (DD/MM/YYYY HH24:MI:SS) fixed to the UTC+10 time zone (NEM time)

VERSIONNO

NUMBER(5)

X

Version (FPP run number from the FPP database)

FPPRUN_DATETIME

DATE

 

Completion time of the FPP calculation run (DD/MM/YYYY HH24:MI:SS) fixed to the UTC+10 time zone (NEM time)

RUN_STATUS

VARCHAR2(20)

 

Date and time of the trading interval (DD/MM/YYYY HH24:MI:SS) fixed to the UTC+10 time zone (NEM time)

AUTHORISED_DATETIME

DATE

 

Date and time of the authorisation of this FPP calculation run (DD/MM/YYYY HH24:MI:SS) fixed to the UTC+10 time zone (NEM time) - Note may be delayed in cases of ex-post calculation runs


Table: FPP_UNIT_MW

FPP_UNIT_MW

Name

FPP_UNIT_MW

Comment

This report delivers the curated 4 second measurement MW data for each FPP unit


Notes

Name

Comment

Value

Visibility

 

Private & Public Next-Day


Primary Key Columns

Name

FPP_UNITID

INTERVAL_DATETIME

MEASUREMENT_DATETIME

VERSIONNO


Content

Name

Data Type

Mandatory

Comment

INTERVAL_DATETIME

DATE

X

Date and time of the trading interval (DD/MM/YYYY HH24:MI:SS) fixed to the UTC+10 time zone (NEM time)

MEASUREMENT_DATETIME

DATE

X

Date and time of the SCADA data (DD/MM/YYYY HH24:MI:SS) fixed to the UTC+10 time zone (NEM time)

FPP_UNITID

VARCHAR2(20)

X

FPP Unit ID (registered DUID/TNI)

VERSIONNO

NUMBER(5)

X

Version (FPP run number from the FPP database)

MEASURED_MW

NUMBER(18,8)

 

Measured MW (4 second SCADA measurement in MW)

MW_QUALITY_FLAG

NUMBER(5)

 

MW Quality (4 second SCADA measurement Quality) Supported values are: 0 = Bad Quality 1 = Good Quality 2 = Suspect Quality

SCHEDULED_MW

NUMBER(18,5)

 

Scheduled MW (reference trajectory value from FPP calculation process)

DEVIATION_MW

NUMBER(18,5)

 

Unit Deviation (output of the FPP calculation process)

PARTICIPANTID

VARCHAR2(20)

 

Participant ID


Table: FPP_USAGE

FPP_USAGE

Name

FPP_USAGE

Comment

This report delivers the calculated usage for each constraint for each 5 minute trading interval


Notes

Name

Comment

Value

Visibility

 

Public


Primary Key Columns

Name

CONSTRAINTID

INTERVAL_DATETIME

VERSIONNO


Content

Name

Data Type

Mandatory

Comment

INTERVAL_DATETIME

DATE

X

Date and time of the trading interval (DD/MM/YYYY HH24:MI:SS) fixed to the UTC+10 time zone (NEM time)

CONSTRAINTID

VARCHAR2(20)

X

Constraint ID (binding constraint ID from FCAS data used in FPP calculations)

VERSIONNO

NUMBER(5)

X

Version (FPP run number from the FPP database)

BIDTYPE

VARCHAR2(10)

 

Bid type (the bid type saved in relation to constraint ID from FCAS data used in FPP calculations)

REGULATION_MW

NUMBER(18,8)

 

Enabled regulation MW used in the FPP calculation (from FPP database)

USED_MW

NUMBER(18,8)

 

Maximum used regulation MW value (quantity of regulation FCAS that was calculated to be used in MW)

USAGE

NUMBER(18,8)

 

Usage (calculation of the proportion of regulation FCAS that was calculated to be used)

USAGE_REASON_FLAG

NUMBER(5)

 

The reason flag showing the decision matrix for the requirement for corrective response (RCR) calculation Supported values are: 0 = Usage is calculated based on good input data 1 = Usage is 0 as FM is unreliable 2 = Usage is 0 as the percentage of units with unavailable input or bad data is greater than the threshold percentage