| INTERVAL_DATETIME |
datetime(3)  |
datetime2(0) |
Date and time of the trading interval (DD/MM/YYYY HH24:MI:SS) fixed to the UTC+10 time zone (NEM time) |
| CONSTRAINTID |
varchar(20) |
varchar(20) |
Constraint ID (binding constraint ID from FCAS data used in FPP calculations) |
| FPP_UNITID |
varchar(20) |
varchar(20) |
FPP Unit ID (registered DUID/ TNI) |
| VERSIONNO |
numeric(5, 0) |
smallint |
Version (FPP run number from the FPP database) |
| BIDTYPE |
varchar(10) |
varchar(10) |
Bid type (the bid type saved in relation to constraint ID from FCAS data used in FPP calculations) |
| CONTRIBUTION_FACTOR |
numeric(18, 8) |
numeric(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 |
numeric(18, 8) |
numeric(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 |
numeric(18, 8) |
numeric(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 |
numeric(5, 0) |
tinyint |
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 |
numeric(18, 8) |
numeric(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 |
numeric(18, 8) |
numeric(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 |
numeric(18, 8) |
numeric(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 |
varchar(20) |
varchar(10) |
Participant ID |
| SETTLEMENTS_UNITID |
varchar(50) |
varchar(50) |
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. |