|
Name |
|
|
Comment |
DAYTRACK identifies the actual settlement run processed for each settlement day. Settlement run is in the column EXPOSTRUNNO. Generally the number of the settlement run used in the latest statement is the maximum number. |
|
DAYTRACK is a public data, and is available to all participants. Source DAYTRACK is populated by the posting of a billing run. Volume Daily billing runs insert one row per day. A non-interim statement has seven records inserted per week. An indicative maximum is 35 records inserted per week. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
EXPOSTRUNNO |
|
SETTLEMENTDATE |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Calendar Settlement Date |
|
REGIONID |
VARCHAR2(10) |
|
Not Used |
|
EXANTERUNSTATUS |
VARCHAR2(15) |
|
Not Used |
|
EXANTERUNNO |
NUMBER(3,0) |
|
Not Used |
|
EXPOSTRUNSTATUS |
VARCHAR2(15) |
|
Not Used |
|
EXPOSTRUNNO |
NUMBER(3,0) |
X |
Settlement Run No |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
SETTLEMENTINTERVALLENGTH |
NUMBER(3,0) |
|
Length of a settlement interval, in minutes (was 30 minutes, will be 5 minutes starting the commencement of 5MS rule change date). |
|
METER_CASEID |
NUMBER(5,0) |
|
The Metering Case Id used for the Settlement Run. For Estimate Daily Run this will be 0 |
|
METER_RUNTYPE |
VARCHAR2(10) |
|
The Type of Settlement Run(ESTIMATE/PRELIM/FINAL/REVISE) |
|
Name |
|
|
Comment |
APC Compensation payment amounts in the Settlements timeframe |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
APEVENTID |
|
CLAIMID |
|
PARTICIPANTID |
|
PERIODID |
|
SETTLEMENTDATE |
|
VERSIONNO |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Settlement run date |
|
VERSIONNO |
NUMBER(3) |
X |
Settlement run number |
|
APEVENTID |
NUMBER(6) |
X |
AP Event Id |
|
CLAIMID |
NUMBER(6) |
X |
AP Event Claim Id |
|
PARTICIPANTID |
VARCHAR2(20) |
X |
Participant identifier |
|
PERIODID |
NUMBER(3) |
X |
Trading interval identifier |
|
COMPENSATION_AMOUNT |
NUMBER(18,8) |
|
Compensation amount for the event claim in this interval |
|
Name |
|
|
Comment |
APC Compensation recovery amounts in the Settlements timeframe |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
APEVENTID |
|
CLAIMID |
|
PARTICIPANTID |
|
PERIODID |
|
REGIONID |
|
SETTLEMENTDATE |
|
VERSIONNO |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Settlement run date |
|
VERSIONNO |
NUMBER(3) |
X |
Settlement run number |
|
APEVENTID |
NUMBER(6) |
X |
AP Event Id |
|
CLAIMID |
NUMBER(6) |
X |
AP Event Claim Id |
|
PARTICIPANTID |
VARCHAR2(20) |
X |
Participant identifier |
|
PERIODID |
NUMBER(3) |
X |
Settlements Trading Interval. |
|
REGIONID |
VARCHAR2(20) |
X |
Region id for the recovery amount |
|
RECOVERY_AMOUNT |
NUMBER(18,8) |
|
Recovery amount in the region attributable to the participant for the event claim in this interval |
|
REGION_RECOVERY_ |
NUMBER(18,8) |
|
Total Recovery amount in the region for the event claim in this interval |
|
Name |
|
|
Comment |
SET_ANCILLARY_SUMMARY summarises payments for all Ancillary Services to participants on the basis of regions and trading intervals. |
|
SET_ANCILLARY_SUMMARY data is available to all participants. Volume Approximately 30, 000 per week. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
PAYMENTTYPE |
|
PERIODID |
|
REGIONID |
|
SERVICE |
|
SETTLEMENTDATE |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Settlement Date |
|
VERSIONNO |
NUMBER(3,0) |
X |
Settlement Run No |
|
SERVICE |
VARCHAR2(20) |
X |
Ancillary service identifier (e.g. REACTIVE_POWER) |
|
PAYMENTTYPE |
VARCHAR2(20) |
X |
Payment type identifier (e.g. COMPENSATION) |
|
REGIONID |
VARCHAR2(10) |
X |
Region Identifier |
|
PERIODID |
NUMBER(3,0) |
X |
Trading interval |
|
PAYMENTAMOUNT |
NUMBER(18,8) |
|
The NEM ancillary summary regional payment amount ($) |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
The Settlement Energy Genset report contains the Energy Transactions data for each generation meter point. This report is produced only for Settlement Date post the IESS rule effective date. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
DUID |
|
GENSETID |
|
PERIODID |
|
SETTLEMENTDATE |
|
STATIONID |
|
VERSIONNO |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
The Settlement Date of the Billing Week |
|
VERSIONNO |
NUMBER(3,0) |
X |
The Settlement Run No |
|
PERIODID |
NUMBER(3,0) |
X |
The Period ID Identifier |
|
PARTICIPANTID |
VARCHAR2(20) |
|
The Participant Id Identifier |
|
STATIONID |
VARCHAR2(20) |
X |
The StationId identifier associated with the GensetId |
|
DUID |
VARCHAR2(20) |
X |
The DUID for the meter associated with the GensetId |
|
GENSETID |
VARCHAR2(20) |
X |
The GensetId for the Meter Id received |
|
REGIONID |
VARCHAR2(20) |
|
The Region Id for the Connection Point associated with the DUID |
|
CONNECTIONPOINTID |
VARCHAR2(20) |
|
The Connection Point associated with the DUID |
|
RRP |
NUMBER(18,8) |
|
The Regional Reference Price for the Settlement Period |
|
TLF |
NUMBER(18,8) |
|
The Transmission Loss Factor applied to the Connection Point Id. TLF is calculated based on the Net Flow at the TNI. |
|
METERID |
VARCHAR2(20) |
|
The Meter ID Identifier (NMI) |
|
CE_MWH |
NUMBER(18,8) |
|
The Consumed Energy for the Meter Id . Energy received in the meter reads (DLF Adjusted) |
|
UFEA_MWH |
NUMBER(18,8) |
|
The UFEA allocation amount applied to the Meter Data |
|
ACE_MWH |
NUMBER(18,8) |
|
The Adjusted Consumed Energy for the Meter Id (CE_MWh + UFEA) |
|
ASOE_MWH |
NUMBER(18,8) |
|
The Adjusted Sent Out Energy for the Meter Id. |
|
TOTAL_MWH |
NUMBER(18,8) |
|
The Total MWh for the Meter Id (ACE_MWh + ASOE_MWh) |
|
DME_MWH |
NUMBER(18,8) |
|
The DME MWh value that is used to calculate the UFEA Allocation Amount |
|
ACE_AMOUNT |
NUMBER(18,8) |
|
The Adjusted Consumed Energy Dollar Amount |
|
ASOE_AMOUNT |
NUMBER(18,8) |
|
The Adjusted Sent Out Energy Dollar Amount |
|
TOTAL_AMOUNT |
NUMBER(18,8) |
|
The Total Amount for the Meter Id (ACE_Amount + ASOE_Amount) |
|
LASTCHANGED |
DATE |
|
The Last changed Date time of the record |
|
Name |
|
|
Comment |
The Settlement Energy Region Summary report contains the Energy Transactions Summary for all the NEM regions. This report is produced only for Settlement Date post the IESS rule effective date. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
PERIODID |
|
REGIONID |
|
SETTLEMENTDATE |
|
VERSIONNO |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
The Settlement Date of the Billing Week |
|
VERSIONNO |
NUMBER(3,0) |
X |
The Settlement Run No |
|
PERIODID |
NUMBER(3,0) |
X |
The Period ID Identifier |
|
REGIONID |
VARCHAR2(20) |
X |
The NEM Region Id Identifier |
|
CE_MWH |
NUMBER(18,8) |
|
The Consumed Energy summary for the Region Id |
|
UFEA_MWH |
NUMBER(18,8) |
|
The UFEA Energy summary for the Region Id |
|
ACE_MWH |
NUMBER(18,8) |
|
The Adjusted Consumed Energy summary for the Region Id |
|
ASOE_MWH |
NUMBER(18,8) |
|
The Adjusted Sent Out Energy summary for the Region Id |
|
ACE_AMOUNT |
NUMBER(18,8) |
|
The Adjusted Consumed Energy Amount for the Region Id |
|
ASOE_AMOUNT |
NUMBER(18,8) |
|
The Adjusted Sent Out Energy Amount for the Region Id |
|
TOTAL_MWH |
NUMBER(18,8) |
|
The Total Energy summary for the Region Id |
|
TOTAL_AMOUNT |
NUMBER(18,8) |
|
The Total Dollar Amount summary for the Region Id |
|
LASTCHANGED |
DATE |
|
The Last changed Date time of the record |
|
Name |
|
|
Comment |
The table shows the Transaction Details for the SAPS Connection Points. The table contains both the MSRPs and Retailers data |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
PARTICIPANTID |
|
PERIODID |
|
SETTLEMENTDATE |
|
TNI |
|
VERSIONNO |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
The Settlement Date of the Billing Week |
|
VERSIONNO |
NUMBER(3,0) |
X |
The Settlement Run No |
|
PERIODID |
NUMBER(3,0) |
X |
The Period Id identifier |
|
PARTICIPANTID |
VARCHAR2(20) |
X |
The Participant ID for the SAPS TNI |
|
TNI |
VARCHAR2(20) |
X |
The SAPS Connection Point Identifier |
|
REGIONID |
VARCHAR2(20) |
|
The SAPS Region ID |
|
SAPS_RRP |
NUMBER(18,8) |
|
The SAPS Settlement Price for the Region |
|
CONSUMED_ENERGY_MWH |
NUMBER(18,8) |
|
The Energy MWh Consumed for that TNI for the Participant ID |
|
SENTOUT_ENERGY_MWH |
NUMBER(18,8) |
|
The Energy MWh Sent Out for the TNI for the Participant Id |
|
CONSUMED_ENERGY_COST |
NUMBER(18,8) |
|
The Cost of the Consumed Energy |
|
SENTOUT_ENERGY_COST |
NUMBER(18,8) |
|
The Cost of the Sent Out Energy |
|
LASTCHANGED |
DATE |
|
The Last changed Date time of the record |
|
Name |
|
|
Comment |
The Settlement Energy Transactions report contains the Energy Transactions data for all the Participants based on their ACE and ASOE at each customer and generator Connection Point ID. This table is populated The Settlement Energy Transactions report contains the Energy Transactions data for all the Participants based on their ACE and ASOE at each customer and generator Connection Point ID. This table is populated only if Settlement Date is post the IESS rule effective date. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
CONNECTIONPOINTID |
|
METER_TYPE |
|
PARTICIPANTID |
|
PERIODID |
|
SETTLEMENTDATE |
|
VERSIONNO |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
The Settlement Date of the Billing Week |
|
VERSIONNO |
NUMBER(3,0) |
X |
The Settlement Run No |
|
PERIODID |
NUMBER(3,0) |
X |
The Period ID Identifier |
|
PARTICIPANTID |
VARCHAR2(20) |
X |
The Participant Id Identifier |
|
CONNECTIONPOINTID |
VARCHAR2(20) |
X |
The Connection Point associated with the Energy Transaction reads. |
|
METER_TYPE |
VARCHAR2(20) |
X |
The type of meter reads received. Eg Customer, Generator, BDU, NREG etc. |
|
REGIONID |
VARCHAR2(20) |
|
The NEM Region Id Identifier |
|
RRP |
NUMBER(18,8) |
|
The Regional Reference Price for the Region |
|
TLF |
NUMBER(18,8) |
|
The Transmission Loss Factor applied to the Connection Point Id. TLF is calculated based on the Net Flow at the TNI. |
|
CE_MWH |
NUMBER(18,8) |
|
The Consumed Energy . Energy received in the meter reads (DLF Adjusted) |
|
UFEA_MWH |
NUMBER(18,8) |
|
The UFE Allocation Amount applied to the Participant |
|
ACE_MWH |
NUMBER(18,8) |
|
The Adjusted Consumed Energy MWh ( CE_MWh + UFEA) for the ConnectionPointId |
|
ASOE_MWH |
NUMBER(18,8) |
|
The Adjusted Sent Out Energy for the ConnectionPointId . Energy received in the meter reads adjusted by DLF. |
|
TOTAL_MWH |
NUMBER(18,8) |
|
The Total MWh Value for the Participant. ACE_MWh + ASOE_MWh |
|
ACE_AMOUNT |
NUMBER(18,8) |
|
The dollar amount for Adjusted Consumed Energy MWh (ACE_MWh * TLF * RRP) |
|
ASOE_AMOUNT |
NUMBER(18,8) |
|
The dollar amount for Adjusted Sent Out Energy MWh (ASOE_MWh * TLF * RRP) |
|
TOTAL_AMOUNT |
NUMBER(18,8) |
|
The Total Dollar Value for the Participant. ACE_Amount + ASOE_Amount |
|
CASE_ID |
NUMBER(10,0) |
|
The Metering Case ID |
|
DME_MWH |
NUMBER(18,8) |
|
The DME MWh (Distribution Connected) that is used in the UFEA Calculation. |
|
AGGREGATE_READ_FLAG |
NUMBER(3,0) |
|
The Flag is 1 if the meter data source is from Aggregate Reads Meter Data, Else 0 |
|
INDIVIDUAL_READ_FLAG |
NUMBER(3,0) |
|
The Flag is 1 if the meter data source is from Individual Reads Meter Data, Else 0 |
|
LASTCHANGED |
DATE |
|
The Last changed Date time of the record |
|
Name |
|
|
Comment |
This report contains the Interval Datetime affected by the Clawback Run and the adjusted FCAS requirement Costs. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
BIDTYPE |
|
CONSTRAINTID |
|
INTERVAL_DATETIME |
|
REGIONID |
|
RUNNO |
|
Name |
Data Type |
Mandatory |
Comment |
|
INTERVAL_DATETIME |
DATE |
X |
The Interval Datetime for which a the Clawback Run has been completed. |
|
RUNNO |
NUMBER(3,0) |
X |
The RunNo associated with the Clawback Run for the above interval date time. |
|
CONSTRAINTID |
VARCHAR2(20) |
X |
The FCAS Constraint ID used in the FCAS Requirements. |
|
REGIONID |
VARCHAR2(20) |
X |
The Region ID associated with each Constraint Requirements |
|
BIDTYPE |
VARCHAR2(10) |
X |
The FCAS Service - DUID offered type |
|
REGION_ENABLEMENT |
NUMBER(18,8) |
|
The Overridden Regional Enablement. SUM(FCAS MW) from FCAS.Clawback_Unitsolution |
|
CONSTRAINT_ENABLEMENT |
NUMBER(18,8) |
|
How much is enabled for this bid Type within the constraint. Sum(Regional_Enablement) Group by Interval_Datetime, ConstraintId, BidType |
|
REGION_BASE_COST |
NUMBER(18,8) |
|
The Region Base Cost adjusted by the Regional Enablement Adj Ratio |
|
BASE_COST |
NUMBER(18,8) |
|
The Base cost of the constraint before the regulation/contingency split. SUM(REGION_BASE_COST) Group by interval datetime, ConstraintId |
|
ADJUSTED_COST |
NUMBER(18,8) |
|
The adjusted cost of the constraint for this service, after the regulation/contingency split. This is adjusted by the Base Cost Adjustment Ratio. |
|
P_REGULATION |
NUMBER(18,8) |
|
P Regulation value is not affected by Clawback. This value is copied from Original Data source(DISPATCH ) |
|
PREV_REGION_ENABLEMENT |
NUMBER(18,8) |
|
The Regional Enablement before Override |
|
PREV_CONSTRAINT_ENABLEMENT |
NUMBER(18,8) |
|
The Constraint Enablement before Override |
|
PREV_REGION_BASE_COST |
NUMBER(18,8) |
|
The Region Base Cost before Override |
|
PREV_BASE_COST |
NUMBER(18,8) |
|
The Base Cost before Override |
|
PREV_ADJUSTED_COST |
NUMBER(18,8) |
|
The Adjusted Cost before override |
|
LASTCHANGED |
DATE |
|
The Last Changed Date time of the record. |
|
Name |
|
|
Comment |
This Settlements FCAS Clawback Run Track report contains the Interval Datetime for which a Clawback has occurred and included in the Settlement run. The report will be produced only if there is any Clawback Run for the Interval date time in the Settlement Date |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
INTERVAL_DATETIME |
|
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 |
|
INTERVAL_DATETIME |
DATE |
X |
The Interval Datetime for which a Clawback Run has been completed. |
|
RUNNO |
NUMBER(3,0) |
|
The RunNo associated with the Clawback for the above interval date time. |
|
CLAWBACK_DATE |
DATE |
|
The Date time the Clawback data has been loaded into the System for processing. |
|
PREV_DATA_SOURCE |
VARCHAR2(20) |
|
The Clawback Data source Used. If this interval has any Clawback already applied in past then value will be CLAWBACK , else DISPATCH. For the first Clawback processing for the Interval the Source is DISPATCH. |
|
LASTCHANGED |
DATE |
|
The Last changed Date time of the record |
|
Name |
|
|
Comment |
This report contains the Interval Datetime affected by the Clawback Run and the reduced MW for the FCAS Service for each affected DUID. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
DUID |
|
INTERVAL_DATETIME |
|
RUNNO |
|
Name |
Data Type |
Mandatory |
Comment |
|
INTERVAL_DATETIME |
DATE |
X |
The Interval Datetime for which a the Clawback Run has been completed. |
|
RUNNO |
NUMBER(3,0) |
X |
The RunNo associated with the Clawback Run for the above interval date time. |
|
DUID |
VARCHAR2(20) |
X |
The DUID for which the Reduced MW has been applied for the FCAS Service. |
|
LOWER1SEC |
NUMBER(18,8) |
|
The Clawback Volume for the LOWER1SEC Service. If this service is not affected in that Clawback then retain Prev Value. |
|
LOWER5MIN |
NUMBER(18,8) |
|
The Clawback Volume for the LOWER5MIN Service. If this service is not affected in that Clawback then retain Prev Value. |
|
LOWER60SEC |
NUMBER(18,8) |
|
The Clawback Volume for the LOWER60SEC Service. If this service is not affected in that Clawback then retain Prev Value. |
|
LOWER6SEC |
NUMBER(18,8) |
|
The Clawback Volume for the LOWER6SEC Service. If this service is not affected in that Clawback then retain Prev Value. |
|
RAISE1SEC |
NUMBER(18,8) |
|
The Clawback Volume for the RAISE1SEC Service. If this service is not affected in that Clawback then retain Prev Value. |
|
RAISE5MIN |
NUMBER(18,8) |
|
The Clawback Volume for the RAISE5MIN Service. If this service is not affected in that Clawback then retain Prev Value. |
|
RAISE60SEC |
NUMBER(18,8) |
|
The Clawback Volume for the RAISE60SEC Service. If this service is not affected in that Clawback then retain Prev Value. |
|
RAISE6SEC |
NUMBER(18,8) |
|
The Clawback Volume for the RAISE6SEC Service. If this service is not affected in that Clawback then retain Prev Value. |
|
LOWERREG |
NUMBER(18,8) |
|
The Clawback Volume for the LOWERREG Service. If this service is not affected in that Clawback then retain Prev Value. |
|
RAISEREG |
NUMBER(18,8) |
|
The Clawback Volume for the RAISEREG Service. If this service is not affected in that Clawback then retain Prev Value. |
|
LASTCHANGED |
DATE |
|
The Last Changed Date time of the record. |
|
Name |
|
|
Comment |
SET_FCAS_PAYMENT sets out the enabling payment details for frequency controlled Ancillary Services. |
|
SET_FCAS_PAYMENT data is confidential to the relevant participant. Volume Approximately 150,000 per week. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
DUID |
|
PERIODID |
|
SETTLEMENTDATE |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Settlement Date |
|
VERSIONNO |
NUMBER(3,0) |
X |
Settlement Run No |
|
PARTICIPANTID |
VARCHAR2(10) |
|
Participant identifier |
|
DUID |
VARCHAR2(10) |
X |
Dispatchable unit identifier |
|
REGIONID |
VARCHAR2(10) |
|
Region Identifier |
|
PERIODID |
NUMBER(3,0) |
X |
Settlements Trading Interval. |
|
LOWER6SEC_PAYMENT |
NUMBER(18,8) |
|
Lower 6 Second Payment |
|
RAISE6SEC_PAYMENT |
NUMBER(18,8) |
|
Raise 6 Second Payment |
|
LOWER60SEC_PAYMENT |
NUMBER(18,8) |
|
Lower 60 Second Payment |
|
RAISE60SEC_PAYMENT |
NUMBER(18,8) |
|
Raise 60 Second Payment |
|
LOWER5MIN_PAYMENT |
NUMBER(18,8) |
|
Lower 5 Minute Payment |
|
RAISE5MIN_PAYMENT |
NUMBER(18,8) |
|
Raise 5 Minute Payment |
|
LOWERREG_PAYMENT |
NUMBER(18,8) |
|
Lower 5 Minute Regulation Payment |
|
RAISEREG_PAYMENT |
NUMBER(18,8) |
|
Raise 5 Minute Regulation Payment |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
RAISE1SEC_PAYMENT |
NUMBER(18,8) |
|
Payment amount for the very fast raise service |
|
LOWER1SEC_PAYMENT |
NUMBER(18,8) |
|
Payment amount for the very fast lower service |
|
Name |
|
|
Comment |
SET_FCAS_RECOVERY shows reimbursements for the Frequency Control Ancillary Services (FCAS) to be recovered from participants. Beware of potential confusion with the table SETFCASRECOVERY, which reports reimbursements for Frequency Control Ancillary Services Compensation (now unused). |
|
SET_FCAS_RECOVERY data is confidential to the relevant participant. Volume Approximately 1, 500, 000 per week. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
PARTICIPANTID |
|
PERIODID |
|
REGIONID |
|
SETTLEMENTDATE |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Settlement Date |
|
VERSIONNO |
VARCHAR2(3) |
X |
Settlement Run No |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Participant identifier |
|
REGIONID |
VARCHAR2(10) |
X |
Region Identifier |
|
PERIODID |
NUMBER(3,0) |
X |
Settlements Trading Interval. |
|
LOWER6SEC_RECOVERY |
NUMBER(18,8) |
|
Recovery amount for the Lower 6 Second service attributable to customer connection points. NULL for Settlement date post the IESS rule effective date |
|
RAISE6SEC_RECOVERY |
NUMBER(18,8) |
|
Recovery amount for the Raise 6 Second service attributable to customer connection points. NULL for Settlement dates post the IESS rule effective date |
|
LOWER60SEC_RECOVERY |
NUMBER(18,8) |
|
Recovery amount for the Lower 60 Second service attributable to customer connection points. NULL for Settlement dates post the IESS rule effective date |
|
RAISE60SEC_RECOVERY |
NUMBER(18,8) |
|
Recovery amount for the Raise 60 Second service attributable to customer connection points. NULL for Settlement dates post the IESS rule effective date |
|
LOWER5MIN_RECOVERY |
NUMBER(18,8) |
|
Recovery amount for the Lower 5 Minute service attributable to customer connection points. NULL for Settlement dates post the IESS rule effective date |
|
RAISE5MIN_RECOVERY |
NUMBER(18,8) |
|
Recovery amount for the Raise 5 Minute service attributable to customer connection points. NULL for Settlement dates post the IESS rule effective date |
|
LOWERREG_RECOVERY |
NUMBER(18,8) |
|
For Settlement Date post the IESS rule effective date the column represent the Lower Regulation FCAS MPF Recovery Amount from Customer and Generator Connection Point MPFs only. Residue Recovery Amount is not included in this amount. For Settlement Dates past FPP Rule Effective Dates this column will be NULL. |
|
RAISEREG_RECOVERY |
NUMBER(18,8) |
|
For Settlement Date post the IESS rule effective date the column represent the Raise Regulation FCAS MPF Recovery Amount from Customer and Generator Connection Point MPFs only. Residue Recovery Amount is not included in this amount. For Settlement Dates past FPP Rule Effective Dates this column will be NULL. |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
LOWER6SEC_RECOVERY_GEN |
NUMBER(18,8) |
|
Recovery amount for the Lower 6 Second service attributable to generator connection points. NULL for Settlement dates post the IESS rule effective date |
|
RAISE6SEC_RECOVERY_GEN |
NUMBER(18,8) |
|
Recovery amount for the Raise 6 Second service attributable to generator connection points. NULL for Settlement dates post the IESS rule effective date |
|
LOWER60SEC_RECOVERY_GEN |
NUMBER(18,8) |
|
Recovery amount for the Lower 60 Second service attributable to generator connection points. NULL for Settlement dates post the IESS rule effective date |
|
RAISE60SEC_RECOVERY_GEN |
NUMBER(18,8) |
|
Recovery amount for the Raise 60 Second service attributable to generator connection points. NULL for Settlement dates post the IESS rule effective date |
|
LOWER5MIN_RECOVERY_GEN |
NUMBER(18,8) |
|
Recovery amount for the Lower 5 Minute service attributable to generator connection points. NULL for Settlement dates post the IESS rule effective date |
|
RAISE5MIN_RECOVERY_GEN |
NUMBER(18,8) |
|
Recovery amount for the Raise 5 Minute service attributable to generator connection points. NULL for Settlement dates post the IESS rule effective date |
|
LOWERREG_RECOVERY_GEN |
NUMBER(18,8) |
|
For Settlement date prior to the IESS rule effective date, the column represent Sum of MPF Lower Regulation recovery amount from Generator Connection Points. NULL for Settlement dates post the IESS rule effective date. |
|
RAISEREG_RECOVERY_GEN |
NUMBER(18,8) |
|
For Settlement date prior to the IESS rule effective date, the column represent Sum of MPF Raise Regulation recovery amount from Generator Connection Points. NULL for Settlement dates post the IESS rule effective date. |
|
RAISE1SEC_RECOVERY |
NUMBER(18,8) |
|
Customer recovery amount for the very fast raise service. NULL for Settlement dates post the IESS rule effective date |
|
LOWER1SEC_RECOVERY |
NUMBER(18,8) |
|
Customer recovery amount for the very fast lower service. NULL for Settlement dates post the IESS rule effective date |
|
RAISE1SEC_RECOVERY_GEN |
NUMBER(18,8) |
|
Generator recovery amount for the very fast raise service. NULL for Settlement dates post the IESS rule effective date |
|
LOWER1SEC_RECOVERY_GEN |
NUMBER(18,8) |
|
Generator recovery amount for the very fast lower service. NULL for Settlement dates post the IESS rule effective date |
|
LOWERREG_ACE |
NUMBER(18,8) |
|
The Lower Regulation FCAS Residue Recovery Amount using ACE MWh values excluding the MPF Connection Points. NULL value for Settlement Dates prior to the IESS rule effective date. For Settlement dates past FPP Rule Effective date this column will be LOWERREG_USED_ACE + LOWERREG_UNUSED_ACE |
|
RAISEREG_ACE |
NUMBER(18,8) |
|
The Raise Regulation FCAS Residue Recovery Amount using ACE MWh values excluding the MPF Connection Points. NULL Value for Settlement Dates prior to the IESS rule effective date. For Settlement dates past FPP Rule Effective date this column will be RAISEREG_USED_ACE + RAISEREG_UNUSED_ACE |
|
RAISE1SEC_ACE |
NUMBER(18,8) |
|
The Raise1Sec FCAS Recovery Amount for the Participant and Region from ACE MWh Portion. NULL Value for Settlement Dates prior to the IESS rule effective date. |
|
RAISE1SEC_ASOE |
NUMBER(18,8) |
|
The Raise1Sec FCAS Recovery Amount for the Participant and Region from ASOE MWh Portion. NULL Value for Settlement Dates prior to the IESS rule effective date. |
|
LOWER1SEC_ACE |
NUMBER(18,8) |
|
The Lower1Sec FCAS Recovery Amount for the Participant and Region from ACE MWh Portion. NULL Value for Settlement Dates prior to the IESS rule effective date. |
|
LOWER1SEC_ASOE |
NUMBER(18,8) |
|
The Lower1Sec FCAS Recovery Amount for the Participant and Region from ASOE MWh Portion. NULL Value for Settlement Dates prior to the IESS rule effective date. |
|
RAISE6SEC_ACE |
NUMBER(18,8) |
|
The Raise6Sec FCAS Recovery Amount for the Participant and Region from ACE MWh Portion. NULL Value for Settlement Dates prior to the IESS rule effective date. |
|
RAISE6SEC_ASOE |
NUMBER(18,8) |
|
The Raise6Sec FCAS Recovery Amount for the Participant and Region from ASOE MWh Portion. NULL Value for Settlement Dates prior to the IESS rule effective date. |
|
LOWER6SEC_ACE |
NUMBER(18,8) |
|
The Lower6Sec FCAS Recovery Amount for the Participant and Region from ACE MWh Portion. NULL Value for Settlement Dates prior to the IESS rule effective date. |
|
LOWER6SEC_ASOE |
NUMBER(18,8) |
|
The Lower6Sec FCAS Recovery Amount for the Participant and Region from ASOE MWh Portion. NULL Value for Settlement Dates prior to the IESS rule effective date. |
|
RAISE60SEC_ACE |
NUMBER(18,8) |
|
The Raise60Sec FCAS Recovery Amount for the Participant and Region from ACE MWh Portion. NULL Value for Settlement Dates prior to the IESS rule effective date. |
|
RAISE60SEC_ASOE |
NUMBER(18,8) |
|
The Raise60Sec FCAS Recovery Amount for the Participant and Region from ASOE MWh Portion. NULL Value for Settlement Dates prior to the IESS rule effective date. |
|
LOWER60SEC_ACE |
NUMBER(18,8) |
|
The Lower60Sec FCAS Recovery Amount for the Participant and Region from ACE MWh Portion. NULL Value for Settlement Dates prior to the IESS rule effective date. |
|
LOWER60SEC_ASOE |
NUMBER(18,8) |
|
The Lower60Sec FCAS Recovery Amount for the Participant and Region from ASOE MWh Portion. NULL Value for Settlement Dates prior to the IESS rule effective date. |
|
RAISE5MIN_ACE |
NUMBER(18,8) |
|
The Raise5Min FCAS Recovery Amount for the Participant and Region from ACE MWh Portion. NULL Value for Settlement Dates prior to the IESS rule effective date. |
|
RAISE5MIN_ASOE |
NUMBER(18,8) |
|
The Raise5Min FCAS Recovery Amount for the Participant and Region from ASOE MWh Portion. NULL Value for Settlement Dates prior to the IESS rule effective date. |
|
LOWER5MIN_ACE |
NUMBER(18,8) |
|
The Lower5Min FCAS Recovery Amount for the Participant and Region from ACE MWh Portion. NULL Value for Settlement Dates prior to the IESS rule effective date. |
|
LOWER5MIN_ASOE |
NUMBER(18,8) |
|
The Lower5Min FCAS Recovery Amount for the Participant and Region from ASOE MWh Portion. NULL Value for Settlement Dates prior to the IESS rule effective date. |
|
LOWERREG_ASOE |
NUMBER(18,8) |
|
This column is LOWERREG_USED_ASOE + LOWERREG_UNUSED_ASOE. For Settlement dates prior to FPP Rule Effective date this column will be NULL |
|
RAISEREG_ASOE |
NUMBER(18,8) |
|
This column is RAISEREG_USED_ASOE + RAISEREG_UNUSED_ASOE. For Settlement dates prior to FPP Rule Effective date this column will be NULL |
|
LOWERREG_USED |
NUMBER(18,8) |
|
The LowerReg Used amount for the Participant and Region |
|
RAISEREG_USED |
NUMBER(18,8) |
|
The RaiseReg Used amount for the Participant and Region |
|
LOWERREG_UNUSED |
NUMBER(18,8) |
|
The LowerReg Unused amount for the Participant and Region |
|
RAISEREG_UNUSED |
NUMBER(18,8) |
|
The RaiseReg Unused amount for the Participant and Region |
|
|
|