4 Electricity Data Model 5.7
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.7. 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 |
|---|---|---|---|
|
REVISION0_STATEMENTDATE |
DATE |
No |
Revision 0 Statement Date for the billing week. |
4.3 Package: BILLING_RUN
Results from a published Billing Run. The settlement data and billing run data are updated daily Energy Rules Terms between 6am and 8am 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.
Each billing run is uniquely identified by contract year, week no and bill run no.
4.3.1 Modified table: BILLINGRUNTRK
|
Comment |
BILLINGRUNTRK identifies the Statement type (i.e. Status of PRELIM, FINAL, REVISE) and date of the BillRunNo posted, per WeekNo. This provides a further extension of tracking data from the BILLINGDAYTRK table. |
|---|---|
|
Visibility |
Public |
|
Data volume |
Medium |
|
Trigger |
Triggered and populated by the posting of a billing run |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports |
|
Primary key (in order) |
BILLRUNNO, CONTRACTYEAR, WEEKNO |
|
Project |
Shortening the Settlement Cycle |
New columns
|
Field name |
Data type |
Primary key |
Comment |
|---|---|---|---|
|
REVISIONINDEX |
NUMBER(3,0) |
No |
Revision Run Type |
4.4 Package: DISPATCH
Results from a published Dispatch See National Electricity Rules Run
4.4.1 Modified table: NEGATIVE_RESIDUE
|
Comment |
Shows the inputs provided to the Negative Residue Constraints in the Dispatch horizon |
|---|---|
|
Visibility |
Public |
|
Data volume |
Medium |
|
Trigger |
With every Dispatch interval |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports |
|
Primary key (in order) |
DIRECTIONAL_INTERCONNECTORID, NRM_DATETIME, SETTLEMENTDATE |
|
Project |
Project Energy Connect - Market Integration (PEC-MI) |
New columns
|
Field name |
Data type |
Primary key |
Comment |
|---|---|---|---|
|
NRM_LOOP_FLAG |
NUMBER(1,0) |
No |
NRM Loop Flag controls monitoring behaviour: |
4.5 Package: GENERIC_CONSTRAINT
4.5.1 Modified table: GENCONDATA
|
Comment |
GENCONDATA sets out the generic constraints contained within a generic constraint set invoked in PASA, predispatch and dispatch. |
|---|---|
|
Visibility |
Public |
|
Data volume |
Medium |
|
Trigger |
On Change by AEMO |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports |
|
Primary key (in order) |
EFFECTIVEDATE, GENCONID, VERSIONNO |
|
Project |
Improving Security Frameworks |
New columns
|
Field name |
Data type |
Primary key |
Comment |
|---|---|---|---|
|
SYSTEMSECURITY |
VARCHAR2(1) |
No |
Flags constraint is used in System Security Management (SSM) processes. 1-Used(in SSM only),0-not used |
|
SSM_REGIONID |
VARCHAR2(20) |
No |
Region constraint relates to, in the format <REGIONID>_xxxx where xxxx is descriptive text |
|
SSM_GROUPID |
VARCHAR2(40) |
No |
Related constraints processed together in optimiser. |
4.5.2 New table: PASA_CONTINGENCY_DEFINITION
|
Comment |
PASA_CONTINGENCY_DEFINITION shows the contingency details used by PD and ST PASA. |
|---|---|
|
Visibility |
Public |
|
Data volume |
Medium |
|
Trigger |
On Change |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports |
|
Primary key (in order) |
CONTINGENCYID, EFFECTIVEDATE, VERSIONNO |
|
Project |
STPASA Replacement project |
New columns
|
Field name |
Data type |
Primary key |
Comment |
|---|---|---|---|
|
CONTINGENCYID |
VARCHAR2(20) |
Yes |
The contingency identifier |
|
EFFECTIVEDATE |
DATE |
Yes |
The effective date for this contingency |
|
VERSIONNO |
NUMBER(3,0) |
Yes |
Version number for the Effective date |
|
CONTINGENCYDESCRIPTION |
VARCHAR2(100) |
No |
The description for this contingency |
|
LASTCHANGED |
DATE |
No |
Date time this record was created |
4.6 Package: PARTICIPANT_REGISTRATION
4.6.1 New 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 |
|---|---|---|---|
|
INTERZONALCONNECTORID |
VARCHAR2(50) |
Yes |
The identifier for this Interzonal connector |
|
EFFECTIVEDATE |
DATE |
Yes |
Effective date of this InterZonal Mapping |
|
VERSIONNO |
NUMBER(3,0) |
Yes |
Version number for the Effective date |
|
FROMZONEID |
VARCHAR2(30) |
No |
The From ZoneId for this Interzonal connector |
|
TOZONEID |
VARCHAR2(30) |
No |
The To ZoneId for this Interzonal connector |
|
OPERATINGSTATUS |
VARCHAR2(20) |
No |
Active or inactive indicator |
|
LASTCHANGED |
DATE |
No |
Date time this record was created |
4.6.2 New table: PASA_ZONE_REGION_MAPPING
|
Comment |
PASA_ZONE_REGION_MAPPING shows zone to region mapping details and provide the Region Reference Zone information. |
|---|---|
|
Visibility |
Public |
|
Data volume |
Small |
|
Trigger |
On Change |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports |
|
Primary key (in order) |
ZONEID, EFFECTIVEDATE, VERSIONNO |
|
Project |
STPASA Replacement project |
New columns
|
Field name |
Data type |
Primary key |
Comment |
|---|---|---|---|
|
ZONEID |
VARCHAR2(30) |
Yes |
Zone identifier |
|
EFFECTIVEDATE |
DATE |
Yes |
Effective date of this Zone-Region Mapping |
|
VERSIONNO |
NUMBER(3,0) |
Yes |
Version number for the Effective date |
|
REGIONID |
VARCHAR2(20) |
No |
Region in which this Zone belongs |
|
IS_RRN_ZONE |
VARCHAR2(10) |
No |
YES or NO/<Blank>. LORCONDITION is only reported for supply deficits in a Zone that contains the Regional Reference Node |
|
OPERATINGSTATUS |
VARCHAR2(20) |
No |
Active or inactive indicator |
|
LASTCHANGED |
DATE |
No |
Date time this record was created |
4.7 Package: PDPASA
4.7.1 Modified table: PDPASA_REGIONSOLUTION
|
Comment |
The PDPASA region solution data. Note that the OUTAGE_LRC Run Type is no longer reported from 31 July 2025. |
|---|---|
|
Visibility |
Public |
|
Data volume |
Medium |
|
Trigger |
PDPASA_REGIONSOLUTION is updated each PDPASA run (i.e. half-hourly). |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports |
|
Primary key (in order) |
INTERVAL_DATETIME, REGIONID, RUN_DATETIME, RUNTYPE |
|
Project |
ST PASA Procedure and Recall Period |
Modified columns
Comment changes only
|
Field name |
Data type |
Primary key |
Comment |
|---|---|---|---|
|
AGGREGATEPASAAVAILABILITY |
NUMBER(12,0) |
No |
Sum of PASAAVAILABILITY for all scheduled generating units and scheduled bidirectional units (Gen side) with a Recall_Period <= 24 hours plus the sum of Unconstrained Intermittent Generation Forecasts (UIGF) for all semi-scheduled generating units. For the OUTAGE_LRC run, UIGF is the POE90 forecast. For the LOR Run, UIGF is the POE50 forecast. Note that the OUTAGE_LRC Run Type is discontinued from 31 July 2025. From March 2026, AGGREGATEPASAAVAILABILITY changes from that with Recall_Period <= 24 to that achievable by the relevant INTERVAL_DATETIME if recalled at the start of the run. |
4.7.2 New table: PDPASA_FNM_CASESOLUTION
|
Comment |
PDPASA_FNM_CASESOLUTION shows the case run details, including the available run types, LOR and Deficit condition for each case. |
|---|---|
|
Visibility |
Public |
|
Data volume |
Medium |
|
Trigger |
Every 30 minutes |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports |
|
Primary key (in order) |
RUN_DATETIME |
|
Project |
STPASA Replacement project |
New columns
|
Field name |
Data type |
Primary key |
Comment |
|---|---|---|---|
|
RUN_DATETIME |
DATE |
Yes |
Unique Timestamp Identifier for this run, identified by the first half hour ended interval of the run |
|
LORCONDITION |
NUMBER(1,0) |
No |
LORCONDITION is only set if supply deficit exists in a Zone that contains the Regional Reference Node. LORCONDITION indicates the most severe condition for the case: |
|
DEFICITCONDITION |
NUMBER(1,0) |
No |
DEFICITCONDITION is only set if supply deficit exists in a Zone that does NOT contain the Regional Reference Node. DEFICITCONDITION indicates the most severe condition for the case: |
|
BASE_RUN_AVAILABLE |
VARCHAR2(10) |
No |
YES = Available, NO = Not Available |
|
RELIABILITY_RUN_AVAILABLE |
VARCHAR2(10) |
No |
YES = Available, NO = Not Available |
|
WARNING_RUN_AVAILABLE |
VARCHAR2(10) |
No |
YES = Available, NO = Not Available |
|
PASAVERSION |
VARCHAR2(30) |
No |
Version of the PASA solver used to solve this case |
|
LASTCHANGED |
DATE |
No |
Date time this record was created |
4.7.3 New table: PDPASA_FNM_CONSTRAINTSOLUTION
|
Comment |
PDPASA_FNM_CONSTRAINTSOLUTION shows manual or thermal constraint (created by PASA), including marginal value, violation degree, LHS and RHS. |
|---|---|
|
Visibility |
Public |
|
Data volume |
Large |
|
Trigger |
Every 30 minutes |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports |
|
Primary key (in order) |
RUN_DATETIME, RUNTYPE, INTERVAL_DATETIME, CONSTRAINTID |
|
Project |
STPASA Replacement project |
New columns
|
Field name |
Data type |
Primary key |
Comment |
|---|---|---|---|
|
RUN_DATETIME |
DATE |
Yes |
Unique Timestamp Identifier for this run, identified by the first half hour ended interval of the run |
|
RUNTYPE |
VARCHAR2(20) |
Yes |
Run Type (BASE, RELIABILITY, WARNING) |
|
INTERVAL_DATETIME |
DATE |
Yes |
End date time of the interval |
|
CONSTRAINTID |
VARCHAR2(100) |
Yes |
Constraint identifier, either manual constraint (synonymous with GenConID) or thermal constraint created by PASA with format ‘BASE_<BranchName>’ or ‘<ContingencyID>_<BranchName>’ |
|
MARGINALVALUE |
NUMBER(20,5) |
No |
Constraint Marginal Value ($/MW) |
|
VIOLATIONDEGREE |
NUMBER(15,5) |
No |
Constraint Violation Degree (MW) |
|
LHS |
NUMBER(15,5) |
No |
Constraint LHS (MW) |
|
RHS |
NUMBER(15,5) |
No |
Constraint RHS (MW) |
|
LASTCHANGED |
DATE |
No |
Date time this record was created |
4.7.4 New table: PDPASA_FNM_DUIDAVAILABILITY
|
Comment |
PDPASA_FNM_DUIDAVAILABILITY shows Available Capacity, PASA Availability and Recall Period for all scheduled resources |
|---|---|
|
Visibility |
Public |
|
Data volume |
Large |
|
Trigger |
Every 30 minutes |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports |
|
Primary key (in order) |
RUN_DATETIME, INTERVAL_DATETIME, DUID |
|
Project |
STPASA Replacement project |
New columns
|
Field name |
Data type |
Primary key |
Comment |
|---|---|---|---|
|
RUN_DATETIME |
DATE |
Yes |
Unique Timestamp Identifier for this run, identified by the first half hour ended interval of the run |
|
INTERVAL_DATETIME |
DATE |
Yes |
End date time of the interval |
|
DUID |
VARCHAR2(20) |
Yes |
NEM Dispatchable Unit Identifier |
|
BID_TRADINGDATE |
DATE |
No |
Trading Date of the energy bid |
|
BID_OFFERDATETIME |
DATE |
No |
Date Time that the energy bid was received |
|
GENERATION_MAX_AVAILABILITY |
NUMBER (12,3) |
No |
Available Capacity for a scheduled generating unit, semi-scheduled generating unit, BDU (Gen side), WDR or MNSP (MW) |
|
GENERATION_PASA_AVAILABILITY |
NUMBER (12,3) |
No |
PASA Availability for a scheduled generating unit, BDU (Gen side), WDR or MNSP. Null for a semi-scheduled generating unit (MW) |
|
GENERATION_RECALL_PERIOD |
NUMBER (8,3) |
No |
Recall Period associated with the PASA Availability for a scheduled generating unit, BDU (Gen side), WDR or MNSP. Null for a semi-scheduled generating unit (Hours) |
|
LOAD_MAX_AVAILABILITY |
NUMBER (12,3) |
No |
Available Capacity for a scheduled load or BDU (Load side) (MW) |
|
LOAD_PASA_AVAILABILITY |
NUMBER (12,3) |
No |
PASA Availability for a scheduled load or BDU (Load side) (MW) |
|
LOAD_RECALL_PERIOD |
NUMBER (8,3) |
No |
Recall Period associated with the PASA Availability for a scheduled load or BDU (Load side) (Hours) |
|
LASTCHANGED |
DATE |
No |
Date time this record was created |
4.7.5 New table: PDPASA_FNM_INTERCONNECTORSOLN
|
Comment |
PDPASA_FNM_INTERCONNECTORSOLN shows cleared Interconnector flow for the interval. |
|---|---|
|
Visibility |
Public |
|
Data volume |
Medium |
|
Trigger |
Every 30 minutes |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports |
|
Primary key (in order) |
RUN_DATETIME, RUNTYPE, INTERVAL_DATETIME, INTERCONNECTORID |
|
Project |
STPASA Replacement project |
New columns
|
Field name |
Data type |
Primary key |
Comment |
|---|---|---|---|
|
RUN_DATETIME |
DATE |
Yes |
Unique Timestamp Identifier for this run, identified by the first half hour ended interval of the run |
|
RUNTYPE |
VARCHAR2(20) |
Yes |
Run Type (BASE, RELIABILITY, WARNING) |
|
INTERVAL_DATETIME |
DATE |
Yes |
End date time of the interval |
|
INTERCONNECTORID |
VARCHAR2(10) |
Yes |
Interconnector Identifier |
|
CLEAREDFLOW |
NUMBER(12,2) |
No |
Cleared Interconnector flow (MW) |
|
LASTCHANGED |
DATE |
No |
Date time this record was created |
4.7.6 New table: PDPASA_FNM_INTERZONALSOLUTION
|
Comment |
PDPASA_FNM_INTERZONALSOLUTION shows cleared inter zonal flow for the interval and run type. |
|---|---|
|
Visibility |
Public |
|
Data volume |
Medium |
|
Trigger |
Every 30 minutes |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports |
|
Primary key (in order) |
RUN_DATETIME, RUNTYPE, INTERVAL_DATETIME, INTERZONALCONNECTORID |
|
Project |
STPASA Replacement project |
New columns
|
Field name |
Data type |
Primary key |
Comment |
|---|---|---|---|
|
RUN_DATETIME |
DATE |
Yes |
Unique Timestamp Identifier for this run, identified by the first half hour ended interval of the run |
|
RUNTYPE |
VARCHAR2(20) |
Yes |
Run Type (BASE, RELIABILITY, WARNING) |
|
INTERVAL_DATETIME |
DATE |
Yes |
End date time of the interval |
|
INTERZONALCONNECTORID |
VARCHAR2(50) |
Yes |
InterzonalConnector Identifier |
|
FROMZONEID |
VARCHAR2(30) |
No |
FromZoneID of the InterZonalConnectorID |
|
TOZONEID |
VARCHAR2(30) |
No |
ToZoneID of the InterZonalConnectorID |
|
CLEAREDFLOW |
NUMBER(12,2) |
No |
Cleared Interzonal flow (MW) |
|
LASTCHANGED |
DATE |
No |
Date time this record was created |
4.7.7 New table: PDPASA_FNM_REGIONSOLUTION
|
Comment |
PDPASA_FNM_REGIONSOLUTION shows region demand, cleared values of resources, spare capacity, losses for each run type and intervals. |
|---|---|
|
Visibility |
Public |
|
Data volume |
Medium |
|
Trigger |
Every 30 minutes |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports |
|
Primary key (in order) |
RUN_DATETIME, RUNTYPE, INTERVAL_DATETIME, REGIONID |
|
Project |
STPASA Replacement project |
New columns
|
Field name |
Data type |
Primary key |
Comment |
|---|---|---|---|
|
RUN_DATETIME |
DATE |
Yes |
Unique Timestamp Identifier for this run, identified by the first half hour ended interval of the run |
|
RUNTYPE |
VARCHAR2(20) |
Yes |
Run Type (BASE, RELIABILITY, WARNING) |
|
INTERVAL_DATETIME |
DATE |
Yes |
End date time of the interval |
|
REGIONID |
VARCHAR2(20) |
Yes |
Region Identifier |
|
LORCONDITION |
NUMBER(1,0) |
No |
Lack of Reserve Condition (LORCONDITION) > 0 if a supply deficit exists in the Zone for this Region that contains its Regional Reference Node |
|
DEFICITCONDITION |
NUMBER(1,0) |
No |
Deficit Condition (DEFICITCONDITION) > 0 if a supply deficit only exists in a Zone for this Region that does not contain its Regional Reference Node |
|
INITIALDEMAND |
NUMBER(12,2) |
No |
Most probable Demand Forecast adjusted by Demand Uncertainty Margin (MW) |
|
DEMAND_UNCERTAINTY_MARGIN |
NUMBER(12,2) |
No |
Aggregate Uncertainty Margin adjustment to most probable Demand Forecast (MW) |
|
SCHED_GEN_UNCERTAINTY_MARGIN |
NUMBER(12,2) |
No |
Aggregate Uncertainty Margin adjustment to Scheduled Generation Bid Max Avail (MW) |
|
VRE_GEN_UNCERTAINTY_MARGIN |
NUMBER(12,2) |
No |
Aggregate Uncertainty Margin adjustment to most probable VRE Forecast (MW) |
|
SCHED_GEN_AUX_LOAD |
NUMBER(12,2) |
No |
Aggregate Auxiliary Load adjustment to uncertainty-adjusted Bid MaxAvail of all scheduled generating units (MW) |
|
ENERGYUNCONSTRAINED_CLEARED |
NUMBER(12,2) |
No |
Cleared Generation from non energy-constrained resources - that is, excluding bidirectional units and generating units subject to daily energy limits (MW) |
|
ENERGYCONSTRAINED_CLEARED |
NUMBER(12,2) |
No |
Cleared Generation from energy-constrained resources - that is, from bidirectional units and generating units subject to daily energy limits (MW) |
|
BDU_CLEARED |
NUMBER(12,2) |
No |
Cleared Generation (positive) or Consumption (negative) from bidirectional units (MW) |
|
SS_CLEARED |
NUMBER(12,2) |
No |
Cleared Generation from semi-scheduled generating units (MW) |
|
SS_SOLAR_CLEARED |
NUMBER(12,2) |
No |
Cleared Generation from semi-scheduled solar generating units (MW) |
|
SS_WIND_CLEARED |
NUMBER(12,2) |
No |
Cleared Generation from semi-scheduled wind generating units (MW) |
|
SPARECAPACITY |
NUMBER(12,2) |
No |
Spare Generation Capacity = max(0, Available Generation minus [Cleared Generation minus Cleared Net Interchange]) (MW) |
|
CLEAREDSUPPLY |
NUMBER(12,2) |
No |
Cleared Generation (MW) |
|
CLEAREDLOSSES |
NUMBER(12,2) |
No |
Cleared Grid Losses (MW) |
|
CLEAREDNETINTERCHANGE |
NUMBER(12,2) |
No |
Cleared Net Export (positive) or Net Import (negative) (MW) |
|
CLEAREDDEMAND |
NUMBER(12,2) |
No |
Cleared Demand (MW) |
|
SUPPLYDEFICIT |
NUMBER(12,2) |
No |
Supply Deficit (MW) across at all loads in the Region = Max(0, Initial Demand minus Cleared Demand) where Cleared Demand = (Cleared Generation minus Cleared Losses minus Cleared Net Interchange). |
|
SUPPLYDEFICIT_RRN |
NUMBER(12,2) |
No |
Supply Deficit across all loads in the Zone that contains the Regional Reference Node (MW) |
|
SUPPLYDEFICIT_NONRRN |
NUMBER(12,2) |
No |
Supply Deficit across all loads in the Zone(s) that do not contain the Regional Reference Node (MW) |
|
LASTCHANGED |
DATE |
No |
Date time this record was created |
4.7.8 New table: PDPASA_FNM_REGIONSUMMARY
|
Comment |
PDPASA_FNM_REGIONSUMMARY shows the summary of PDPASA outcome for each region. |
|---|---|
|
Visibility |
Public |
|
Data volume |
Medium |
|
Trigger |
Every 30 minutes |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports |
|
Primary key (in order) |
RUN_DATETIME, INTERVAL_DATETIME, REGIONID |
|
Project |
STPASA Replacement project |
New columns
|
Field name |
Data type |
Primary key |
Comment |
|---|---|---|---|
|
RUN_DATETIME |
DATE |
Yes |
Unique Timestamp Identifier for this run, identified by the first half hour ended interval of the run |
|
INTERVAL_DATETIME |
DATE |
Yes |
End date time of the interval |
|
REGIONID |
VARCHAR2(20) |
Yes |
Region identifier |
|
LORCONDITION |
NUMBER(1,0) |
No |
Lack of Reserve Condition (LORCONDITION) > 0 if a supply deficit exists in the Zone for this Region that contains its Regional Reference Node |
|
DEFICITCONDITION |
NUMBER(1,0) |
No |
Deficit Condition (DEFICITCONDITION) > 0 if a supply deficit only exists in a Zone for this Region that does not contain its Regional Reference Node DEFICITCONDITION indicates the most severe condition: |
|
DEMAND50 |
NUMBER(12,2) |
No |
50% Probability of Exceedance demand forecast (MW) |
|
DEMAND50_UNSCHED_GEN |
NUMBER(12,2) |
No |
50% Probability of Exceedance demand forecast plus Aggregate Generation Forecast of all non-scheduled and exempt generation (MW) |
|
SCHED_SS_GEN_CAPACITYAVAIL |
NUMBER(12,2) |
No |
Aggregate Bid MaxAvail of all scheduled generating units, scheduled bidirectional units (Gen side) and semi-scheduled generating units, with latter capped at UIGF (MW) |
|
UNSCHED_GEN_CAPACITYAVAIL |
NUMBER(12,2) |
No |
Aggregate Generation Forecast of all non-scheduled and exempt generation (MW) |
|
SCHED_SS_GEN_PASAAVAIL |
NUMBER(12,2) |
No |
Aggregate Bid PASAAvailability of all scheduled generating units and scheduled bidirectional units (Gen side) with a Bid Recall Period less than (Interval_DateTime minus Run_DateTime) plus UIGF for all semi-scheduled generating units (MW) |
|
SCHED_LOAD_CAPACITYAVAIL |
NUMBER(12,2) |
No |
Aggregate Bid MaxAvail of all scheduled loads (MW) |
|
SS_UIGF |
NUMBER(12,2) |
No |
Aggregate 50% Probability of Exceedance Unconstrained Intermittent Generation Forecast (UIGF) of all semi-scheduled generating units (MW) |
|
SS_SOLAR_UIGF |
NUMBER(12,2) |
No |
Aggregate 50% Probability of Exceedance Unconstrained Intermittent Generation Forecast (UIGF) of all solar semi-scheduled generating units (MW) |
|
SS_WIND_UIGF |
NUMBER(12,2) |
No |
Aggregate 50% Probability of Exceedance Unconstrained Intermittent Generation Forecast (UIGF) of all wind semi-scheduled generating units (MW) |
|
LASTCHANGED |
DATE |
No |
Date time this record was created |
4.7.9 New table: PDPASA_FNM_ZONESOLUTION
|
Comment |
PDPASA_FNM_ZONESOLUTION shows zone demand, cleared values of resources, spare capacity, losses for each run type and intervals. |
|---|---|
|
Visibility |
Public |
|
Data volume |
Medium |
|
Trigger |
Every 30 minutes |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports |
|
Primary key (in order) |
RUN_DATETIME, RUNTYPE, INTERVAL_DATETIME, ZONEID |
|
Project |
STPASA Replacement project |
New columns
|
Field name |
Data type |
Primary key |
Comment |
|---|---|---|---|
|
RUN_DATETIME |
DATE |
Yes |
Unique Timestamp Identifier for this run, identified by the first half hour ended interval of the run |
|
RUNTYPE |
VARCHAR2(20) |
Yes |
Run Type (BASE, RELIABILITY, WARNING) |
|
INTERVAL_DATETIME |
DATE |
Yes |
End date time of the interval |
|
ZONEID |
VARCHAR2(30) |
Yes |
Zone identifier |
|
REGIONID |
VARCHAR2(20) |
No |
Region identifier of the Region containing this Zone |
|
LORCONDITION |
NUMBER(1,0) |
No |
Lack of Reserve Condition (LORCONDITION) > 0 if a supply deficit exists and this Zone contains the Regional Reference Node |
|
DEFICITCONDITION |
NUMBER(1,0) |
No |
Deficit Condition (DEFICITCONDITION) > 0 if a supply deficit exists and this Zone does not contain the Regional Reference Node |
|
INITIALDEMAND |
NUMBER(12,2) |
No |
Most probable Demand Forecast adjusted by Demand Uncertainty Margin (MW) |
|
DEMAND_UNCERTAINTY_MARGIN |
NUMBER(12,2) |
No |
Aggregate Uncertainty Margin adjustment (increase) to most probable Demand Forecast (MW) |
|
SCHED_GEN_UNCERTAINTY_MARGIN |
NUMBER(12,2) |
No |
Aggregate Uncertainty Margin adjustment (decrease) to Scheduled Generation Bid Max Avail (MW) |
|
VRE_GEN_UNCERTAINTY_MARGIN |
NUMBER(12,2) |
No |
Aggregate Uncertainty Margin adjustment (decrease) to most probable VRE Forecast (MW) |
|
SCHED_GEN_AUX_LOAD |
NUMBER(12,2) |
No |
Aggregate Auxiliary Load adjustment to uncertainty-adjusted Bid MaxAvail of all scheduled generating units (MW) |
|
ENERGYUNCONSTRAINED_CLEARED |
NUMBER(12,2) |
No |
Cleared Generation from non energy-constrained resources - that is, excluding bidirectional units and generating units subject to daily energy limits (MW) |
|
ENERGYCONSTRAINED_CLEARED |
NUMBER(12,2) |
No |
Cleared Generation from energy-constrained resources - that is, from bidirectional units and generating units subject to daily energy limits (MW) |
|
BDU_CLEARED |
NUMBER(12,2) |
No |
Cleared Generation (positive) or Consumption (negative) from bidirectional units (MW) |
|
SS_CLEARED |
NUMBER(12,2) |
No |
Cleared Generation from semi-scheduled generating units (MW) |
|
SS_SOLAR_CLEARED |
NUMBER(12,2) |
No |
Cleared Generation from semi-scheduled solar generating units (MW) |
|
SS_WIND_CLEARED |
NUMBER(12,2) |
No |
Cleared Generation from semi-scheduled wind generating units (MW) |
|
SPARECAPACITY |
NUMBER(12,2) |
No |
Spare generation capacity = max(0, Available Generation minus [Cleared Generation minus Cleared Net Interchange]) (MW) |
|
CLEAREDSUPPLY |
NUMBER(12,2) |
No |
Cleared Generation (MW) |
|
CLEAREDLOSSES |
NUMBER(12,2) |
No |
Cleared Grid Losses (MW) |
|
CLEAREDNETINTERCHANGE |
NUMBER(12,2) |
No |
Cleared Net Export (positive) or Net Import (negative) (MW) |
|
CLEAREDDEMAND |
NUMBER(12,2) |
No |
Cleared Demand (MW) |
|
SUPPLYDEFICIT |
NUMBER(12,2) |
No |
Supply Deficit at loads = Max(0, Initial Demand minus Cleared Demand) where Cleared Demand = (Cleared Generation minus Cleared Losses minus Cleared Net Interchange) (MW) |
|
LASTCHANGED |
DATE |
No |
Date time this record was created |
4.7.10 New table: PDPASA_FNM_ZONESUMMARY
|
Comment |
PDPASA_FNM_ZONESUMMARY shows the summary of PDPASA outcome for each zone. |
|---|---|
|
Visibility |
Public |
|
Data volume |
Medium |
|
Trigger |
Every 30 minutes |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports |
|
Primary key (in order) |
RUN_DATETIME, INTERVAL_DATETIME, ZONEID |
|
Project |
STPASA Replacement project |
New columns
|
Field name |
Data type |
Primary key |
Comment |
|---|---|---|---|
|
RUN_DATETIME |
DATE |
Yes |
Unique Timestamp Identifier for this run, identified by the first half hour ended interval of the run |
|
INTERVAL_DATETIME |
DATE |
Yes |
End date time of the interval |
|
ZONEID |
VARCHAR2(30) |
Yes |
Zone identifier |
|
REGIONID |
VARCHAR2(20) |
No |
Region identifier of the Region containing this Zone |
|
LORCONDITION |
NUMBER(1,0) |
No |
Lack of Reserve Condition (LORCONDITION) > 0 if a supply deficit exists and this Zone contains the Regional Reference Node |
|
DEFICITCONDITION |
NUMBER(1,0) |
No |
Deficit Condition (DEFICITCONDITION) > 0 if a supply deficit only exists in a Zone for this Region that does not contain the Regional Reference Node. DEFICITCONDITION indicates the most severe condition: |
|
DEMAND50 |
NUMBER(12,2) |
No |
50% Probability of Exceedance demand forecast (MW) |
|
DEMAND50_UNSCHED_GEN |
NUMBER(12,2) |
No |
50% Probability of Exceedance demand forecast plus Aggregate Generation Forecast of all non-scheduled and exempt generation (MW) |
|
SCHED_SS_GEN_CAPACITYAVAIL |
NUMBER(12,2) |
No |
Aggregate Bid MaxAvail of all scheduled generating units, scheduled bidirectional units (Gen side) and semi-scheduled generating units, with latter capped at UIGF (MW) |
|
UNSCHED_GEN_CAPACITYAVAIL |
NUMBER(12,2) |
No |
Aggregate Generation Forecast of all non-scheduled and exempt generation (MW) |
|
SCHED_SS_GEN_PASAAVAIL |
NUMBER(12,2) |
No |
Aggregate Bid PASAAvailability of all scheduled generating units and scheduled bidirectional units (Gen side) with a Bid Recall Period less than (Interval_DateTime minus Run_DateTime) plus UIGF for all semi-scheduled generating units (MW) |
|
SCHED_LOAD_CAPACITYAVAIL |
NUMBER(12,2) |
No |
Aggregate Bid MaxAvail of all scheduled loads (MW) |
|
SS_UIGF |
NUMBER(12,2) |
No |
Aggregate 50% Probability of Exceedance Unconstrained Intermittent Generation Forecast (UIGF) of all semi-scheduled generating units (MW) |
|
SS_SOLAR_UIGF |
NUMBER(12,2) |
No |
Aggregate 50% Probability of Exceedance Unconstrained Intermittent Generation Forecast (UIGF) of all solar semi-scheduled generating units (MW) |
|
SS_WIND_UIGF |
NUMBER(12,2) |
No |
Aggregate 50% Probability of Exceedance Unconstrained Intermittent Generation Forecast (UIGF) of all wind semi-scheduled generating units (MW) |
|
LASTCHANGED |
DATE |
No |
Date time this record was created |
4.8 Package: SETTLEMENT_DATA
Results from a published Settlements See Relevant Rules or Procedures Run. The settlement data and billing run data are updated daily between 6 am and 8 am for AEMO's prudential processes. In a normal week, AEMO publishes one PRELIM, one FINAL and two REVISION runs in addition to the daily runs
4.8.1 Modified table: SET_NMAS_RECOVERY
|
Comment |
SET_NMAS_RECOVERY sets out the NSCAS recovery data for payments other than testing This Table may also be used for NSCAS and Type 1 transitional services procured by AEMO under the ISF framework during 2025 and prior to the implementation of all system changes. During this time descriptions in these tables may not be correct. |
|---|---|
|
Visibility |
Private |
|
Data volume |
Medium |
|
Trigger |
Settlement Run |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReport |
|
Primary key (in order) |
SETTLEMENTDATE, VERSIONNO, PERIODID, PARTICIPANTID, SERVICE, CONTRACTID, PAYMENTTYPE, REGIONID |
|
Project |
Improving Security Frameworks |
Modified Column
Data type changes only
|
Field name |
Data type |
Primary key |
Comment |
|---|---|---|---|
|
SERVICE |
VARCHAR2(20) |
Yes |
The type of NSCAS service incl ISF Services. Current value values are: REACTIVE LOADSHED RESTART INERTIA, SYSTEM STRENGTH, TYPE1, TYPE2 |
|
CONTRACTID |
VARCHAR2(20) |
Yes |
The NMAS/ISF Contract Id |
4.8.2 Modified table: SET_NMAS_RECOVERY_RBF
Data type changes only
|
Comment |
SET_NMAS_RECOVERY_RBF publishes the RBF for NSCAS non testing payments on a half hourly basis. This Table may also be used for NSCAS and Type 1 transitional services procured by AEMO under the ISF framework during 2025 and prior to the implementation of all system changes. During this time descriptions in these tables may not be correct. |
|---|---|
|
Visibility |
Public |
|
Data volume |
Medium |
|
Trigger |
Settlement Run |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReport |
|
Primary key (in order) |
SETTLEMENTDATE, VERSIONNO, PERIODID, SERVICE, CONTRACTID, PAYMENTTYPE, REGIONID |
|
Project |
Improving Security Frameworks |
Modified Column
|
Field name |
Data type |
Primary key |
Comment |
|---|---|---|---|
|
SERVICE |
VARCHAR2(20) |
Yes |
The type of NSCAS service incl ISF Services. Current value values are: REACTIVE LOADSHED RESTART INERTIA, SYSTEM STRENGTH, TYPE1, TYPE2 |
|
CONTRACTID |
VARCHAR2(20) |
Yes |
The NMAS/ISF Contract Id |
4.9 Package: STPASA_SOLUTION
4.9.1 New table: STPASA_FNM_CASESOLUTION
|
Comment |
STPASA_FNM_CASESOLUTION shows the case run details, including the available run types, LOR and Deficit condition for each case. |
|---|---|
|
Visibility |
Public |
|
Data volume |
Medium |
|
Trigger |
Every 60 minutes |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports |
|
Primary key (in order) |
RUN_DATETIME |
|
Project |
STPASA Replacement project |
New columns
|
Field name |
Data type |
Primary key |
Comment |
|---|---|---|---|
|
RUN_DATETIME |
DATE |
Yes |
Unique Timestamp Identifier for this run, identified by the first half hour ended interval of the run |
|
LORCONDITION |
NUMBER(1,0) |
No |
LORCONDITION is only set if supply deficit exists in a Zone that contains the Regional Reference Node |
|
DEFICITCONDITION |
NUMBER(1,0) |
No |
DEFICITCONDITION is only set if supply deficit exists in a Zone that does NOT contain the Regional Reference Node |
|
BASE_RUN_AVAILABLE |
VARCHAR2(10) |
No |
YES = Available, NO = Not Available |
|
RELIABILITY_RUN_AVAILABLE |
VARCHAR2(10) |
No |
YES = Available, NO = Not Available |
|
WARNING_RUN_AVAILABLE |
VARCHAR2(10) |
No |
YES = Available, NO = Not Available |
|
PASAVERSION |
VARCHAR2(30) |
No |
Version of the PASA solver used to solve this case |
|
LASTCHANGED |
DATE |
No |
Date time this record was created |
4.9.2 New table: STPASA_FNM_CONSTRAINTSOLUTION
|
Comment |
STPASA_FNM_CONSTRAINTSOLUTION shows the manual or thermal constraint (created by PASA), including marginal value, violation degree, LHS and RHS. |
|---|---|
|
Visibility |
Public |
|
Data volume |
Large |
|
Trigger |
Every 60 minutes |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports |
|
Primary key (in order) |
RUN_DATETIME, RUNTYPE, INTERVAL_DATETIME, CONSTRAINTID |
|
Project |
STPASA Replacement project |
New columns
|
Field name |
Data type |
Primary key |
Comment |
|---|---|---|---|
|
RUN_DATETIME |
DATE |
Yes |
Unique Timestamp Identifier for this run, identified by the first half hour ended interval of the run |
|
RUNTYPE |
VARCHAR2(20) |
Yes |
Run Type (BASE, RELIABILITY, WARNING) |
|
INTERVAL_DATETIME |
DATE |
Yes |
End date time of the interval |
|
CONSTRAINTID |
VARCHAR2(100) |
Yes |
Constraint identifier, either manual constraint (synonymous with GenConID) or thermal constraint created by PASA with format ‘BASE_<BranchName>’ or '<ContingencyID>_<BranchName>' |
|
MARGINALVALUE |
NUMBER(20,5) |
No |
Constraint Marginal Value ($/MW) |
|
VIOLATIONDEGREE |
NUMBER(15,5) |
No |
Constraint Violation Degree (MW) |
|
LHS |
NUMBER(15,5) |
No |
Constraint LHS (MW) |
|
RHS |
NUMBER(15,5) |
No |
Constraint RHS (MW) |
|
LASTCHANGED |
DATE |
No |
Date time this record was created |
4.9.3 New table: STPASA_FNM_DUIDAVAILABILITY
|
Comment |
STPASA_FNM_DUIDAVAILABILITY shows Available Capacity, PASA Availability and given Recall Period for all scheduled |
|---|---|
|
Visibility |
Public |
|
Data volume |
Large |
|
Trigger |
Every 60 minutes |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports |
|
Primary key (in order) |
RUN_DATETIME, INTERVAL_DATETIME, DUID |
|
Project |
STPASA Replacement project |
New columns
|
Field name |
Data type |
Primary key |
Comment |
|---|---|---|---|
|
RUN_DATETIME |
DATE |
Yes |
Unique Timestamp Identifier for this run, identified by the first half hour ended interval of the run |
|
INTERVAL_DATETIME |
DATE |
Yes |
End date time of the interval |
|
DUID |
VARCHAR2(20) |
Yes |
NEM Dispatchable Unit Identifier |
|
BID_TRADINGDATE |
DATE |
No |
Trading Date of the energy bid |
|
BID_OFFERDATETIME |
DATE |
No |
Date Time that the energy bid was received |
|
GENERATION_MAX_AVAILABILITY |
NUMBER (12,3) |
No |
Available Capacity for a scheduled generating unit, semi-scheduled generating unit, BDU (Gen side), WDR or MNSP |
|
GENERATION_PASA_AVAILABILITY |
NUMBER (12,3) |
No |
PASA Availability for a scheduled generating unit, BDU (Gen side), WDR or MNSP. Null for a semi-scheduled generating unit (MW) |
|
GENERATION_RECALL_PERIOD |
NUMBER (8,3) |
No |
Recall Period associated with the PASA Availability for a scheduled generating unit, BDU (Gen side), WDR or MNSP. Null for a semi-scheduled generating unit (Hours) |
|
LOAD_MAX_AVAILABILITY |
NUMBER (12,3) |
No |
Available Capacity for a scheduled load or BDU (Load side) (MW) |
|
LOAD_PASA_AVAILABILITY |
NUMBER (12,3) |
No |
PASA Availability for a scheduled load or BDU (Load side) (MW) |
|
LOAD_RECALL_PERIOD |
NUMBER (8,3) |
No |
Recall Period associated with the PASA Availability for a scheduled load or BDU (Load side) (Hours) |
|
LASTCHANGED |
DATE |
No |
Date time this record was created |
4.9.4 New table: STPASA_FNM_INTERCONNECTORSOLN
|
Comment |
STPASA_FNM_INTERCONNECTORSOLN shows cleared Interconnector flow for the interval. |
|---|---|
|
Visibility |
Public |
|
Data volume |
Medium |
|
Trigger |
Every 60 minutes |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports |
|
Primary key (in order) |
RUN_DATETIME, RUNTYPE, INTERVAL_DATETIME, INTERCONNECTORID |
|
Project |
STPASA Replacement project |
New columns
|
Field name |
Data type |
Primary key |
Comment |
|---|---|---|---|
|
RUN_DATETIME |
DATE |
Yes |
Unique Timestamp Identifier for this run, identified by the first half hour ended interval of the run |
|
RUNTYPE |
VARCHAR2(20) |
Yes |
Run Type (BASE, RELIABILITY, WARNING) |
|
INTERVAL_DATETIME |
DATE |
Yes |
End date time of the interval |
|
INTERCONNECTORID |
VARCHAR2(10) |
Yes |
Interconnector Identifier |
|
CLEAREDFLOW |
NUMBER(12,2) |
No |
Cleared Interconnector flow (MW) |
|
LASTCHANGED |
DATE |
No |
Date time this record was created |
4.9.5 New table: STPASA_FNM_INTERZONALSOLUTION
|
Comment |
STPASA_FNM_INTERZONALSOLUTION shows cleared inter zonal flow for the interval and run type. |
|---|---|
|
Visibility |
Public |
|
Data volume |
Medium |
|
Trigger |
Every 60 minutes |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports |
|
Primary key (in order) |
RUN_DATETIME, RUNTYPE, INTERVAL_DATETIME, INTERZONALCONNECTORID |
|
Project |
STPASA Replacement project |
New columns
|
Field name |
Data type |
Primary key |
Comment |
|---|---|---|---|
|
RUN_DATETIME |
DATE |
Yes |
Unique Timestamp Identifier for this run, identified by the first half hour ended interval of the run |
|
RUNTYPE |
VARCHAR2(20) |
Yes |
Run Type (BASE, RELIABILITY, WARNING) |
|
INTERVAL_DATETIME |
DATE |
Yes |
End date time of the interval |
|
INTERZONALCONNECTORID |
VARCHAR2(50) |
Yes |
InterzonalConnector Identifier |
|
FROMZONEID |
VARCHAR2(30) |
No |
FromZoneID of the InterZonalConnectorID |
|
TOZONEID |
VARCHAR2(30) |
No |
ToZoneID of the InterZonalConnectorID |
|
CLEAREDFLOW |
NUMBER(12,2) |
No |
Cleared Interzonal flow (MW) |
|
LASTCHANGED |
DATE |
No |
Date time this record was created |
4.9.6 New table: STPASA_FNM_REGIONSOLUTION
|
Comment |
STPASA_FNM_REGIONSOLUTION shows regional demand, cleared values of resources, spare capacity, losses for each run type and intervals. |
|---|---|
|
Visibility |
Public |
|
Data volume |
Medium |
|
Trigger |
Every 60 minutes |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports |
|
Primary key (in order) |
RUN_DATETIME, RUNTYPE, INTERVAL_DATETIME, REGIONID |
|
Project |
STPASA Replacement project |
New columns
|
Field name |
Data type |
Primary key |
Comment |
|---|---|---|---|
|
RUN_DATETIME |
DATE |
Yes |
Unique Timestamp Identifier for this run, identified by the first half hour ended interval of the run |
|
RUNTYPE |
VARCHAR2(20) |
Yes |
Run Type (BASE, RELIABILITY, WARNING) |
|
INTERVAL_DATETIME |
DATE |
Yes |
End date time of the interval |
|
REGIONID |
VARCHAR2(20) |
Yes |
Region Identifier |
|
LORCONDITION |
NUMBER(1,0) |
No |
Lack of Reserve Condition (LORCONDITION) > 0 if a supply deficit exists in the Zone for this Region that contains its Regional Reference Node |
|
DEFICITCONDITION |
NUMBER(1,0) |
No |
Deficit Condition (DEFICITCONDITION) > 0 if a supply deficit only exists in a Zone for this Region that does not contain its Regional Reference Node |
|
INITIALDEMAND |
NUMBER(12,2) |
No |
Most probable Demand Forecast adjusted by Demand Uncertainty Margin (MW) |
|
DEMAND_UNCERTAINTY_MARGIN |
NUMBER(12,2) |
No |
Aggregate Uncertainty Margin adjustment to most probable Demand Forecast (MW) |
|
SCHED_GEN_UNCERTAINTY_MARGIN |
NUMBER(12,2) |
No |
Aggregate Uncertainty Margin adjustment to Scheduled Generation Bid Max Avail (MW) |
|
VRE_GEN_UNCERTAINTY_MARGIN |
NUMBER(12,2) |
No |
Aggregate Uncertainty Margin adjustment to most probable VRE Forecast (MW) |
|
SCHED_GEN_AUX_LOAD |
NUMBER(12,2) |
No |
Aggregate Auxiliary Load adjustment to uncertainty-adjusted Bid MaxAvail of all scheduled generating units (MW) |
|
ENERGYUNCONSTRAINED_CLEARED |
NUMBER(12,2) |
No |
Cleared Generation from non energy-constrained resources - that is, excluding bidirectional units and generating units subject to daily energy limits (MW) |
|
ENERGYCONSTRAINED_CLEARED |
NUMBER(12,2) |
No |
Cleared Generation from energy-constrained resources - that is, from bidirectional units and generating units subject to daily energy limits (MW) |
|
BDU_CLEARED |
NUMBER(12,2) |
No |
Cleared Generation (positive) or Consumption (negative) from bidirectional units (MW) |
|
SS_CLEARED |
NUMBER(12,2) |
No |
Cleared Generation from semi-scheduled generating units (MW) |
|
SS_SOLAR_CLEARED |
NUMBER(12,2) |
No |
Cleared Generation from semi-scheduled solar generating units (MW) |
|
SS_WIND_CLEARED |
NUMBER(12,2) |
No |
Cleared Generation from semi-scheduled wind generating units (MW) |
|
SPARECAPACITY |
NUMBER(12,2) |
No |
Spare Generation Capacity = max(0, Available Generation minus [Cleared Generation minus Cleared Net Interchange]) (MW) |
|
CLEAREDSUPPLY |
NUMBER(12,2) |
No |
Cleared Generation (MW) |
|
CLEAREDLOSSES |
NUMBER(12,2) |
No |
Cleared Grid Losses (MW) |
|
CLEAREDDEMAND |
NUMBER(12,2) |
No |
Cleared Demand (MW) |
|
CLEAREDNETINTERCHANGE |
NUMBER(12,2) |
No |
Cleared Net Export (positive) or Net Import (negative) (MW) |
|
SUPPLYDEFICIT |
NUMBER(12,2) |
No |
Supply Deficit (MW) across at all loads in the Region = Max(0, Initial Demand minus Cleared Demand) where Cleared Demand = (Cleared Generation minus Cleared Losses minus Cleared Net Interchange). |
|
SUPPLYDEFICIT_RRN |
NUMBER(12,2) |
No |
Supply Deficit across all loads in the Zone that contains the Regional Reference Node (MW) |
|
SUPPLYDEFICIT_NONRRN |
NUMBER(12,2) |
No |
Supply Deficit across all loads in the Zone(s) that do not contain the Regional Reference Node (MW) |
|
LASTCHANGED |
DATE |
No |
Date time this record was created |
4.9.7 New table: STPASA_FNM_REGIONSUMMARY
|
Comment |
STPASA_FNM_REGIONSUMMARY shows the summary of STPASA outcome for each region. |
|---|---|
|
Visibility |
Public |
|
Data volume |
Medium |
|
Trigger |
Every 60 minutes |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports |
|
Primary key (in order) |
RUN_DATETIME, INTERVAL_DATETIME, REGIONID |
|
Project |
STPASA Replacement project |
New columns
|
Field name |
Data type |
Primary key |
Comment |
|---|---|---|---|
|
RUN_DATETIME |
DATE |
Yes |
Unique Timestamp Identifier for this run, identified by the first half hour ended interval of the run |
|
INTERVAL_DATETIME |
DATE |
Yes |
End date time of the interval |
|
REGIONID |
VARCHAR2(20) |
Yes |
Region identifier |
|
LORCONDITION |
NUMBER(1,0) |
No |
Lack of Reserve Condition (LORCONDITION) > 0 if a supply deficit exists in the Zone for this Region that contains its Regional Reference Node |
|
DEFICITCONDITION |
NUMBER(1,0) |
No |
Deficit Condition (DEFICITCONDITION) > 0 if a supply deficit only exists in a Zone for this Region that does not contain its Regional Reference Node. |
|
DEMAND50 |
NUMBER(12,2) |
No |
50% Probability of Exceedance demand forecast (MW) |
|
DEMAND50_UNSCHED_GEN |
NUMBER(12,2) |
No |
50% Probability of Exceedance demand forecast plus Aggregate Generation Forecast of all non-scheduled and exempt generation (MW) |
|
SCHED_SS_GEN_CAPACITYAVAIL |
NUMBER(12,2) |
No |
Aggregate Bid MaxAvail of all scheduled generating units, scheduled bidirectional units (Gen side) and semi-scheduled generating units, with latter capped at UIGF (MW) |
|
UNSCHED_GEN_CAPACITYAVAIL |
NUMBER(12,2) |
No |
Aggregate Generation Forecast of all non-scheduled and exempt generation (MW) |
|
SCHED_SS_GEN_PASAAVAIL |
NUMBER(12,2) |
No |
Aggregate Bid PASAAvailability of all scheduled generating units and scheduled bidirectional units (Gen side) with a Bid Recall Period less than (Interval_DateTime minus Run_DateTime) plus UIGF for all semi-scheduled generating units (MW) |
|
SCHED_LOAD_CAPACITYAVAIL |
NUMBER(12,2) |
No |
Aggregate Bid MaxAvail of all scheduled loads (MW) |
|
SS_UIGF |
NUMBER(12,2) |
No |
Aggregate 50% Probability of Exceedance Unconstrained Intermittent Generation Forecast (UIGF) of all semi-scheduled generating units (MW) |
|
SS_SOLAR_UIGF |
NUMBER(12,2) |
No |
Aggregate 50% Probability of Exceedance Unconstrained Intermittent Generation Forecast (UIGF) of all solar semi-scheduled generating units (MW) |
|
SS_WIND_UIGF |
NUMBER(12,2) |
No |
Aggregate 50% Probability of Exceedance Unconstrained Intermittent Generation Forecast (UIGF) of all wind semi-scheduled generating units (MW) |
|
LASTCHANGED |
DATE |
No |
Date time this record was created |
4.9.8 New table: STPASA_FNM_ZONESOLUTION
|
Comment |
STPASA_FNM_ZONESOLUTION shows zone demand, cleared value of resources, spare capacity, losses for each run type and interval. |
|---|---|
|
Visibility |
Public |
|
Data volume |
Medium |
|
Trigger |
Every 60 minutes |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports |
|
Primary key (in order) |
RUN_DATETIME, RUNTYPE, INTERVAL_DATETIME, ZONEID |
|
Project |
STPASA Replacement project |
New columns
|
Field name |
Data type |
Primary key |
Comment |
|---|---|---|---|
|
RUN_DATETIME |
DATE |
Yes |
Unique Timestamp Identifier for this run, identified by the first half hour ended interval of the run |
|
RUNTYPE |
VARCHAR2(20) |
Yes |
Run Type (BASE, RELIABILITY, WARNING) |
|
INTERVAL_DATETIME |
DATE |
Yes |
End date time of the interval |
|
ZONEID |
VARCHAR2(30) |
Yes |
Zone identifier |
|
REGIONID |
VARCHAR2(20) |
No |
Region identifier of the Region containing this Zone |
|
LORCONDITION |
NUMBER(1,0) |
No |
Lack of Reserve Condition (LORCONDITION) > 0 if a supply deficit exists and this Zone contains the Regional Reference Node |
|
DEFICITCONDITION |
NUMBER(1,0) |
No |
Deficit Condition (DEFICITCONDITION) > 0 if a supply deficit exists and this Zone does not contain the Regional Reference Node. |
|
INITIALDEMAND |
NUMBER(12,2) |
No |
Most probable Demand Forecast adjusted by Demand Uncertainty Margin (MW) |
|
DEMAND_UNCERTAINTY_MARGIN |
NUMBER(12,2) |
No |
Aggregate Uncertainty Margin adjustment (increase) to most probable Demand Forecast (MW) |
|
SCHED_GEN_UNCERTAINTY_MARGIN |
NUMBER(12,2) |
No |
Aggregate Uncertainty Margin adjustment (decrease) to Scheduled Generation Bid Max Avail (MW) |
|
VRE_GEN_UNCERTAINTY_MARGIN |
NUMBER(12,2) |
No |
Aggregate Uncertainty Margin adjustment (decrease) to most probable VRE Forecast (MW) |
|
SCHED_GEN_AUX_LOAD |
NUMBER(12,2) |
No |
Aggregate Auxiliary Load adjustment to uncertainty-adjusted Bid MaxAvail of all scheduled generating units (MW) |
|
ENERGYUNCONSTRAINED_CLEARED |
NUMBER(12,2) |
No |
Cleared Generation from non energy-constrained resources - that is, excluding bidirectional units and generating units subject to daily energy limits (MW) |
|
ENERGYCONSTRAINED_CLEARED |
NUMBER(12,2) |
No |
Cleared Generation from energy-constrained resources - that is, from bidirectional units and generating units subject to daily energy limits (MW) |
|
BDU_CLEARED |
NUMBER(12,2) |
No |
Cleared Generation (positive) or Consumption (negative) from bidirectional units (MW) |
|
SS_CLEARED |
NUMBER(12,2) |
No |
Cleared Generation from semi-scheduled generating units (MW) |
|
SS_SOLAR_CLEARED |
NUMBER(12,2) |
No |
Cleared Generation from semi-scheduled solar generating units (MW) |
|
SS_WIND_CLEARED |
NUMBER(12,2) |
No |
Cleared Generation from semi-scheduled wind generating units (MW) |
|
SPARECAPACITY |
NUMBER(12,2) |
No |
Spare generation capacity = max(0, Available Generation minus [Cleared Generation minus Cleared Net Interchange]) (MW) |
|
CLEAREDSUPPLY |
NUMBER(12,2) |
No |
Cleared Generation (MW) |
|
CLEAREDLOSSES |
NUMBER(12,2) |
No |
Cleared Grid Losses (MW) |
|
CLEAREDNETINTERCHANGE |
NUMBER(12,2) |
No |
Cleared Net Export (positive) or Net Import (negative) (MW) |
|
CLEAREDDEMAND |
NUMBER(12,2) |
No |
Cleared Demand (MW) |
|
SUPPLYDEFICIT |
NUMBER(12,2) |
No |
Supply Deficit at loads = Max(0, Initial Demand minus Cleared Demand) where Cleared Demand = (Cleared Generation minus Cleared Losses minus Cleared Net Interchange) (MW) |
|
LASTCHANGED |
DATE |
No |
Date time this record was created |
4.9.9 New table: STPASA_FNM_ZONESUMMARY
|
Comment |
STPASA_FNM_ZONESUMMARY shows the summary of STPASA outcome for each zone. |
|---|---|
|
Visibility |
Public |
|
Data volume |
Medium |
|
Trigger |
Every 60 minutes |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports |
|
Primary key (in order) |
RUN_DATETIME, INTERVAL_DATETIME, ZONEID |
|
Project |
STPASA Replacement project |
New columns
|
Field name |
Data type |
Primary key |
Comment |
|---|---|---|---|
|
RUN_DATETIME |
DATE |
Yes |
Unique Timestamp Identifier for this run, identified by the first half hour ended interval of the run |
|
INTERVAL_DATETIME |
DATE |
Yes |
End date time of the interval |
|
ZONEID |
VARCHAR2(30) |
Yes |
Zone identifier |
|
REGIONID |
VARCHAR2(20) |
No |
Region identifier of the Region containing this Zone |
|
LORCONDITION |
NUMBER(1,0) |
No |
Lack of Reserve Condition (LORCONDITION) > 0 if a supply deficit exists and this Zone contains the Regional Reference Node |
|
DEFICITCONDITION |
NUMBER(1,0) |
No |
Deficit Condition (DEFICITCONDITION) > 0 if a supply deficit only exists in a Zone for this Region that does not contain the Regional Reference Node |
|
DEMAND50 |
NUMBER(12,2) |
No |
50% Probability of Exceedance demand forecast (MW) |
|
DEMAND50_UNSCHED_GEN |
NUMBER(12,2) |
No |
50% Probability of Exceedance demand forecast plus Aggregate Generation Forecast of all non-scheduled and exempt generation (MW) |
|
SCHED_SS_GEN_CAPACITYAVAIL |
NUMBER(12,2) |
No |
Aggregate Bid MaxAvail of all scheduled generating units, scheduled bidirectional units (Gen side) and semi-scheduled generating units, with latter capped at UIGF (MW) |
|
UNSCHED_GEN_CAPACITYAVAIL |
NUMBER(12,2) |
No |
Aggregate Generation Forecast of all non-scheduled and exempt generation (MW) |
|
SCHED_SS_GEN_PASAAVAIL |
NUMBER(12,2) |
No |
Aggregate Bid PASAAvailability of all scheduled generating units and scheduled bidirectional units (Gen side) with a Bid Recall Period less than (Interval_DateTime minus Run_DateTime) plus UIGF for all semi-scheduled generating units (MW) |
|
SCHED_LOAD_CAPACITYAVAIL |
NUMBER(12,2) |
No |
Aggregate Bid MaxAvail of all scheduled loads (MW) |
|
SS_UIGF |
NUMBER(12,2) |
No |
Aggregate 50% Probability of Exceedance Unconstrained Intermittent Generation Forecast (UIGF) of all semi-scheduled generating units (MW) |
|
SS_SOLAR_UIGF |
NUMBER(12,2) |
No |
Aggregate 50% Probability of Exceedance Unconstrained Intermittent Generation Forecast (UIGF) of all solar semi-scheduled generating units (MW) |
|
SS_WIND_UIGF |
NUMBER(12,2) |
No |
Aggregate 50% Probability of Exceedance Unconstrained Intermittent Generation Forecast (UIGF) of all wind semi-scheduled generating units (MW) |
|
LASTCHANGED |
DATE |
No |
ate time this record was created |
4.9.10 Modified table: STPASA_REGIONSOLUTION
|
Comment |
STPASA_REGIONSOLUTION shows the results of the regional capacity, maximum surplus reserve and maximum spare capacity evaluations for each period of the study. Note that the RELIABILITY_LRC and OUTAGE_LRC Run Types are no longer reported from 31 July 2025. |
|---|---|
|
Visibility |
Public |
|
Data volume |
Medium |
|
Trigger |
Start of each STPASA run (every hour). |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports |
|
Primary key (in order) |
INTERVAL_DATETIME, REGIONID, RUN_DATETIME, RUNTYPE |
|
Project |
ST PASA Procedure and Recall Period |
Modified columns
Comment changes only
|
Field name |
Data type |
Primary key |
Comment |
|---|---|---|---|
|
AGGREGATEPASAAVAILABILITY |
NUMBER(12,0) |
No |
Sum of PASAAVAILABILITY for all scheduled generating units and scheduled bidirectional units (Gen side) with a Recall_Period <= 24 hours plus the sum of Unconstrained Intermittent Generation Forecasts (UIGF) for all semi-scheduled generating units. For the RELIABILITY_LRC and OUTAGE_LRC runs, UIGF is the POE90 forecast. For the LOR Run, UIGF is the POE50 forecast. Note that the RELIABILITY_LRC and OUTAGE_LRC Run Types are discontinued from 31 July 2025. From March 2026, AGGREGATEPASAAVAILABILITY changes from that with Recall_Period <= 24 to that achievable by the relevant INTERVAL_DATETIME if recalled at the start of the run. |
4.10 Package: SYSTEM_SECURITY_MANAGEMENT
4.10.1 New table: SSM_INDICATIVE_ROLL_DUID
|
Comment |
Indicative rolling DUID schedule provides notice of system security status to service providers/TNSP. The intent is to provide forewarning of possible enablement instruction that may be required |
|---|---|
|
Visibility |
Private |
|
Data volume |
Medium |
|
Trigger |
SSM Post Processing completion (currently every 30 minutes) |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports |
|
Primary key (in order) |
VERSION_DATETIME, INTERVAL_DATETIME, DUID, CONTRACT_ID |
|
Project |
Improving Security Frameworks |
New columns
|
Field name |
Data type |
Primary key |
Comment |
|---|---|---|---|
|
VERSION_DATETIME |
DATE |
YES |
Version date time |
|
INTERVAL_DATETIME |
DATE |
YES |
Interval date time |
|
DUID |
VARCHAR2(20) |
YES |
Dispatchable Unit Identifier |
|
CONTRACT_ID |
VARCHAR2(20) |
YES |
Unique Contract Identifier used to create enablement. |
|
DUID_PARTICIPANTID |
VARCHAR2(20) |
NO |
Primary recipient (SSM Service Provider) of enablement instruction. |
|
INSTRUCTION_ID |
VARCHAR2(20) |
NO |
Unique Instruction Identifier. Null where not applicable. |
|
DUID_STATUS |
VARCHAR2(40) |
NO |
Scheduled pending, Scheduled approved, Instruction issued, Fulfilment, Available, Offline, Online, Outage |
|
MIN_DISPATCH_MW |
NUMBER(18,8) |
NO |
Minimum Dispatch Target required for DUID to enable the contract. |
|
EQUIPMENT_TYPE |
VARCHAR2(40) |
NO |
Dispatchable Unit resource (for example, GENERATOR, LOAD, BIDIRECTIONAL, SYNCHRONOUS CONDENSER). |
|
LASTCHANGED |
DATE |
NO |
Last changed date |
4.10.2 New table: SSM_INDICATIVE_ROLL_REGION
|
Comment |
Indicative rolling Region schedule provides notice of system security status to service providers/TNSP. The intent is to provide the security strength status of a region |
|---|---|
|
Visibility |
Public |
|
Data volume |
Medium |
|
Trigger |
SSM Post Processing completion (currently every 30 minutes) |
|
Participant file share location |
<#INTRFACE>\<#PARTICIPANTID>\IMPORT\REPORTS\CSVReports |
|
Primary key (in order) |
VERSION_DATETIME, INTERVAL_DATETIME, REGIONID |
|
Project |
Improving Security Frameworks |
New columns
|
Field name |
Data type |
Primary key |
Comment |
|---|---|---|---|
|
VERSION_DATETIME |
DATE |
YES |
Version date time |
|
INTERVAL_DATETIME |
DATE |
YES |
Interval date time |
|
REGIONID |
VARCHAR2(20) |
YES |
Region |
|
REGION_STATUS |
VARCHAR2(40) |
NO |
Secure, Resolved, Not Secure |
|
DUID_COUNT_FIRM |
NUMBER(4,0) |
NO |
Sum of firm units enabled for the region with confirmed enablement instruction(s) sent |
|
DUID_COUNT_SPECULATIVE |
NUMBER(4,0) |
NO |
Sum of proposed units enabled for the region where enablement instruction(s) not sent |
|
LASTCHANGED |
DATE |
NO |
Last changed date |
4.11 File interface changes
|
Package |
File ID |
Description |
Batcher file masks |
Frequency |
Change |
Auto-subscription |
|
|---|---|---|---|---|---|---|---|
|
BILLING_CONFIG |
BILLINGCALENDAR |
|
|
|
Modified |
No |
|
|
BILLING_RUN |
BILLING |
|
|
|
Modified |
No |
|
|
BILLING_INIT |
|
|
|
Modified |
No |
|
|
|
DISPATCH |
DISPATCH_NEGATIVE_RESIDUE |
|
|
|
Modified |
No |
|
|
GENERIC_CONSTRAINT |
PASA_CONTINGENCY |
|
|
on change |
New |
Yes |
|
|
SYSTEM_SECURITY_MANAGEMENT |
SSM_FORECAST |
|
|
30 minutes |
New |
Yes |
|
|
STPASA_SOLUTION |
STPASA_FNM |
|
|
Hourly |
New |
Yes |
|
|
PARTICIPANT_REGISTRATION |
PASA_ZONE_REGION |
|
|
on change |
New |
Yes |
|
|
PASA_INTERZONAL |
|
|
on change |
New |
Yes |
|
|
|
PDPASA |
PDPASA_FNM |
|
|
30 minutes |
New |
Yes |
|
4.12 Participant interfaces changes
|
Package |
Data model table |
File ID |
CSV report type |
Change |
|---|---|---|---|---|
|
BILLING_CONFIG |
BILLINGCALENDAR |
BILLINGCALENDAR |
BILLING_CONFIG,BILLINGCALENDAR,3 |
Modified |
|
BILLING_RUN |
BILLINGRUNTRK |
BILLING |
BILLING,RUNTRK,6 |
Modified |
|
BILLINGRUNTRK |
BILLING_INIT |
BILLING,RUNTRK,6 |
Modified |
|
|
DISPATCH |
NEGATIVE_RESIDUE |
DISPATCH_NEGATIVE_RESIDUE |
DISPATCH,NEGATIVE_RESIDUE,2 |
Modified |
|
SYSTEM_SECURITY_MANAGEMENT |
SSM_INDICATIVE_ROLL_DUID |
SSM_FORECAST |
SSM,INDICATIVE_ROLL_DUID,1 |
New |
|
SSM_INDICATIVE_ROLL_REGION |
SSM_FORECAST |
SSM,INDICATIVE_ROLL_REGION,1 |
New |
|
|
STPASA_SOLUTION |
STPASA_FNM_CASESOLUTION |
STPASA_FNM |
STPASA,FNM_CASESOLUTION,1 |
New |
|
STPASA_FNM_CONSTRAINTSOLUTION |
STPASA_FNM |
STPASA,FNM_CONSTRAINTSOLUTION,1 |
New |
|
|
STPASA_FNM_DUIDAVAILABILITY |
STPASA_FNM_DUIDAVAILABILITY |
STPASA,FNM_DUIDAVAILABILITY,1 |
New |
|
|
STPASA_FNM_INTERCONNECTORSOLN |
STPASA_FNM |
STPASA,FNM_INTERCONNECTORSOLN,1 |
New |
|
|
STPASA_FNM_INTERZONALSOLUTION |
STPASA_FNM |
STPASA,FNM_INTERZONALSOLUTION,1 |
New |
|
|
STPASA_FNM_REGIONSOLUTION |
STPASA_FNM |
STPASA,FNM_REGIONSOLUTION,1 |
New |
|
|
STPASA_FNM_REGIONSUMMARY |
STPASA_FNM |
STPASA,FNM_REGIONSUMMARY,1 |
New |
|
|
STPASA_FNM_ZONESOLUTION |
STPASA_FNM |
STPASA,FNM_ZONESOLUTION,1 |
New |
|
|
STPASA_FNM_ZONESUMMARY |
STPASA_FNM |
STPASA,FNM_ZONESUMMARY,1 |
New |
|
|
PDPASA |
PDPASA_FNM_CASESOLUTION |
PDPASA_FNM |
PDPASA,FNM_CASESOLUTION,1 |
New |
|
PDPASA_FNM_CONSTRAINTSOLUTION |
PDPASA_FNM |
PDPASA,FNM_CONSTRAINTSOLUTION,1 |
New |
|
|
PDPASA_FNM_DUIDAVAILABILITY |
PDPASA_FNM_DUIDAVAILABILITY |
PDPASA,FNM_DUIDAVAILABILITY,1 |
New |
|
|
PDPASA_FNM_INTERCONNECTORSOLN |
PDPASA_FNM |
PDPASA,FNM_INTERCONNECTORSOLN,1 |
New |
|
|
PDPASA_FNM_INTERZONALSOLUTION |
PDPASA_FNM |
PDPASA,FNM_INTERZONALSOLUTION,1 |
New |
|
|
PDPASA_FNM_REGIONSOLUTION |
PDPASA_FNM |
PDPASA,FNM_REGIONSOLUTION,1 |
New |
|
|
PDPASA_FNM_REGIONSUMMARY |
PDPASA_FNM |
PDPASA,FNM_REGIONSUMMARY,1 |
New |
|
|
PDPASA_FNM_ZONESOLUTION |
PDPASA_FNM |
PDPASA,FNM_ZONESOLUTION,1 |
New |
|
|
PDPASA_FNM_ZONESUMMARY |
PDPASA_FNM |
PDPASA,FNM_ZONESUMMARY,1 |
New |
|
|
PARTICIPANT_REGISTRATION |
PASA_ZONE_REGION_MAPPING |
PASA_ZONE_REGION |
PARTICIPANT_REGISTRATION,PASA_INTERZONAL_MAPPING,1 |
New |
|
PASA_INTERZONAL_MAPPING |
PASA_INTERZONAL |
PARTICIPANT_REGISTRATION,PASA_ZONE_REGION_MAPPING,1 |
New |
|
|
GENERIC_CONSTRAINT |
GENCONDATA |
GENCONDATA_TRG |
GENCONDATA,7 |
Modified |
|
|
PASA_CONTINGENCY_DEFINITION |
PASA_CONTINGENCY |
GENERIC_CONSTRAINT,PASA_CONTINGENCY_DEFINITION,1 |
New |
4.13 Discontinued reports
|
Data model table |
File ID |
Delivered in file |
CSV report type |
Replaced by |
|---|---|---|---|---|
|
In alphabetical order |
|
*_FILEID_LEGACY*.CSV |
BILLING,BILLINGCPDATA,7 |
BILLING,BILLINGCPDATA,8 |