|
Name |
|
|
Comment |
AUCTION holds auction details. AUCTION is new in March 2003 to support SRA Inter-Temporal Linking. |
|
AUCTION is public data, and is available to all participants. Source Static. Volume 4 records per year |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
AUCTIONID |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
AUCTIONID |
VARCHAR2(30) |
X |
Unique id for each auction date |
|
AUCTIONDATE |
DATE |
|
Auction date |
|
NOTIFYDATE |
DATE |
|
|
|
STARTDATE |
DATE |
|
Open date for bidding |
|
ENDDATE |
DATE |
|
Close date for bidding |
|
DESCRIPTION |
VARCHAR2(100) |
|
Description of an auction |
|
AUTHORISEDDATE |
DATE |
|
|
|
AUTHORISEDBY |
VARCHAR2(30) |
|
|
|
LASTCHANGED |
DATE |
|
|
|
Name |
|
|
Comment |
AUCTION_CALENDAR holds the definitions of each auction quarter in a contract year. AUCTION_CALENDAR supports the Settlement Residue Auction. |
|
AUCTION_CALENDAR is public data, and is available to all participants. Source Updates are usually quarterly by the SRA team. Volume AUCTION_CALENDAR shows a maximum of 16 records per year. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
CONTRACTYEAR |
|
QUARTER |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
SRA Contracted Year |
|
QUARTER |
NUMBER(1,0) |
X |
SRA Contracted Quarter |
|
STARTDATE |
DATE |
|
First day of SRA Contract Quarter expressed as Date |
|
ENDDATE |
DATE |
|
Last day of SRA Contract Quarter expressed as Date |
|
NOTIFYDATE |
DATE |
|
Default notification date |
|
PAYMENTDATE |
DATE |
|
Date for payment by Participant |
|
RECONCILIATIONDATE |
DATE |
|
Date of reconciliation for the quarter |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
PRELIMPURCHASESTMTDATE |
DATE |
|
The date the Prelim Purchase Statement is generated |
|
PRELIMPROCEEDSSTMTDATE |
DATE |
|
The date the Prelim Proceeds Statement is generated |
|
FINALPURCHASESTMTDATE |
DATE |
|
The date the Final Purchase Statement is generated |
|
FINALPROCEEDSSTMTDATE |
DATE |
|
The date the Final Proceeds Statement is generated |
|
Name |
|
|
Comment |
AUCTION_IC_ALLOCATIONS supports the Settlement Residue Auction by providing the basis for setting up contracts for individual tranches. AUCTION_IC_ALLOCATIONS shows the default definitions for the total number of units and proportion applicable to each directional interconnector for a specified auction quarter. |
|
AUCTION_IC_ALLOCATIONS is public data, and is available to all participants. Source Updates are usually quarterly as auctions are held from Settlement Residue Auction team's SRIS interface. Volume AUCTION_IC_ALLOCATIONS contains a maximum of 100 records per year. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
CONTRACTYEAR |
|
FROMREGIONID |
|
INTERCONNECTORID |
|
QUARTER |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
SRA Contracted Year |
|
QUARTER |
NUMBER(1,0) |
X |
SRA Contracted Quarter |
|
VERSIONNO |
NUMBER(3,0) |
X |
Version of data for other key data - a higher version for same key data takes precedence |
|
INTERCONNECTORID |
VARCHAR2(10) |
X |
Contracted Interconnector Identifier |
|
FROMREGIONID |
VARCHAR2(10) |
X |
Nominated source region for Interconnector |
|
MAXIMUMUNITS |
NUMBER(5,0) |
|
Number of units on the interconnector |
|
PROPORTION |
NUMBER(8,5) |
|
Percentage of the total residue for each Unit |
|
AUCTIONFEE |
NUMBER(17,5) |
|
Daily auction fee |
|
CHANGEDATE |
DATE |
|
Authorisation date |
|
CHANGEDBY |
VARCHAR2(15) |
|
Name of person authorising this data set |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
AUCTIONFEE_SALES |
Number(18,8) |
|
Fees for Cancelled Units. |
|
Name |
|
|
Comment |
AUCTION_REVENUE_ESTIMATE supports the Settlement Residue Auction, by holding the evaluator’s estimates of revenue for each month of a given quarter. |
|
AUCTION_REVENUE_ESTIMATE is public data, and is available to all participants. Source Updates are quarterly from SRA team via SRIS interface Volume AUCTION_REVENUE_ESTIMATE contains a maximum of 300 records per year. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
CONTRACTYEAR |
|
FROMREGIONID |
|
INTERCONNECTORID |
|
MONTHNO |
|
QUARTER |
|
VALUATIONID |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
SRA Contracted Year |
|
QUARTER |
NUMBER(1,0) |
X |
SRA Contracted Quarter |
|
VALUATIONID |
VARCHAR2(15) |
X |
Identifier of the estimator |
|
VERSIONNO |
NUMBER(3,0) |
X |
Version of data for other key data - a higher version for same key data will take precedence |
|
INTERCONNECTORID |
VARCHAR2(10) |
X |
Contracted Interconnector |
|
FROMREGIONID |
VARCHAR2(10) |
X |
Nominated source region for Interconnector |
|
MONTHNO |
NUMBER(1,0) |
X |
Month number within quarter (1..3) |
|
STARTDATE |
DATE |
|
First day of month as date |
|
ENDDATE |
DATE |
|
Last day of month as date |
|
REVENUE |
NUMBER(17,5) |
|
Estimated Revenue |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
AUCTION_REVENUE_TRACK supports the Settlement Residue Auction, by holding the tracking information for each evaluator’s estimates for a given quarter. The status field is dynamic and is used for selection of estimates to be published. |
|
AUCTION_REVENUE_TRACK is public data, and is available to all participants. Source Updates are quarterly after SRA team updates SRIS interface. Volume AUCTION_REVENUE_TRACK contains a maximum of 100 records per year. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
CONTRACTYEAR |
|
QUARTER |
|
VALUATIONID |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
SRA Contracted Year |
|
QUARTER |
NUMBER(1,0) |
X |
SRA Contracted Quarter |
|
VALUATIONID |
VARCHAR2(15) |
X |
Identifier of the estimator |
|
VERSIONNO |
NUMBER(3,0) |
X |
Version of data for other key data - a higher version for same key data takes precedence |
|
EFFECTIVEDATE |
DATE |
|
Date from which the record change is applicable |
|
STATUS |
VARCHAR2(10) |
|
Internal use |
|
DOCUMENTREF |
VARCHAR2(30) |
|
Reference to methodology document |
|
AUTHORISEDDATE |
DATE |
|
Date of authorisation for this record |
|
AUTHORISEDBY |
VARCHAR2(15) |
|
Name of person authorising this record |
|
LASTCHANGED |
DATE |
|
Date and time this record was last changed |
|
Name |
|
|
Comment |
AUCTION_RP_ESTIMATE supports the Settlement Residue Auction, by holding the evaluator’s estimates of revenue prices for a given quarter. |
|
AUCTION_RP_ESTIMATE is public data, and is available to all participants. Source Updates are quarterly by SRA team via SRIS interface. Volume This view contains a maximum of 100 records per year. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
CONTRACTYEAR |
|
FROMREGIONID |
|
INTERCONNECTORID |
|
QUARTER |
|
VALUATIONID |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
SRA Contracted Year |
|
QUARTER |
NUMBER(1,0) |
X |
SRA Contracted Quarter |
|
VALUATIONID |
VARCHAR2(15) |
X |
Identifier of the estimator |
|
VERSIONNO |
NUMBER(3,0) |
X |
Version of data for other key data - a higher version for same key data takes precedence |
|
INTERCONNECTORID |
VARCHAR2(10) |
X |
Contracted Interconnector |
|
FROMREGIONID |
VARCHAR2(10) |
X |
Nominated source region for Interconnector |
|
RPESTIMATE |
NUMBER(17,5) |
|
Estimate of reserve price |
|
LASTCHANGED |
DATE |
|
Last date and time record was changed |
|
Name |
|
|
Comment |
AUCTION_TRANCHE supports the Settlement Residue Auction, by holding the default definitions for the percentage number of units allocated and dates applicable to each tranche for a specified auction quarter. This information provides the basis for setting up contracts for individual tranches. |
|
AUCTION_TRANCHE is public data, and is available to all participants. Source Updates are quarterly from SRA team via SRIS interface. Volume AUCTION_TRANCHE contains a maximum of 100 records per year. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
CONTRACTYEAR |
|
QUARTER |
|
TRANCHE |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
SRA Contracted Year |
|
QUARTER |
NUMBER(1,0) |
X |
SRA Contracted Quarter |
|
VERSIONNO |
NUMBER(3,0) |
X |
Version of data for other key data - a higher version for same key data will take precedence |
|
TRANCHE |
NUMBER(2,0) |
X |
Label identifying the arbitrary segmented share of the Interconnector flow |
|
AUCTIONDATE |
DATE |
|
Default date of the auction |
|
NOTIFYDATE |
DATE |
|
Default date participants notified of details |
|
UNITALLOCATION |
NUMBER(18,8) |
|
Percentage of units allocated to the tranche |
|
CHANGEDATE |
DATE |
|
Date of changing this record |
|
CHANGEDBY |
VARCHAR2(15) |
|
Name of person who changed this record |
|
LASTCHANGED |
DATE |
|
Date and time record was last changed |
|
Name |
|
|
Comment |
RESIDUE_BID_TRK supports the Settlement Residue Auction, by detailing which bid was used for which SRA Contract run. |
|
Source RESIDUE_BID_TRK updates are usually quarterly from participants before an Auction. RESIDUE_BID_TRK data is confidential to the relevant participant. RESIDUE_BID_TRK excludes contracts and versions without a valid publication date (i.e invalid bids are ignored). Volume Assuming monthly contracts, RESIDUE_BID_TRK shows a maximum of 500 records per year. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
AUCTIONID |
|
PARTICIPANTID |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTID |
VARCHAR2(30) |
|
SRA Contract unique identifier |
|
VERSIONNO |
NUMBER(3,0) |
X |
Version of Bid used |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Identifier of participant |
|
BIDLOADDATE |
DATE |
|
Date and time bid used |
|
LASTCHANGED |
DATE |
|
Date and time this record was last changed |
|
AUCTIONID |
VARCHAR2(30) |
X |
Unique id for each auction date. (new in March 2003 to support SRA Inter-Temporal Linking) |
|
Name |
|
|
Comment |
RESIDUE_CON_DATA supports the Settlement Residue Auction, by holding for each participant the confidential data from the auction. RESIDUE_CON_DATA joins to RESIDUE_PUBLIC_DATA and RESIDUE_TRK. |
|
Source RESIDUE_CON_DATA refreshes whenever a Settlement Residue Auction is run (i.e. quarterly). RESIDUE_CON_DATA data is confidential to the relevant participant. RESIDUE_CON_DATA excludes contracts and versions without a valid publication date (i.e invalid bids are ignored). Volume RESIDUE_CON_DATA shows a maximum of 6000 records per year. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
CONTRACTID |
|
FROMREGIONID |
|
INTERCONNECTORID |
|
PARTICIPANTID |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTID |
VARCHAR2(30) |
X |
SRA Contract unique identifier |
|
VERSIONNO |
NUMBER(3,0) |
X |
Contract run version |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Identifier of Contracted Participant |
|
INTERCONNECTORID |
VARCHAR2(10) |
X |
Identifier of Contracted Interconnector |
|
FROMREGIONID |
VARCHAR2(10) |
X |
Nominated source region for Interconnector |
|
UNITSPURCHASED |
NUMBER(17,5) |
|
Units purchased on the directional interconnector (i.e. Contracted quantity) |
|
LINKPAYMENT |
NUMBER(17,5) |
|
Payment due (i.e. total purchase price) |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
SECONDARY_UNITS_SOLD |
Number(18,8) |
|
The number of cancelled Units for all Auction Participants. |
|
Name |
|
|
Comment |
RESIDUE_CON_ESTIMATES_TRK supports the Settlement Residue Auction, by holding the tracking details of the estimates used to generate the reserve price for each contract. |
|
Source RESIDUE_CON_ESTIMATES_TRK updates are quarterly by SRA team. Volume Assuming monthly contracts, RESIDUE_CON_ESTIMATES_TRK shows a maximum of 50 records per year. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
CONTRACTID |
|
CONTRACTYEAR |
|
QUARTER |
|
VALUATIONID |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTID |
VARCHAR2(30) |
X |
SRA Contract unique identifier |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
AEMO Contract Year number starting in week containing 1st January |
|
QUARTER |
NUMBER(1,0) |
X |
Contract Quarter |
|
VALUATIONID |
VARCHAR2(15) |
X |
Identifier of the estimator |
|
VERSIONNO |
NUMBER(3,0) |
|
Version of a record, as nominated by the participant |
|
LASTCHANGED |
DATE |
|
Date and time this record was changed |
|
Name |
|
|
Comment |
RESIDUE_CON_FUNDS supports the Settlement Residue Auction, by holding the fund details for each contract. |
|
RESIDUE_CON_FUNDS data is public, so is available to all participants. Source RESIDUE_CON_FUNDS updates are quarterly from SRA team via SRIS interface. Volume Assuming quarterly contracts, RESIDUE_CON_FUNDS contains a maximum of 600 records per year. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
CONTRACTID |
|
FROMREGIONID |
|
INTERCONNECTORID |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTID |
VARCHAR2(30) |
X |
SRA Contract unique identifier as specified by AEMO |
|
INTERCONNECTORID |
VARCHAR2(10) |
X |
Identifier for the Contracted Interconnector |
|
FROMREGIONID |
VARCHAR2(10) |
X |
Nominated source region for Interconnector |
|
DEFAULTUNITS |
NUMBER(5,0) |
|
Actual number of units allocated based on the auction default percentage for the tranche and the total number of units to be auctioned for this quarter |
|
ROLLOVERUNITS |
NUMBER(5,0) |
|
Units reallocated from the previous tranche of this quarter |
|
REALLOCATEDUNITS |
NUMBER(5,0) |
|
Units reallocated from the previous tranche of this quarter because they were not taken up by the participant |
|
UNITSOFFERED |
NUMBER(5,0) |
|
Total units offered for Contract |
|
MEANRESERVEPRICE |
NUMBER(9,2) |
|
Average reserve price calculated from the selected estimates |
|
SCALEFACTOR |
NUMBER(8,5) |
|
Scaling factor for regional Frequency control Ancillary Service requirement |
|
ACTUALRESERVEPRICE |
NUMBER(9,2) |
|
Actual reserve price |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
RESIDUE_CONTRACTS supports the Settlement Residue Auction, by holding the contract details for each period for which a residue contract will be offered. |
|
RESIDUE_CONTRACTS data is public, so is available to all participants. Source RESIDUE_CONTRACTS updates are quarterly by AEMO. Volume Assuming quarterly contracts, RESIDUE_CONTRACTS contains a maximum of 50 records per year. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
CONTRACTYEAR |
|
QUARTER |
|
TRANCHE |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
SRA Contracted Year |
|
QUARTER |
NUMBER(1,0) |
X |
SRA Contracted Quarter |
|
TRANCHE |
NUMBER(2,0) |
X |
Label identifying the arbitrary segmented share of the Interconnector flow |
|
CONTRACTID |
VARCHAR2(30) |
|
Unique identifier for each SRA Contract as specified by AEMO |
|
STARTDATE |
DATE |
|
SRA Quarter start date |
|
ENDDATE |
DATE |
|
SRA Quarter end date |
|
NOTIFYDATE |
DATE |
|
Open date of bidding, calculated as RNOTIFYDATE business days before the auction date |
|
AUCTIONDATE |
DATE |
|
Close date of bidding, calculated as RAUCDATE business days before the contract start date |
|
CALCMETHOD |
VARCHAR2(20) |
|
Identifies methodology used |
|
AUTHORISEDDATE |
DATE |
|
Authorisation date for this record |
|
AUTHORISEDBY |
VARCHAR2(15) |
|
Name of authorising officer or process |
|
NOTIFYPOSTDATE |
DATE |
|
Date notification posted |
|
NOTIFYBY |
VARCHAR2(15) |
|
Name of notifying person |
|
POSTDATE |
DATE |
|
Date of publishing the auction results |
|
POSTEDBY |
VARCHAR2(15) |
|
Name of publishing officer or process |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
DESCRIPTION |
VARCHAR2(80) |
|
Description of Contract |
|
AUCTIONID |
VARCHAR2(30) |
|
Unique id for each auction date (new in March 2003 to support SRA Inter-Temporal Linking) |
|
Name |
|
|
Comment |
RESIDUE_FUNDS_BID supports the Settlement Residue Auction, by showing the fund details for each SRA bid by each Participant. |
|
Source Participant's bid file. RESIDUE_FUNDS_BID data is confidential to the relevant participant. RESIDUE_FUNDS_BID shows a maximum of 30,000 records per year. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
CONTRACTID |
|
FROMREGIONID |
|
INTERCONNECTORID |
|
LOADDATE |
|
OPTIONID |
|
PARTICIPANTID |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTID |
VARCHAR2(30) |
X |
SRA Contract identifier |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Participant identifier |
|
LOADDATE |
DATE |
X |
Date and time the batcher loaded the SRA offer |
|
OPTIONID |
NUMBER(3,0) |
X |
Unique option identifier (1..20) |
|
INTERCONNECTORID |
VARCHAR2(10) |
X |
Interconnector Identifier |
|
FROMREGIONID |
VARCHAR2(10) |
X |
Nominated source region for Interconnector |
|
UNITS |
NUMBER(5,0) |
|
Quantity of units bid for |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
RESIDUE_PRICE_BID supports the Settlement Residue Auction, holding the unit and bid price details for each participant. |
|
Source The participant's own bid file RESIDUE_PRICE_BID data is confidential to the relevant participant. The public version of the data is available to all auction participants post the associated auction date in RESIDUE_PRICE_FUNDS_BID. Volume RESIDUE_PRICE_BID shows a maximum of 10,000 records per year. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
AUCTIONID |
|
LOADDATE |
|
OPTIONID |
|
PARTICIPANTID |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTID |
VARCHAR2(30) |
|
Not to be used. Unique id for each SRA contract (specified by AEMO) |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Participant identifier |
|
LOADDATE |
DATE |
X |
Date and Time the batcher loaded the bid |
|
OPTIONID |
NUMBER(3,0) |
X |
Unique option (bid) identifier (1..800) |
|
BIDPRICE |
NUMBER(17,5) |
|
Price offered for each unit |
|
LASTCHANGED |
DATE |
|
Date and time this record was last changed |
|
AUCTIONID |
VARCHAR2(30) |
X |
Unique id for each auction date (new in March 2003 to support SRA Inter-Temporal Linking) |
|
Name |
|
|
Comment |
RESIDUE_PRICE_FUNDS_BIDshows the bids producing the auction outcome, without exposing participant-specific details. RESIDUE_PRICE_FUNDS_BID is new in March 2003 to support SRA Inter-Temporal Linking. |
|
RESIDUE_PRICE_FUNDS_BID data is public. The data is available to all auction participants post the associated auction date. Volume The volume is very dependent on the number of active bids. An indication is about 250,000 per year. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
AUCTIONID |
|
CONTRACTID |
|
FROMREGIONID |
|
INTERCONNECTORID |
|
LINKEDBIDFLAG |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTID |
VARCHAR2(30) |
X |
Unique id for each contract specified by AEMO |
|
INTERCONNECTORID |
VARCHAR2(10) |
X |
Unique interconnector identifier |
|
FROMREGIONID |
VARCHAR2(10) |
X |
Unique region identifier |
|
UNITS |
NUMBER(5,0) |
|
Quantity of units bid |
|
BIDPRICE |
NUMBER(17,5) |
|
Price bid for each unit |
|
LINKEDBIDFLAG |
NUMBER(6,0) |
X |
A unique option id, with respect to the auction, created to show which bid elements are linked. |
|
AUCTIONID |
VARCHAR2(30) |
X |
Unique id for each auction date |
|
LASTCHANGED |
DATE |
|
Date and time this record was last changed |
|
Name |
|
|
Comment |
RESIDUE_PUBLIC_DATA shows the public auction results. |
|
RESIDUE_PUBLIC_DATA excludes contracts and versions without a valid publication date (i.e. invalid bids are ignored). The data is available to all auction participants post the associated auction date. Source RESIDUE_PUBLIC_DATA updates are quarterly from NEMMCO. Volume RESIDUE_PUBLIC_DATA shows a maximum of 120 records per year. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
CONTRACTID |
|
FROMREGIONID |
|
INTERCONNECTORID |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTID |
VARCHAR2(30) |
X |
Unique id for each contract to be specified by AEMO |
|
VERSIONNO |
NUMBER(3,0) |
X |
Version Number |
|
INTERCONNECTORID |
VARCHAR2(10) |
X |
Unique interconnector identifier |
|
FROMREGIONID |
VARCHAR2(10) |
X |
Nominated source region for Interconnector |
|
UNITSOFFERED |
NUMBER(5,0) |
|
Total units offered for auction |
|
UNITSSOLD |
NUMBER(16,6) |
|
Units Sold (modified format and usage in March 2003 to support SRA Inter-Temporal Linking) |
|
CLEARINGPRICE |
NUMBER(17,5) |
|
Clearing price |
|
RESERVEPRICE |
NUMBER(17,5) |
|
Reserve price |
|
LASTCHANGED |
DATE |
|
Date and time this record was last changed |
|
Name |
|
|
Comment |
RESIDUE_TRK supports the Settlement Residue Auction, by showing the tracking records for different residue auction runs. RESIDUE_TRK joins to RESIDUE_PUBLIC_DATA and RESIDUE_CON_DATA. |
|
Source RESIDUE_TRK updates whenever Settlement Residue Auctions are run and the results published (i.e. quarterly). The RESIDUE_TRK data is available to all participants post the associated auction date. Volume Assuming quarterly contracts, RESIDUE_TRK shows a maximum of 50 records per year. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
AUCTIONID |
|
VERSIONNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTID |
VARCHAR2(30) |
|
SRA Contract identifier |
|
VERSIONNO |
NUMBER(3,0) |
X |
Contract run version |
|
RUNDATE |
DATE |
|
Date auction results determined |
|
AUTHORISEDDATE |
DATE |
|
Date results published |
|
AUTHORISEDBY |
VARCHAR2(15) |
|
Authorising officer or process |
|
POSTDATE |
DATE |
|
Date the run is authorised |
|
POSTEDBY |
VARCHAR2(15) |
|
Name of authorising officer or process |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
STATUS |
VARCHAR2(15) |
|
Load status [SUCCESSFUL/CORRUPT] |
|
AUCTIONID |
VARCHAR2(30) |
X |
Unique id for each auction date. (new in March 2003 to support SRA Inter-Temporal Linking) |
|
Name |
|
|
Comment |
RESIDUECONTRACTPAYMENTS shows Settlement Residue Auction payment Participant notifications. |
|
RESIDUECONTRACTPAYMENTS data is confidential to the relevant participant. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
CONTRACTID |
|
PARTICIPANTID |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTID |
VARCHAR2(30) |
X |
SRA Contract ID |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Participant Identifier |
|
LASTCHANGED |
DATE |
|
Date and time this record was last changed |
|
Name |
|
|
Comment |
RESIDUEFILETRK records all Settlement Residue Auction offers submitted by participants. |
|
RESIDUEFILETRK data is confidential to each participant Source RESIDUEFILETRK updates are ad hoc from participants Volume Assuming quarterly contracts RESIDUEFILETRK contains a maximum of 5,000 records per annum. Each bid file can contain many bids for each auction. Participants can input multiple bids (with the last acknowledged file being used in the auction). |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
AUCTIONID |
|
LOADDATE |
|
PARTICIPANTID |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTID |
VARCHAR2(30) |
|
SRA ContractID |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Participant Identifier |
|
LOADDATE |
DATE |
X |
Date-Time SRA offer was loaded |
|
FILENAME |
VARCHAR2(40) |
|
SRA offer file name |
|
ACKFILENAME |
VARCHAR2(40) |
|
SRA acknowledgment file name |
|
STATUS |
VARCHAR2(10) |
|
Load status [SUCCESSFUL/CORRUPT] |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
AUCTIONID |
VARCHAR2(30) |
X |
Unique id for each auction date. (new in March 2003 to support SRA Inter-Temporal Linking) |
|
Name |
|
|
Comment |
Records the Cash Security details provided by an SRA Auction Participant as collateral to cover their Trading Position in the SRA market |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
CASH_SECURITY_ID |
|
Name |
Data Type |
Mandatory |
Comment |
|
CASH_SECURITY_ID |
VARCHAR2(36) |
X |
Unique identifier for the cash security. |
|
PARTICIPANTID |
VARCHAR2(10) |
|
Unique identifier for the auction participant lodging the cash security. |
|
PROVISION_DATE |
DATE |
|
Date AEMO received the Cash Security deposit |
|
CASH_AMOUNT |
NUMBER(18,8) |
|
Dollar amount of the cash security. |
|
INTEREST_ACCT_ID |
VARCHAR2(20) |
|
The interest account ID for calculating the interest payment |
|
AUTHORISEDDATE |
DATE |
|
Authorised date |
|
FINALRETURNDATE |
DATE |
|
Date the entire Cash Security amount was returned to the Auction Participant |
|
CASH_SECURITY_RETURNED |
NUMBER(18,8) |
|
Returned Dollar amount of the Cash Security. |
|
DELETIONDATE |
DATE |
|
Cash Security deleted date. For valid records, DeletionDate will be Null. |
|
LASTCHANGED |
DATE |
|
The date and time this record was last modified |
|
Name |
|
|
Comment |
This table stores details of the margins returned to the participants. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
CASH_SECURITY_ID |
|
PARTICIPANTID |
|
SRA_QUARTER |
|
SRA_RUNNO |
|
SRA_YEAR |
|
Name |
Data Type |
Mandatory |
Comment |
|
SRA_YEAR |
NUMBER(4) |
X |
Year of the Tranche |
|
SRA_QUARTER |
NUMBER(3) |
X |
Relevant Quarter of the Tranche |
|
SRA_RUNNO |
NUMBER(3) |
X |
SRA Run Number |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
The participant identifier. |
|
CASH_SECURITY_ID |
VARCHAR2(36) |
X |
Unique identifier for the cash security. |
|
RETURNED_AMOUNT |
NUMBER(18,8) |
|
The amount returned to the Auction participant from this cash security. |
|
RETURNED_INTEREST |
NUMBER(18,8) |
|
The amount of interest applicable to the returned amount. |
|
Name |
|
|
Comment |
Records the amount of Cash Security required to be held by an Auction Participant after settlement |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
PARTICIPANTID |
|
SRA_QUARTER |
|
SRA_RUNNO |
|
SRA_YEAR |
|
Name |
Data Type |
Mandatory |
Comment |
|
SRA_YEAR |
NUMBER(4) |
X |
Year of the Tranche |
|
SRA_QUARTER |
NUMBER(3) |
X |
Relevant Quarter of the Tranche |
|
SRA_RUNNO |
NUMBER(3) |
X |
SRA Run Number |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Unique participant identifier. |
|
TOTAL_CASH_SECURITY |
NUMBER(18,8) |
|
Total cash security held by the participant. |
|
REQUIRED_MARGIN |
NUMBER(18,8) |
|
The amount of trading cash security required to be held by the participant after settlement. |
|
RETURNED_MARGIN |
NUMBER(18,8) |
|
The amount of cash security returned to the participant. |
|
RETURNED_MARGIN_INTEREST |
NUMBER(18,8) |
|
The amount of interest applicable to returned cash security amounts. |
|
Name |
|
|
Comment |
Records details of the Cancelled Units and their value for the Auction Participant |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
CONTRACTID |
|
FROMREGIONID |
|
INTERCONNECTORID |
|
PARTICIPANTID |
|
SRA_QUARTER |
|
SRA_RUNNO |
|
SRA_YEAR |
|
Name |
Data Type |
Mandatory |
Comment |
|
SRA_YEAR |
NUMBER(4) |
X |
Year of the Tranche |
|
SRA_QUARTER |
NUMBER(3) |
X |
Relevant Quarter of the Tranche |
|
SRA_RUNNO |
NUMBER(3) |
X |
SRA Run Number |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Unique participant identifier |
|
INTERCONNECTORID |
VARCHAR2(10) |
X |
The identifier for the Directional Interconnector |
|
FROMREGIONID |
VARCHAR2(10) |
X |
The source region identifier for the Directional Interconnector |
|
CONTRACTID |
VARCHAR2(10) |
X |
The SRA contract identifier |
|
UNITS_PURCHASED |
NUMBER(18,8) |
|
The number of units purchased |
|
CLEARING_PRICE |
NUMBER(18,8) |
|
The clearing price of the auction |
|
RECEIPT_AMOUNT |
NUMBER(18,8) |
|
The payment amount owed to AEMO |
|
LASTCHANGED |
DATE |
|
The last changed date for the record |
|
PROCEEDS_AMOUNT |
NUMBER(18,8) |
|
Dollar value of Cancelled Units in the Auction for the Auction Participant |
|
UNITS_SOLD |
NUMBER(18,8) |
|
Units cancelled in the auction by the Auction participant. |
|
Name |
|
|
Comment |
Records details of the SRA financial auction payment |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
CONTRACTID |
|
FROMREGIONID |
|
INTERCONNECTORID |
|
PARTICIPANTID |
|
SRA_QUARTER |
|
SRA_RUNNO |
|
SRA_YEAR |
|
Name |
Data Type |
Mandatory |
Comment |
|
SRA_YEAR |
NUMBER(4) |
X |
Year of the Tranche |
|
SRA_QUARTER |
NUMBER(3) |
X |
Relevant Quarter of the Tranche |
|
SRA_RUNNO |
NUMBER(3) |
X |
SRA Run Number |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Unique participant identifier |
|
INTERCONNECTORID |
VARCHAR2(10) |
X |
The identifier for the Directional Interconnector |
|
FROMREGIONID |
VARCHAR2(10) |
X |
The source Region identifier for the Directional Interconnector |
|
CONTRACTID |
VARCHAR2(10) |
X |
The SRA contract identifier |
|
MAXIMUM_UNITS |
NUMBER(18,8) |
|
The Maximum Units Available for purchase in the Auction |
|
UNITS_SOLD |
NUMBER(18,8) |
|
The total number of Allocated Units in the Auction, including Cancelled Units by an Auction Participant |
|
SHORTFALL_UNITS |
NUMBER(18,8) |
|
The total number of units unpaid for in the auction |
|
RESERVE_PRICE |
NUMBER(18,8) |
|
The reserve price of the auction |
|
CLEARING_PRICE |
NUMBER(18,8) |
|
The Market Clearing Price of the Auction |
|
PAYMENT_AMOUNT |
NUMBER(18,8) |
|
The payment amount owed by AEMO before shortfall |
|
SHORTFALL_AMOUNT |
NUMBER(18,8) |
|
The shortfall amount |
|
ALLOCATION |
NUMBER(18,8) |
|
The percentage of the auction proceeds allocated to the TNSP on the directional link |
|
NET_PAYMENT_AMOUNT |
NUMBER(18,8) |
|
The payment amount owed by AEMO, including shortfall |
|
LASTCHANGED |
DATE |
|
The date and time this record was last modified |
|
Name |
|
|
Comment |
Records a summary of the Auction payment amount |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
PARTICIPANTID |
|
SRA_QUARTER |
|
SRA_RUNNO |
|
SRA_YEAR |
|
Name |
Data Type |
Mandatory |
Comment |
|
SRA_YEAR |
NUMBER(4) |
X |
Year of the Tranche |
|
SRA_QUARTER |
NUMBER(3) |
X |
Relevant Quarter of the Tranche |
|
SRA_RUNNO |
NUMBER(3) |
X |
SRA Run Number |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Unique participant identifier |
|
GROSS_PROCEEDS_AMOUNT |
NUMBER(18,8) |
|
The total auction proceeds allocated to the TNSP |
|
TOTAL_GROSS_PROCEEDS_AMOUNT |
NUMBER(18,8) |
|
The total auction proceeds allocated to all TNSPs in the SRA quarter |
|
SHORTFALL_AMOUNT |
NUMBER(18,8) |
|
The shortfall amount for in the SRA Quarter for the TNSP |
|
TOTAL_SHORTFALL_AMOUNT |
NUMBER(18,8) |
|
The total shortfall amount for in the SRA Quarter for all TNSPs |
|
NET_PAYMENT_AMOUNT |
NUMBER(18,8) |
|
The net payment amount owed by AEMO to the TNSP |
|
LASTCHANGED |
DATE |
|
The date and time this record was last modified |
|
Name |
|
|
Comment |
Records details of the settlement process for the cancellation and purchase of SRA Auction Units |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
SRA_QUARTER |
|
SRA_RUNNO |
|
SRA_YEAR |
|
Name |
Data Type |
Mandatory |
Comment |
|
SRA_YEAR |
NUMBER(4) |
X |
Year of the Tranche |
|
SRA_QUARTER |
NUMBER(3) |
X |
Relevant Quarter of the Tranche |
|
SRA_RUNNO |
NUMBER(3) |
X |
SRA Run Number |
|
RUNTYPE |
VARCHAR2(20) |
|
The type of SRA run |
|
RUNDATE |
DATE |
|
The date and time the run was triggered |
|
POSTEDDATE |
DATE |
|
The date/time the run was posted |
|
INTEREST_VERSIONNO |
NUMBER(3) |
|
Version number of the interest component used in the payments run |
|
MAKEUP_VERSIONNO |
NUMBER(3) |
|
Version number of the makeup component used in the makeup run |
|
LASTCHANGED |
DATE |
|
The date and time this record was last modified |
|
Name |
|
|
Comment |
Holds the Product details for each Offer File submitted by each SRA Auction Participant. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
AUCTIONID |
|
LOADDATE |
|
OPTIONID |
|
PARTICIPANTID |
|
Name |
Data Type |
Mandatory |
Comment |
|
AUCTIONID |
VARCHAR2(30) |
X |
Unique ID for each Auction date |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Unique participant identifier |
|
LOADDATE |
DATE |
X |
The date and time the system loaded the SRA Offer File |
|
OPTIONID |
NUMBER(4) |
X |
Unique Product identifier (1 - 2000) |
|
INTERCONNECTORID |
VARCHAR2(10) |
|
Unique Directional Interconnector identifier |
|
FROMREGIONID |
VARCHAR2(10) |
|
The source Region identifier for the Directional Interconnector |
|
OFFER_QUANTITY |
NUMBER(5) |
|
The Offer quantity for this Product |
|
OFFER_PRICE |
NUMBER(18,8) |
|
The Offer price for this Product |
|
TRANCHEID |
VARCHAR2(30) |
|
Tranche identifier |
|
LASTCHANGED |
DATE |
|
The date and time this record was last modified |
|
Name |
|
|
Comment |
Holds the data of an SRA Auction Participant Offer Submission. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
AUCTIONID |
|
LOADDATE |
|
PARTICIPANTID |
|
Name |
Data Type |
Mandatory |
Comment |
|
AUCTIONID |
VARCHAR2(30) |
X |
Unique ID for each Auction date |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Unique participant identifier |
|
LOADDATE |
DATE |
X |
The date and time the system loaded the SRA Offer File |
|
FILENAME |
VARCHAR2(40) |
|
SRA Offer File name |
|
ACKFILENAME |
VARCHAR2(40) |
|
SRA acknowledgment file name |
|
TRANSACTIONID |
VARCHAR2(100) |
|
Transaction ID used for tracking |
|
LASTCHANGED |
DATE |
|
The date and time this record was last modified |
|
Name |
|
|
Comment |
Records the Cash Security details provided by an SRA Auction Participant as collateral to cover their Trading Position in the SRA market |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
CASH_SECURITY_ID |
|
PARTICIPANTID |
|
PRUDENTIAL_DATE |
|
PRUDENTIAL_RUNNO |
|
Name |
Data Type |
Mandatory |
Comment |
|
PRUDENTIAL_DATE |
DATE |
X |
The prudential date of the run. |
|
PRUDENTIAL_RUNNO |
NUMBER(8) |
X |
The run number for the prudential date |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Unique participant identifier for the Auction Participant lodging the Cash Security |
|
CASH_SECURITY_ID |
VARCHAR2(36) |
X |
Unique identifier for the cash security. |
|
CASH_SECURITY_AMOUNT |
NUMBER(18,8) |
|
Remaining Cash Security deposit available |
|
Name |
|
|
Comment |
The prudential position of each company at the date and time of a specific prudential run |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
PARTICIPANTID |
|
PRUDENTIAL_DATE |
|
PRUDENTIAL_RUNNO |
|
Name |
Data Type |
Mandatory |
Comment |
|
PRUDENTIAL_DATE |
DATE |
X |
The prudential date of the run. |
|
PRUDENTIAL_RUNNO |
NUMBER(8) |
X |
The run number for the prudential date |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Unique participant identifier |
|
TRADING_LIMIT |
NUMBER(18,8) |
|
The Trading Limit of the company at the time of the prudential run |
|
PRUDENTIAL_EXPOSURE_AMOUNT |
NUMBER(18,8) |
|
Current Prudential Exposure of the Auction Participant including Offers |
|
TRADING_MARGIN |
NUMBER(18,8) |
|
The amount of Trading Margin available to the Auction Participant to trade (including Offered Units and Cancelled Units). Equal to TRADING_LIMIT minus PRUDENTIAL_EXPOSURE_AMOUNT. |
|
Name |
|
|
Comment |
Records details of the Prudential Exposure of an SRA Auction Participant |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
FROMREGIONID |
|
INTERCONNECTORID |
|
PARTICIPANTID |
|
PRUDENTIAL_DATE |
|
PRUDENTIAL_RUNNO |
|
SRA_QUARTER |
|
SRA_YEAR |
|
Name |
Data Type |
Mandatory |
Comment |
|
PRUDENTIAL_DATE |
DATE |
X |
The prudential date of the run. |
|
PRUDENTIAL_RUNNO |
NUMBER(8) |
X |
The run number for the prudential date. |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Unique participant identifier |
|
SRA_YEAR |
NUMBER(4) |
X |
AEMO Contract Year number starting the week beginning 1 January |
|
SRA_QUARTER |
NUMBER(3) |
X |
Contract Relevant Quarter |
|
INTERCONNECTORID |
VARCHAR2(10) |
X |
The identifier for the Directional Interconnector |
|
FROMREGIONID |
VARCHAR2(10) |
X |
The source Region identifier for the Directional Interconnector |
|
MAX_TRANCHE |
NUMBER(2) |
|
The largest Tranche where the Unit was either sold or offered. Used in the calculation of the Average Purchase Price for the Trading Position of the Product. The most recent Tranche where Units were cancelled or offered (if the Offer is below the Average Purchase Price) |
|
AUCTIONID |
VARCHAR2(30) |
|
Unique identifier for the Auction having the Offer. Has a null value when no Offer is made for the Relevant Quarter |
|
OFFER_SUBMISSIONTIME |
DATE |
|
Timestamp of the Offer File submitted by the Auction Participant. Has a null value when no Offer is made for the Relevant Quarter |
|
AVERAGE_PURCHASE_PRICE |
NUMBER(18,8) |
|
Calculated Average Purchase Price for the Product |
|
AVERAGE_CANCELLATION_PRICE |
NUMBER(18,8) |
|
Calculated average cancellation price for product. |
|
CANCELLATION_VOLUME |
NUMBER(18,8) |
|
Calculated cancellation volume for product. |
|
TRADING_POSITION |
NUMBER(18,8) |
|
Calculated trading position for product. |
|
Name |
|
|
Comment |
Records the prudential run details for each prudential date |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
PRUDENTIAL_DATE |
|
PRUDENTIAL_RUNNO |
|
Name |
Data Type |
Mandatory |
Comment |
|
PRUDENTIAL_DATE |
DATE |
X |
The prudential date of the run. |
|
PRUDENTIAL_RUNNO |
NUMBER(8) |
X |
The prudential run number for the run |
|
Name |
|
|
Comment |
VALUATIONID shows the identifiers and descriptions of the valuers submitting estimates of upcoming settlement residues. VALUATIONID supports the Settlement Residue Auction. |
|
VALUATIONID is public data, and is available to all participants. Source VALUATIONID updates are quarterly from the Settlement Residues Information System [SRIS]. Volume VALUATIONID shows up to five (5) records. Updates are rare. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
VALUATIONID |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
VALUATIONID |
VARCHAR2(15) |
X |
Identifier of the estimator |
|
DESCRIPTION |
VARCHAR2(80) |
|
Full name of estimator |
|
LASTCHANGED |
DATE |
|
Timestamp of record creation or modification |
|
|
|