|
Name |
|
|
Comment |
BIDDAYOFFER shows the Energy and Ancillary Service bid data for each Market Day. BIDDAYOFFER is the parent table to BIDOFFERPERIOD. BIDDAYOFFER is a child table to BIDOFFERFILETRK |
|
The ancillary service arrangements require availability and prices for each Frequency Control Ancillary Service to be bid on a similar basis to energy. Three tables (BIDOFFERFILETRK, BIDDAYOFFER and BIDOFFERPERIOD) facilitate ancillary service bidding and include energy bidding. BIDDAYOFFER data is confidential to the submitting participant until made public after 4am the next day. Source BIDDAYOFFER updates as ancillary service bids are processed. BIDDAYOFFER includes all accepted energy and ancillary service bids. Volume Approximately 1,500,000 records per year |
|
Name |
Comment |
Value |
|
Visibility |
|
Private & Public Next-Day |
|
Name |
|
BIDTYPE |
|
DIRECTION |
|
DUID |
|
OFFERDATE |
|
SETTLEMENTDATE |
|
Name |
|
LASTCHANGED |
|
Name |
|
PARTICIPANTID |
|
Name |
Data Type |
Mandatory |
Comment |
|
DUID |
VARCHAR2(10) |
X |
Dispatchable unit identifier |
|
BIDTYPE |
VARCHAR2(10) |
X |
Bid Type Identifier |
|
SETTLEMENTDATE |
DATE |
X |
Market date for applying the bid |
|
OFFERDATE |
TIMESTAMP(3) |
X |
Time this bid was processed and loaded |
|
DIRECTION |
VARCHAR2(20) |
X |
The power flow direction to which this offer applies: GEN, LOAD or BIDIRECTIONAL |
|
VERSIONNO |
NUMBER(22,0) |
|
Version No. for given offer date |
|
PARTICIPANTID |
VARCHAR2(10) |
|
Unique participant identifier |
|
DAILYENERGYCONSTRAINT |
NUMBER(12,6) |
|
Maximum energy available from Energy Constrained Plant. (Energy Bids Only) |
|
REBIDEXPLANATION |
VARCHAR2(500) |
|
Explanation for all rebids and inflexibilities |
|
PRICEBAND1 |
NUMBER(9,2) |
|
Price for Availability Band 1 |
|
PRICEBAND2 |
NUMBER(9,2) |
|
Price for Availability Band 2 |
|
PRICEBAND3 |
NUMBER(9,2) |
|
Price for Availability Band 3 |
|
PRICEBAND4 |
NUMBER(9,2) |
|
Price for Availability Band 4 |
|
PRICEBAND5 |
NUMBER(9,2) |
|
Price for Availability Band 5 |
|
PRICEBAND6 |
NUMBER(9,2) |
|
Price for Availability Band 6 |
|
PRICEBAND7 |
NUMBER(9,2) |
|
Price for Availability Band 6 |
|
PRICEBAND8 |
NUMBER(9,2) |
|
Price for Availability Band 8 |
|
PRICEBAND9 |
NUMBER(9,2) |
|
Price for Availability Band 9 |
|
PRICEBAND10 |
NUMBER(9,2) |
|
Price for Availability Band 10 |
|
MINIMUMLOAD |
NUMBER(22,0) |
|
Minimum MW load fast start plant |
|
T1 |
NUMBER(22,0) |
|
Time to synchronise in minutes (Energy Bids Only) |
|
T2 |
NUMBER(22,0) |
|
Time to minimum load in minutes (Energy Bids Only) |
|
T3 |
NUMBER(22,0) |
|
Time at minimum load in minutes (Energy Bids Only) |
|
T4 |
NUMBER(22,0) |
|
Time to shutdown in minutes (Energy Bids Only) |
|
NORMALSTATUS |
VARCHAR2(3) |
|
not used; was ON/OFF for loads (Energy Bids Only) |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
MR_FACTOR |
NUMBER(16,6) |
|
Mandatory Restriction Offer Factor |
|
ENTRYTYPE |
VARCHAR2(20) |
|
Daily if processed before BidCutOff of previous day, otherwise REBID |
|
REBID_EVENT_TIME |
VARCHAR2(20) |
|
The time of the event(s) or other occurrence(s) cited/adduced as the reason for the rebid. Required for rebids, not required for fixed load or low ramp rates. Expected in the format: HH:MM:SS e.g. 20:11:00 |
|
REBID_AWARE_TIME |
VARCHAR2(20) |
|
Intended to support the Rebidding and Technical Parameters Guideline. The time at which the participant became aware of the event(s) / occurrence(s) that prompted the rebid.Not validated by AEMO |
|
REBID_DECISION_TIME |
VARCHAR2(20) |
|
Intended to support the Rebidding and Technical Parameters Guideline. The time at which the participant made the decision to rebid. Not validated by AEMO |
|
REBID_CATEGORY |
VARCHAR2(1) |
|
Intended to support the Rebidding and Technical Parameters Guideline. A provided rebid category. Not validated by AEMO |
|
REFERENCE_ID |
VARCHAR2(100) |
|
A participants unique Reference Id |
|
Name |
|
|
Comment |
BIDDAYOFFER_D shows the public summary of the energy and FCAS offers applicable in the Dispatch for the |
|
BIDDAYOFFER_D data is made public after 4am the next day. Source BIDDAYOFFER_D updates as ancillary service bids are processed. BIDDAYOFFER_D shows latest accepted energy and ancillary service bids. Volume Summary - approximately 1,000 rows per day |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
BIDTYPE |
|
DIRECTION |
|
DUID |
|
SETTLEMENTDATE |
|
Name |
|
LASTCHANGED |
|
Name |
|
PARTICIPANTID |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Market date for which the bid applied |
|
DUID |
VARCHAR2(10) |
X |
Dispatchable unit identifier |
|
BIDTYPE |
VARCHAR2(10) |
X |
Bid Type Identifier |
|
DIRECTION |
VARCHAR2(20) |
X |
The power flow direction to which this offer applies: GEN, LOAD or BIDIRECTIONAL |
|
BIDSETTLEMENTDATE |
DATE |
|
Market date for which the bid was submitted. |
|
OFFERDATE |
DATE |
|
Offer date and time |
|
VERSIONNO |
NUMBER(22,0) |
|
Version No. for given offer date |
|
PARTICIPANTID |
VARCHAR2(10) |
|
Unique participant identifier |
|
DAILYENERGYCONSTRAINT |
NUMBER(12,6) |
|
Maximum energy available from Energy Constrained Plant. (Energy Bids Only) |
|
REBIDEXPLANATION |
VARCHAR2(500) |
|
Explanation for all rebids and inflexibilities |
|
PRICEBAND1 |
NUMBER(9,2) |
|
Price for Availability Band 1 |
|
PRICEBAND2 |
NUMBER(9,2) |
|
Price for Availability Band 2 |
|
PRICEBAND3 |
NUMBER(9,2) |
|
Price for Availability Band 3 |
|
PRICEBAND4 |
NUMBER(9,2) |
|
Price for Availability Band 4 |
|
PRICEBAND5 |
NUMBER(9,2) |
|
Price for Availability Band 5 |
|
PRICEBAND6 |
NUMBER(9,2) |
|
Price for Availability Band 6 |
|
PRICEBAND7 |
NUMBER(9,2) |
|
Price for Availability Band 7 |
|
PRICEBAND8 |
NUMBER(9,2) |
|
Price for Availability Band 8 |
|
PRICEBAND9 |
NUMBER(9,2) |
|
Price for Availability Band 9 |
|
PRICEBAND10 |
NUMBER(9,2) |
|
Price for Availability Band 10 |
|
MINIMUMLOAD |
NUMBER(22,0) |
|
Minimum MW load fast start plant |
|
T1 |
NUMBER(22,0) |
|
Time to synchronise in minutes (Energy Bids Only) |
|
T2 |
NUMBER(22,0) |
|
Time to minimum load in minutes (Energy Bids Only) |
|
T3 |
NUMBER(22,0) |
|
Time at minimum load in minutes (Energy Bids Only) |
|
T4 |
NUMBER(22,0) |
|
Time to shutdown in minutes (Energy Bids Only) |
|
NORMALSTATUS |
VARCHAR2(3) |
|
ON/OFF for loads (Energy Bids Only) |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
MR_FACTOR |
NUMBER(16,6) |
|
Mandatory Restriction Scaling Factor |
|
ENTRYTYPE |
VARCHAR2(20) |
|
Daily if processed before BidCutOff of previous day, otherwise REBID |
|
Name |
|
|
Comment |
BIDOFFERFILETRK shows an audit trail of all files submitted containing ENERGY/FCAS/MNSP bid, including corrupt bids and rebids. |
|
BIDOFFERFILETRK data is confidential to the submitting participant. The new ancillary service arrangements require availability and prices for each Frequency Control Ancillary Service to be bid on a similar basis to energy. Three new tables facilitate ancillary service bidding. The new tables (BIDOFFERFILETRK, BIDDAYOFFER and BIDOFFERPERIOD) are similar in structure to energy bidding tables (OFFERFILETRK, DAYOFFER and PEROFFER). The significant differences with the new tables are. · The OFFERDATE field reflects the time the bid was loaded and this field alone provides the key for versioning of bids. The VERSIONNO field is retained for participant use as information only. · The new tables support bids for multiple services. The BIDTYPE field defines the service to which the bid applies. · There are no default bids. In the absence of a bid for a specific settlement date, the latest bid submitted for a previous settlement date applies. Source This data is updated as bids are processed. It includes all bids submitted including corrupt bids. Volume Approximately 100,000 records per year Note Confirmation is via CSV bid acknowledgement file |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
FILENAME |
|
Name |
|
OFFERDATE |
|
PARTICIPANTID |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Unique participant identifier |
|
OFFERDATE |
TIMESTAMP(3) |
X |
Time this bid was processed and loaded |
|
FILENAME |
VARCHAR2(80) |
X |
Submitted file name |
|
STATUS |
VARCHAR2(10) |
|
Load status [SUCCESSFUL/CORRUPT] |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
AUTHORISEDBY |
VARCHAR2(20) |
|
Participant agent who created the Offer |
|
AUTHORISEDDATE |
DATE |
|
When the Offer was processed - synonymous with LastChanged |
|
TRANSACTION_ID |
VARCHAR2(100) |
|
A GUID used to identify the submission transaction in AEMOs systems |
|
REFERENCE_ID |
VARCHAR2(100) |
|
A participant provided reference, which is required to be unique per submission (for a PARTICIPANTID) |
|
SUBMISSION_TIMESTAMP |
DATE |
|
The participant provided date/time for the submission |
|
COMMENTS |
VARCHAR2(1000) |
|
A participant provided comment |
|
SUBMISSION_METHOD |
VARCHAR2(20) |
|
Method by which this submission was made typically FTP, API, WEB |
|
Name |
|
|
Comment |
BIDOFFERPERIOD shows 5-minute period-based Energy and Ancillary Service bid data.BIDOFFERPERIOD is a child table of BIDDAYOFFER |
|
Name |
Comment |
Value |
|
Visibility |
|
Private & Public Next-Day |
|
Name |
|
BIDTYPE |
|
DIRECTION |
|
DUID |
|
OFFERDATETIME |
|
PERIODID |
|
TRADINGDATE |
|
Name |
Data Type |
Mandatory |
Comment |
|
DUID |
VARCHAR2(20) |
X |
Dispatchable Unit ID |
|
BIDTYPE |
VARCHAR2(10) |
X |
The type of bid, one-of ENERGY, RAISE6SEC, RAISE60SEC, RAISE5MIN, RAISEREG, LOWER6SEC, LOWER60SEC, LOWER5MIN, LOWERREG |
|
TRADINGDATE |
DATE |
X |
The trading date this bid is for |
|
OFFERDATETIME |
TIMESTAMP(3) |
X |
Time this bid was processed and loaded |
|
DIRECTION |
VARCHAR2(20) |
X |
The power flow direction to which this offer applies: GEN, LOAD or BIDIRECTIONAL |
|
PERIODID |
NUMBER(3,0) |
X |
Period ID 1 to 288 |
|
MAXAVAIL |
NUMBER(8,3) |
|
Maximum availability for this BidType in this period |
|
FIXEDLOAD |
NUMBER(8,3) |
|
Fixed unit output MW (Energy bids only) A null value means no fixed load so the unit is dispatched according to bid and market |
|
RAMPUPRATE |
NUMBER(6) |
|
MW/Min for raise (Energy bids only) |
|
RAMPDOWNRATE |
NUMBER(6) |
|
MW/Min for lower (Energy bids only) |
|
ENABLEMENTMIN |
NUMBER(8,3) |
|
Minimum Energy Output (MW) at which this ancillary service becomes available (AS Only) |
|
ENABLEMENTMAX |
NUMBER(8,3) |
|
Maximum Energy Output (MW) at which this ancillary service can be supplied (AS Only) |
|
LOWBREAKPOINT |
NUMBER(8,3) |
|
Minimum Energy Output (MW) at which the unit can provide the full availability (MAXAVAIL) for this ancillary service (AS Only) |
|
HIGHBREAKPOINT |
NUMBER(8,3) |
|
Maximum Energy Output (MW) at which the unit can provide the full availability (MAXAVAIL) for this ancillary service (AS Only) |
|
BANDAVAIL1 |
NUMBER(8,3) |
|
Availability at price band 1 |
|
BANDAVAIL2 |
NUMBER(8,3) |
|
Availability at price band 2 |
|
BANDAVAIL3 |
NUMBER(8,3) |
|
Availability at price band 3 |
|
BANDAVAIL4 |
NUMBER(8,3) |
|
Availability at price band 4 |
|
BANDAVAIL5 |
NUMBER(8,3) |
|
Availability at price band 5 |
|
BANDAVAIL6 |
NUMBER(8,3) |
|
Availability at price band 6 |
|
BANDAVAIL7 |
NUMBER(8,3) |
|
Availability at price band 7 |
|
BANDAVAIL8 |
NUMBER(8,3) |
|
Availability at price band 8 |
|
BANDAVAIL9 |
NUMBER(8,3) |
|
Availability at price band 9 |
|
BANDAVAIL10 |
NUMBER(8,3) |
|
Availability at price band 10 |
|
PASAAVAILABILITY |
NUMBER(8,3) |
|
Allows for future use for Energy bids, being the physical plant capability including any capability potentially available within 24 hours |
|
ENERGYLIMIT |
NUMBER(15,5) |
|
The Energy limit applying at the end of this dispatch interval in MWh. For GEN this is a lower energy limit. For LOAD this is an upper energy limit |
|
PERIODIDTO |
NUMBER(3,0) |
|
Period ID Ending |
|
Name |
|
|
Comment |
BIDPEROFFER_D shows the public summary of the energy and FCAS offers applicable in the Dispatch for the |
|
BIDPEROFFER_D is public data, so is available to all participants. Source BIDPEROFFER_D updates daily shortly after 4am. See also BIDPEROFFER. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
BIDTYPE |
|
DIRECTION |
|
DUID |
|
INTERVAL_DATETIME |
|
SETTLEMENTDATE |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Market date for which the bid applied |
|
DUID |
VARCHAR2(10) |
X |
Dispatchable Unit identifier |
|
BIDTYPE |
VARCHAR2(10) |
X |
Bid Type Identifier |
|
DIRECTION |
VARCHAR2(20) |
X |
The power flow direction to which this offer applies: GEN, LOAD or BIDIRECTIONAL |
|
INTERVAL_DATETIME |
DATE |
X |
Date and Time of the dispatch interval to which the offer applied |
|
BIDSETTLEMENTDATE |
DATE |
|
Market date for which the bid was submitted |
|
OFFERDATE |
DATE |
|
Offer date and time |
|
PERIODID |
NUMBER(22,0) |
|
The trading interval period identifier (1-288) |
|
VERSIONNO |
NUMBER(22,0) |
|
Version number of offer |
|
MAXAVAIL |
NUMBER(12,6) |
|
Maximum availability for this BidType in this period |
|
FIXEDLOAD |
NUMBER(12,6) |
|
Fixed unit output MW (Energy Bids Only). 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 (Energy Bids Only) |
|
ROCDOWN |
NUMBER(6,0) |
|
MW/Min for lower (Energy Bids Only) |
|
ENABLEMENTMIN |
NUMBER(6,0) |
|
Minimum Energy Output (MW) at which this ancillary service becomes available (AS Only) |
|
ENABLEMENTMAX |
NUMBER(6,0) |
|
Maximum Energy Output (MW) at which this ancillary service can be supplied (AS Only) |
|
LOWBREAKPOINT |
NUMBER(6,0) |
|
Minimum Energy Output (MW) at which the unit can provide the full availability (MAXAVAIL) for this ancillary service (AS Only) |
|
HIGHBREAKPOINT |
NUMBER(6,0) |
|
Maximum Energy Output (MW) at which the unit can provide the full availability (MAXAVAIL) for this ancillary service (AS Only) |
|
BANDAVAIL1 |
NUMBER(22,0) |
|
Availability at price band 1 |
|
BANDAVAIL2 |
NUMBER(22,0) |
|
Availability at price band 2 |
|
BANDAVAIL3 |
NUMBER(22,0) |
|
Availability at price band 3 |
|
BANDAVAIL4 |
NUMBER(22,0) |
|
Availability at price band 4 |
|
BANDAVAIL5 |
NUMBER(22,0) |
|
Availability at price band 5 |
|
BANDAVAIL6 |
NUMBER(22,0) |
|
Availability at price band 6 |
|
BANDAVAIL7 |
NUMBER(22,0) |
|
Availability at price band 7 |
|
BANDAVAIL8 |
NUMBER(22,0) |
|
Availability at price band 8 |
|
BANDAVAIL9 |
NUMBER(22,0) |
|
Availability at price band 9 |
|
BANDAVAIL10 |
NUMBER(22,0) |
|
Availability at price band 10 |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
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 |
|
ENERGYLIMIT |
NUMBER(15,5) |
|
The Energy limit applying at the end of this dispatch interval in MWh. For GEN this is a lower energy limit. For LOAD this is an upper energy limit |
|
Name |
|
|
Comment |
MNSP_BIDOFFERPERIOD shows availability for 5-minute periods for a specific Bid and LinkID for the given Trading Date and period. MNSP_BIDOFFERPERIOD is a child to MNSP_DAYOFFER and links to BIDOFFERFILETRK for 5MS Bids. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private & Public Next-Day |
|
Name |
|
LINKID |
|
OFFERDATETIME |
|
PERIODID |
|
TRADINGDATE |
|
Name |
Data Type |
Mandatory |
Comment |
|
LINKID |
VARCHAR2(20) |
X |
Identifier for each of the two MNSP Interconnector Links. Each link pertains to the direction from and to. |
|
TRADINGDATE |
DATE |
X |
The trading date this bid is for |
|
OFFERDATETIME |
TIMESTAMP(3) |
X |
Time this bid was processed and loaded |
|
PERIODID |
NUMBER(3,0) |
X |
Period ID, 1 to 288 |
|
MAXAVAIL |
NUMBER(8,3) |
|
Maximum planned availability MW |
|
FIXEDLOAD |
NUMBER(8,3) |
|
Fixed unit output, in MW. A value of NULL means no fixed load so the unit is dispatched according to bid and the market. |
|
RAMPUPRATE |
NUMBER(6) |
|
Ramp rate (MW / min) in the positive direction of flow for this MNSP link for this half-hour period |
|
BANDAVAIL1 |
NUMBER(8,3) |
|
Availability at price band 1 |
|
BANDAVAIL2 |
NUMBER(8,3) |
|
Availability at price band 2 |
|
BANDAVAIL3 |
NUMBER(8,3) |
|
Availability at price band 3 |
|
BANDAVAIL4 |
NUMBER(8,3) |
|
Availability at price band 4 |
|
BANDAVAIL5 |
NUMBER(8,3) |
|
Availability at price band 5 |
|
BANDAVAIL6 |
NUMBER(8,3) |
|
Availability at price band 6 |
|
BANDAVAIL7 |
NUMBER(8,3) |
|
Availability at price band 7 |
|
BANDAVAIL8 |
NUMBER(8,3) |
|
Availability at price band 8 |
|
BANDAVAIL9 |
NUMBER(8,3) |
|
Availability at price band 9 |
|
BANDAVAIL10 |
NUMBER(8,3) |
|
Availability at price band 10 |
|
PASAAVAILABILITY |
NUMBER(8,3) |
|
Allows for future use for Energy bids, being the physical plant capability including any capability potentially available within 24 hours |
|
Name |
|
|
Comment |
MNSP_DAYOFFER updates as bids are processed. All bids are available as part of next day market data. MNSP_DAYOFFER is the parent table to MNSP_BIDOFFERPERIOD, and joins to BIDOFFERFILETRK for 5MS Bids. |
|
MNSP_DAYOFFER shows own (confidential) data updates as bids are processed. All bids are available as part of next day market data. Volume 4, 000 per year |
|
Name |
Comment |
Value |
|
Visibility |
|
Private & Public Next-Day |
|
Name |
|
LINKID |
|
OFFERDATE |
|
PARTICIPANTID |
|
SETTLEMENTDATE |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
SETTLEMENTDATE |
DATE |
X |
Market Date from which bid is active |
|
OFFERDATE |
TIMESTAMP(3) |
X |
Time this bid was processed and loaded |
|
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. |
|
ENTRYTYPE |
VARCHAR2(20) |
|
Bid type. Either Rebid or Daily |
|
REBIDEXPLANATION |
VARCHAR2(500) |
|
Explanation for all rebids and inflexibilities |
|
PRICEBAND1 |
NUMBER(9,2) |
|
Price for Availability Band 1 |
|
PRICEBAND2 |
NUMBER(9,2) |
|
Price for Availability Band 2 |
|
PRICEBAND3 |
NUMBER(9,2) |
|
Price for Availability Band 3 |
|
PRICEBAND4 |
NUMBER(9,2) |
|
Price for Availability Band 4 |
|
PRICEBAND5 |
NUMBER(9,2) |
|
Price for Availability Band 5 |
|
PRICEBAND6 |
NUMBER(9,2) |
|
Price for Availability Band 6 |
|
PRICEBAND7 |
NUMBER(9,2) |
|
Price for Availability Band 7 |
|
PRICEBAND8 |
NUMBER(9,2) |
|
Price for Availability Band 8 |
|
PRICEBAND9 |
NUMBER(9,2) |
|
Price for Availability Band 9 |
|
PRICEBAND10 |
NUMBER(9,2) |
|
Price for Availability Band 10 |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
MR_FACTOR |
NUMBER(16,6) |
|
Mandatory Restriction Offer Factor |
|
REBID_EVENT_TIME |
VARCHAR2(20) |
|
The time of the event(s) or other occurrence(s) cited/adduced as the reason for the rebid. Required for rebids, not required for fixed load or low ramp rates. Expected in the format: HH:MM:SS e.g. 20:11:00 |
|
REBID_AWARE_TIME |
VARCHAR2(20) |
|
Intended to support the Rebidding and Technical Parameters Guideline. The time at which the participant became aware of the event(s) / occurrence(s) that prompted the rebid. Not validated by AEMO |
|
REBID_DECISION_TIME |
VARCHAR2(20) |
|
Intended to support the Rebidding and Technical Parameters Guideline. The time at which the participant made the decision to rebid. Not validated by AEMO |
|
REBID_CATEGORY |
VARCHAR2(1) |
|
Intended to support the Rebidding and Technical Parameters Guideline. A provided rebid category. Not validated by AEMO |
|
REFERENCE_ID |
VARCHAR2(100) |
|
A participants unique Reference Id |
|
Name |
|
|
Comment |
Participant submitted Offers for MTPASA process |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
EFFECTIVEDATE |
|
OFFERDATETIME |
|
PARTICIPANTID |
|
UNITID |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
PARTICIPANTID |
VARCHAR2(20) |
X |
Unique participant identifier |
|
OFFERDATETIME |
DATE |
X |
Date time file processed |
|
UNITID |
VARCHAR2(20) |
X |
either duid or mnsp linkid |
|
EFFECTIVEDATE |
DATE |
X |
trade date when the offer becomes effective |
|
ENERGY |
NUMBER(9) |
|
weekly energy constraint value |
|
CAPACITY1 |
NUMBER(9) |
|
capacity value day 1 (sunday) |
|
CAPACITY2 |
NUMBER(9) |
|
capacity value day 2 (monday) |
|
CAPACITY3 |
NUMBER(9) |
|
capacity value day 3 (tuesday) |
|
CAPACITY4 |
NUMBER(9) |
|
capacity value day 4 (wednesday) |
|
CAPACITY5 |
NUMBER(9) |
|
capacity value day 5 (thursday) |
|
CAPACITY6 |
NUMBER(9) |
|
capacity value day 6 (friday) |
|
CAPACITY7 |
NUMBER(9) |
|
capacity value day 7 (saturday) |
|
LASTCHANGED |
DATE |
|
timestamp when record last changed |
|
UNITSTATE1 |
VARCHAR2(20) |
|
The unit state value for day 1 Sunday |
|
UNITSTATE2 |
VARCHAR2(20) |
|
The unit state value for day 2 Monday |
|
UNITSTATE3 |
VARCHAR2(20) |
|
The unit state value for day 3 Tuesday |
|
UNITSTATE4 |
VARCHAR2(20) |
|
The unit state value for 4 Wednesday |
|
UNITSTATE5 |
VARCHAR2(20) |
|
The unit state value for day 5 Thursday |
|
UNITSTATE6 |
VARCHAR2(20) |
|
The unit state value for day 6 Friday |
|
UNITSTATE7 |
VARCHAR2(20) |
|
The unit state value for day 7 Saturday |
|
RECALLTIME1 |
NUMBER(4) |
|
The recall time associated with the unit state for day 1 Sunday |
|
RECALLTIME2 |
NUMBER(4) |
|
The recall time associated with the unit state for day 2 Monday |
|
RECALLTIME3 |
NUMBER(4) |
|
The recall time associated with the unit state for day 3 Tuesday |
|
RECALLTIME4 |
NUMBER(4) |
|
The recall time associated with the unit state for day 4 Wednesday |
|
RECALLTIME5 |
NUMBER(4) |
|
The recall time associated with the unit state for day 5 Thursday |
|
RECALLTIME6 |
NUMBER(4) |
|
The recall time associated with the unit state for day 6 Friday |
|
RECALLTIME7 |
NUMBER(4) |
|
The recall time associated with the unit state for day 7 Saturday |
|
Name |
|
|
Comment |
Participant submitted Offers for MTPASA process |
|
MTPASA_OFFERFILETRK is confidential to the relevant participant. Source MTPASA_OFFERFILETRK updates for every submitted MTPASA bid. Volume 4000 per year, being one per bid containing an MTPASA bid |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
OFFERDATETIME |
|
PARTICIPANTID |
|
Name |
Data Type |
Mandatory |
Comment |
|
PARTICIPANTID |
VARCHAR2(20) |
X |
Unique participant identifier |
|
OFFERDATETIME |
DATE |
X |
Date time file processed |
|
FILENAME |
VARCHAR2(200) |
|
Submitted file name |
|
|
|