4 Electricity Data Model 5.8
This Release contains an updated version of the Electricity Data Model The Electricity Data Model is the definition of the interface to participants of data published by AEMO from National Electricity Market (NEM) systems. 5 8. This section describes the affected packages, tables, files, reports, and interfaces.
4.1 Data model changes summary
4.2 Package: BILLING_CONFIG
Configuration data for the Billing Process
4.2.1 Modified table: BILLINGCALENDAR
|
Comment |
BILLINGCALENDAR sets out the billing calendar for the year, with week number 1 starting on 1 January. BILLINGCALENDAR advises preliminary and final statement posting date and corresponding settlement for each billing week. |
|---|---|
|
Visibility |
Public |
|
Data volume |
Small |
|
Trigger |
Triggered when inserting billing weeks for a future contract year |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports |
|
Primary key (in order) |
CONTRACTYEAR, WEEKNO |
|
Project |
Shortening the Settlement Cycle |
New columns
|
Field name |
Data type |
Primary key |
Comment |
|---|---|---|---|
|
REVISIONS_ATTACHED_TO_FINAL |
VARCHAR2(50) |
No |
The list of Revisions that are attached in the FINAL Statement of the week |
|
REV0_FINAL_ATTACH_WEEK |
VARCHAR2(10) |
No |
The FINAL Week where the R0 will be attached. |
|
REV0_PAYMENT_DATE |
DATE |
No |
The payment date of the FINAL week in REV0_FINAL_ATTACH_WEEK. |
|
REV1_FINAL_ATTACH_WEEK |
VARCHAR2(10) |
No |
The FINAL Week where the R1 will be attached. |
|
REV1_PAYMENT_DATE |
DATE |
No |
The payment date of the FINAL week in REV1_FINAL_ATTACH_WEEK. |
|
REV2_FINAL_ATTACH_WEEK |
VARCHAR2(10) |
No |
The FINAL Week where the R2 will be attached. |
|
REV2_PAYMENT_DATE |
DATE |
No |
The payment date of the FINAL week in REV2_FINAL_ATTACH_WEEK. |
4.3 Package: PRUDENTIALS
4.3.1 New table: BANK_GUARANTEE
|
Comment |
Indicates the amount of bank guarantee the Company has with AEMO |
|---|---|
|
Visibility |
Private |
|
Data volume |
Small |
|
Trigger |
On change |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports |
|
Primary key (in order) |
GUARANTEE_ID |
|
Project |
Cash Security (C4C) |
New columns
|
Field name |
Data type |
Primary key |
Comment |
|---|---|---|---|
|
GUARANTEE_ID |
VARCHAR2(30) |
Yes |
The Bank Guarantee ID |
|
COMPANY_ID |
VARCHAR2(20) |
No |
Company ID owning the Bank Guarantee |
|
PARTICIPANTID |
VARCHAR2(20) |
No |
Participant Id belonging to the company (Even though BG belongs to a Company, Participant Id is also added as all reports are published to the Participants) |
|
CREDIT_PROVIDER |
VARCHAR2(20) |
No |
Bank Guarantee Provider Id |
|
COMMENCEMENT_DATE |
DATE |
No |
Date AEMO received the bank guarantee details |
|
TERMINATION_DATE |
DATE |
No |
Date of Termination |
|
RETURN_DATE |
DATE |
No |
Date of Return |
|
GUARANTEE_AMOUNT |
NUMBER(18,8) |
No |
Dollar Amount of the bank guarantee |
|
LASTCHANGED |
DATE |
No |
The last changed date time of the record |
4.3.2 New Table: CASH_SECURITY
|
Comment |
Indicates the amount of cash security the participant has with AEMO |
|---|---|
|
Visibility |
Private |
|
Data volume |
Small |
|
Trigger |
On change |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports |
|
Primary key (in order) |
CASH_SECURITY_ID |
|
Project |
Cash Security (C4C) |
New columns
|
Field name |
Data type |
Primary key |
Comment |
|---|---|---|---|
|
CASH_SECURITY_ID |
VARCHAR2(20) |
Yes |
Unique ID for each cash security record |
|
PARTICIPANTID |
VARCHAR2(20) |
No |
Participant ID (Provider of the Cash Security) |
|
TRANSACTION_DATE |
DATE |
No |
Date when the CS was received by AEMO |
|
CASH_AMOUNT |
NUMBER(18,8) |
No |
Cash security amount (in dollars) |
|
RETURNED_AMOUNT |
NUMBER(18,8) |
No |
Cash amount returned (In dollars) |
|
INTEREST_ACCT_ID |
VARCHAR2(20) |
No |
Interest Account id used for daily interest calculation |
|
STATUS |
VARCHAR2(10) |
No |
Active/Closed |
|
LASTCHANGED |
DATE |
No |
The last changed date time of the record |
4.4 Package: BILLING_RUN
4.4.1 New Table: BILLING_CASHSEC_INTEREST_PAY
|
Comment |
Indicates the amount of cash security interest payment the participant receives |
|---|---|
|
Visibility |
Private |
|
Data volume |
Small |
|
Trigger |
On change |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports |
|
Primary key (in order) |
CONTRACTYEAR, WEEKNO, BILLRUNNO, CASH_SECURITY_ID |
|
Project |
Cash Security (C4C) |
New columns
|
Field Name |
Data type |
Primary Key |
Comment |
|---|---|---|---|
|
CONTRACTYEAR |
NUMBER(4,0) |
Yes |
ContractYear/ WeekNo/ BillRunNo for the Interest payment |
|
WEEKNO |
NUMBER(3,0) |
Yes |
The Billing WeekNo |
|
BILLRUNNO |
NUMBER(3,0) |
Yes |
The Billing RunNo |
|
CASH_SECURITY_ID |
VARCHAR2(20) |
Yes |
The Cash Security ID |
|
PARTICIPANTID |
VARCHAR2(20) |
No |
Unique identifier for the Participant lodging the cash security |
|
CASH_AMOUNT |
NUMBER(18,8) |
No |
Dollar amount of the cash security |
|
INTEREST_ACCT_ID |
VARCHAR2(20) |
No |
The interest account ID for calculating the interest payment |
|
INTEREST_AMOUNT |
NUMBER(18,8) |
No |
Interest amount calculated for the billing week |
|
LASTCHANGED |
DATE |
No |
The last changed date time of the record |
4.4.2 New table: BILLING_IRSR_NSP_ALLOCATION
|
Comment |
The report is used to show the participants the negative residue amount to TNSP based on regional share |
|---|---|
|
Visibility |
Private |
|
Data volume |
Medium |
|
Trigger |
Daily Billing Run & Posting a PRELIM/FINAL and REVISE Billing Run. |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports |
|
Primary key (in order) |
CONTRACTYEAR, WEEKNO, BILLRUNNO, PARTICIPANTID, REGIONID |
|
Project |
Project Energy Connect - Market Integration (PEC-MI) |
New columns
|
Field name |
Data type |
Primary key |
Comment |
|---|---|---|---|
|
CONTRACTYEAR |
NUMBER(4,0) |
Yes |
The Billing Contract Year. |
|
WEEKNO |
NUMBER(3,0) |
Yes |
The Billing WeekNo |
|
BILLRUNNO |
NUMBER(3,0) |
Yes |
The Billing RunNo |
|
PARTICIPANTID |
VARCHAR2(20) |
Yes |
TNSP Participant Identifier |
|
REGIONID |
VARCHAR2(20) |
Yes |
The Region Identifier |
|
RESIDUE_AMOUNT |
NUMBER(18,8) |
No |
Calculated Amount based on regional share |
|
LASTCHANGED |
DATE |
No |
The last changed date time of the record |
4.5 Package: DISPATCH
4.5.1 New Table: DISPATCH_AGC_DATA
|
Comment |
THIS report delivers 4-second system data from the AEMO AGC system |
|---|---|
|
Visibility |
Public |
|
Data volume |
Large |
|
Trigger |
Every 5 minutes |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports |
|
Primary key (in order) |
MEASUREMENT_DATETIME, VERSIONNO, AGC_AREA, AGC_DATA_TYPE |
|
Project |
Regulation FCAS usage information |
New columns
|
Field name |
Data type |
Primary key |
Comment |
|---|---|---|---|
|
MEASUREMENT_DATETIME |
DATE |
Yes |
Date and time of the SCADA data (DD/MM/YYYY HH24:MI:SS) fixed to the UTC+10 time zone (NEM time) |
|
VERSIONNO |
NUMBER(3) |
Yes |
Count of version |
|
AGC_AREA |
VARCHAR2(20) |
Yes |
AGC Control Region |
|
AGC_DATA_TYPE |
VARCHAR2(20) |
Yes |
AGC parameter type |
|
AGC_VALUE |
NUMBER(15,5) |
No |
AGC parameter value |
|
LASTCHANGED |
DATE |
No |
Last date and time record changed |
4.6 Package: PARTICIPANT_REGISTRATION
4.6.1 Modified table: PASA_INTERZONAL_MAPPING
|
Comment |
PASA_INTERZONAL_MAPPING shows inter-zonal mapping details, including operating status. |
|---|---|
|
Visibility |
Public |
|
Data volume |
Small |
|
Trigger |
On change |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports |
|
Primary key (in order) |
INTERZONALCONNECTORID, EFFECTIVEDATE, VERSIONNO |
|
Project |
STPASA Replacement project |
New columns
|
Field name |
Data type |
Primary key |
Comment |
|---|---|---|---|
|
INTERZONALCONNECTOR_FULLNAME |
VARCHAR2(50) |
No |
Full Name for this Interzonal connector |
4.6.2 New table: PASA_DUID_SUBSTATION_MAPPING
|
Comment |
PASA_DUID_SUBSTATION_MAPPING shows the mapping of each DUID to its Energy Management System Substation ID |
|---|---|
|
Visibility |
Public |
|
Data volume |
Small |
|
Trigger |
On change |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports |
|
Primary key (in order) |
DUID, SUBSTATIONID, EFFECTIVEDATE, VERSIONNO |
|
Project |
STPASA Replacement project |
New columns
|
Field name |
Data type |
Primary key |
Comment |
|---|---|---|---|
|
DUID |
VARCHAR2(20) |
Yes |
The dispatchable unit identifier |
|
SUBSTATIONID |
VARCHAR2(30) |
Yes |
The Energy Management System identifier of the Substation to which this DUID belongs |
|
EFFECTIVEDATE |
DATE |
Yes |
Effective date of this DUID to Substation ID mapping |
|
VERSIONNO |
NUMBER(3,0) |
Yes |
Version number for the Effective date |
|
OPERATINGSTATUS |
VARCHAR2(20) |
No |
Active or inactive indicator |
|
LASTCHANGED |
DATE |
No |
Date time this record was created |
4.6.3 New table: PASA_INTERCONNECTOR_BOUNDARY
|
Comment |
PASA_INTERCONNECTOR_BOUNDARY shows the mapping of each Interconnector boundary to its constituent Energy Management System Branch IDs |
|---|---|
|
Visibility |
Public |
|
Data volume |
Small |
|
Trigger |
On change |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports |
|
Primary key (in order) |
INTERCONNECTORID, EFFECTIVEDATE, VERSIONNO, BRANCHID, BRANCHSUBID |
|
Project |
STPASA Replacement project |
New columns
|
Field name |
Data type |
Primary key |
Comment |
|---|---|---|---|
|
INTERCONNECTORID |
VARCHAR2(20) |
Yes |
The identifier of the Interconnector |
|
EFFECTIVEDATE |
DATE |
Yes |
Effective date of this Interconnector Boundary mapping |
|
VERSIONNO |
NUMBER(3,0) |
Yes |
Version number for the Effective date |
|
BRANCHID |
VARCHAR2(50) |
Yes |
Branch Identifier |
|
BRANCHSUBID |
VARCHAR2(50) |
Yes |
Branch Sub-Identifier |
|
BRANCHFROMSUBSTATION |
VARCHAR2(30) |
No |
Branch FromSubstation. Positive BranchFlow from FromSubstation to ToSubstation. |
|
BRANCHTOSUBSTATION |
VARCHAR2(30) |
No |
Branch ToSubstation. Positive BranchFlow from FromSubStation to ToSubStation. |
|
BRANCHTYPE |
VARCHAR2(10) |
No |
Branch Type (LN = Line, XF = Transformer, ZBR = Zero Impedance Branch) |
|
BRANCH_TO_INTERCONN_FLOWMULT |
NUMBER(1,0) |
No |
Multiplier (1 or -1) used to convert from Branch Flow direction to Interconnector flow direction |
|
OPERATINGSTATUS |
VARCHAR2(20) |
No |
Active or inactive indicator |
|
LASTCHANGED |
DATE |
No |
Date time this record was created |
4.6.4 New table: PASA_INTERCONNECTOR_MAPPING
|
Comment |
PASA_INTERCONNECTOR_MAPPING shows the mapping of each Interconnector to its From Region ID and To Region ID |
|---|---|
|
Visibility |
Public |
|
Data volume |
Small |
|
Trigger |
On change |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports |
|
Primary key (in order) |
INTERCONNECTORID, EFFECTIVEDATE, VERSIONNO |
|
Project |
STPASA Replacement project |
New columns
|
Field name |
Data type |
Primary key |
Comment |
|---|---|---|---|
|
INTERCONNECTORID |
VARCHAR2(20) |
Yes |
The identifier for this Interconnector |
|
EFFECTIVEDATE |
DATE |
Yes |
Effective date of this Interconnector mapping |
|
VERSIONNO |
NUMBER(3,0) |
Yes |
Version number for the Effective date |
|
FROMREGIONID |
VARCHAR2(20) |
No |
From Region ID for this Interconnector |
|
TOREGIONID |
VARCHAR2(20) |
No |
To Region ID for this Interconnector |
|
INTERCONNECTOR_FULLNAME |
VARCHAR2(50) |
No |
Full Name for this Interconnector |
|
OPERATINGSTATUS |
VARCHAR2(20) |
No |
Active or inactive indicator |
|
LASTCHANGED |
DATE |
No |
Date time this record was created |
4.6.5 New table: PASA_INTERZONAL_BOUNDARY
|
Comment |
PASA_INTERZONAL_BOUNDARY shows the mapping of each Interzonal connector boundary to its constituent Energy Management System Branch IDs |
|---|---|
|
Visibility |
Public |
|
Data volume |
Small |
|
Trigger |
On change |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports |
|
Primary key (in order) |
INTERZONALCONNECTORID, EFFECTIVEDATE, VERSIONNO, BRANCHID, BRANCHSUBID |
|
Project |
STPASA Replacement project |
New columns
|
Field name |
Data type |
Primary key |
Comment |
|---|---|---|---|
|
INTERZONALCONNECTORID |
VARCHAR2(50) |
Yes |
The identifier for this Interzonal connector |
|
EFFECTIVEDATE |
DATE |
Yes |
Effective date of this Interzonal connector boundary definition |
|
VERSIONNO |
NUMBER(3,0) |
Yes |
Version number for the Effective date |
|
BRANCHID |
VARCHAR2(50) |
Yes |
Branch Identifier |
|
BRANCHSUBID |
VARCHAR2(50) |
Yes |
Branch Sub-Identifier |
|
BRANCHFROMSUBSTATION |
VARCHAR2(30) |
No |
Branch FromSubstation. Positive Branch Flow from FromSubstation to ToSubstation. |
|
BRANCHTOSUBSTATION |
VARCHAR2(30) |
No |
Branch ToSubstation. Positive Branch Flow from FromSubstation to ToSubstation. |
|
BRANCHTYPE |
VARCHAR2(10) |
No |
Branch Type (LN = Line, XF = Transformer, ZBR = Zero Impedance Branch) |
|
BRANCH_TO_INTERZONAL_FLOWMULT |
NUMBER(1,0) |
No |
Multiplier (1 or -1) used to convert from Branch Flow direction to Interzonal connector flow direction |
|
OPERATINGSTATUS |
VARCHAR2(20) |
No |
Active or inactive indicator |
|
LASTCHANGED |
DATE |
No |
Date time this record was created |
4.6.6 New table: PASA_SUBSTATION_ZONE_MAPPING
|
Comment |
PASA_SUBSTATION_ZONE_MAPPING shows the mapping of each Energy Management System Substation ID to its parent Zone ID |
|---|---|
|
Visibility |
Public |
|
Data volume |
Small |
|
Trigger |
On change |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports |
|
Primary key (in order) |
SUBSTATIONID, EFFECTIVEDATE, VERSIONNO |
|
Project |
STPASA Replacement project |
New columns
|
Field name |
Data type |
Primary key |
Comment |
|---|---|---|---|
|
SUBSTATIONID |
VARCHAR2(30) |
Yes |
The Energy Management System identifier for this Substation |
|
EFFECTIVEDATE |
DATE |
Yes |
Effective date of this Energy Management System Substation ID to Zone ID mapping |
|
VERSIONNO |
NUMBER(3,0) |
Yes |
Version number for the Effective date |
|
ZONEID |
VARCHAR2(30) |
No |
The identifier of the Zone to which this Energy Management System Substation ID belongs |
|
OPERATINGSTATUS |
VARCHAR2(20) |
No |
Active or inactive indicator |
|
LASTCHANGED |
DATE |
No |
Date time this record was created |
4.7 Package: SETTLEMENT_DATA
Results from a published Settlements See Relevant Rules or Procedures Run. The settlement data and billing run data are updated daily Energy Rules Terms between 6 am and 8 am for AEMO Australian Energy Market Operator's prudential processes. In a normal week, AEMO publishes one PRELIM, one FINAL and two REVISION runs in addition to the daily runs
4.7.1 New table: SET_IRSR_DIRECTIONAL_LINK
|
Comment |
This report contains the MW Flow and Inter-Regional Residue Amounts for all primary interconnectors. |
|---|---|
|
Visibility |
Public |
|
Data volume |
Medium |
|
Trigger |
Daily Billing Run & Posting a PRELIM/FINAL and REVISE Billing Run. |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports |
|
Primary key (in order) |
SETTLEMENTDATE, VERSIONNO, PERIODID, INTERCONNECTORID, FROMREGIONID |
|
Project |
Project Energy Connect - Market Integration (PEC-MI) |
New columns
|
Field name |
Data type |
Primary key |
Comment |
|---|---|---|---|
|
SETTLEMENTDATE |
DATE |
Yes |
The Settlement Date of the Billing Week |
|
VERSIONNO |
NUMBER(3,0) |
Yes |
The Settlement Run No |
|
PERIODID |
NUMBER(3,0) |
Yes |
The Settlement Period Id (1-288) |
|
INTERCONNECTORID |
VARCHAR2(20) |
Yes |
The Interconnector Identifier |
|
FROMREGIONID |
VARCHAR2(20) |
Yes |
The Exporting Region Identifier |
|
INTERCONNECTORLOOPID |
VARCHAR2(20) |
No |
The Interconnector Loop Identifier, Blank if Interconnector not part of the loop |
|
MWFLOW |
NUMBER(18,8) |
No |
Consumed Energy in MWh |
|
SURPLUSVALUE |
NUMBER(18,8) |
No |
Updated Surplus Value for the primary interconnector |
|
ORG_SURPLUSVALUE |
NUMBER(18,8) |
No |
Original Surplus Value |
|
LASTCHANGED |
DATE |
No |
The last changed date time of the record |
4.7.2 New table: SET_IRSR_LOOP_REGION_SUMMARY
|
Comment |
This report contains Inter-Regional Net Loop Allocations and Net Regional Export Quantities. |
|---|---|
|
Visibility |
Public |
|
Data volume |
Medium |
|
Trigger |
Daily Billing Run & Posting a PRELIM/FINAL and REVISE Billing Run. |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports |
|
Primary key (in order) |
SETTLEMENTDATE, VERSIONNO, PERIODID, REGIONID, INTERCONNECTORLOOPID |
|
Project |
Project Energy Connect - Market Integration (PEC-MI) |
New columns
|
Field name |
Data type |
Primary key |
Comment |
|---|---|---|---|
|
SETTLEMENTDATE |
DATE |
Yes |
The Settlement Date of the Billing Week |
|
VERSIONNO |
NUMBER(3,0) |
Yes |
The Settlement Run No |
|
PERIODID |
NUMBER(3,0) |
Yes |
The Settlement Period Id (1-288) |
|
REGIONID |
VARCHAR2(20) |
Yes |
The Region Id |
|
INTERCONNECTORLOOPID |
VARCHAR2(20) |
Yes |
The Interconnector Loop Identifier |
|
POSLOOPALLOCATION |
NUMBER(18,8) |
No |
Total Positive Allocation across the Loop |
|
NEGLOOPALLOCATION |
NUMBER(18,8) |
No |
Total Negative Allocation across the Loop |
|
NLA |
NUMBER(18,8) |
No |
Net Loop Allocation (can be positive or negative) |
|
EXPORT_MWH |
NUMBER(18,8) |
No |
Total Export Flow in MWh for the Region |
|
IMPORT_MWH |
NUMBER(18,8) |
No |
Total Import Flow in MWh for the Region |
|
NETREGIONAL_MWH |
NUMBER(18,8) |
No |
Net Flow for the Region |
|
LASTCHANGED |
DATE |
No |
The last changed date time of the record. |
4.7.3 New table: SET_IRSR_LOOP_NSP_ALLOCATION
|
Comment |
This report contains Inter-Regional Negative Residue Amounts to allocate to TNSPs. |
|---|---|
|
Visibility |
Private |
|
Data volume |
Medium |
|
Trigger |
Daily Billing Run & Posting a PRELIM/FINAL and REVISE Billing Run. |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports |
|
Primary key (in order) |
SETTLEMENTDATE, VERSIONNO, PERIODID, REGIONID, PARTICIPANTID, INTERCONNECTORLOOPID |
|
Project |
Project Energy Connect - Market Integration (PEC-MI) |
New columns
|
Field name |
Data type |
Primary key |
Comment |
|---|---|---|---|
|
SETTLEMENTDATE |
DATE |
Yes |
The Settlement Date of the Billing Week |
|
VERSIONNO |
NUMBER(3,0) |
Yes |
The Settlement Run No |
|
PERIODID |
NUMBER(3,0) |
Yes |
The Settlement Period Id (1-288) |
|
REGIONID |
VARCHAR2(20) |
Yes |
The Region Identifier |
|
PARTICIPANTID |
VARCHAR2(20) |
Yes |
The TNSP Participant Identifier |
|
INTERCONNECTORLOOPID |
VARCHAR2(20) |
Yes |
The Interconnector Loop Identifier |
|
ALLOCATION |
NUMBER(18,8) |
No |
Participant Portion % (e.g. 100) |
|
NLA |
NUMBER(18,8) |
No |
Net Loop Allocation (negative only) |
|
AVGREGION_MWH |
NUMBER(18,8) |
No |
Annual Regional Demand for the Region |
|
TOTALREGION_MWH |
NUMBER(18,8) |
No |
Total Annual Regional Demand for all Regions in the Loop |
|
RESIDUE_AMOUNT |
NUMBER(18,8) |
No |
Calculated Negative Residue Amount based on regional share |
|
LASTCHANGED |
DATE |
No |
The last changed date time of the record. |
4.7.4 New table: SET_IRSR_LOOP_NETTRADE_AMOUNT
|
Comment |
This report contains the final net trade amount for the two directional interconnectors to allocate. |
|---|---|
|
Visibility |
Public |
|
Data volume |
Medium |
|
Trigger |
Daily Billing Run & Posting a PRELIM/FINAL and REVISE Billing Run. |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports |
|
Primary key (in order) |
SETTLEMENTDATE, VERSIONNO, PERIODID, INTERCONNECTORID, FROMREGIONID, INTERCONNECTORLOOPID |
|
Project |
Project Energy Connect - Market Integration (PEC-MI) |
New columns
|
Field name |
Data type |
Primary key |
Comment |
|---|---|---|---|
|
SETTLEMENTDATE |
DATE |
Yes |
The Settlement Date of the Billing Week |
|
VERSIONNO |
NUMBER(3,0) |
Yes |
The Settlement Run No |
|
PERIODID |
NUMBER(3,0) |
Yes |
The Settlement Period Id (1-288) |
|
INTERCONNECTORID |
VARCHAR2(20) |
Yes |
The Interconnector Identifier |
|
FROMREGIONID |
VARCHAR2(20) |
Yes |
The Exporting Region Identifier |
|
INTERCONNECTORLOOPID |
VARCHAR2(20) |
Yes |
The Interconnector Loop Identifier |
|
NLA |
NUMBER(18,8) |
No |
Net Loop Allocation (can be positive or negative) |
|
NETREGIONAL_MWH |
NUMBER(18,8) |
No |
Net Flow for the Region |
|
REGIONRRP |
NUMBER(18,8) |
No |
Exporting Region RRP |
|
RRPDIFF |
NUMBER(18,8) |
No |
Importing and Exporting Region RRP difference |
|
NOTIONALAMOUNT |
NUMBER(18,8) |
No |
Notional Amount for each direction interconnector |
|
PROVNETTRADEAMOUNT |
NUMBER(18,8) |
No |
Provisional Net Trade Amount based on the Positive Allocation |
|
FINALNETTRADEAMOUNT |
NUMBER(18,8) |
No |
Final Net Trade Amount |
|
LASTCHANGED |
DATE |
No |
The last changed date time of the record |
4.8 File interface changes
|
Package |
File ID |
Description |
Batcher file masks |
Frequency |
Change |
Auto-subscription |
|---|---|---|---|---|---|---|
|
BILLING_CONFIG |
BILLINGCALENDAR |
|
PUBLIC_BILLINGCALENDAR_*.CSV |
Yearly |
Modified |
No |
|
BILLING_RUN |
BILLING |
|
*_BILLING_*.CSV |
Daily |
Modified |
No |
|
BILLING_INIT |
|
*_BILLING_INIT_*.CSV |
Daily |
Modified |
No |
|
|
DISPATCH |
DISPATCH_AGC_DATA |
|
PUBLIC_DISPATCH_AGC_DATA_*.CSV |
Every 5 minutes |
New |
No |
|
PARTICIPANT_REGISTRATION |
PASA_INTERZONAL |
|
PUBLIC_PASA_INTERZONAL_*.CSV |
On change |
Modified |
No |
|
PASA_INTERCONNECTOR |
|
PUBLIC_PASA_INTERCONNECTOR_*.CSV |
On change |
New |
No |
|
|
PRUDENTIALS |
BANK_GUARANTEE |
|
*_BANK_GUARANTEE5_*.CSV |
On change |
New |
Yes |
|
CASH_SECURITY |
|
*_CASH_SECURITY_*.CSV |
On change |
New |
Yes |
|
|
SETTLEMENT_DATA |
SETTLEMENTS_EXTN |
|
*_SETTLEMENTS_EXTN_*.CSV |
Daily |
Modified |
No |
|
SETTLEMENTS_INIT |
|
PUBLIC_SETTLEMENTS_INIT_*.CSV |
Daily |
Modified |
No |
4.9 Data model loader mappings
|
Package |
Data model table |
File ID |
CSV report type |
Change |
|---|---|---|---|---|
|
BILLING_CONFIG |
BILLINGCALENDAR |
BILLINGCALENDAR |
BILLING_CONFIG,BILLINGCALENDAR,4 |
Modified |
|
BILLING_RUN |
BILLING_CASHSEC_INTEREST_PAY |
BILLING |
BILLING,CASHSEC_INTEREST_PAY,1 |
New |
|
BILLING_CASHSEC_INTEREST_PAY |
BILLING_INIT |
BILLING,CASHSEC_INTEREST_PAY,1 |
New |
|
|
BILLING_IRSR_NSP_ALLOCATION |
BILLING_INIT |
BILLING,IRSR_NSP_ALLOCATION,1 |
New |
|
|
BILLING_IRSR_NSP_ALLOCATION |
BILLING |
BILLING,IRSR_NSP_ALLOCATION,1 |
New |
|
|
DISPATCH |
DISPATCH_AGC_DATA |
DISPATCH_AGC_DATA |
DISPATCH,AGC_DATA,1 |
New |
|
PARTICIPANT_REGISTRATION |
PASA_INTERZONAL_MAPPING |
PASA_INTERZONAL |
PARTICIPANT_REGISTRATION,PASA_INTERZONAL_MAPPING,1 |
Modified |
|
PASA_DUID_SUBSTATION_MAPPING |
PASA_INTERZONAL |
PARTICIPANT_REGISTRATION,PASA_DUID_SUBSTATION_MAPPING,1 |
New |
|
|
PASA_INTERCONNECTOR_BOUNDARY |
PASA_INTERCONNECTOR |
PARTICIPANT_REGISTRATION,PASA_INTERCONNECTOR_BOUNDARY,1 |
New |
|
|
PASA_INTERCONNECTOR_MAPPING |
PASA_INTERCONNECTOR |
PARTICIPANT_REGISTRATION,PASA_INTERCONNECTOR_MAPPING,1 |
New |
|
|
PASA_INTERZONAL_BOUNDARY |
PASA_INTERZONAL |
PARTICIPANT_REGISTRATION,PASA_INTERZONAL_BOUNDARY,1 |
New |
|
|
PASA_SUBSTATION_ZONE_MAPPING |
PASA_INTERZONAL |
PARTICIPANT_REGISTRATION,PASA_SUBSTATION_ZONE_MAPPING,1 |
New |
|
|
PRUDENTIALS |
BANK_GUARANTEE |
BANK_GUARANTEE |
PRUDENTIAL,BANK_GUARANTEE,1 |
New |
|
CASH_SECURITY |
CASH_SECURITY |
PRUDENTIAL,CASH_SECURITY,1 |
New |
|
|
SETTLEMENT_DATA |
SET_IRSR_DIRECTIONAL_LINK |
SETTLEMENTS_EXTN |
SETTLEMENTS,IRSR_DIRECTIONAL_LINK,1 |
New |
|
SET_IRSR_DIRECTIONAL_LINK |
SETTLEMENTS_INIT |
SETTLEMENTS,IRSR_DIRECTIONAL_LINK,1 |
|
|
|
SET_IRSR_LOOP_REGION_SUMMARY |
SETTLEMENTS_EXTN |
SETTLEMENTS,IRSR_LOOP_REGION_SUMMARY,1 |
|
|
|
SET_IRSR_LOOP_REGION_SUMMARY |
SETTLEMENTS_INIT |
SETTLEMENTS,IRSR_LOOP_REGION_SUMMARY,1 |
New |
|
|
SET_IRSR_LOOP_NSP_ALLOCATION |
SETTLEMENTS_EXTN |
SETTLEMENTS,IRSR_LOOP_NSP_ALLOCATION,1 |
|
|
|
SET_IRSR_LOOP_NSP_ALLOCATION |
SETTLEMENTS_INIT |
SETTLEMENTS,IRSR_LOOP_NSP_ALLOCATION,1 |
New |
|
|
SET_IRSR_LOOP_NETTRADE_AMOUNT |
SETTLEMENTS_EXTN |
SETTLEMENTS,IRSR_LOOP_NETTRADE_AMOUNT,1 |
|
|
|
SET_IRSR_LOOP_NETTRADE_AMOUNT |
SETTLEMENTS_INIT |
SETTLEMENTS,IRSR_LOOP_NETTRADE_AMOUNT,1 |
New |
4.10 Discontinued reports
|
Data model table |
File ID |
Delivered in file |
CSV report type |
Replaced by |
|---|---|---|---|---|
|
BILLINGCALENDAR |
BILLINGCALENDAR |
*_BILLINGCALENDAR_LEGACY*.CSV |
BILLING_CONFIG,BILLINGCALENDAR,2 |
BILLING_CONFIG,BILLINGCALENDAR,4 |