|
Name |
|
|
Comment |
MAS_CP_MASTER shows the current MAS configuration. |
|
Obsolete; Replaced by MSATS Source MAS_CP_MASTER updates daily with each MAS export. Note
|
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
NMI |
|
VALID_FROM_DATE |
|
Name |
|
NMI |
|
VALID_TO_DATE |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
NMI |
VARCHAR2(10) |
X |
National Metering Identifier |
|
CP_SECURITY_CODE |
VARCHAR2(4) |
|
Security Code |
|
IN_USE |
VARCHAR2(1) |
|
Active/Inactive Status flag (NEW/N/Y/X) |
|
VALID_FROM_DATE |
DATE |
X |
Record valid from date |
|
VALID_TO_DATE |
DATE |
X |
Record valid to date |
|
LOCAL_NETWORK_PROVIDER |
VARCHAR2(10) |
|
LNSP |
|
LOCAL_RETAILER |
VARCHAR2(10) |
|
Local Retailer |
|
FINANCIAL_PARTICIPANT |
VARCHAR2(10) |
|
FRMP |
|
METERING_DATA_AGENT |
VARCHAR2(10) |
|
MDA |
|
RETAILER_OF_LAST_RESORT |
VARCHAR2(10) |
|
ROLR |
|
RESPONSIBLE_PERSON |
VARCHAR2(10) |
|
Responsible Person |
|
CP_NAME |
VARCHAR2(30) |
|
Connection point name |
|
CP_DETAIL_1 |
VARCHAR2(30) |
|
Connection point detail 1 |
|
CP_DETAIL_2 |
VARCHAR2(30) |
|
Connection point detail 2 |
|
CITY_SUBURB |
VARCHAR2(30) |
|
Connection point city/suburb |
|
STATE |
VARCHAR2(3) |
|
State of Australia |
|
POST_CODE |
VARCHAR2(4) |
|
Connection point postcode |
|
TX_NODE |
VARCHAR2(4) |
|
Connection point TNI |
|
AGGREGATE_DATA |
VARCHAR2(1) |
|
Aggregate data flag (YIN) |
|
AVERAGE_DAILY_LOAD_KWH |
NUMBER(8,0) |
|
Average daily load in KWh |
|
DISTRIBUTION_LOSS |
NUMBER(5,4) |
|
Distribution loss factor |
|
LSNP_TEXT |
VARCHAR2(30) |
|
LNSP text field (name has misspelt LNSP) |
|
LR_TEXT |
VARCHAR2(30) |
|
LR text field |
|
FRMP_TEXT |
VARCHAR2(30) |
|
FRMP text field |
|
MDA_TEXT |
VARCHAR2(30) |
|
MDA text field |
|
ROLR_TEXT |
VARCHAR2(30) |
|
ROLR text field |
|
RP_TEXT |
VARCHAR2(30) |
|
RP text field |
|
LASTCHANGED |
DATE |
|
Last changed date |
|
NMI_CLASS |
VARCHAR2(9) |
|
|
|
METERING_TYPE |
VARCHAR2(9) |
|
|
|
JURISDICTION |
VARCHAR2(3) |
|
|
|
Name |
|
|
Comment |
METERDATA sets out a meter data for each customer connection point. METERDATA covers market load. Use the field METERRUNNO to match the meter data version for each settlement run. |
|
METERDATA data is confidential to the relevant participant. Source METERDATA updates whenever meter files are processed from MSATS. Volume Depends on number of TNI, FRMP, LR combinations and number of data file loads (versions) from MSATS per settlement run. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
CONNECTIONPOINTID |
|
HOSTDISTRIBUTOR |
|
MDA |
|
METERRUNNO |
|
PARTICIPANTID |
|
PERIODID |
|
SETTLEMENTDATE |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Unique participant identifier |
|
PERIODID |
NUMBER(3,0) |
X |
Settlement period identifier (half hour period) |
|
SETTLEMENTDATE |
DATE |
X |
Settlement date |
|
METERRUNNO |
NUMBER(6,0) |
X |
Data version no |
|
CONNECTIONPOINTID |
VARCHAR2(10) |
X |
Transmission Node Identifier (TNI). Identifies a Transmission NetworkConnection Point. |
|
IMPORTENERGYVALUE |
NUMBER(9,6) |
|
Imported energy value (MWh) |
|
EXPORTENERGYVALUE |
NUMBER(9,6) |
|
Exported energy value (MWh) |
|
IMPORTREACTIVEVALUE |
NUMBER(9,6) |
|
Not used |
|
EXPORTREACTIVEVALUE |
NUMBER(9,6) |
|
Not used |
|
HOSTDISTRIBUTOR |
VARCHAR2(10) |
X |
Local Retailer participant identifier |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
MDA |
VARCHAR2(10) |
X |
Defaults to MSATS |
|
Name |
|
|
Comment |
Recorded actual generation of non-scheduled units where SCADA data is available. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
DUID |
|
INTERVAL_DATETIME |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
INTERVAL_DATETIME |
date |
X |
Timestamp of the recorded interval |
|
DUID |
varchar2(10) |
X |
Unit ID |
|
MWH_READING |
number(18,8) |
|
MW reading |
|
LASTCHANGED |
date |
|
Timestamp of last record change |
|
Name |
|
|
Comment |
Tracking table for the publication of wholesale settlement data associated with BILLING run |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
CASE_ID |
|
Name |
|
CASE_ID |
|
Name |
Data Type |
Mandatory |
Comment |
|
CASE_ID |
NUMBER(15,0) |
X |
Case Identifier |
|
AGGREGATE_READS_LOAD_DATETIME |
DATE |
|
Timestamp of the aggregated reads being loaded for this case |
|
INDIVIDUAL_READS_LOAD_DATETIME |
DATE |
|
Timestamp of the non aggregated reads being loaded for this case |
|
STARTDATE |
DATE |
|
The start date of data associated with the CASE_ID |
|
ENDDATE |
DATE |
|
The end date of data associated with the Case_ID |
|
LASTCHANGED |
DATE |
|
Last changed date for the record |
|
Name |
|
|
Comment |
METERDATATRK records meter data files submitted for each connection point on a daily basis. The same data is provided in METERDATA period by period (i.e. 48 records), whereas METERDATATRK shows one record per day for each file submitted for a connection point. |
|
METERDATATRK data is confidential to the relevant participant. Source METERDATATRK updates whenever meter files are processed. Volume Depends on the number of TNI, FRMP and LR combinations plus the number of data file loads (versions) from MSATS per settlement run. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
CONNECTIONPOINTID |
|
HOSTDISTRIBUTOR |
|
METERINGDATAAGENT |
|
METERRUNNO |
|
PARTICIPANTID |
|
SETTLEMENTDATE |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Settlement calendar date |
|
METERRUNNO |
NUMBER(6,0) |
X |
Meter data version number |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Participant identifier |
|
FILENAME |
VARCHAR2(40) |
|
Meter file name (MSATS file name) |
|
ACKFILENAME |
VARCHAR2(40) |
|
Not used |
|
CONNECTIONPOINTID |
VARCHAR2(10) |
X |
Transmission Node Identifier (TNI) |
|
AUTHORISEDDATE |
DATE |
|
Date processed |
|
AUTHORISEDBY |
VARCHAR2(15) |
|
Not used |
|
METERINGDATAAGENT |
VARCHAR2(10) |
X |
Defaults to MSATS |
|
HOSTDISTRIBUTOR |
VARCHAR2(10) |
X |
Local retailer participant identifier |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
MNSP_FILETRK shows all MNSPOFFERS transmitted to the MMS system. |
|
MNSP_FILETRK is confidential to the relevant participant. Source MNSP_FILETRK updates for every submitted MNSP bid. Volume 4000 per year, being one per bid containing an MNSP bid |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
FILENAME |
|
OFFERDATE |
|
PARTICIPANTID |
|
SETTLEMENTDATE |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Market Date from which bid is active |
|
OFFERDATE |
DATE |
X |
The actual date and time the bid file was submitted by the participant |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Participant Identifier |
|
FILENAME |
VARCHAR2(40) |
X |
File name for default bids, bids, rebids, re-offers or meter files, as appropriate to table |
|
STATUS |
VARCHAR2(10) |
|
Load status [SUCCESSFUL/CORRUPT] |
|
ACKFILENAME |
VARCHAR2(40) |
|
Acknowledge file name for bids, rebids |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
MNSP_OFFERTRK records all valid MNSPOFFERS loaded into the MMS system. The authorised date reflects the date and time of the load. MNSP_OFFERTRK is key for tracking MNSP bid submission. |
|
MNSP_OFFERTRK shows own (confidential) data updates as bids are processed. All bids are available as part of next day market data. Volume 4000 per year |
|
Name |
Comment |
Value |
|
Visibility |
|
Private & Public Next-Day |
|
Name |
|
FILENAME |
|
OFFERDATE |
|
PARTICIPANTID |
|
SETTLEMENTDATE |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
|
|
OFFERDATE |
DATE |
X |
|
|
VERSIONNO |
NUMBER(3,0) |
X |
|
|
PARTICIPANTID |
VARCHAR2(10) |
X |
|
|
FILENAME |
VARCHAR2(40) |
X |
|
|
AUTHORISEDDATE |
DATE |
|
|
|
AUTHORISEDBY |
VARCHAR2(15) |
|
|
|
LASTCHANGED |
DATE |
|
|
|
Name |
|
|
Comment |
MNSP_PEROFFER shows period by period availability and other period data pertaining to a specific bid and LinkID for the given Settlement Date. |
|
MNSP_PEROFFER shows own (confidential) data updates as bids are processed. All bids are available as part of next day market data. Volume 192, 000 per year |
|
Name |
Comment |
Value |
|
Visibility |
|
Private & Public Next-Day |
|
Name |
|
LINKID |
|
OFFERDATE |
|
PARTICIPANTID |
|
PERIODID |
|
SETTLEMENTDATE |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Market Date from which bid is active |
|
OFFERDATE |
DATE |
X |
Offer date for bid |
|
VERSIONNO |
NUMBER(3,0) |
X |
Version of data for other key data - a higher version for same key data will take precedence |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Participant Identifier |
|
LINKID |
VARCHAR2(10) |
X |
Identifier for each of the two MNSP Interconnector Links. Each link pertains to the direction from and to. |
|
PERIODID |
NUMBER(22,0) |
X |
Trading Interval number |
|
MAXAVAIL |
NUMBER(6,0) |
|
Maximum planned availability MW |
|
BANDAVAIL1 |
NUMBER(6,0) |
|
Band Availability for current Period |
|
BANDAVAIL2 |
NUMBER(6,0) |
|
Band Availability for current Period |
|
BANDAVAIL3 |
NUMBER(6,0) |
|
Band Availability for current Period |
|
BANDAVAIL4 |
NUMBER(6,0) |
|
Band Availability for current Period |
|
BANDAVAIL5 |
NUMBER(6,0) |
|
Band Availability for current Period |
|
BANDAVAIL6 |
NUMBER(6,0) |
|
Band Availability for current Period |
|
BANDAVAIL7 |
NUMBER(6,0) |
|
Band Availability for current Period |
|
BANDAVAIL8 |
NUMBER(6,0) |
|
Band Availability for current Period |
|
BANDAVAIL9 |
NUMBER(6,0) |
|
Band Availability for current Period |
|
BANDAVAIL10 |
NUMBER(6,0) |
|
Band Availability for current Period |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
FIXEDLOAD |
NUMBER(12,6) |
|
Inflexibility flag and availability. Fixed unit output MW. A value of zero means no fixed load so the unit is dispatched according to bid and market (rather than zero fixed load) |
|
RAMPUPRATE |
NUMBER(6,0) |
|
Ramp rate (MW / min) in the positive direction of flow for this MNSP link for this half-hour period |
|
PASAAVAILABILITY |
NUMBER(12,0) |
|
Allows for future use for energy bids, being the physical plant capability including any capability potentially available within 24 hours |
|
MR_CAPACITY |
NUMBER(6,0) |
|
Mandatory Restriction Offer amount |
|
Name |
|
|
Comment |
MR_DAYOFFER_STACK defines the Stack order for each version of the Acceptance Schedule, including all units submitting MR offers for that event. MR_DAYOFFER_STACK is the child to MR_EVENT_SCHEDULE, and parent to MR_PEROFFER_STACK. |
|
Once the offer cut off time has passed and as the schedule changes AEMO is obliged to accept MR capacity to meet the schedule in merit order according to the offers submitted. The relationship to a specific schedule, the merit order of submitted offers and accepted quantities for each trading interval are stored in the MR_EVENT_SCHEDULE, MR_DAYOFFER_STACK and MR_PEROFFER_STACK. MR_DAYOFFER_STACK sets includes all generators/MNSPs in the region that submitted an MR offer and a primary key reference to the Offer tables to identify the specific offer used for that unit. MR_DAYOFFER_STACK also includes a Stack Order, irrespective of whether the unit is required to meet the Schedule. MR_DAYOFFER_STACK updates are confidential on day of submission, with public exposure the next day. Source MR_DAYOFFER_STACK updates are ad hoc. Volume 100 rows per year |
|
Name |
Comment |
Value |
|
Visibility |
|
Private & Public Next-Day |
|
Name |
|
MR_DATE |
|
REGIONID |
|
STACK_POSITION |
|
VERSION_DATETIME |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
MR_DATE |
DATE |
X |
Mandatory Restriction imposition date |
|
REGIONID |
VARCHAR2(10) |
X |
Unique RegionID |
|
VERSION_DATETIME |
DATE |
X |
Allows many Stack versions |
|
STACK_POSITION |
NUMBER(3,0) |
X |
Loss Adjusted Offer Factor Stack order starting at 1 |
|
DUID |
VARCHAR2(10) |
|
Dispatchable Unit ID or LinkID |
|
AUTHORISED |
NUMBER(1,0) |
|
Confirms the unit is allowed to Contribute MR Capacity |
|
OFFER_SETTLEMENTDATE |
DATE |
|
Foreign key reference to XXXX_DayOffer.SettlementDate |
|
OFFER_OFFERDATE |
DATE |
|
Foreign key reference to XXXX_DayOffer.OfferDate |
|
OFFER_VERSIONNO |
NUMBER(3,0) |
|
Foreign key reference to XXXX_DayOffer.VersionNo |
|
OFFER_TYPE |
VARCHAR2(20) |
|
Source tables - ENERGY or MNSP |
|
LAOF |
NUMBER(16,6) |
|
Loss Adjusted Offer Factor = TLF times MR_Factor |
|
LASTCHANGED |
DATE |
|
Date and time the record was last inserted/modified |
|
Name |
|
|
Comment |
MR_EVENT defines an MR Event for a given region on a specific trading date. |
|
MR_EVENT defines a mandatory restriction event for a given region and trading date (04:30 to 04:00). Data within MR_EVENT includes the cut-off time for submission of MR offers for this event and a notification that the settlements figures are locked due to results from an independent expert being engaged to allocate settlement of a significant shortfall. If mandatory restrictions are defined in two regions on the same trading day, two MR events are defined. MR_EVENT data is public, so is available to all participants. Source MR_EVENT updates are ad hoc. Volume 1 Row per year |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
MR_DATE |
|
REGIONID |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
MR_DATE |
DATE |
X |
Mandatory Restriction imposition date |
|
REGIONID |
VARCHAR2(10) |
X |
Unique RegionID |
|
DESCRIPTION |
VARCHAR2(200) |
|
Description of MR |
|
AUTHORISEDDATE |
DATE |
|
Required for MR_Event to take effect |
|
AUTHORISEDBY |
VARCHAR2(20) |
|
Ignored - Tracking purpose only |
|
OFFER_CUT_OFF_TIME |
DATE |
|
Cut off after when new Offers and Scaling Factor changes are disallowed |
|
SETTLEMENT_COMPLETE |
NUMBER(1,0) |
|
Flag:1 = MR settlement figures locked. Do not recalculate, · 0 = MR settlements to be recalculated |
|
LASTCHANGED |
DATE |
|
Date/Time record inserted/modified |
|
Name |
|
|
Comment |
MR_EVENT_SCHEDULE defines the Stack version of the Acceptance Schedule and is the parent table to MR_DayOffer_Stack and MR_PerOffer_Stack. |
|
Once the offer cut off time has passed and as the schedule changes AEMO is obliged to accept MR capacity to meet the schedule in merit order according to the offers submitted. The relationship to a specific schedule, the merit order of submitted offers and accepted quantities for each trading interval are stored in the MR_Event_Schedule, MR_DayOffer_Stack and MR_PerOffer_Stack table. The MR_EVENT_SCHEDULE table determines the existence of an MR offer acceptance stack for a specific MR schedule of an MR event. The MR_EVENT_SCHEDULE table also tracks the time each stack is exercised. MR_EVENT_SCHEDULE is public and notifies the market that a new offer stack has been created. Source MR_EVENT_SCHEDULE updates are ad hoc. Volume 2 Rows per year |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
MR_DATE |
|
REGIONID |
|
VERSION_DATETIME |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
MR_DATE |
DATE |
X |
Mandatory Restriction imposition date |
|
REGIONID |
VARCHAR2(10) |
X |
Unique RegionID |
|
VERSION_DATETIME |
DATE |
X |
Effective Date/Time of Schedule; Allows many Stack versions |
|
DEMAND_EFFECTIVEDATE |
DATE |
|
Foreign key reference to ResDemandTrk.EffectiveDate |
|
DEMAND_OFFERDATE |
DATE |
|
Foreign key reference to ResDemandTrk.OfferDate |
|
DEMAND_VERSIONNO |
NUMBER(3,0) |
|
Foreign key reference to ResDemandTrk.VersionNo |
|
AUTHORISEDBY |
VARCHAR2(20) |
|
Authorised person confirming Offer Stack (AKA Acceptance) |
|
AUTHORISEDDATE |
DATE |
|
Date and time the Offer Stack confirmed |
|
LASTCHANGED |
DATE |
|
Date and time the record was inserted/modified |
|
Name |
|
|
Comment |
MR_PEROFFER_STACK defines the accepted capacity on a period basis for the Acceptance Schedule, is a child table to MR_DayOffer_Stack and only includes records or units with accepted_capacity > 0 for the specific period. |
|
Once the offer cut off time has passed and as the schedule changes AEMO is obliged to accept MR capacity to meet the schedule in merit order according to the offers submitted. The relationship to a specific schedule, the merit order of submitted offers and accepted quantities for each trading interval are stored in MR_Event_Schedule, MR_DayOffer_Stack and MR_PerOffer_Stack. MR_PEROFFER_STACK reports the accepted MR capacity (Accepted_Capacity) required from each unit for each trading interval. MR_PEROFFER_STACK is sparse so lists only units with accepted capacity > 0 for that trading interval. The Deducted_Capacity field allows the tracking and implementation of participant requested reductions to accepted MR capacity to be tracked and applied. MR_PEROFFER_STACK is reported confidentially to each participant to notify acceptance of an MR offer. Source MR_PEROFFER_STACK updates are ad hoc. Volume 4800 rows per year |
|
Name |
Comment |
Value |
|
Visibility |
|
Private & Public Next-Day |
|
Name |
|
MR_DATE |
|
PERIODID |
|
REGIONID |
|
STACK_POSITION |
|
VERSION_DATETIME |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
MR_DATE |
DATE |
X |
Mandatory Restriction imposition date |
|
REGIONID |
VARCHAR2(10) |
X |
Unique RegionID |
|
VERSION_DATETIME |
DATE |
X |
Allows many Period Stack versions for the one Scaling Factor stack |
|
STACK_POSITION |
NUMBER(3,0) |
X |
LAOF Stack order |
|
PERIODID |
NUMBER(3,0) |
X |
Trade Period for the MR Offer |
|
DUID |
VARCHAR2(10) |
|
Dispatchable Unit ID or LinkID. Only required here for CSV reports |
|
ACCEPTED_CAPACITY |
NUMBER(6,0) |
|
MR Capacity to be Dispatched |
|
DEDUCTED_CAPACITY |
NUMBER(6,0) |
|
Requested capacity reduction amount |
|
LASTCHANGED |
DATE |
|
Date and time the record was last inserted/modified |
|
Name |
|
|
Comment |
MTPASA_CASE_SET is obsolete from 2005 End of Year Release. The RUNTYPE added to the primary key of the detail tables for MTPASA allows for the different types of runs for each case. |
|
Source Update weekly. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
RUN_DATETIME |
|
RUN_NO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
RUN_DATETIME |
DATE |
X |
Date processing of the run begins. Generated from the solution file CASEID. |
|
RUN_NO |
NUMBER(3,0) |
X |
Unique run id. Generated from the solution file CASEID. |
|
CASESETID |
NUMBER(3,0) |
|
Unique id to link a set of cases run from the same inputs |
|
RUNTYPEID |
NUMBER(1,0) |
|
Unique id for type of run, being either |
|
LASTCHANGED |
DATE |
|
Date the solution was loaded |
|
Name |
|
|
Comment |
MTPASA_CASESOLUTION is obsolete from 2017 End of Year DM4.27 Release. |
|
MTPASA_CASESOLUTION is public data. Source MTPASA_CASESOLUTION is updated each MTPASA run (i.e. weekly). Volume Rows per week: 1 Rows per month: 5 Monthly space increment is based on storing all the MT PASA solutions. To store only the latest solution, divide these figures by 5 (number of weeks per month rounded up). |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
RUN_DATETIME |
|
RUN_NO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
RUN_DATETIME |
DATE |
X |
Date processing of the run begins. Generated from the solution file caseid |
|
RUN_NO |
NUMBER(3,0) |
X |
Unique run id. Generated from the solution file caseid |
|
PASAVERSION |
VARCHAR2(10) |
|
Version of the PASA solver used to solve this case |
|
RESERVECONDITION |
NUMBER(1,0) |
|
Low Reserve Condition (LRC) flag for the case (1 - LRC in the case, 0 - No LRCs in the case) for capacity run |
|
LORCONDITION |
NUMBER(1,0) |
|
Lack of Reserve Condition (LOR) flag for the case indicates the most severe condition in the case (3 = LOR3, 2 = LOR2, 1 = LOR1, 0 = No LOR) |
|
CAPACITYOBJFUNCTION |
NUMBER(12,3) |
|
Objective Function from the Capacity Adequacy run |
|
CAPACITYOPTION |
NUMBER(12,3) |
|
Not populated as of 2005 End of Year Release; was the demand forecast used for capacity adequacy assessment: 0 = no assessment, 1 = 10%, 2 = 50%, 3 = 90% |
|
MAXSURPLUSRESERVEOPTION |
NUMBER(12,3) |
|
Not populated as of 2005 End of Year Release; was the demand forecast used for assessment of Maximum surplus Reserve: 0 = no assessment, 1 = 10%, 2 = 50%, 3 = 90% |
|
MAXSPARECAPACITYOPTION |
NUMBER(12,3) |
|
Not populated as of 2005 End of Year Release; was the demand forecast used for assessment of Maximum Spare Capacity: 0 = no assessment, 1 = 10%, 2 = 50%, 3 = 90% |
|
INTERCONNECTORFLOWPENALTY |
NUMBER(12,3) |
|
The penalty for non-zero interconnector flow |
|
LASTCHANGED |
DATE |
|
Date and time the record was created or modified |
|
RUNTYPE |
VARCHAR2(50) |
|
Discontinued in Dec 2005; was description of the constraints included in this run, being either System Normal and Planned Outage Constraints or System Normal Constraints Only |
|
RELIABILITYLRCDEMANDOPTION |
NUMBER(12,3) |
|
Specifies the Probability of Exceedence (POE) demand forecast for Reliability LRC assessment (0 if no assessment, 10 for 10%, 50 for 50%, 90 for 90%) |
|
OUTAGELRCDEMANDOPTION |
NUMBER(12,3) |
|
Specifies the Probability of Exceedence (POE) demand forecast for outage LRC assessment (0 if no assessment, 10 for 10%, 50 for 50%, 90 for 90%) |
|
LORDEMANDOPTION |
NUMBER(12,3) |
|
Specifies the Probability of Exceedence (POE) demand forecast for LOR assessment (0 if no assessment, 10 for 10%, 50 for 50%, 90 for 90%) |
|
RELIABILITYLRCCAPACITYOPTION |
VARCHAR2(10) |
|
Generation Availability to be used in Reliability LRC run (either PASA or MARKET) |
|
OUTAGELRCCAPACITYOPTION |
VARCHAR2(10) |
|
Generation Availability to be used in Outage LRC run (either PASA or MARKET) |
|
LORCAPACITYOPTION |
VARCHAR2(10) |
|
Generation Availability to be used in LOR run (either PASA or MARKET) |
|
LORUIGFOPTION |
NUMBER(3,0) |
|
UIGF POE forecast availability used for this option |
|
RELIABILITYLRCUIGFOPTION |
NUMBER(3,0) |
|
UIGF POE forecast availability used for this option |
|
OUTAGELRCUIGFOPTION |
NUMBER(3,0) |
|
UIGF POE forecast availability used for this option |
|
Name |
|
|
Comment |
MTPASA_CONSTRAINTSOLUTION is obsolete from 2017 End of Year DM4.27 Release. |
|
MTPASA_CONSTRAINTSOLUTION is public data. Source MTPASA_CONSTRAINTSOLUTION is updated each MTPASA run (i.e. weekly). Volume Rows per week: 230 To store only the latest solution, divide these figures by 5. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
CONSTRAINTID |
|
DAY |
|
ENERGYBLOCK |
|
LDCBLOCK |
|
RUN_DATETIME |
|
RUN_NO |
|
RUNTYPE |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
RUN_DATETIME |
DATE |
X |
Date processing of the run begins |
|
RUN_NO |
NUMBER(3,0) |
X |
Unique run id. Generated from the solution file caseid |
|
ENERGYBLOCK |
DATE |
X |
Sunday at start of the week for this solutions energy block. Generated from the solution file energy block |
|
DAY |
DATE |
X |
Day this solution is for. Generated from the solution file periodid |
|
LDCBLOCK |
NUMBER(3,0) |
X |
LDC block this solution is for. Generated from the solution file periodid |
|
CONSTRAINTID |
VARCHAR2(20) |
X |
The unique identifier for the constraint |
|
CAPACITYRHS |
NUMBER(12,2) |
|
The RHS value in the capacity evaluation |
|
CAPACITYMARGINALVALUE |
NUMBER(12,2) |
|
Capacity adequacy assessment marginal value; 0 if not binding |
|
CAPACITYVIOLATIONDEGREE |
NUMBER(12,2) |
|
Capacity adequacy assessment violation degree; 0 if not violating |
|
LASTCHANGED |
DATE |
|
Date the solution was loaded |
|
RUNTYPE |
VARCHAR2(20) |
X |
Type of run. Values are RELIABILITY_LRC and OUTAGE_LRC |
|
Name |
|
|
Comment |
MTPASA_INTERCONNECTORSOLUTION is obsolete from 2017 End of Year DM4.27 Release. |
|
MTPASA_INTERCONNECTORSOLUTION is public so is available to all participants. Source MTPASA_INTERCONNECTORSOLUTION is updated each MTPASA run (i.e. weekly). Volume Rows per week: 35280 To store only the latest solution, divide these figures by 5 (number of weeks per month rounded up). |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
DAY |
|
ENERGYBLOCK |
|
INTERCONNECTORID |
|
LDCBLOCK |
|
RUN_DATETIME |
|
RUN_NO |
|
RUNTYPE |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
RUN_DATETIME |
DATE |
X |
Date processing of the run begins |
|
RUN_NO |
NUMBER(3,0) |
X |
Unique run id. Generated from the solution file caseid |
|
ENERGYBLOCK |
DATE |
X |
Sunday at start of the week for this solutions energy block. Generated from the solution file energy block |
|
DAY |
DATE |
X |
Day this solution is for. Generated from the solution file periodid |
|
LDCBLOCK |
NUMBER(3,0) |
X |
LDC block this solution is for. Generated from the solution file periodid |
|
INTERCONNECTORID |
VARCHAR2(10) |
X |
The unique identifier for the interconnector |
|
CAPACITYMWFLOW |
NUMBER(12,2) |
|
Interconnector loading level (MW) that can be reached in case of capacity scarcity in neighbouring regions subject to network and energy constraints |
|
CAPACITYMARGINALVALUE |
NUMBER(12,2) |
|
Capacity adequacy assessment marginal value; 0 if not binding |
|
CAPACITYVIOLATIONDEGREE |
NUMBER(12,2) |
|
Capacity adequacy assessment violation degree, 0 if not violating; where CapacityMWFLow <= export + violation Degree (Deficit)CapacityMWFLow >= import + CapacityViolationDegree (Deficit) |
|
CALCULATEDEXPORTLIMIT |
NUMBER(12,2) |
|
Calculated Interconnector limit of exporting energy on the basis of invoked constraints and static interconnector export limit |
|
CALCULATEDIMPORTLIMIT |
NUMBER(12,2) |
|
Calculated Interconnector limit of importing energy on the basis of invoked constraints and static interconnector import limit. Note unlike the input interconnector import limit this is a directional quantity and should be defined with respect to the interconnector flow |
|
LASTCHANGED |
DATE |
|
Date the solution was loaded |
|
RUNTYPE |
VARCHAR2(20) |
X |
Type of run. Values are RELIABILITY_LRC and OUTAGE_LRC |
|
EXPORTLIMITCONSTRAINTID |
VARCHAR2(20) |
|
ID of the constraint that sets the Interconnector Export Limit |
|
IMPORTLIMITCONSTRAINTID |
VARCHAR2(20) |
|
ID of the constraint that sets the Interconnector Import Limit |
|
Name |
|
|
Comment |
MTPASA_CASESOLUTION is obsolete from 2017 End of Year DM4.27 Release. |
|
MTPASA_REGIONSOLUTION is public so is available to all participants. Source MTPASA_REGIONSOLUTION is updated each MTPASA run (i.e. weekly). Volume Rows per week: 29400 To store only the latest solution, divide these figures by 5 (number of weeks per month rounded up). |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
DAY |
|
ENERGYBLOCK |
|
LDCBLOCK |
|
REGIONID |
|
RUN_DATETIME |
|
RUN_NO |
|
RUNTYPE |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
RUN_DATETIME |
DATE |
X |
Date processing of the run begins |
|
RUN_NO |
NUMBER(3,0) |
X |
Unique run id. Generated from the solution file caseid |
|
ENERGYBLOCK |
DATE |
X |
Sunday at start of the week for this solutions energy block. Generated from the solution file energy block |
|
DAY |
DATE |
X |
Day this solution is for. Generated from the solution file periodid |
|
LDCBLOCK |
NUMBER(3,0) |
X |
LDC block this solution is for. Generated from the solution file periodid |
|
REGIONID |
VARCHAR2(10) |
X |
The unique region identifier |
|
DEMAND10 |
NUMBER(12,2) |
|
Input value for 10% probability demand |
|
RESERVEREQ |
NUMBER(12,2) |
|
Not used from 21/05/2010. Prior to 21/05/2010: Input reserve requirement |
|
CAPACITYREQ |
NUMBER(12,2) |
|
Not used from 21/05/2010. Prior to 21/05/2010: CA Demand + Reserve Requirement |
|
ENERGYREQDEMAND10 |
NUMBER(12,2) |
|
Sum of: (Region Period Demand - given Demand10)/PeriodLength(sum by Energy Block, entered in first period of energy block, GWh) |
|
UNCONSTRAINEDCAPACITY |
NUMBER(12,0) |
|
Region energy unconstrained MW capacity subject to network security constraints |
|
CONSTRAINEDCAPACITY |
NUMBER(12,0) |
|
Region energy constrained MW capacity subject to energy and network security constraints |
|
NETINTERCHANGEUNDERSCARCITY |
NUMBER(12,2) |
|
Calculated in capacity adequacy evaluation: Export if > 0, Import if < 0. |
|
SURPLUSCAPACITY |
NUMBER(12,2) |
|
Regional surplus capacity MW, +/- values indicate surplus/deficit capacity |
|
SURPLUSRESERVE |
NUMBER(12,2) |
|
Not used from 21/05/2010. Prior to 21/05/2010: Regional reserve surplus. +/-0 values indicate surplus/deficit reserve |
|
RESERVECONDITION |
NUMBER(1,0) |
|
The regional reserve condition: 0 = Adequate, 1 = LRC |
|
MAXSURPLUSRESERVE |
NUMBER(12,2) |
|
The Maximum generation (MW) that could be withdrawn from this region without incurring a Low Reserve Condition. |
|
MAXSPARECAPACITY |
NUMBER(12,2) |
|
The Maximum Spare Capacity evaluated for this region in this period. Calculated for each region in turn |
|
LORCONDITION |
NUMBER(1,0) |
|
The LOR Condition determined from the Maximum Spare Capacity value: 0 = no condition, 1 = LOR1 condition, 2 = LOR2 condition, 3 = LOR3 condition |
|
AGGREGATECAPACITYAVAILABLE |
NUMBER(12,2) |
|
Sum of MAXAVAIL quantities offered by all Scheduled Generators in a given Region for a given PERIODID. |
|
AGGREGATESCHEDULEDLOAD |
NUMBER(12,2) |
|
Sum of MAXAVAIL quantities bid by of all Scheduled Loads in a given Region for a given PERIODID. |
|
LASTCHANGED |
DATE |
|
Date the solution was loaded |
|
AGGREGATEPASAAVAILABILITY |
NUMBER(12,0) |
|
Sum of PASAAVAILABILITY quantities offered by all Scheduled Generators in a given Region for a given PERIODID. |
|
RUNTYPE |
VARCHAR2(20) |
X |
Type of run. Values are RELIABILITY_LRC and OUTAGE_LRC |
|
CALCULATEDLOR1LEVEL |
NUMBER(16,6) |
|
Region Reserve Level for LOR1 used. Can be static value or calculated value if an interconnector is a credible contingency |
|
CALCULATEDLOR2LEVEL |
NUMBER(16,6) |
|
Region Reserve Level for LOR2 used. Can be static value or calculated value if an interconnector is a credible contingency |
|
MSRNETINTERCHANGEUNDERSCARCITY |
NUMBER(12,2) |
|
Net interconnector flow from the region for this interval from the MSR assessment |
|
LORNETINTERCHANGEUNDERSCARCITY |
NUMBER(12,2) |
|
Net interconnector flow from the region for this interval from the LOR assessment |
|
TOTALINTERMITTENTGENERATION |
NUMBER(15,5) |
|
Allowance made for non-scheduled generation in the demand forecast (MW). |
|
DEMAND50 |
NUMBER(12,2) |
|
Input value for 50% probability demand |
|
DEMAND_AND_NONSCHEDGEN |
NUMBER(15,5) |
|
Sum of Cleared Scheduled generation, imported generation (at the region boundary) and allowances made for non-scheduled generation (MW). |
|
UIGF |
NUMBER(12,2) |
|
Regional aggregated Unconstrained Intermittent Generation Forecast of Semi-scheduled generation (MW). |
|
SEMISCHEDULEDCAPACITY |
NUMBER(12,2) |
|
Aggregate Regional UIGF availability |
|
LOR_SEMISCHEDULEDCAPACITY |
NUMBER(12,2) |
|
Aggregate Regional UIGF availability for LOR |
|
DEFICITRESERVE |
NUMBER(16,6) |
|
Regional reserve deficit (MW) |
|
MAXUSEFULRESPONSE |
NUMBER(12,2) |
|
The Maximum market response (MW) needed for the region to eliminate a Low Reserve Condition (LRC) |
|
MURNETINTERCHANGEUNDERSCARCITY |
NUMBER(12,2) |
|
Net interconnector flow from the region for this interval from the MRR assessment |
|
LORTOTALINTERMITTENTGENERATION |
NUMBER(15,5) |
|
Allowance made for non-scheduled generation in the LOR assessment |
|
ENERGYREQDEMAND50 |
number(12,2) |
|
Sum of: (Region Period Demand - given Demand50)/PeriodLength (sum by Energy Block, entered in first period of energy block, GWh) |
|
Name |
|
|
Comment |
MTPASA_RESERVELIMITSOLUTION is obsolete from 2017 End of Year DM4.27 Release. |
|
Source MTPASA_RESERVELIMITSOLUTION is updated each MTPASA run (i.e. weekly). Volume 400,000 rows per year |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
DAY |
|
ENERGYBLOCK |
|
LDCBLOCK |
|
RESERVELIMITID |
|
RUN_DATETIME |
|
RUN_NO |
|
RUNTYPE |
|
Name |
Data Type |
Mandatory |
Comment |
|
RUN_DATETIME |
DATE |
X |
Date processing of the run begins |
|
RUN_NO |
NUMBER(3,0) |
X |
Unique run ID. Generated from the solution file Case ID. |
|
RUNTYPE |
VARCHAR2(20) |
X |
Type of run. Values are RELIABILITY_LRC and OUTAGE_LRC |
|
ENERGYBLOCK |
DATE |
X |
Sunday at start of the week for this solutions energy block. Generated from the solution file energy block. |
|
DAY |
DATE |
X |
Day this solution is for. Generated from the solution file period id. |
|
LDCBLOCK |
NUMBER(3,0) |
X |
Load Duration Curve block this solution is for. Generated from the solution file period id. |
|
RESERVELIMITID |
VARCHAR2(20) |
X |
The unique identifier of the MT PASA LRC Reserve Requirement. |
|
MARGINALVALUE |
NUMBER(16,6) |
|
Marginal Value of the Reserve Requirement Constraint. A non-zero value indicates that the reserve requirement is binding. |
|
LASTCHANGED |
DATE |
|
Timestamp the record was last modified. |
|
Name |
|
|
Comment |
MTPASACONSTRAINTSOLUTION_D sets out MT PASA constraint solution results, where constraints are binding. |
|
MTPASACONSTRAINTSOLUTION_D is public data. Source MTPASACONSTRAINTSOLUTION_D updates weekly. Volume Each run overwrites data from previous runs for all future dates. Growth is one record per newly effective constraint. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
CONSTRAINT_ID |
|
DATETIME |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
DATETIME |
DATE |
X |
Date constraint is binding |
|
CONSTRAINT_ID |
VARCHAR2(20) |
X |
Constraint Identifier |
|
DEGREE_OF_VIOLATION |
NUMBER(16,6) |
|
The degree in MW by which the constraint would be violated if the solution could not solve. This could be due to incorrect penalties etc. This figure should always be 0. |
|
LASTCHANGED |
DATE |
|
Last changed data and time. |
|
RUN_DATETIME |
DATE |
|
The run date and time |
|
Name |
|
|
Comment |
MTPASAINTERCONNECTORSOLUTION_D shows interconnector results for MT PASA, shown region by region. |
|
MTPASAINTERCONNECTORSOLUTION_D is public data. Source MTPASAINTERCONNECTORSOLUTION_D updates weekly. Volume Each run overwrites data from previous runs for all future dates. Growth is one record per day per interconnector. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
DATETIME |
|
INTERCONNECTOR_ID |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
DATETIME |
DATE |
X |
Date of results. One record for each day for next two years. |
|
INTERCONNECTOR_ID |
VARCHAR2(12) |
X |
Interconnector Identifier |
|
POSITIVE_INTERCONNECTOR_FLOW |
NUMBER(16,6) |
|
The MW flow out |
|
POSITIVE_TRANSFER_LIMITS |
NUMBER(16,6) |
|
The MW transfer limits out |
|
POSITIVE_BINDING |
VARCHAR2(10) |
|
Indication of a binding limit in the out direction |
|
NEGATIVE_INTERCONNECTOR_FLOW |
NUMBER(16,6) |
|
The MW flow in |
|
NEGATIVE_TRANSFER_LIMITS |
NUMBER(16,6) |
|
the MW transfer limits in |
|
NEGATIVE_BINDING |
VARCHAR2(10) |
|
Indication of a binding limit in the in direction |
|
LASTCHANGED |
DATE |
|
Last change date and time |
|
RUN_DATETIME |
DATE |
|
The run date and time |
|
Name |
|
|
Comment |
MTPASAREGIONSOLUTION_D shows region results for MT PASA, showing predicted demand and any capacity limits. |
|
MTPASAREGIONSOLUTION_D is public data. Source MTPASAREGIONSOLUTION_D updates weekly. Volume Each run overwrites data from previous runs for all future dates. Growth is one record per day per region. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
DATETIME |
|
REGION_ID |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
DATETIME |
DATE |
X |
Date of results. One record for each day for next two years. |
|
REGION_ID |
VARCHAR2(12) |
X |
Region Identifier |
|
RUN_DATETIME |
DATE |
|
The run date and time |
|
RESERVE_CONDITION |
VARCHAR2(50) |
|
The regional reserve condition |
|
RESERVE_SURPLUS |
NUMBER(16,6) |
|
Regional reserve surplus value |
|
CAPACITY_REQUIREMENT |
NUMBER(16,6) |
|
Capacity in MW required to meet demand |
|
MINIMUM_RESERVE_REQUIREMENT |
NUMBER(16,6) |
|
Minimum required regional reserve value |
|
REGION_DEMAND_10POE |
NUMBER(16,6) |
|
Regional 10% Probability of Exceedance demand forecast value |
|
DEMAND_MINUS_SCHEDULED_LOAD |
NUMBER(16,6) |
|
Regional demand minus the scheduled load value |
|
CONSTRAINED_CAPACITY |
NUMBER(16,6) |
|
The total regional capacity due to energy and network constraints |
|
UNCONSTRAINED_CAPACITY |
NUMBER(16,6) |
|
The total regional capacity, subject to network constraints. |
|
NET_INTERCHANGE |
NUMBER(16,6) |
|
Regional net MW import via interconnectors |
|
ENERGY_REQUIREMENT_10POE |
NUMBER(16,6) |
|
Regional energy required to meet demand |
|
REPORTED_BLOCK_ID |
NUMBER(16,6) |
|
The load duration curve block that is recorded in the report. |
|
LASTCHANGED |
DATE |
|
Last change date and time. |
|
Name |
|
|
Comment |
OARTRACK shows an audit trail of bids for a particular settlement day. Corrupt bids do not update OARTRACK, but are just in OFFERFILETRK. |
|
Not in Use - discontinued 16/11/2003 Status The OARTRACK table is obsolete. Please refer to BIDOFFERFILETRK. As a transition assist, the OARTRACK views expose data based on BIDOFFERFILETRK. Source Own (confidential) data updates as bids are processed. All bids are available as part of next day market data. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private & Public Next-Day |
|
Name |
|
OFFERDATE |
|
PARTICIPANTID |
|
SETTLEMENTDATE |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
|
PARTICIPANTID |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Settlement date |
|
OFFERDATE |
DATE |
X |
Date file offered |
|
VERSIONNO |
NUMBER(3,0) |
X |
Version no for this offer date |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Unique participant identifier |
|
FILENAME |
VARCHAR2(40) |
|
Load file name |
|
AUTHORISEDDATE |
DATE |
|
Date record authorised |
|
AUTHORISEDBY |
VARCHAR2(10) |
|
User authorising record |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
OFFERFILETRK shows an audit trail of all bid files submitted containing energy bids, including corrupt bids/rebids. |
|
Status OFFERFILETRK is obsolete. Please see BIDOFFERFILETRK. Source OFFERFILETRK is obsolete. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
FILENAME |
|
OFFERDATE |
|
PARTICIPANTID |
|
Name |
|
LASTCHANGED |
|
Name |
|
PARTICIPANTID |
|
Name |
Data Type |
Mandatory |
Comment |
|
OFFERDATE |
DATE |
X |
Date file offered |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Unique participant identifier |
|
STATUS |
VARCHAR2(10) |
|
Load status [SUCCESSFUL/CORRUPT] |
|
ACKFILENAME |
VARCHAR2(40) |
|
Acknowledge file name |
|
ENDDATE |
DATE |
|
Not used |
|
FILENAME |
VARCHAR2(40) |
X |
Load file name |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
OFFERGOVDATA sets out reoffers of governor (6 and 60 second FCAS) availability. |
|
Not in Use - discontinued 30/09/2001 Confidential to participant Source Updated as reoffers process. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
CONTRACTID |
|
EFFECTIVEDATE |
|
PERIODID |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
|
CONTRACTID |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTID |
VARCHAR2(10) |
X |
Contract Version No. |
|
EFFECTIVEDATE |
DATE |
X |
Effective Date of Re-Offer |
|
VERSIONNO |
NUMBER(3,0) |
X |
Version No. of Re-Offer |
|
PERIODID |
NUMBER(3,0) |
X |
Market day trading interval number |
|
SEC6AVAILUP |
NUMBER(6,0) |
|
Availability for 6 Second Raise (0 or 1. '0'= unavailable, '1' = available) |
|
SEC6AVAILDOWN |
NUMBER(6,0) |
|
Availability for 6 Second Lower (0 or 1) |
|
SEC60AVAILUP |
NUMBER(6,0) |
|
Availability for 60 Second Raise (0 or 1) |
|
SEC60AVAILDOWN |
NUMBER(6,0) |
|
Availability for 60 Second Lower (0 or 1) |
|
AUTHORISEDDATE |
DATE |
|
Date Contract was Authorised |
|
AUTHORISEDBY |
VARCHAR2(15) |
|
User Name |
|
FILENAME |
VARCHAR2(40) |
|
File name of Re-Offer file |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
OFFERULOADINGDATA shows reoffers of rapid unit loading capability. |
|
Not in Use - discontinued 30/09/2001 OFFERULOADINGDATA data is confidential to each participant. Source OFFERULOADINGDATA updated as reoffers processed. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
CONTRACTID |
|
EFFECTIVEDATE |
|
PERIODID |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
|
CONTRACTID |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTID |
VARCHAR2(10) |
X |
Contract identifier |
|
EFFECTIVEDATE |
DATE |
X |
Effective date of contract |
|
VERSIONNO |
NUMBER(3,0) |
X |
Version No of contract |
|
AVAILABLELOAD |
NUMBER(4,0) |
|
Available load |
|
AUTHORISEDDATE |
DATE |
|
Authorised date |
|
AUTHORISEDBY |
VARCHAR2(15) |
|
Authorised by |
|
FILENAME |
VARCHAR2(40) |
|
Name of reoffer file |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
PERIODID |
NUMBER(3,0) |
X |
Market day trading interval number |
|
Name |
|
|
Comment |
OFFERUNLOADINGDATA shows reoffers of rapid unit unloading capability. |
|
Not in Use - discontinued 30/09/2001 OFFERUNLOADINGDATA data is confidential to the relevant participant. Source OFFERUNLOADINGDATA updates as reoffers processed. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
CONTRACTID |
|
EFFECTIVEDATE |
|
PERIODID |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
|
CONTRACTID |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTID |
VARCHAR2(10) |
X |
Contract identifier |
|
EFFECTIVEDATE |
DATE |
X |
Market date of reoffer |
|
VERSIONNO |
NUMBER(3,0) |
X |
Version No of reoffer |
|
AVAILABLELOAD |
NUMBER(4,0) |
|
Available load |
|
AUTHORISEDDATE |
DATE |
|
Authorised date |
|
AUTHORISEDBY |
VARCHAR2(15) |
|
Authorised by |
|
FILENAME |
VARCHAR2(40) |
|
Name of reoffer file |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
PERIODID |
NUMBER(3,0) |
X |
Market day trading interval number |
|
Name |
|
|
Comment |
PASACASESOLUTION sets out ST PASA case listing providing details of each STPASA case run. |
|
PASACASESOLUTION is obsolete on 27 March 2002 PASACASESOLUTION is public data, so is available to all participants. Source PASACASESOLUTION is not used; was updated every 2 hours. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
CASEID |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
CASEID |
VARCHAR2(20) |
X |
PASA Case Identifier |
|
SOLUTIONCOMPLETE |
NUMBER(16,6) |
|
Not used |
|
PASAVERSION |
NUMBER(27,10) |
|
Software version identifier |
|
EXCESSGENERATION |
NUMBER(16,6) |
|
Excess generation detected flag |
|
DEFICITCAPACITY |
NUMBER(16,6) |
|
Deficit capacity detected flag |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
DATETIME |
DATE |
|
Scheduled date and time of the run |
|
Name |
|
|
Comment |
PASACONSTRAINTSOLUTION records the latest binding STPASA constraint details for each period. For each solution, the latest recalculation for each period overwrites the previous entry. |
|
PASACONSTRAINTSOLUTION is obsolete on 27 March 2002 PASACONSTRAINTSOLUTION is public data, so is available to all participants. Source PASACONSTRAINTSOLUTION is not used; was updated every 2 hours. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
CONSTRAINTID |
|
PERIODID |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
CASEID |
VARCHAR2(20) |
X |
PASA Case Identifier |
|
CONSTRAINTID |
VARCHAR2(20) |
X |
Generic Constraint Id |
|
PERIODID |
VARCHAR2(20) |
X |
PASA Interval (48 half hours) |
|
CAPACITYMARGINALVALUE |
NUMBER(16,6) |
|
Binding value of capacity and adequacy (if insufficient to measure) |
|
CAPACITYVIOLATIONDEGREE |
NUMBER(16,6) |
|
Deficit MW of surplus capacity |
|
EXCESSGENMARGINALVALUE |
NUMBER(16,6) |
|
Binding value of dispatch generator above aggregate self dispatch |
|
EXCESSGENVIOLATIONDEGREE |
NUMBER(16,6) |
|
Deficit of generator above aggregate self dispatch level |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
DATETIME |
DATE |
|
Date and time of the end of the period |
|
Name |
|
|
Comment |
PASAINTERCONNECTORSOLUTION records ST PASA interconnector solutions for the latest period. |
|
PASAINTERCONNECTORSOLUTION is obsolete on 27 March 2002 PASAINTERCONNECTORSOLUTION is public data, so is available to all participants. Source PASAINTERCONNECTORSOLUTION is unused; was updated every 2 hours. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
INTERCONNECTORID |
|
PERIODID |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
CASEID |
VARCHAR2(20) |
X |
PASA Case Identifier |
|
INTERCONNECTORID |
VARCHAR2(10) |
X |
Interconnector Id |
|
PERIODID |
VARCHAR2(20) |
X |
PASA Interval (48 half hours) |
|
CAPACITYMWFLOW |
NUMBER(16,6) |
|
Capacity MW flow |
|
CAPACITYMARGINALVALUE |
NUMBER(16,6) |
|
Marginal value in capacity |
|
CAPACITYVIOLATIONDEGREE |
NUMBER(16,6) |
|
Violation value in capacity |
|
EXCESSGENMWFLOW |
NUMBER(16,6) |
|
Excess generation MW flow |
|
EXCESSGENMARGINALVALUE |
NUMBER(16,6) |
|
Marginal value in excess generation |
|
EXCESSGENVIOLATIONDEGREE |
NUMBER(16,6) |
|
Violation value in excess generation |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
IMPORTLIMIT |
NUMBER(15,5) |
|
Calculated import limit |
|
EXPORTLIMIT |
NUMBER(15,5) |
|
Calculated export limit |
|
DATETIME |
DATE |
|
Date and time of the end of the period |
|
Name |
|
|
Comment |
PASAREGIONSOLUTION shows the Regional solution for ST PASA showing reserves for each half-hour period. This table (PASAREGIONSOLUTION_D) shows the latest calculated result for each period. |
|
PASAREGIONSOLUTION is obsolete on 27 March 2002. PASAREGIONSOLUTION is public data, so is available to all participants. Source PASAREGIONSOLUTION is not used; was updated every 2 hours. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
PERIODID |
|
REGIONID |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
CASEID |
VARCHAR2(20) |
X |
PASA Case Identifier |
|
REGIONID |
VARCHAR2(10) |
X |
Region Identifier |
|
PERIODID |
VARCHAR2(20) |
X |
PASA Interval (48 half hours) |
|
DEMAND10 |
NUMBER(16,6) |
|
10% exceedence forecast |
|
DEMAND50 |
NUMBER(16,6) |
|
50% exceedence forecast |
|
DEMAND90 |
NUMBER(16,6) |
|
90% exceedence forecast |
|
UNCONSTRAINEDCAPACITY |
NUMBER(16,6) |
|
Unconstrained capacity |
|
CONSTRAINEDCAPACITY |
NUMBER(16,6) |
|
Constrained capacity |
|
CAPACITYSURPLUS |
NUMBER(16,6) |
|
Surplus capacity |
|
RESERVEREQ |
NUMBER(16,6) |
|
Reserve requirement |
|
RESERVECONDITION |
NUMBER(16,6) |
|
Reserve condition |
|
RESERVESURPLUS |
NUMBER(16,6) |
|
Reserve surplus |
|
LOADREJECTIONRESERVEREQ |
NUMBER(16,6) |
|
Load rejection reserve requirement |
|
LOADREJECTIONRESERVESURPLUS |
NUMBER(16,6) |
|
Load rejection reserve surplus |
|
NETINTERCHANGEUNDEREXCESS |
NUMBER(16,6) |
|
Net interchange excess |
|
NETINTERCHANGEUNDERSCARCITY |
NUMBER(16,6) |
|
Net interchange scarcity |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
EXCESSGENERATION |
NUMBER(22,0) |
|
Excess generation in period OR Deficit generation if VoLL |
|
ENERGYREQUIRED |
NUMBER(15,5) |
|
Total amount of energy required for the reported day |
|
CAPACITYREQUIRED |
NUMBER(15,5) |
|
Trading interval demand for the region that has a 10% probability of being exceeded, plus the medium term capacity reserve standard. |
|
DATETIME |
DATE |
|
Date and time of the end of the period |
|
Name |
|
|
Comment |
PEROFFER contains the half-hourly period details of daily bids and rebids, to be used in conjunction with DAYOFFER. These views provide period varying details such as rate of change up (ROCUP), rate of change down (ROCDOWN) and band quantities (BANDAVAIL from 1 to 10). |
|
Status PEROFFER is obsolete. please see BIDPEROFFER. For a transition period, PEROFFER data continued to exist, being based on BIDPEROFFER. Source PEROFFER is obsolete; confidential data was updated for each bid and rebid, with full visibility of rest of market were updated daily as part of next day data. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private & Public Next-Day |
|
Name |
|
DUID |
|
OFFERDATE |
|
PERIODID |
|
SETTLEMENTDATE |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
|
DUID |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Market date starting at 04:00am |
|
DUID |
VARCHAR2(10) |
X |
Dispatchable Unit identifier |
|
OFFERDATE |
DATE |
X |
Offer date made |
|
PERIODID |
NUMBER(3,0) |
X |
Period identifier |
|
VERSIONNO |
NUMBER(3,0) |
X |
Version number of offer |
|
SELFDISPATCH |
NUMBER(12,6) |
|
Not used |
|
MAXAVAIL |
NUMBER(12,6) |
|
Maximum plant availability |
|
FIXEDLOAD |
NUMBER(12,6) |
|
Fixed unit output MW. A value of zero means no fixed load so the unit is dispatched according to bid and market (rather than zero fixed load) |
|
ROCUP |
NUMBER(6,0) |
|
MW/min for raise |
|
ROCDOWN |
NUMBER(6,0) |
|
MW/Min for lower |
|
BANDAVAIL1 |
NUMBER(6,0) |
|
Availability at price band 1 |
|
BANDAVAIL2 |
NUMBER(6,0) |
|
Availability at price band 2 |
|
BANDAVAIL3 |
NUMBER(6,0) |
|
Availability at price band 3 |
|
BANDAVAIL4 |
NUMBER(6,0) |
|
Availability at price band 4 |
|
BANDAVAIL5 |
NUMBER(6,0) |
|
Availability at price band 5 |
|
BANDAVAIL6 |
NUMBER(6,0) |
|
Availability at price band 6 |
|
BANDAVAIL7 |
NUMBER(6,0) |
|
Availability at price band 7 |
|
BANDAVAIL8 |
NUMBER(6,0) |
|
Availability at price band 8 |
|
BANDAVAIL9 |
NUMBER(6,0) |
|
Availability at price band 9 |
|
BANDAVAIL10 |
NUMBER(6,0) |
|
Availability at price band 10 |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
PASAAVAILABILITY |
NUMBER(12,0) |
|
The physical plant capability including any capability potentially available within 24 hours. |
|
MR_CAPACITY |
NUMBER(6,0) |
|
Mandatory Restriction Offer amount |
|
Name |
|
|
Comment |
PEROFFER_D contains the half-hourly period details of daily bids and rebids, to be used in conjunction with DAYOFFER_D. These views provide period varying details such as rate of change up (ROCUP), rate of change down (ROCDOWN) and band quantities (BANDAVAIL from 1 to 10). |
|
Not in Use - discontinued 16/11/2003 Status PEROFFER and its related views are obsolete. please see BIDPEROFFER views. For a transition period, the PEROFFER views exist, being based on the BIDPEROFFER table. Source PEROFFER is obsolete; confidential data was updated for each bid and rebid, with full visibility of rest of market were updated daily as part of next day data. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
DUID |
|
OFFERDATE |
|
PERIODID |
|
SETTLEMENTDATE |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
|
DUID |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Market date starting at 04:00am |
|
DUID |
VARCHAR2(10) |
X |
Dispatchable Unit identifier |
|
OFFERDATE |
DATE |
X |
Offer date made |
|
PERIODID |
NUMBER(3,0) |
X |
Period identifier |
|
VERSIONNO |
NUMBER(3,0) |
X |
Version number of offer |
|
SELFDISPATCH |
NUMBER(12,6) |
|
Not used |
|
MAXAVAIL |
NUMBER(12,6) |
|
Maximum plant availability |
|
FIXEDLOAD |
NUMBER(12,6) |
|
Fixed unit output MW. A value of zero means no fixed load so the unit is dispatched according to bid and market (rather than zero fixed load) |
|
ROCUP |
NUMBER(6,0) |
|
MW/min for raise |
|
ROCDOWN |
NUMBER(6,0) |
|
MW/Min for lower |
|
BANDAVAIL1 |
NUMBER(6,0) |
|
Availability at price band 1 |
|
BANDAVAIL2 |
NUMBER(6,0) |
|
Availability at price band 2 |
|
BANDAVAIL3 |
NUMBER(6,0) |
|
Availability at price band 3 |
|
BANDAVAIL4 |
NUMBER(6,0) |
|
Availability at price band 4 |
|
BANDAVAIL5 |
NUMBER(6,0) |
|
Availability at price band 5 |
|
BANDAVAIL6 |
NUMBER(6,0) |
|
Availability at price band 6 |
|
BANDAVAIL7 |
NUMBER(6,0) |
|
Availability at price band 7 |
|
BANDAVAIL8 |
NUMBER(6,0) |
|
Availability at price band 8 |
|
BANDAVAIL9 |
NUMBER(6,0) |
|
Availability at price band 9 |
|
BANDAVAIL10 |
NUMBER(6,0) |
|
Availability at price band 10 |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
PASAAVAILABILITY |
NUMBER(12,0) |
|
The physical plant capability including any capability potentially available within 24 hours. |
|
MR_CAPACITY |
NUMBER(6,0) |
|
Mandatory Restriction Offer amount |
|
Name |
|
|
Comment |
PREDISPATCHBIDTRK contains an audit trail of bids used in each predispatch run. Where predispatch is over 2 days, two bids are listed. |
|
Status PREDISPATCHOFFERTRK and related views are obsolete. Please see tables and views related to BIDPEROFFER. Source Own (confidential) data shows via inserts with every thirty-minute predispatch. Daily update after close of day shows all market bids for the closed day. Period date and time |
|
Name |
Comment |
Value |
|
Visibility |
|
Private & Public Next-Day |
|
Name |
|
DUID |
|
PERIODID |
|
PREDISPATCHSEQNO |
|
Name |
|
LASTCHANGED |
|
Name |
|
DUID |
|
LASTCHANGED |
|
Name |
|
DUID |
|
SETTLEMENTDATE |
|
Name |
Data Type |
Mandatory |
Comment |
|
PREDISPATCHSEQNO |
VARCHAR2(20) |
X |
Unique identifier of predispatch run in the form YYYYMMDDPP with 01 at 04:30 |
|
DUID |
VARCHAR2(10) |
X |
Dispatchable Unit identifier |
|
PERIODID |
VARCHAR2(20) |
X |
PERIODID is just a period count, starting from 1 for each predispatch run. Use DATETIME to determine half hour period. |
|
BIDTYPE |
VARCHAR2(10) |
|
Bid type (daily, default or rebid) |
|
OFFERDATE |
DATE |
|
Offer date for bid |
|
VERSIONNO |
NUMBER(3,0) |
|
Version no of offer for the offer date |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
SETTLEMENTDATE |
DATE |
|
Market Settlement Date |
|
DATETIME |
DATE |
|
Period date and time |
|
Name |
|
|
Comment |
REALLOCATIONDETAILS sets out specific reallocation agreements. |
|
Not in Use - discontinued 10/06/2004 Source As changes occur. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
EFFECTIVEDATE |
|
REALLOCATIONID |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
REALLOCATIONID |
VARCHAR2(20) |
X |
Identification of the reallocation agreement |
|
EFFECTIVEDATE |
DATE |
X |
Calendar settlement date the agreement starts from |
|
VERSIONNO |
NUMBER(3,0) |
X |
Version number on the effective date, highest is the reallocation used on that date |
|
AUTHORISEDDATE |
DATE |
|
Date the entry was authorised |
|
AUTHORISEDBY |
VARCHAR2(10) |
|
User who authorised the record |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
REALLOCATIONINTERVALS identifies the the reallocation agreement and provides the corresponding reallocation profiles submitted by the participant and accepted by AEMO |
|
Not in Use - discontinued 10/06/2004 Source Only populated if a reallocation contract has been submitted and accepted by AEMO. Volume Generally 144 rows are inserted by week. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
EFFECTIVEDATE |
|
PERIODID |
|
REALLOCATIONID |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
REALLOCATIONID |
VARCHAR2(20) |
X |
Identification of the reallocation agreement |
|
EFFECTIVEDATE |
DATE |
X |
Date the agreement starts from |
|
VERSIONNO |
NUMBER(3,0) |
X |
Version number on the effective date, highest is the reallocation used on that date |
|
PERIODID |
NUMBER(3,0) |
X |
Period number where period 1 use the half hour ended 00:30 EST |
|
REALLOCATIONVALUE |
NUMBER(6,2) |
|
Either $ or MWh depending on agreement type |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
REALLOCATIONS shows reallocation agreement identifiers with corresponding start and end dates of submitted reallocations as accepted by AEMO. |
|
Not in Use - discontinued 10/06/2004 Source This view is populated upon submission of a reallocation contract and accepted by AEMO. Volume Generally 3 rows are inserted by week. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
REALLOCATIONID |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
REALLOCATIONID |
VARCHAR2(20) |
X |
Identification of the reallocation agreement |
|
STARTDATE |
DATE |
|
Starting data for the agreement |
|
STARTPERIOD |
NUMBER(3,0) |
|
Starting period number |
|
ENDDATE |
DATE |
|
Ending date for the agreement |
|
ENDPERIOD |
NUMBER(3,0) |
|
Ending period number |
|
PARTICIPANTTOID |
VARCHAR2(10) |
|
Participant who receives the money |
|
PARTICIPANTFROMID |
VARCHAR2(10) |
|
Participant who provides the money |
|
AGREEMENTTYPE |
VARCHAR2(10) |
|
Either $ or MWh |
|
DEREGISTRATIONDATE |
DATE |
|
Not used |
|
DEREGISTRATIONPERIOD |
NUMBER(3,0) |
|
Not used |
|
REGIONID |
VARCHAR2(10) |
|
Place where the RRP is taken for the agreement |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
REGIONFCASRELAXATION_OCD contains details of regional FCAS requirements relaxed in the over-constrained dispatch (OCD) re-run (if there was one). |
|
REGIONFCASRELAXATION_OCD data is public, so is available to all participants. Source The occurrences of Over-constrained dispatch (OCD) re-runs are ad hoc, with significant dependencies on the configuration or events in the physical power system. Volume Rows per day: ~2 Mb per month: <1 The estimates on the number of rows are based on a 1% occurrence rate for OCD runs. Note The DISPATCHCASESOLUTION results report with the existing CASESUBTYPE field as “OCD” when detecting over-constrained dispatch. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
GLOBAL |
|
REGIONID |
|
RUNNO |
|
SERVICETYPE |
|
SETTLEMENTDATE |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
End date and time of the dispatch interval |
|
RUNNO |
NUMBER(3,0) |
X |
Dispatch run no |
|
REGIONID |
VARCHAR2(10) |
X |
Region Identifier |
|
SERVICETYPE |
VARCHAR2(10) |
X |
Ancillary service type identifier (e.g. LOWER60SEC) |
|
GLOBAL |
NUMBER(1,0) |
X |
FCAS Requirement: 1 = global, 0 = local |
|
REQUIREMENT |
NUMBER(15,5) |
|
Relaxed Requirement used in attempt to avoid violation |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
A settlement table for the publication of Snowy CSP derogation amounts. |
|
Source Settlements data process is populated at the posting of a billing run in which it is included. Volume Estimated number of rows is 13440 for a based on the 35 settlement days posted per week. Note this data would only be delivered to the participant receiving payments from the derogation. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
AMOUNT_ID |
|
PARTICIPANTID |
|
PERIODID |
|
SETTLEMENTDATE |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Settlement Date |
|
VERSIONNO |
NUMBER(3) |
X |
Settlement run number |
|
PERIODID |
NUMBER(3) |
X |
Period identifier |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
The participant allocated the payment amount for the derogation. |
|
AMOUNT_ID |
VARCHAR2(20) |
X |
Amount identifier represented as a string, from "TA1" through to "TA6" (or "TA8" for a LYMMCO derogation result) |
|
DEROGATION_AMOUNT |
NUMBER(18,8) |
|
Derogation amount associated with the amount identifier |
|
LASTCHANGED |
DATE |
|
Last changed date for the record |
|
Name |
|
|
Comment |
A settlements table for the publication of support data for the Snowy CSP derogation amounts. This table publishes the constraint-level information for each five minute interval in the settlement run |
|
Source Settlements data process is populated at the posting of a billing run in which it is included. Volume Estimated number of rows is an average of 1000 per week based on the 35 settlement days posted per week. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
CONSTRAINTID |
|
INTERVAL_DATETIME |
|
PERIODID |
|
SETTLEMENTDATE |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Settlement Date |
|
VERSIONNO |
NUMBER(3) |
X |
Settlement run number |
|
INTERVAL_DATETIME |
DATE |
X |
Dispatch interval identifier |
|
CONSTRAINTID |
VARCHAR2(20) |
X |
Constraint identifier |
|
PERIODID |
NUMBER(3) |
X |
Settlements trading interval identifier |
|
MARGINALVALUE |
NUMBER(18,8) |
|
Marginal value of the constraint |
|
RHS |
NUMBER(18,8) |
|
RHS value of the constraint |
|
LOWERTUMUT_FACTOR |
NUMBER(18,8) |
|
Value of the Lower Tumut left-hand term of the constraint |
|
UPPERTUMUT_FACTOR |
NUMBER(18,8) |
|
Value of the Upper Tumut left hand term of the constraint |
|
LOWERTUMUT_CSPA_COEFF |
NUMBER(18,8) |
|
LOWERTUMUT_FACTOR x MARGINALVALUE |
|
UPPERTUMUT_CSPA_COEFF |
NUMBER(18,8) |
|
UPPERTUMUT_FACTOR x MARGINALVALUE |
|
ABS_X |
NUMBER(18,8) |
|
Equal to RHS if the constraint direction is SOUTH, otherwise zero |
|
ABS_Y |
NUMBER(18,8) |
|
Equal to RHS if the constraint direction is NORTH, otherwise zero |
|
LASTCHANGED |
DATE |
|
Last changed date of the record |
|
Name |
|
|
Comment |
A settlements table for the publication of support data for the Snowy CSP derogation amounts. This table publishes energy differential information for each half-hour interval in the settlement run |
|
THIS TABLE WILL BE DISCONTINUED AS PART OF THE END OF YEAR 2009 MMS RELEASESource Settlements data process is populated at the posting of a billing run in which it is included. Volume Estimated number of rows is an average of 1000 per week based on the 35 settlement days posted per week. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
PERIODID |
|
SETTLEMENTDATE |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Settlement Date |
|
VERSIONNO |
NUMBER(3) |
X |
Settlement run number |
|
PERIODID |
NUMBER(3) |
X |
Period identifier |
|
LOWERTUMUT_SPDP |
NUMBER(18,8) |
|
Lower Tumut Substitute Price for the half hour interval |
|
UPPERTUMUT_SPDP |
NUMBER(18,8) |
|
Upper Tumut Substitute Price for the half hour interval |
|
LOWERTUMUT_EVDP |
NUMBER(18,8) |
|
Lower Tumut Energy Value Differential for the half hour interval |
|
UPPERTUMUT_EVDP |
NUMBER(18,8) |
|
Upper Tumut Energy Value Differential for the half hour interval |
|
FLOW_DIRECTION |
VARCHAR2(20) |
|
Indicates the determined direction of flow in the half hour. Will be either “”NORTH” or “SOUTH” |
|
TOTAL_X |
NUMBER(18,8) |
|
Sum of all "ABS_X" values in the half hour |
|
TOTAL_Y |
NUMBER(18,8) |
|
Sum of all "ABS_Y" values in the half hour |
|
LOWERTUMUT_AGE |
NUMBER(18,8) |
|
Energy output of the Lower Tumut unit in the half hour interval |
|
UPPERTUMUT_AGE |
NUMBER(18,8) |
|
Energy output of the Upper Tumut unit in the half hour interval |
|
EVA |
NUMBER(18,8) |
|
Energy value adjustment for northward flows in the half-hour interval |
|
LASTCHANGED |
DATE |
|
Last changed date for the record |
|
Name |
|
|
Comment |
A settlements table for the publication of support data for the Snowy CSP derogation amounts. This table publishes substitution price information for each five minute interval in the settlement run |
|
Source Settlements data process is populated at the posting of a billing run in which it is included. Volume Estimated number of rows is an average of 1000 per week based on the 35 settlement days posted per week. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
INTERVAL_DATETIME |
|
SETTLEMENTDATE |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Settlement Date |
|
VERSIONNO |
NUMBER(3) |
X |
Settlement run number |
|
INTERVAL_DATETIME |
DATE |
X |
Dispatch interval identifier |
|
PERIODID |
NUMBER(3) |
|
Period identifier |
|
RRP |
NUMBER(18,8) |
|
SNOWY1 RRP for the dispatch interval |
|
IS_CSP_INTERVAL |
NUMBER(1) |
|
A flag to indicate whether a binding CSP constraint was present in the dispatch interval. A value of 1 indicates that CSP processing occurred due to a binding CSP constraint, while a value of 0 indicates that no binding CSP constraints were present in this interval |
|
LOWERTUMUT_TLF |
NUMBER(18,8) |
|
Transmission loss factor of the Lower Tumut unit |
|
UPPERTUMUT_TLF |
NUMBER(18,8) |
|
Transmission Loss factor of the Upper Tumut unit |
|
LOWERTUMUT_PRICE |
NUMBER(18,8) |
|
The dispatch price at the Lower Tumut node |
|
UPPERTUMUT_PRICE |
NUMBER(18,8) |
|
The dispatch price at the Upper Tumut node |
|
LOWERTUMUT_CSPA_COEFF |
NUMBER(18,8) |
|
Sum of CSPAxCOEFF for all constraints and Lower Tumut left-hand terms |
|
UPPERTUMUT_CSPA_COEFF |
NUMBER(18,8) |
|
Sum of CSPAxCOEFF for all constraints and Upper Tumut left-hand terms |
|
LOWERTUMUT_SPDP_UNCAPPED |
NUMBER(18,8) |
|
LOWERTUMUT_SPDP before VOLL or MPF capping is applied |
|
UPPERTUMUT_SPDP_UNCAPPED |
NUMBER(18,8) |
|
UPPERTUMUT_SPDP before VOLL or MPF capping is applied |
|
LOWERTUMUT_SPDP |
NUMBER(18,8) |
|
Substitute Price for Lower Tumut |
|
UPPERTUMUT_SPDP |
NUMBER(18,8) |
|
Substitute Price for Upper Tumut |
|
INTERVAL_ABS_X |
NUMBER(18,8) |
|
Sum of all ABS_X values for binding CSP constraints in the dispatch interval |
|
INTERVAL_ABS_Y |
NUMBER(18,8) |
|
Sum of all ABS_Y values for binding CSP constraints in the dispatch interval |
|
LASTCHANGED |
DATE |
|
Last changed date for the record |
|
Name |
|
|
Comment |
SET_MR_PAYMENT shows trading interval payments on a dispatchable unit basis for accepted MR capacity. |
|
SET_MR_PAYMENT data is confidential to the relevant participant. Source SET_MR_PAYMENT updates are ad hoc, being for MR events only. Volume 24000 rows per year |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
DUID |
|
PERIODID |
|
REGIONID |
|
SETTLEMENTDATE |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Settlement Date (Calendar) |
|
VERSIONNO |
NUMBER(3,0) |
X |
Settlement Run Number for this date |
|
REGIONID |
VARCHAR2(10) |
X |
Unique Region Identifier |
|
PARTICIPANTID |
VARCHAR2(10) |
|
Unique Participant identifier |
|
DUID |
VARCHAR2(10) |
X |
Unique identifier for DUID / MNSP LinkID |
|
PERIODID |
NUMBER(3,0) |
X |
Calendar day Trading Interval number |
|
MR_CAPACITY |
NUMBER(16,6) |
|
Accepted MR Capacity |
|
UNCAPPED_PAYMENT |
NUMBER(16,6) |
|
Uncapped Trading Interval Payment |
|
CAPPED_PAYMENT |
NUMBER(16,6) |
|
Capped Trading Interval Payment |
|
LASTCHANGED |
DATE |
|
Date/Time record inserted/modified |
|
Name |
|
|
Comment |
SET_MR_RECOVERY shows the trading interval recovery charges on a dispatchable unit basis for spot market income from dispatch of MR capacity. |
|
SET_MR_RECOVERY data is confidential to the relevant participant. Source SET_MR_RECOVERY updates are ad hoc, being for MR events only. Volume 24000 rows per year |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
DUID |
|
PERIODID |
|
REGIONID |
|
SETTLEMENTDATE |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Settlement Date (Calendar) |
|
VERSIONNO |
NUMBER(3,0) |
X |
Settlement Run Number for this date |
|
REGIONID |
VARCHAR2(10) |
X |
Unique Region Identifier |
|
PARTICIPANTID |
VARCHAR2(10) |
|
Unique Participant identifier |
|
DUID |
VARCHAR2(10) |
X |
Unique identifier for DUID / MNSP LinkID |
|
PERIODID |
NUMBER(3,0) |
X |
Calendar day Trading Interval number |
|
ARODEF |
NUMBER(16,6) |
|
Accepted Restriction Offer Dispatched Energy Factor |
|
NTA |
NUMBER(16,6) |
|
The amount payable to AEMO for that accepted restriction offer and trading interval |
|
LASTCHANGED |
DATE |
|
Date/Time record inserted/modified |
|
Name |
|
|
Comment |
SETAGCPAYMENT sets out specific payment details for Automatic Generation Control (AGC) services by period. |
|
SETAGCPAYMENT data is confidential to the relevant participant Source SETAGCPAYMENT 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 |
Calendar Settlement Date |
|
VERSIONNO |
NUMBER(3,0) |
X |
Settlement Run No. |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Unique participant identifier |
|
CONTRACTID |
VARCHAR2(10) |
X |
Contract Identifier |
|
PERIODID |
NUMBER(3,0) |
X |
Settlement Period Identifier |
|
DUID |
VARCHAR2(10) |
|
Dispatchable Unit ID |
|
REGIONID |
VARCHAR2(10) |
|
Region Identifier |
|
TLF |
NUMBER(7,5) |
|
Transmission Loss Factor of Unit |
|
EBP |
NUMBER(15,5) |
|
Eligible Bid Price |
|
RRP |
NUMBER(15,5) |
|
Regional Reference Price |
|
CLEAREDMW |
NUMBER(15,5) |
|
Cleared MW of Unit in Enabled Dispatch period |
|
INITIALMW |
NUMBER(15,5) |
|
Initial MW of Unit in Enabled Dispatch period |
|
ENABLINGPAYMENT |
NUMBER(15,5) |
|
Enabling 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 |
|
Name |
|
|
Comment |
SETAGCRECOVERY shows reimbursements for Automatic Generation Control (AGC) Ancillary Services to be recovered from participants. |
|
SETAGCRECOVERY data is confidential to the relevant participant Source SETAGCRECOVERY 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) |
|
|
|
PERIODID |
NUMBER(3,0) |
X |
Trading Interval |
|
REGIONID |
VARCHAR2(10) |
X |
Region Identifier |
|
ENABLINGPAYMENT |
NUMBER(15,5) |
|
Enabling Payment |
|
PARTICIPANTDEMAND |
NUMBER(15,5) |
|
Participant Demand in Region |
|
REGIONDEMAND |
NUMBER(15,5) |
|
Total Regional Demand |
|
ENABLINGRECOVERY |
NUMBER(15,5) |
|
Enabling Recovery |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
ENABLINGRECOVERY_GEN |
NUMBER(15,5) |
|
Enabling Recovery for Generator |
|
PARTICIPANTDEMAND_GEN |
NUMBER(15,5) |
|
Participant Demand in Region for Generator |
|
REGIONDEMAND_GEN |
NUMBER(15,5) |
|
Total Regional Demand for Generator |
|
Name |
|
|
Comment |
SETAPCCOMPENSATION shows Administered Price Cap (APC) compensation payments for each period. |
|
SETAPCCOMPENSATION data is confidential to the relevant participant. Source SETAPCCOMPENSATION updates in settlement runs, as needed. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
PARTICIPANTID |
|
PERIODID |
|
REGIONID |
|
SETTLEMENTDATE |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Calendar Settlement Date |
|
VERSIONNO |
NUMBER(3,0) |
X |
Settlement run number |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Participant identifier |
|
REGIONID |
VARCHAR2(10) |
X |
Region Identifier |
|
PERIODID |
NUMBER(3,0) |
X |
Settlement period (based on calendar day) |
|
APCCOMPENSATION |
NUMBER(15,5) |
|
APC amount |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
SETAPCRECOVERY shows reimbursements for Administered Price Cap (APC) to be recovered from participants. |
|
SETAPCRECOVERY data is confidential to the relevant participant. Source SETAPCRECOVERY 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 |
Calendar Settlement Date |
|
VERSIONNO |
NUMBER(3,0) |
X |
Settlement run number |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Participant identifier |
|
REGIONID |
VARCHAR2(10) |
X |
Region Identifier |
|
PERIODID |
NUMBER(3,0) |
X |
Settlement period (based on calendar day) |
|
TOTALCOMPENSATION |
NUMBER(15,5) |
|
Total compensation |
|
PARTICIPANTDEMAND |
NUMBER(15,5) |
|
Participant MW Demand |
|
REGIONDEMAND |
NUMBER(15,5) |
|
Total region demand |
|
APCRECOVERY |
NUMBER(15,5) |
|
APC Recovery amount |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
SETFCASCOMP shows the compensation details for Frequency Controlled Ancillary Services (FCAS). These compensation values are calculated by a separate “what if” run of the LP Solver and entered as an unconstrained MW value into settlements. |
|
SETFCASCOMP data is confidential to the relevant participant Source SETFCASCOMP updates with each Settlement run, if required. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
DUID |
|
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 |
|
DUID |
VARCHAR2(10) |
X |
Dispatchable Unit ID |
|
REGIONID |
VARCHAR2(10) |
|
Region Identifier |
|
PERIODID |
NUMBER(3,0) |
X |
Period Identifier |
|
CCPRICE |
NUMBER(15,5) |
|
Compensation Cap |
|
CLEAREDMW |
NUMBER(15,5) |
|
Cleared MW of Unit in First Dispatch period in Trading Interval |
|
UNCONSTRAINEDMW |
NUMBER(15,5) |
|
Initial MW of Unit in First Dispatch period in Trading Interval |
|
EBP |
NUMBER(15,5) |
|
Eligible Bid Price |
|
TLF |
NUMBER(7,5) |
|
Transmission Loss Factor of Unit |
|
RRP |
NUMBER(15,5) |
|
Regional Reference Price |
|
EXCESSGEN |
NUMBER(15,5) |
|
Excess Generation Payment in trading interval |
|
FCASCOMP |
NUMBER(15,5) |
|
Frequency Control AS Compensation payment to Generator |
|
LASTCHANGED |
DATE |
|
|
|
Name |
|
|
Comment |
SETFCASERECOVERY shows reimbursements for the Frequency Control Ancillary Services compensation. |
|
Status SETFCASERECOVERY is obsolete since the implementation of Ancillary Services Review. For more details, see Change Notice 126. Confidential to the participant Source This view is updated 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 |
Calendar Settlement Date |
|
VERSIONNO |
NUMBER(3,0) |
X |
Settlement run no |
|
DUID |
VARCHAR2(10) |
|
Dispatchable Unit identifier |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Participant to pay recovery |
|
REGIONID |
VARCHAR2(10) |
X |
Region Identifier |
|
PERIODID |
NUMBER(3,0) |
X |
Settlement Period identifier |
|
FCASCOMP |
NUMBER(15,5) |
|
Frequency Control Ancillary Service Compensation Payment |
|
PARTICIPANTDEMAND |
NUMBER(15,5) |
|
Participant Demand in Region |
|
REGIONDEMAND |
NUMBER(15,5) |
|
Total Regional demand |
|
FCASRECOVERY |
NUMBER(15,5) |
|
Frequency Control Ancillary Service recovery amount. |
|
LASTCHANGED |
DATE |
|
Date and Time last changed |
|
FCASRECOVERY_GEN |
NUMBER(15,5) |
|
Frequency Control Ancillary Service recovery amount for Generator |
|
PARTICIPANTDEMAND_GEN |
NUMBER(15,5) |
|
Participant Demand in Region for Generator |
|
REGIONDEMAND_GEN |
NUMBER(15,5) |
|
Total Regional Demand for Generator |
|
Name |
|
|
Comment |
SETGOVPAYMENTshows specific payment details for Governor services by period. |
|
SETGOVPAYMENT is planned to become unused when Ancillary Services Review is implemented. For more details, see Change Notice 126 (1 Sep 2000), Change Notice 126a (18 Sep 2000) and any subsequent Change Notices with the same number. SETGOVPAYMENT data is confidential to each participant. Frequency and source SETGOVPAYMENT 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 |
Unique participant identifier |
|
CONTRACTID |
VARCHAR2(10) |
X |
Contract Identifier |
|
PERIODID |
NUMBER(3,0) |
X |
Period Identifier |
|
DUID |
VARCHAR2(10) |
|
Dispatchable Unit ID |
|
REGIONID |
VARCHAR2(10) |
|
Region Identifier |
|
TLF |
NUMBER(7,5) |
|
Transmission Loss Factor of Unit |
|
RL6SECRAISE |
NUMBER(15,5) |
|
contract enabling price - 6 sec raise |
|
RL60SECRAISE |
NUMBER(15,5) |
|
contract enabling price - 60 sec raise |
|
RL6SECLOWER |
NUMBER(15,5) |
|
contract enabling price - 6 sec lower |
|
RL60SECLOWER |
NUMBER(15,5) |
|
contract enabling price - 60 sec lower |
|
DEADBANDUP |
NUMBER(7,5) |
|
contracted dead band up |
|
DEADBANDDOWN |
NUMBER(7,5) |
|
contracted dead band down |
|
R6 |
NUMBER(15,5) |
|
6 sec raise response for 1% deviation in frequency (droop equation) |
|
R60 |
NUMBER(15,5) |
|
60 sec raise response for 1% deviation in frequency (droop equation) |
|
L6 |
NUMBER(15,5) |
|
6 sec lower response for 1% deviation in frequency (droop equation) |
|
L60 |
NUMBER(15,5) |
|
60 sec lower response for 1% deviation in frequency (droop equation) |
|
RL6 |
NUMBER(15,5) |
|
6 sec raise response limit equation |
|
RL60 |
NUMBER(15,5) |
|
60 sec raise response limit equation |
|
LL6 |
NUMBER(15,5) |
|
6 sec lower response limit equation |
|
LL60 |
NUMBER(15,5) |
|
6 sec lower response limit equation |
|
ENABLING6RPAYMENT |
NUMBER(15,5) |
|
6 sec raise enabling payment |
|
ENABLING60RPAYMENT |
NUMBER(15,5) |
|
60 sec raise enabling payment |
|
ENABLING6LPAYMENT |
NUMBER(15,5) |
|
6 sec lower enabling payment |
|
ENABLING60LPAYMENT |
NUMBER(15,5) |
|
60 sec lower enabling payment |
|
CONTRACTVERSIONNO |
NUMBER(3,0) |
|
AS contract version no |
|
OFFERDATE |
DATE |
|
re-offer offer date |
|
OFFERVERSIONNO |
NUMBER(3,0) |
|
re-offer offer version |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
SETGOVRECOVERY shows reimbursements for the Governor Ancillary Services to be recovered from participants. |
|
SETGOVRECOVERY became unused when Ancillary Services Review was implemented. For more details, see Change Notice 126. SETGOVRECOVERY data is confidential to each participant. Source SETGOVRECOVERY 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) |
|
|
|
PERIODID |
NUMBER(3,0) |
X |
Trading Interval |
|
REGIONID |
VARCHAR2(10) |
X |
Region Identifier |
|
ENABLING6RPAYMENT |
NUMBER(15,5) |
|
Enabling Payment 6 Second Raise |
|
ENABLING60RPAYMENT |
NUMBER(15,5) |
|
Enabling Payment 60 Second Raise |
|
ENABLING6LPAYMENT |
NUMBER(15,5) |
|
Enabling Payment 6 Second Lower |
|
ENABLING60LPAYMENT |
NUMBER(15,5) |
|
Enabling Payment 60 Second Lower |
|
PARTICIPANTDEMAND |
NUMBER(15,5) |
|
Participant Demand in Region |
|
REGIONDEMAND |
NUMBER(15,5) |
|
Total Regional Demand |
|
ENABLING6RRECOVERY |
NUMBER(15,5) |
|
Enabling Recovery 6 Second Raise |
|
ENABLING60RRECOVERY |
NUMBER(15,5) |
|
Enabling Recovery 60 Second Raise |
|
ENABLING6LRECOVERY |
NUMBER(15,5) |
|
Enabling Recovery 6 Second Lower |
|
ENABLING60LRECOVERY |
NUMBER(15,5) |
|
Enabling Recovery 60 Second Lower |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
ENABLING6LRECOVERY_GEN |
NUMBER(15,5) |
|
Enabling Recovery 6 Second Lower for Generator |
|
ENABLING6RRECOVERY_GEN |
NUMBER(15,5) |
|
Enabling Recovery 6 Second Raise for Generator |
|
ENABLING60LRECOVERY_GEN |
NUMBER(15,5) |
|
Enabling Recovery 60 Second Lower for Generator |
|
ENABLING60RRECOVERY_GEN |
NUMBER(15,5) |
|
Enabling Recovery 60 Second Raise for Generator |
|
PARTICIPANTDEMAND_GEN |
NUMBER(15,5) |
|
Participant Demand in Region for Generator |
|
REGIONDEMAND_GEN |
NUMBER(15,5) |
|
Total Regional Demand for Generator |
|
Name |
|
|
Comment |
SETINTERVENTION shows intervention settlement payment details by unit. |
|
SETINTERVENTION became unused when Ancillary Services Review was implemented. For more details, see Change Notice 126. SETINTERVENTION data is confidential to each participant. Source SETINTERVENTION is unused; was updating when intervention occurred in a billing run. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
DUID |
|
PERIODID |
|
SETTLEMENTDATE |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Calendar Settlement Date |
|
VERSIONNO |
NUMBER(3,0) |
X |
Settlement Run No. |
|
PERIODID |
NUMBER(3,0) |
X |
Settlement Period identifier |
|
CONTRACTID |
VARCHAR2(10) |
|
Intervention Contract Identifier |
|
CONTRACTVERSION |
NUMBER(3,0) |
|
Intervention Contract Version |
|
PARTICIPANTID |
VARCHAR2(10) |
|
Unique participant identifier |
|
REGIONID |
VARCHAR2(10) |
|
Region Identifier |
|
DUID |
VARCHAR2(10) |
X |
Dispatchable Unit ID |
|
RCF |
CHAR(1) |
|
Regional Recovery Flag |
|
INTERVENTIONPAYMENT |
NUMBER(12,5) |
|
Payment to Generator for Intervention |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
SETINTERVENTIONRECOVERY shows intervention recovery details by participant. |
|
Status SETINTERVENTIONRECOVERY became unused when Ancillary Services Review was implemented. For more details, see Change Notice 126. Confidential to participant Source Unused; was updating when intervention 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 |
Calendar Settlement Date |
|
VERSIONNO |
NUMBER(3,0) |
X |
Settlement Run No. |
|
PERIODID |
NUMBER(3,0) |
X |
Settlement Period identifier |
|
CONTRACTID |
VARCHAR2(10) |
X |
Intervention Contract Identifier |
|
RCF |
CHAR(1) |
|
Regional Recovery Flag |
|
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 |
|
INTERVENTIONPAYMENT |
NUMBER(12,5) |
|
Payment to Generator for Intervention |
|
INTERVENTIONAMOUNT |
NUMBER(12,5) |
|
Retailer Payment to Pool for Intervention |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
REGIONID |
VARCHAR2(10) |
|
Region Identifier |
|
Name |
|
|
Comment |
SETIRFMRECOVERY sets out reimbursements for Industrial Relations Force Majeure to be recovered from participants. |
|
SETIRFMRECOVERY data is confidential to the relevant participant. Source SETIRFMRECOVERY updates with each settlement run. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
IRFMID |
|
PARTICIPANTID |
|
PERIODID |
|
SETTLEMENTDATE |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Settlement date |
|
VERSIONNO |
NUMBER(3,0) |
X |
Version number |
|
PERIODID |
NUMBER(3,0) |
X |
Settlement period ID |
|
IRFMID |
VARCHAR2(10) |
X |
Industrial Relations Forced Majeure event number |
|
IRMFVERSION |
NUMBER(3,0) |
|
Industrial Relations Forced Majeure event number |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Participant unique identifier |
|
PARTICIPANTDEMAND |
NUMBER(12,5) |
|
Participant demand |
|
TOTALTCD |
NUMBER(12,5) |
|
Total non franchised load in Victoria. |
|
TOTALTFD |
NUMBER(12,5) |
|
Total franchised load in Victoria. |
|
IRFMAMOUNT |
NUMBER(12,5) |
|
Industrial Relations Forced Majeure event amount in $. |
|
IRFMPAYMENT |
NUMBER(12,5) |
|
Industrial Relations Forced Majeure payment amount in $. |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
SETLULOADPAYMENT shows specific payment details for rapid unit load services by period. |
|
SETLULOADPAYMENT became unused when Ancillary Services Review was implemented. For more details, see Change Notice 126. SETLULOADPAYMENT data is confidential to each participant. Source SETLULOADPAYMENT is unused; was updated 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 |
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 |
|
ENABLINGPRICE |
NUMBER(15,5) |
|
Enabling Price |
|
USAGEPRICE |
NUMBER(15,5) |
|
Usage Price |
|
CCPRICE |
NUMBER(15,5) |
|
Compensation Cap |
|
BLOCKSIZE |
NUMBER(4,0) |
|
Indicates how much of the unit at one given time is available for the ancillary service. |
|
ACR |
NUMBER(6,2) |
|
Dispatch target |
|
UNITOUTPUT |
NUMBER(15,5) |
|
Unit output. |
|
UNITEXCESSGEN |
NUMBER(15,5) |
|
Excess Generation |
|
ENABLINGPAYMENT |
NUMBER(15,5) |
|
Enabling Payment |
|
USAGEPAYMENT |
NUMBER(15,5) |
|
Usage Payment |
|
COMPENSATIONPAYMENT |
NUMBER(15,5) |
|
Compensation 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 |
|
Name |
|
|
Comment |
SETLULOADRECOVERY shows reimbursements for rapid-unit-load Ancillary Services to be recovered from participants. |
|
SETLULOADRECOVERY became unused when Ancillary Services Review was implemented. For more details, see Change Notice 126. SETLULOADRECOVERY data is confidential to each participant. Source SETLULOADRECOVERY is unused; was updated 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) |
|
AS Contract ID |
|
PERIODID |
NUMBER(3,0) |
X |
Trading Interval |
|
REGIONID |
VARCHAR2(10) |
X |
Region Identifier |
|
ENABLINGPAYMENT |
NUMBER(15,5) |
|
Enabling Payment |
|
USAGEPAYMENT |
NUMBER(15,5) |
|
Usage Payment |
|
COMPENSATIONPAYMENT |
NUMBER(15,5) |
|
Compensation Payment |
|
PARTICIPANTDEMAND |
NUMBER(15,5) |
|
Participant Demand in Region |
|
REGIONDEMAND |
NUMBER(15,5) |
|
Total Regional Demand |
|
ENABLINGRECOVERY |
NUMBER(15,5) |
|
Enabling Recovery |
|
USAGERECOVERY |
NUMBER(15,5) |
|
Usage Recovery |
|
COMPENSATIONRECOVERY |
NUMBER(15,5) |
|
Compensation Recovery |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
ENABLINGRECOVERY_GEN |
NUMBER(15,5) |
|
Enabling Recovery for Generator |
|
USAGERECOVERY_GEN |
NUMBER(15,5) |
|
Usage Recovery for Generator |
|
COMPENSATIONRECOVERY_GEN |
NUMBER(15,5) |
|
Compensation Recovery for Generator |
|
PARTICIPANTDEMAND_GEN |
NUMBER(15,5) |
|
Participant Demand in Region for Generator |
|
REGIONDEMAND_GEN |
NUMBER(15,5) |
|
Total Regional Demand for Generator |
|
Name |
|
|
Comment |
SETLUNLOADPAYMENT shows specific payment details for rapid unit unload service. |
|
SETLUNLOADPAYMENT data is confidential to the relevant participant. Source SETLUNLOADPAYMENT 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 |
Unique participant identifier |
|
CONTRACTID |
VARCHAR2(10) |
X |
Ancillary Services contract identifier |
|
PERIODID |
NUMBER(3,0) |
X |
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 |
|
ENABLINGPRICE |
NUMBER(15,5) |
|
Enabling price |
|
USAGEPRICE |
NUMBER(15,5) |
|
Usage Price |
|
CCPRICE |
NUMBER(15,5) |
|
Compensation cap |
|
CLEAREDMW |
NUMBER(15,5) |
|
Cleared MW of Unit in Dispatch, Predispatch or Trading period. |
|
UNCONSTRAINEDMW |
NUMBER(15,5) |
|
MW output the generator would have been running at had it not been constrained up to provide unit unloading |
|
CONTROLRANGE |
NUMBER(4,0) |
|
The MW output achieved in 5 minutes from startup and is what payment is based on. |
|
ENABLINGPAYMENT |
NUMBER(15,5) |
|
Enabling payment |
|
USAGEPAYMENT |
NUMBER(15,5) |
|
Usage Payment |
|
COMPENSATIONPAYMENT |
NUMBER(15,5) |
|
Compensation payment |
|
CONTRACTVERSIONNO |
NUMBER(3,0) |
|
Contract version number |
|
OFFERDATE |
DATE |
|
Re-offer offer date |
|
OFFERVERSIONNO |
NUMBER(3,0) |
|
Re-Offer Version No. |
|
LASTCHANGED |
DATE |
|
Date last changed |
|
Name |
|
|
Comment |
SETLUNLOADRECOVERY shows reimbursements for rapid unit unloading Ancillary Services to be recovered from participants. |
|
SETLUNLOADRECOVERY data is confidential to the relevant participant. Source SETLUNLOADRECOVERY 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) |
|
AS Contract |
|
PERIODID |
NUMBER(3,0) |
X |
Trading Interval |
|
REGIONID |
VARCHAR2(10) |
X |
Region Identifier |
|
ENABLINGPAYMENT |
NUMBER(15,5) |
|
Enabling Payment |
|
USAGEPAYMENT |
NUMBER(15,5) |
|
Usage Payment |
|
COMPENSATIONPAYMENT |
NUMBER(15,5) |
|
Compensation Payment |
|
PARTICIPANTDEMAND |
NUMBER(15,5) |
|
Participant Demand in Region |
|
REGIONDEMAND |
NUMBER(15,5) |
|
Total Regional Demand |
|
ENABLINGRECOVERY |
NUMBER(15,5) |
|
Enabling Recovery |
|
USAGERECOVERY |
NUMBER(15,5) |
|
Usage Recovery |
|
COMPENSATIONRECOVERY |
NUMBER(15,5) |
|
Compensation Recovery |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
ENABLINGRECOVERY_GEN |
NUMBER(15,5) |
|
Enabling Recovery for Generator |
|
USAGERECOVERY_GEN |
NUMBER(15,5) |
|
Usage Recovery for Generator |
|
COMPENSATIONRECOVERY_GEN |
NUMBER(15,5) |
|
Compensation Recovery for Generator |
|
PARTICIPANTDEMAND_GEN |
NUMBER(15,5) |
|
Participant Demand in Region for Generator |
|
REGIONDEMAND_GEN |
NUMBER(15,5) |
|
Total Regional Demand for Generator |
|
Name |
|
|
Comment |
SETRESERVETRADER shows reserve trader details. |
|
SETRESERVETRADER data is confidential to the relevant participant. Source SETRESERVETRADER updates when reserve trading occurs in a billing run, such as during an Administered Price Cap event. SETRESERVETRADER is empty until such an event occurs. |
|
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. |
|
PERIODID |
NUMBER(3,0) |
X |
Period Identifier |
|
CONTRACTID |
VARCHAR2(10) |
|
Reserve Trader Contract Identifier |
|
CONTRACTVERSION |
NUMBER(3,0) |
|
Reserve Trader Contract Version |
|
PARTICIPANTID |
VARCHAR2(10) |
|
Unique participant identifier |
|
REGIONID |
VARCHAR2(10) |
|
Region Identifier |
|
DUID |
VARCHAR2(10) |
X |
Dispatchable Unit ID |
|
RCF |
CHAR(1) |
|
Reserve Recovery Flag |
|
UNITAVAIL |
NUMBER(6,2) |
|
Offered Availability of Unit |
|
CPA |
NUMBER(12,5) |
|
Contract Availability Payment |
|
CPE |
NUMBER(12,5) |
|
Contract Enabling Payment |
|
CPU |
NUMBER(12,5) |
|
Contract Usage Payment |
|
CPTOTAL |
NUMBER(12,5) |
|
Total Payment for Contract |
|
CAPDIFFERENCE |
NUMBER(12,5) |
|
Spot payment applicable to the capacity above the enabling threshold |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
SETVICBOUNDARYENERGY is as requested by Participants for the settlement of Victorian Vesting contracts. |
|
SETVICBOUNDARYENERGY data is confidential to the relevant participants. Source SETVICBOUNDARYENERGY is populated 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 |
|
SETTLEMENTDATE |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Settlement and date |
|
VERSIONNO |
NUMBER(3,0) |
X |
Version number |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Participant Identifier |
|
PERIODID |
NUMBER(3,0) |
X |
Period Identifier |
|
BOUNDARYENERGY |
NUMBER(15,5) |
|
Interval energy purchases in Victoria when host distributor = Pool (in MWh) |
|
LASTCHANGED |
DATE |
|
Last changed |
|
Name |
|
|
Comment |
SETVICENERGYFIGURES is used in settlement of Victorian Vesting contracts. |
|
SETVICENERGYFIGURES data is public, so is available to all participants. Source SETVICENERGYFIGURES updates daily, with settlements. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
PERIODID |
|
SETTLEMENTDATE |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Settlement date |
|
VERSIONNO |
NUMBER(3,0) |
X |
Version number |
|
PERIODID |
NUMBER(3,0) |
X |
Settlement period |
|
TOTALGENOUTPUT |
NUMBER(15,5) |
|
Total generator output |
|
TOTALPCSD |
NUMBER(15,5) |
|
Total participant demand |
|
LASTCHANGED |
DATE |
|
Last changed |
|
TLR |
NUMBER(15,6) |
|
Transmission loss factor |
|
MLF |
NUMBER(15,6) |
|
Marginal loss factor |
|
Name |
|
|
Comment |
SETVICENERGYFLOW is used in settlement of Victorian Vesting contracts. |
|
SETVICENERGYFLOW data is public, so is available to all participants. Source SETVICENERGYFLOW updates daily, with settlements |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
PERIODID |
|
SETTLEMENTDATE |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Settlement date |
|
VERSIONNO |
NUMBER(3,0) |
X |
Version number |
|
PERIODID |
NUMBER(3,0) |
X |
Settlement period |
|
NETFLOW |
NUMBER(15,5) |
|
Net metered energy flowing across the V-SN and V-SA interconnectors |
|
LASTCHANGED |
DATE |
|
Last changed |
|
Name |
|
|
Comment |
STPASA_SYSTEMSOLUTION is obsolete from 2005 End of Year Release. For solution information, see Region solution tables. |
|
STPASA_SYSTEMSOLUTION is public data. Source STPASA_SYSTEMSOLUTION is updated each STPASA run (half-hourly). Volume Rows per day: 48 Mb per month: <1 |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
INTERVAL_DATETIME |
|
Name |
|
LASTCHANGED |
|
Name |
|
RUN_DATETIME |
|
Name |
Data Type |
Mandatory |
Comment |
|
RUN_DATETIME |
DATE |
X |
Unique Timestamp Identifier for this study |
|
INTERVAL_DATETIME |
DATE |
X |
The unique identifier for the interval within this study |
|
SYSTEMDEMAND50 |
NUMBER(12,2) |
|
Sum of Demand 50% PoE |
|
RESERVEREQ |
NUMBER(12,2) |
|
System total reserve requirement |
|
UNCONSTRAINEDCAPACITY |
NUMBER(12,2) |
|
System energy unconstrained capacity MW subject to energy and network constraints |
|
CONSTRAINEDCAPACITY |
NUMBER(12,2) |
|
System energy constrained capacity MW subject to energy and network constraints |
|
SURPLUSCAPACITY |
NUMBER(12,2) |
|
System capacity surplus MW, +/- values indicate surplus/deficit capacity |
|
SURPLUSRESERVE |
NUMBER(12,2) |
|
System reserve surplus MW, +/- values indicate surplus/deficit reserve |
|
RESERVECONDITION |
NUMBER(1,0) |
|
The system reserve condition: 0 Adequate, 1 LRC |
|
LASTCHANGED |
DATE |
|
Last changed date of this record |
|
Name |
|
|
Comment |
STPASA_UNITSOLUTION shows the unit results from the capacity evaluations for each period of the study. |
|
STPASA_UNITSOLUTION was discontinued in the End Year 2005 MMS Release. See Change Notice 512c for further details.
STPASA_UNITSOLUTION is confidential data. Source STPASA_UNITSOLUTION is updated each STPASA run (i.e. every 2 hours). |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
DUID |
|
INTERVAL_DATETIME |
|
RUN_DATETIME |
|
RUNTYPE |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
RUN_DATETIME |
DATE |
X |
Unique Timestamp Identifier for this study |
|
INTERVAL_DATETIME |
DATE |
X |
The unique identifier for the interval within this study |
|
DUID |
VARCHAR2(10) |
X |
Dispatchable unit Identifier |
|
CONNECTIONPOINTID |
VARCHAR2(10) |
|
Connection point identifier |
|
EXPECTEDMAXCAPACITY |
NUMBER(12,2) |
|
Max MW capacity that can be obtained in case of capacity scarcity from units subject to network and energy constraints. |
|
CAPACITYMARGINALVALUE |
NUMBER(12,2) |
|
Capacity adequacy assessment marginal value, 0 if not binding |
|
CAPACITYVIOLATIONDEGREE |
NUMBER(12,2) |
|
Capacity adequacy assessment violation degree for unit capacity; 0 if not violating |
|
CAPACITYAVAILABLE |
NUMBER(12,2) |
|
The available MW capacity for the period |
|
ENERGYCONSTRAINED |
NUMBER(1,0) |
|
0 if not energy constrained, 1 if energy constrained for this energy block |
|
ENERGYAVAILABLE |
NUMBER(10,0) |
|
The energy limit (MWH) over this energy block for the energy constrained unit |
|
LASTCHANGED |
DATE |
|
Last changed date of this record |
|
PASAAVAILABILITY |
NUMBER(12,0) |
|
The physical plant capability including any capability that can be made available within 24 hrs |
|
RUNTYPE |
VARCHAR2(20) |
X |
Type of run. Values are RELIABILITY_LRC and OUTAGE_LRC |
|
Name |
|
|
Comment |
TRADINGLOAD shows half-hourly average dispatch levels, including fields to handle the Ancillary Services functionality. |
|
Source Own (confidential) TRADINGLOAD data updates half hourly, with public availability of all data on next day. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private & Public Next-Day |
|
Name |
|
DUID |
|
PERIODID |
|
RUNNO |
|
SETTLEMENTDATE |
|
TRADETYPE |
|
Name |
|
LASTCHANGED |
|
Name |
|
DUID |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Date that this data applies to |
|
RUNNO |
NUMBER(3,0) |
X |
Dispatch run no. |
|
DUID |
VARCHAR2(10) |
X |
Dispatchable Unit Identifier |
|
TRADETYPE |
NUMBER(2,0) |
X |
Not used |
|
PERIODID |
NUMBER(3,0) |
X |
Period Identifier |
|
INITIALMW |
NUMBER(15,5) |
|
Average Initial MW at start of each period |
|
TOTALCLEARED |
NUMBER(15,5) |
|
Average total MW dispatched over period |
|
RAMPDOWNRATE |
NUMBER(15,5) |
|
Average ramp down rate |
|
RAMPUPRATE |
NUMBER(15,5) |
|
Average ramp up rate |
|
LOWER5MIN |
NUMBER(15,5) |
|
Average 5 min lower dispatch |
|
LOWER60SEC |
NUMBER(15,5) |
|
Average 60 sec lower dispatch |
|
LOWER6SEC |
NUMBER(15,5) |
|
Average60 sec lower dispatch |
|
RAISE5MIN |
NUMBER(15,5) |
|
Average 5 min raise dispatch |
|
RAISE60SEC |
NUMBER(15,5) |
|
Average 60 sec raise dispatch |
|
RAISE6SEC |
NUMBER(15,5) |
|
Average 6 sec raise dispatch |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
LOWERREG |
NUMBER(15,5) |
|
Lower Regulation reserve target |
|
RAISEREG |
NUMBER(15,5) |
|
Raise Regulation reserve target |
|
AVAILABILITY |
NUMBER(15,5) |
|
Bid energy availability |
|
SEMIDISPATCHCAP |
NUMBER(3,0) |
|
Boolean representation flagging if the Target is Capped |
|
Name |
|
|
Comment |
TRADINGREGIONSUM sets out the half-hourly average regional demand and frequency control services. TRADINGREGIONSUM includes fields for the Raise Regulation and Lower Regulation Ancillary Services plus improvements to demand calculations. |
|
TRADINGREGIONSUM is public data, and is available to all participants. Source TRADINGREGIONSUM is updated every 30 minutes. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
PERIODID |
|
REGIONID |
|
RUNNO |
|
SETTLEMENTDATE |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Date that this data applies to |
|
RUNNO |
NUMBER(3,0) |
X |
Dispatch run no. |
|
REGIONID |
VARCHAR2(10) |
X |
Region Identifier |
|
PERIODID |
NUMBER(3,0) |
X |
Trading interval identifier within settlement day. |
|
TOTALDEMAND |
NUMBER(15,5) |
|
Total demand for region |
|
AVAILABLEGENERATION |
NUMBER(15,5) |
|
The available generation in the Region for the interval |
|
AVAILABLELOAD |
NUMBER(15,5) |
|
Not used |
|
DEMANDFORECAST |
NUMBER(15,5) |
|
Forecast demand for region |
|
DISPATCHABLEGENERATION |
NUMBER(15,5) |
|
Averaged generation dispatched in region |
|
DISPATCHABLELOAD |
NUMBER(15,5) |
|
Averaged load dispatched in region |
|
NETINTERCHANGE |
NUMBER(15,5) |
|
Average energy transferred over interconnector |
|
EXCESSGENERATION |
NUMBER(15,5) |
|
Average excess generation in region |
|
LOWER5MINDISPATCH |
NUMBER(15,5) |
|
Not used since Dec 2003. Lower 5 min MW dispatch |
|
LOWER5MINIMPORT |
NUMBER(15,5) |
|
Not used since Dec 2003. Lower 5 min MW imported |
|
LOWER5MINLOCALDISPATCH |
NUMBER(15,5) |
|
Lower 5 min local dispatch |
|
LOWER5MINLOCALPRICE |
NUMBER(15,5) |
|
Not used since Dec 2003. Local price of lower 5 min |
|
LOWER5MINLOCALREQ |
NUMBER(15,5) |
|
Not used since Dec 2003. Lower 5 min local requirement |
|
LOWER5MINPRICE |
NUMBER(15,5) |
|
Not used since Dec 2003. Regional price of lower 5 min |
|
LOWER5MINREQ |
NUMBER(15,5) |
|
Not used since Dec 2003. Lower 5 min total requirement |
|
LOWER5MINSUPPLYPRICE |
NUMBER(15,5) |
|
Not used since Dec 2003. Supply price of lower 5 min |
|
LOWER60SECDISPATCH |
NUMBER(15,5) |
|
Not used since Dec 2003. Lower 60 sec MW dispatch |
|
LOWER60SECIMPORT |
NUMBER(15,5) |
|
Not used since Dec 2003. Lower 60 sec MW imported |
|
LOWER60SECLOCALDISPATCH |
NUMBER(15,5) |
|
Lower 60 sec local dispatch |
|
LOWER60SECLOCALPRICE |
NUMBER(15,5) |
|
Not used since Dec 2003. Local price of lower 60 sec |
|
LOWER60SECLOCALREQ |
NUMBER(15,5) |
|
Not used since Dec 2003. Lower 60 sec local requirement |
|
LOWER60SECPRICE |
NUMBER(15,5) |
|
Not used since Dec 2003. Regional price of lower 60 sec |
|
LOWER60SECREQ |
NUMBER(15,5) |
|
Not used since Dec 2003. Lower 60 sec total requirement |
|
LOWER60SECSUPPLYPRICE |
NUMBER(15,5) |
|
Not used since Dec 2003. Supply price of lower 60 sec |
|
LOWER6SECDISPATCH |
NUMBER(15,5) |
|
Not used since Dec 2003. Lower 6 sec MW dispatch |
|
LOWER6SECIMPORT |
NUMBER(15,5) |
|
Not used since Dec 2003. Lower 6 sec MW imported |
|
LOWER6SECLOCALDISPATCH |
NUMBER(15,5) |
|
Lower 6 sec local dispatch |
|
LOWER6SECLOCALPRICE |
NUMBER(15,5) |
|
Not used since Dec 2003. Local price of lower 6 sec |
|
LOWER6SECLOCALREQ |
NUMBER(15,5) |
|
Not used since Dec 2003. Lower 6 sec local requirement |
|
LOWER6SECPRICE |
NUMBER(15,5) |
|
Not used since Dec 2003. Regional price of lower 6 sec |
|
LOWER6SECREQ |
NUMBER(15,5) |
|
Not used since Dec 2003. Lower 6 sec total requirement |
|
LOWER6SECSUPPLYPRICE |
NUMBER(15,5) |
|
Not used since Dec 2003. Supply price of lower 6 sec |
|
RAISE5MINDISPATCH |
NUMBER(15,5) |
|
Not used since Dec 2003. Raise 5 min MW dispatch |
|
RAISE5MINIMPORT |
NUMBER(15,5) |
|
Not used since Dec 2003. Raise 5 min MW imported |
|
RAISE5MINLOCALDISPATCH |
NUMBER(15,5) |
|
Raise 5 min local dispatch |
|
RAISE5MINLOCALPRICE |
NUMBER(15,5) |
|
Not used since Dec 2003. Local price of raise 5 min |
|
RAISE5MINLOCALREQ |
NUMBER(15,5) |
|
Not used since Dec 2003. Raise 5 min local requirement |
|
RAISE5MINPRICE |
NUMBER(15,5) |
|
Not used since Dec 2003. Regional price of raise 5 min |
|
RAISE5MINREQ |
NUMBER(15,5) |
|
Not used since Dec 2003. Raise 5 min total requirement |
|
RAISE5MINSUPPLYPRICE |
NUMBER(15,5) |
|
Not used since Dec 2003. Supply price of raise 5 min |
|
RAISE60SECDISPATCH |
NUMBER(15,5) |
|
Not used since Dec 2003. Raise 60 sec MW dispatch |
|
RAISE60SECIMPORT |
NUMBER(15,5) |
|
Not used since Dec 2003. Raise 60 sec MW imported |
|
RAISE60SECLOCALDISPATCH |
NUMBER(15,5) |
|
Raise 60 sec local dispatch |
|
RAISE60SECLOCALPRICE |
NUMBER(15,5) |
|
Not used since Dec 2003. Local price of raise 60 sec |
|
RAISE60SECLOCALREQ |
NUMBER(15,5) |
|
Not used since Dec 2003. Raise 60 sec local requirement |
|
RAISE60SECPRICE |
NUMBER(15,5) |
|
Not used since Dec 2003. Regional price of raise 60 sec |
|
|
|