|
Name |
|
|
Comment |
Billing result table for APC compensation payments. |
|
Updated with each billing run |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
APEVENTID |
|
BILLRUNNO |
|
CLAIMID |
|
CONTRACTYEAR |
|
WEEKNO |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4) |
X |
Billing contract year |
|
WEEKNO |
NUMBER(3) |
X |
Billing week number |
|
BILLRUNNO |
NUMBER(3) |
X |
Billing run number |
|
APEVENTID |
NUMBER(6) |
X |
AP Event Id |
|
CLAIMID |
NUMBER(6) |
X |
AP Event Claim Id |
|
PARTICIPANTID |
VARCHAR2(20) |
|
Participant identifier |
|
COMPENSATION_AMOUNT |
NUMBER(18,8) |
|
Payment amount to the participant |
|
EVENT_TYPE |
VARCHAR2(20) |
|
The Administered Price Event Type. Valid values: ENERGY, FCAS, BOTH |
|
COMPENSATION_TYPE |
VARCHAR2(20) |
|
The Type of Administered Price Compensation Claim. Valid values: DIRECT_COST, OTHER_COST |
|
LASTCHANGED |
DATE |
|
The date and time of last changed record |
|
Name |
|
|
Comment |
Billing result table for recovery of APC compensation payments |
|
Updated with each billing run |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
APEVENTID |
|
BILLRUNNO |
|
CLAIMID |
|
CONTRACTYEAR |
|
PARTICIPANTID |
|
REGIONID |
|
WEEKNO |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4) |
X |
Billing contract year |
|
WEEKNO |
NUMBER(3) |
X |
Billing week number |
|
BILLRUNNO |
NUMBER(3) |
X |
Billing run number |
|
APEVENTID |
NUMBER(6) |
X |
AP Event Id |
|
CLAIMID |
NUMBER(6) |
X |
AP Event Claim Id |
|
PARTICIPANTID |
VARCHAR2(20) |
X |
Participant identifier |
|
REGIONID |
VARCHAR2(20) |
X |
Region Identifier |
|
RECOVERY_AMOUNT |
NUMBER(18,8) |
|
Recovery amount attributable to the participant in that region |
|
ELIGIBILITY_START_INTERVAL |
DATE |
|
The starting half hourly interval for the eligibility period for recovery of APC Payment |
|
ELIGIBILITY_END_INTERVAL |
DATE |
|
The ending half hourly interval for the eligibility period for recovery of APC Payment |
|
PARTICIPANT_DEMAND |
NUMBER(18,8) |
|
The participant demand in the cost recovery region |
|
REGION_DEMAND |
NUMBER(18,8) |
|
The sum of demand of all participants in the cost recovery region (Region Sum) |
|
LASTCHANGED |
DATE |
|
The date and time of last changed record |
|
PARTICIPANT_ACE_MWH |
NUMBER(18,8) |
|
The ACE MWh value of the participant from the Eligibility Interval used for the APC Recovery Calculation. If the Billing Week is prior to the IESS rule effective date, then value is Null. |
|
REGION_ACE_MWH |
NUMBER(18,8) |
|
The ACE MWh value of the Region from the Eligibility Interval used for the APC Recovery Calculation. This is the sum of the ACE MWh of all the participants in that recovery. If the Billing Week is prior to the IESS rule effective date, then value is Null. |
|
Name |
|
|
Comment |
Carbon Dioxide Intensity Index publication table |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
CONTRACTYEAR |
|
REGIONID |
|
SETTLEMENTDATE |
|
WEEKNO |
|
Name |
|
CONTRACTYEAR |
|
WEEKNO |
|
SETTLEMENTDATE |
|
REGIONID |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4) |
X |
Billing contract year |
|
WEEKNO |
NUMBER(3) |
X |
Billing week no |
|
BILLRUNNO |
NUMBER(3) |
X |
Billing run no |
|
SETTLEMENTDATE |
DATE |
X |
Settlement Date (Calendar) |
|
REGIONID |
VARCHAR(20) |
X |
Region identifier |
|
SENTOUTENERGY |
NUMBER(18,8) |
|
Total sent out energy for region (MWh) |
|
GENERATOREMISSIONS |
NUMBER(18,8) |
|
Total generator emissions for region (Co2-e) |
|
INTENSITYINDEX |
NUMBER(18,8) |
|
Carbon Dioxide Intensity index for region (CO2-e/MWh) |
|
Name |
|
|
Comment |
Carbon Dioxide Intensity Index publication tracking table |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
CONTRACTYEAR |
|
WEEKNO |
|
Name |
|
CONTRACTYEAR |
|
WEEKNO |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4) |
X |
Billing contract year |
|
WEEKNO |
NUMBER(3) |
X |
Billing week no |
|
BILLRUNNO |
NUMBER(3) |
|
Billing run no |
|
LASTCHANGED |
DATE |
|
Last changed date time |
|
Name |
|
|
Comment |
Billing result table containing daily summary data for customer and generator energy amounts |
|
BILLING_DAILY_ENERGY_SUMMARY data is confidential to the relevant participant. Source Populated by the posting of a billing run. Volume Approximately 20 records per billrunno. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
PARTICIPANTID |
|
REGIONID |
|
SETTLEMENTDATE |
|
WEEKNO |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
Billing Contract Year |
|
WEEKNO |
NUMBER(3,0) |
X |
Billing Week number |
|
BILLRUNNO |
NUMBER(3,0) |
X |
Billing Run number |
|
SETTLEMENTDATE |
DATE |
X |
settlement date |
|
PARTICIPANTID |
VARCHAR2(20) |
X |
participant identifier |
|
REGIONID |
VARCHAR2(20) |
X |
Unique Region Identifier |
|
CUSTOMER_ENERGY_PURCHASED |
NUMBER(18,8) |
|
Customer energy amount purchased on this settlement day by the participant in the region. NULL for Billing Week post the IESS rule effective date. |
|
GENERATOR_ENERGY_SOLD |
NUMBER(18,8) |
|
Generator energy amount sold on this settlement day by the participant in the region. NULL for Billing Week post the IESS rule effective date. |
|
GENERATOR_ENERGY_PURCHASED |
NUMBER(18,8) |
|
Generator energy amount purchased on this settlement day by the participant in the region. NULL for Billing Week post the IESS rule effective date. |
|
ACE_MWH |
NUMBER(18,8) |
|
The Sum of ACE MWh value for the Participant and region for the Settlement Date. NULL for Billing Week prior to the IESS rule effective date |
|
ASOE_MWH |
NUMBER(18,8) |
|
The Sum of ASOE MWh value for the Participant and region for the Settlement Date. NULL for Billing Week prior to the IESS rule effective date |
|
ACE_AMOUNT |
NUMBER(18,8) |
|
The Sum of ACE Amount for the Participant and region for the Settlement Date. NULL for Billing Week prior to the IESS rule effective date |
|
ASOE_AMOUNT |
NUMBER(18,8) |
|
The Sum of ASOE Amount for the Participant and region for the Settlement Date. NULL for Billing Week prior to the IESS rule effective date |
|
CE_MWH |
NUMBER(18,8) |
|
The Sum of CE MWh value for the Participant and region for the Settlement Date. NULL for Billing Week prior to the IESS rule effective date |
|
UFEA_MWH |
NUMBER(18,8) |
|
The Sum of UFEA MWh value for the Participant and region for the Settlement Date. NULL for Billing Week prior to the IESS rule effective date |
|
TOTAL_MWH |
NUMBER(18,8) |
|
The Sum of Total MWh value for the Participant and region for the Settlement Date. NULL for Billing Week prior to the IESS rule effective date |
|
TOTAL_AMOUNT |
NUMBER(18,8) |
|
The Sum of Total Amount for the Participant and region for the Settlement Date. NULL for Billing Week prior to the IESS rule effective date |
|
Name |
|
|
Comment |
The Billing Final Directions Payment Amount for Directed/Affected/Eligible participants |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
BILLRUNNO |
|
COMPENSATION_TYPE |
|
CONTRACTYEAR |
|
DIRECTION_ID |
|
PARTICIPANTID |
|
WEEKNO |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
The Billing Contract Year |
|
WEEKNO |
NUMBER(3,0) |
X |
The Billing WeekNo |
|
BILLRUNNO |
NUMBER(3,0) |
X |
The Billing RunNo |
|
DIRECTION_ID |
VARCHAR2(20) |
X |
The Direction Unique Identifier |
|
PARTICIPANTID |
VARCHAR2(20) |
X |
The Direction Payment Participant ID |
|
COMPENSATION_TYPE |
VARCHAR2(40) |
X |
The Direction Payment Type, Directed_Comp, Affected_Comp, Eligible_Comp. |
|
PROVISIONAL_AMOUNT |
NUMBER(18,8) |
|
The Direction Provisional Payment Amount |
|
FINAL_AMOUNT |
NUMBER(18,8) |
|
The Direction Final Payment Amount |
|
LASTCHANGED |
DATE |
|
The Last datetime record is updated |
|
Name |
|
|
Comment |
The Billing Final Directions Recovery Amount for the participants |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
DIRECTION_ID |
|
PARTICIPANTID |
|
WEEKNO |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
The Billing Contract Year |
|
WEEKNO |
NUMBER(3,0) |
X |
The Billing WeekNo |
|
BILLRUNNO |
NUMBER(3,0) |
X |
The Billing RunNo |
|
DIRECTION_ID |
VARCHAR2(20) |
X |
The Direction Unique Identifier |
|
PARTICIPANTID |
VARCHAR2(20) |
X |
The Direction Payment Participant ID |
|
CRA_AMOUNT |
NUMBER(18,8) |
|
The Direction Compensation Recovery Amount |
|
PROVISIONAL_AMOUNT |
NUMBER(18,8) |
|
The Provisional Recovery Amount |
|
FINAL_AMOUNT |
NUMBER(18,8) |
|
The Final Recovery Amount |
|
LASTCHANGED |
DATE |
|
The Last datetime record is updated |
|
Name |
|
|
Comment |
The Billing Provisional Directions Payment Amount for Directed/Affected/Eligible participants |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
BILLRUNNO |
|
COMPENSATION_TYPE |
|
CONTRACTYEAR |
|
DIRECTION_ID |
|
PARTICIPANTID |
|
WEEKNO |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
The Billing Contract Year |
|
WEEKNO |
NUMBER(3,0) |
X |
The Billing WeekNo |
|
BILLRUNNO |
NUMBER(3,0) |
X |
The Billing RunNo |
|
DIRECTION_ID |
VARCHAR2(20) |
X |
The Direction Unique Identifier |
|
PARTICIPANTID |
VARCHAR2(20) |
X |
The Direction Payment Participant ID |
|
COMPENSATION_TYPE |
VARCHAR2(40) |
X |
The Direction Payment Type, Directed_Comp, Affected_Comp, Eligible_Comp |
|
COMPENSATION_AMOUNT |
NUMBER(18,8) |
|
The Direction Payment Amount |
|
LASTCHANGED |
DATE |
|
The Last datetime record is updated |
|
Name |
|
|
Comment |
The Billing Provisional Directions Recovery Amount for the participants |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
DIRECTION_ID |
|
PARTICIPANTID |
|
WEEKNO |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
The Billing Contract Year |
|
WEEKNO |
NUMBER(3,0) |
X |
The Billing WeekNo |
|
BILLRUNNO |
NUMBER(3,0) |
X |
The Billing RunNo |
|
DIRECTION_ID |
VARCHAR2(20) |
X |
The Direction Unique Identifier |
|
PARTICIPANTID |
VARCHAR2(20) |
X |
The Direction Payment Participant ID |
|
CRA_AMOUNT |
NUMBER(18,8) |
|
The Direction Compensation Recovery Amount |
|
RECOVERY_AMOUNT |
NUMBER(18,8) |
|
The Direction Recovery Amount |
|
LASTCHANGED |
DATE |
|
The Last datetime record is updated |
|
Name |
|
|
Comment |
The Billing Directions Recovery Details for the participants |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
DIRECTION_ID |
|
PARTICIPANTCATEGORYID |
|
PARTICIPANTID |
|
REGIONID |
|
WEEKNO |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
The Billing Contract Year |
|
WEEKNO |
NUMBER(3,0) |
X |
The Billing WeekNo |
|
BILLRUNNO |
NUMBER(3,0) |
X |
The Billing RunNo |
|
DIRECTION_ID |
VARCHAR2(20) |
X |
The Direction Unique Identifier |
|
PARTICIPANTID |
VARCHAR2(20) |
X |
The Direction Payment Participant ID |
|
PARTICIPANTCATEGORYID |
VARCHAR2(20) |
X |
The Participant Category for recovery Customer/Generator /SmallGen |
|
REGIONID |
VARCHAR2(20) |
X |
The Region ID for the recovery |
|
RECOVERY_AMOUNT |
NUMBER(18,8) |
|
The Direction Recovery Amount |
|
RECOVERY_ENERGY |
NUMBER(18,8) |
|
The Energy Value used for the Recovery |
|
REGION_ENERGY |
NUMBER(18,8) |
|
The total Energy at the Region ID |
|
EXCLUDED_ENERGY |
NUMBER(18,8) |
|
The Energy Value (Scheduled Loads) that is excluded |
|
LASTCHANGED |
DATE |
|
The Last datetime record is updated |
|
Name |
|
|
Comment |
Billing reconciliation result table for both provisional and final directions |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
DIRECTION_ID |
|
REGIONID |
|
WEEKNO |
|
Name |
|
CONTRACTYEAR |
|
WEEKNO |
|
BILLRUNNO |
|
DIRECTION_ID |
|
REGIONID |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4) |
X |
Billing contract year |
|
WEEKNO |
NUMBER(3) |
X |
Billing week no |
|
BILLRUNNO |
NUMBER(3) |
X |
Billing run no |
|
DIRECTION_ID |
VARCHAR2(20) |
X |
Direction identifier |
|
REGIONID |
VARCHAR2(20) |
X |
Region Identifier |
|
DIRECTION_DESC |
VARCHAR2(200) |
|
Direction description |
|
DIRECTION_TYPE_ID |
VARCHAR2(20) |
|
The service for which the direction occurred (ENERGY, ANCILLARY, NON_ENERGY_NON_AS, etc) |
|
DIRECTION_START_DATE |
DATE |
|
Settlement day on which the direction starts |
|
DIRECTION_END_DATE |
DATE |
|
Settlement day on which the direction ends. The same value for all regions |
|
DIRECTION_START_INTERVAL |
DATE |
|
Dispatch interval in which the direction starts. The same value for all regions |
|
DIRECTION_END_INTERVAL |
DATE |
|
Dispatch interval in which the direction ends. The same value for all regions |
|
COMPENSATION_AMOUNT |
NUMBER(18,8) |
|
The final compensation amount for the direction. The same value for all regions |
|
INTEREST_AMOUNT |
NUMBER(18,8) |
|
The interest amount calculated on the final compensation amount for the direction. The same value for all regions |
|
INDEPENDENT_EXPERT_FEE |
NUMBER(18,8) |
|
The independent expert fee amount for the direction. The same value for all regions |
|
CRA |
NUMBER(18,8) |
|
The total recovery amount for the direction. The same value for all regions |
|
REGIONAL_CUSTOMER_ENERGY |
NUMBER(18,8) |
|
The total customer energy for this region, over the duration of the direction. NULL for Billing Week post the IESS rule effective date. |
|
REGIONAL_GENERATOR_ENERGY |
NUMBER(18,8) |
|
The total generator energy for this region, over the duration of the direction. NULL for Billing Week post the IESS rule effective date. |
|
REGIONAL_BENEFIT_FACTOR |
NUMBER(18,8) |
|
The regional benefit factor allocated to this region for the direction |
|
REGION_ACE_MWH |
NUMBER(18,8) |
|
The Sum of ACE MWh value for the Region over the duration of the direction. NULL for Billing Week prior to the IESS rule effective date |
|
REGION_ASOE_MWH |
NUMBER(18,8) |
|
The Sum of ASOE MWh value for the Region over the duration of the direction. NULL for Billing Week prior to the IESS rule effective date |
|
DIRECTION_SERVICE_ID |
VARCHAR2(20) |
|
The Direction Service ID associated with the Direction Type ID. Eg For FCAS Direction Type, Direction Service could be any contingency service. |
|
Name |
|
|
Comment |
Billing reconciliation result table for both provisional and final directions using the FPP methodology (prior to 1st July 2011) |
|
Source BILLING_DIRECTION_RECONCILIATN is populated by the posting of a billing run. Volume One record inserted per direction per billing run, or 11 records inserted per week. Presently |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
DIRECTION_ID |
|
WEEKNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4) |
X |
Billing contract year |
|
WEEKNO |
NUMBER(3) |
X |
Billing week no |
|
BILLRUNNO |
NUMBER(3) |
X |
Billing run no |
|
DIRECTION_ID |
VARCHAR2(20) |
X |
Direction identifier |
|
DIRECTION_DESC |
VARCHAR2(200) |
|
Direction description |
|
DIRECTION_START_DATE |
DATE |
|
Direction start date time |
|
DIRECTION_END_DATE |
DATE |
|
Direction end date time |
|
COMPENSATION_AMOUNT |
NUMBER(16,6) |
|
Direction compensation amount |
|
INDEPENDENT_EXPERT_FEE |
NUMBER(16,6) |
|
Independent expert fee charged on calculating direction compensation amount |
|
INTEREST_AMOUNT |
NUMBER(16,6) |
|
Interest occurred on direction compensation amount |
|
CRA |
NUMBER(16,6) |
|
Direction compensation recovery amount |
|
NEM_FEE_ID |
VARCHAR2(20) |
|
Fixed settlement fee identifier for direction purpose |
|
NEM_FIXED_FEE_AMOUNT |
NUMBER(16,6) |
|
Fixed settlement fee for participants between direction start and end date |
|
MKT_CUSTOMER_PERC |
NUMBER(16,6) |
|
Direction compensation recovery amount percentage breakdown among customers |
|
GENERATOR_PERC |
NUMBER(16,6) |
|
Direction compensation recovery amount percentage breakdown among generators |
|
LASTCHANGED |
DATE |
|
Last changed date time |
|
Name |
|
|
Comment |
The billing shortfall run amounts |
|
BILLING_EFTSHORTFALL_AMOUNT data is confidential, and is available only to the relevant participant. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
PARTICIPANTID |
|
WEEKNO |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
The shortfall affected billing contract year |
|
WEEKNO |
NUMBER(3,0) |
X |
The shortfall affected billing week no |
|
BILLRUNNO |
NUMBER(3,0) |
X |
The shortfall affected billing week run no |
|
PARTICIPANTID |
VARCHAR2(20) |
X |
The participant affected by the shortfall calculation |
|
SHORTFALL_AMOUNT |
NUMBER(18,8) |
|
The Participant shortfall amount |
|
SHORTFALL |
NUMBER(18,8) |
|
The market shortfall amount |
|
SHORTFALL_COMPANY_ID |
VARCHAR2(20) |
|
The Company ID associated with the Participant ID used in the shortfall calculation |
|
COMPANY_SHORTFALL_AMOUNT |
NUMBER(18,8) |
|
The shortfall amount for the Company ID associated with the Participant ID used in the shortfall calculation |
|
PARTICIPANT_NET_ENERGY |
NUMBER(18,8) |
|
The participant NET energy used in shortfall calculation |
|
COMPANY_NET_ENERGY |
NUMBER(18,8) |
|
The NET energy for the Company ID associated with the Participant ID used in the shortfall calculation |
|
Name |
|
|
Comment |
The Billing Shortfall Run Amount details |
|
BILLING_EFTSHORTFALL_DETAIL data is confidential, and is available only to the relevant participant. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
PARTICIPANTID |
|
TRANSACTION_TYPE |
|
WEEKNO |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
The shortfall affected billing contract year |
|
WEEKNO |
NUMBER(3,0) |
X |
The shortfall affected billing week no |
|
BILLRUNNO |
NUMBER(3,0) |
X |
The shortfall affected billing week run no |
|
PARTICIPANTID |
VARCHAR2(20) |
X |
The participant affected by the shortfall calculation |
|
TRANSACTION_TYPE |
VARCHAR2(40) |
X |
The transaction type details associated with the shortfall calculation |
|
AMOUNT |
NUMBER(18,8) |
|
The amount for each transaction type |
|
Name |
|
|
Comment |
The Billing Energy Genset report contains the Genset Energy detail summary for the Billing Week data |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
BILLRUNNO |
|
CONNECTIONPOINTID |
|
CONTRACTYEAR |
|
DUID |
|
GENSETID |
|
METERID |
|
PARTICIPANTID |
|
REGIONID |
|
STATIONID |
|
WEEKNO |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
The Billing Contract Year |
|
WEEKNO |
NUMBER(3,0) |
X |
The Billing Week No |
|
BILLRUNNO |
NUMBER(4,0) |
X |
The Billing Run No |
|
PARTICIPANTID |
VARCHAR2(20) |
X |
The Participant Id Identifier |
|
STATIONID |
VARCHAR2(20) |
X |
The StationId identifier associated with the GensetId |
|
DUID |
VARCHAR2(20) |
X |
The DUID for the meter associated with the GensetId |
|
GENSETID |
VARCHAR2(20) |
X |
The GensetId for the Meter Id received |
|
REGIONID |
VARCHAR2(20) |
X |
The Region Id for the Connection Point associated with the DUID |
|
CONNECTIONPOINTID |
VARCHAR2(20) |
X |
The Connection Point associated with the DUID |
|
METERID |
VARCHAR2(20) |
X |
The Meter ID Identifier (NMI) |
|
CE_MWH |
NUMBER(18,8) |
|
The Consumed Energy for the Meter Id . Energy received in the meter reads (DLF Adjusted) in that Billing Week |
|
UFEA_MWH |
NUMBER(18,8) |
|
The UFEA Energy MWh Consumed for that Connection Point for the Participant Id in that Billing Week |
|
ACE_MWH |
NUMBER(18,8) |
|
The Adjusted Consumed Energy MWh Consumed for that Connection Point for the Participant Id in that Billing Week |
|
ASOE_MWH |
NUMBER(18,8) |
|
The Adjusted Sent Out Energy MWh Consumed for that Connection Point for the Participant Id in that Billing Week |
|
TOTAL_MWH |
NUMBER(18,8) |
|
The Total MWh(ACE_MWh + ASOE_MWh) for that Connection Point for the Participant Id in that Billing Week |
|
DME_MWH |
NUMBER(18,8) |
|
The DME MWh for that Connection Point for the Participant Id in that Billing Week. This is the MWh value that is used for the UFEA Allocation |
|
ACE_AMOUNT |
NUMBER(18,8) |
|
The Adjusted Consumed Energy Dollar Amount for that Connection Point for the Participant Id in that Billing Week |
|
ASOE_AMOUNT |
NUMBER(18,8) |
|
The Adjusted Sent Out Energy Dollar Amount for that Connection Point for the Participant Id in that Billing Week |
|
TOTAL_AMOUNT |
NUMBER(18,8) |
|
The Total Amount(ACE_Amount + ASOE_Amount) for that Connection Point for the Participant Id in that Billing Week |
|
LASTCHANGED |
DATE |
|
The Last changed date time for the record |
|
Name |
|
|
Comment |
The SAP Billing Transaction Details for the Participants |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
PARTICIPANTID |
|
TNI |
|
WEEKNO |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
The Billing Contract Year |
|
WEEKNO |
NUMBER(3,0) |
X |
The Billing WeekNo |
|
BILLRUNNO |
NUMBER(3,0) |
X |
The Billing RunNo |
|
PARTICIPANTID |
VARCHAR2(20) |
X |
The SAP Participant ID |
|
TNI |
VARCHAR2(20) |
X |
The SAPS Connection Point ID |
|
REGIONID |
VARCHAR2(20) |
|
The Region ID associated with the TNI |
|
CONSUMED_ENERGY_MWH |
NUMBER(18,8) |
|
The Energy MWh Consumed for that TNI for the Participant Id in that Billing Week |
|
SENTOUT_ENERGY_MWH |
NUMBER(18,8) |
|
The Energy MWh Sent Out for the TNI for the Participant Id in that Billing Week |
|
CONSUMED_ENERGY_COST |
NUMBER(18,8) |
|
The Cost of the Consumed Energy |
|
SENTOUT_ENERGY_COST |
NUMBER(18,8) |
|
The Cost of the Sent Out Energy |
|
LASTCHANGED |
DATE |
|
The Last datetime record is updated |
|
Name |
|
|
Comment |
The Billing Energy Transactions is the summary of the Settlement Energy Transactions that has the ACE and ASOE MWh and Dollar values that is used for the Statement |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
BILLRUNNO |
|
CONNECTIONPOINTID |
|
CONTRACTYEAR |
|
PARTICIPANTID |
|
REGIONID |
|
WEEKNO |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
The Billing Contract Year |
|
WEEKNO |
NUMBER(3,0) |
X |
The Billing WeekNo |
|
BILLRUNNO |
NUMBER(4,0) |
X |
The Billing RunNo |
|
PARTICIPANTID |
VARCHAR2(20) |
X |
The Participant Id Identifier |
|
CONNECTIONPOINTID |
VARCHAR2(20) |
X |
The ConnectionPoint Id for the Billing Aggregation for the Participant Id. |
|
REGIONID |
VARCHAR2(20) |
X |
The Region Id Identifier |
|
CE_MWH |
NUMBER(18,8) |
|
The Consumed Energy MWh Consumed for that Connection Point for the Participant Id in that Billing Week |
|
UFEA_MWH |
NUMBER(18,8) |
|
The UFEA Energy MWh Consumed for that Connection Point for the Participant Id in that Billing Week |
|
ACE_MWH |
NUMBER(18,8) |
|
The Adjusted Consumed Energy MWh Consumed for that Connection Point for the Participant Id in that Billing Week |
|
ASOE_MWH |
NUMBER(18,8) |
|
The Adjusted Sent Out Energy MWh Consumed for that Connection Point for the Participant Id in that Billing Week |
|
ACE_AMOUNT |
NUMBER(18,8) |
|
The Adjusted Consumed Energy Dollar Amount for that Connection Point for the Participant Id in that Billing Week |
|
ASOE_AMOUNT |
NUMBER(18,8) |
|
The Adjusted Sent Out Energy Dollar Amount for that Connection Point for the Participant Id in that Billing Week |
|
TOTAL_MWH |
NUMBER(18,8) |
|
The Total MWh(ACE_MWh + ASOE_MWh) for that Connection Point for the Participant Id in that Billing Week |
|
TOTAL_AMOUNT |
NUMBER(18,8) |
|
The Total Amount(ACE_Amount + ASOE_Amount) for that Connection Point for the Participant Id in that Billing Week |
|
DME_MWH |
NUMBER(18,8) |
|
The DME MWh for that Connection Point for the Participant Id in that Billing Week. This is the MWh value that is used for the UFEA Allocation. |
|
LASTCHANGED |
DATE |
|
The Last Changed date time for the record |
|
Name |
|
|
Comment |
BILLING_GST_DETAIL shows the BAS class, GST_Exclusive and GST amount (if any) attributable to a participant for each transaction type. |
|
BILLING_GST_DETAIL data is confidential to NSP participants. Source Populated by the posting of a billing run. Volume Approximately 20 records are inserted per billrunno, or about 220 records inserted per week. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
BAS_CLASS |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
PARTICIPANTID |
|
TRANSACTION_TYPE |
|
WEEKNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
AEMO Contract Year number starting in week containing 1st January |
|
WEEKNO |
NUMBER(3,0) |
X |
Week no within the contract year. Week no 1 is the week containing 1st January |
|
BILLRUNNO |
NUMBER(3,0) |
X |
Unique run no within a given contract year and week no |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Unique participant identifier |
|
BAS_CLASS |
VARCHAR2(30) |
X |
The BAS classification that the transaction type belongs to. |
|
TRANSACTION_TYPE |
VARCHAR2(30) |
X |
The transaction type (e.g. CUSTOMER_ENERGY_PURCHASES) |
|
GST_EXCLUSIVE_AMOUNT |
NUMBER(15,5) |
|
The GST exclusive amount paid by/to the participant to/by AEMO for this transaction type. |
|
GST_AMOUNT |
NUMBER(15,5) |
|
The GST amount for this transaction type. |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
BILLING_GST_SUMMARY shows the GST_Exclusive and GST amount (if any) attributable to a participant for each BAS class. |
|
BILLING_GST_SUMMARY data is confidential to NSP participants. Source Populated by the posting of a billing run. Volume Approximately 5 records are inserted per billrunno, or about 55 records inserted per week. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
BAS_CLASS |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
PARTICIPANTID |
|
WEEKNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
AEMO Contract Year number starting in week containing 1st January |
|
WEEKNO |
NUMBER(3,0) |
X |
Week no within the contract year. Week no 1 is the week containing 1st January |
|
BILLRUNNO |
NUMBER(3,0) |
X |
Unique run no within a given contract year and week no |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Unique participant identifier |
|
BAS_CLASS |
VARCHAR2(30) |
X |
The BAS classification |
|
GST_EXCLUSIVE_AMOUNT |
NUMBER(15,5) |
|
The GST exclusive amount paid by/to the participant to/by AEMO for this BAS classification. |
|
GST_AMOUNT |
NUMBER(15,5) |
|
The GST amount for this BAS classification. |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
BILLING_NMAS_TEST_PAYMENTS publish the NSCAS/SRAS Testing Payments data for a posted billing week. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
BILLRUNNO |
|
CONTRACTID |
|
CONTRACTYEAR |
|
PARTICIPANTID |
|
SERVICE |
|
WEEKNO |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
AEMO Contract Year number starting in week containing 1 January |
|
WEEKNO |
NUMBER(3,0) |
X |
Week no within the contract year. Week no 1 is the week containing 1 January |
|
BILLRUNNO |
NUMBER(3,0) |
X |
The current Billing RunNo for the week |
|
PARTICIPANTID |
VARCHAR(20) |
X |
The Participant from whom the amount is recovered |
|
SERVICE |
VARCHAR(10) |
X |
The type of NSCAS service. Current value values are: |
|
CONTRACTID |
VARCHAR(10) |
X |
The NMAS Contract Id |
|
PAYMENT_AMOUNT |
NUMBER(18,8) |
|
The Testing Payment Amount to recover |
|
Name |
|
|
Comment |
BILLING_NMAS_TEST_RECOVERY sets out the recovery of NMAS testing payments |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
BILLRUNNO |
|
CONTRACTID |
|
CONTRACTYEAR |
|
PARTICIPANTID |
|
REGIONID |
|
SERVICE |
|
WEEKNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
AEMO Contract Year number starting in week containing 1 January |
|
WEEKNO |
NUMBER(3,0) |
X |
Week no within the contract year. Week no 1 is the week containing 1 January |
|
BILLRUNNO |
NUMBER(3,0) |
X |
The current Billing RunNo for the week |
|
PARTICIPANTID |
VARCHAR(20) |
X |
The Participant from whom the amount is recovered |
|
SERVICE |
VARCHAR(10) |
X |
The type of NSCAS service. Current value values are: |
|
CONTRACTID |
VARCHAR(10) |
X |
The NMAS Contract Id |
|
REGIONID |
VARCHAR(10) |
X |
The region from where the amount is recovered |
|
RBF |
NUMBER(18,8) |
|
The Benefitting Factor for the RegionId |
|
TEST_PAYMENT |
NUMBER(18,8) |
|
The total Testing Payment Amount to recover from all benefitting regions |
|
RECOVERY_START_DATE |
DATE |
|
The Recovery Start Date for the Testing Payment Calculation |
|
RECOVERY_END_DATE |
DATE |
|
The Recovery End Date for the Testing Payment Calculation |
|
PARTICIPANT_ENERGY |
NUMBER(18,8) |
|
The Participant energy in MWh for the recovery period |
|
REGION_ENERGY |
NUMBER(18,8) |
|
The RegionId energy in MWh for the recovery period |
|
NEM_ENERGY |
NUMBER(18,8) |
|
The NEM energy in MWh for the recovery period |
|
CUSTOMER_PROPORTION |
NUMBER(18,8) |
|
The Customer Proportion for recovery amount in Percent |
|
GENERATOR_PROPORTION |
NUMBER(18,8) |
|
The Generator Proportion for recovery amount in Percent (100-Customer Portion) |
|
PARTICIPANT_GENERATION |
NUMBER(18,8) |
|
The Participant Generation for the recovery period |
|
NEM_GENERATION |
NUMBER(18,8) |
|
The NEM Generation for the recovery period |
|
RECOVERY_AMOUNT |
NUMBER(18,8) |
|
The Total recovery amount for the billing week, being the sum of the customer and generator proportions for the PARTICIPANTID in REGIONID and sum of RecoveryAmount_ACE and RecoveryAmount_ASOE. |
|
LASTCHANGED |
DATE |
|
The Last Updated date and time |
|
PARTICIPANT_ACE_MWH |
NUMBER(18,8) |
|
The Participant ACE MWh Value used in the Recovery of the Testing Payment Amount if the service is recovered from ACE. NULL for Billing Week prior to the IESS rule effective date |
|
REGION_ACE_MWH |
NUMBER(18,8) |
|
The Region ACE MWh Value used in the Recovery of the Testing Payment Amount if the service is recovered from ACE. NULL for Billing Week prior to the IESS rule effective date |
|
ACE_PORTION |
NUMBER(18,8) |
|
The Portion of ACE MWh Value used in the Recovery Calculation. . NULL for Billing Week prior to the IESS rule effective date |
|
ASOE_PORTION |
NUMBER(18,8) |
|
The Portion of ASOE MWh Value used in the Recovery Calculation (100 - ACE_Portion). . NULL for Billing Week prior to the IESS rule effective date |
|
PARTICIPANT_ASOE_MWH |
NUMBER(18,8) |
|
The Participant ASOE MWh Value used in the Recovery of the Testing Payment Amount if the service is recovered from ASOE. NULL for Billing Week prior to the IESS rule effective date |
|
REGION_ASOE_MWH |
NUMBER(18,8) |
|
The Region ASOE MWh Value used in the Recovery of the Testing Payment Amount if the service is recovered from ASOE. NULL for Billing Week prior to the IESS rule effective date |
|
RECOVERYAMOUNT_ACE |
NUMBER(18,8) |
|
The Participant Recovery Amount based on ACE MWh Value if the service is recovered from ACE . NULL for Billing Week prior to the IESS rule effective date |
|
RECOVERYAMOUNT_ASOE |
NUMBER(18,8) |
|
The Participant Recovery Amount based on ASOE MWh Value if the service is recovered from ASOE . NULL for Billing Week prior to the IESS rule effective date |
|
Name |
|
|
Comment |
BILLING_NMAS_TEST_RECVRY_RBF sets out the NSCAS/SRAS Testing Payment recovery data for the posted billing week. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
BILLRUNNO |
|
CONTRACTID |
|
CONTRACTYEAR |
|
REGIONID |
|
SERVICE |
|
WEEKNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
AEMO Contract Year number starting in week containing 1 January |
|
WEEKNO |
NUMBER(3,0) |
X |
Week no within the contract year. Week no 1 is the week containing 1 January |
|
BILLRUNNO |
NUMBER(3,0) |
X |
The current Billing RunNo for the week |
|
SERVICE |
VARCHAR(10) |
X |
The type of NSCAS service. Current value values are: |
|
CONTRACTID |
VARCHAR(10) |
X |
The NMAS Contract Id |
|
REGIONID |
VARCHAR(10) |
X |
The region from where the amount is recovered |
|
RBF |
NUMBER(18,8) |
|
The Benefitting Factor for the RegionId |
|
PAYMENT_AMOUNT |
NUMBER(18,8) |
|
The total Testing Payment Amount to recover from all benefitting regions |
|
RECOVERY_AMOUNT |
NUMBER(18,8) |
|
The Testing Payment amount to recover from RegionId |
|
LASTCHANGED |
DATE |
|
The Last Updated date and time |
|
Name |
|
|
Comment |
BILLING_NMAS_TEST_RECVRY_TRK tracks the energy data used to allocate the test payment recovery over the recovery period. |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
RECOVERY_BILLRUNNO |
|
RECOVERY_CONTRACTYEAR |
|
RECOVERY_WEEKNO |
|
WEEKNO |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
AEMO Contract Year number starting in week containing 1 January |
|
WEEKNO |
NUMBER(3,0) |
X |
Week no within the contract year. Week no 1 is the week containing 1 January |
|
BILLRUNNO |
NUMBER(3,0) |
X |
The current Billing RunNo for the week |
|
RECOVERY_CONTRACTYEAR |
NUMBER(4,0) |
X |
AEMO Contract Year for energy data used in recovery calculation |
|
RECOVERY_WEEKNO |
NUMBER(3,0) |
X |
Week no for energy data used in recovery calculation |
|
RECOVERY_BILLRUNNO |
NUMBER(3,0) |
X |
Billing RunNo for energy data used in recovery calculation |
|
Name |
|
|
Comment |
The interest amount for security deposit calculated by billing, based on whether it is a fixed/floating rate |
|
BILLING_SECDEP_INTEREST_PAY data is confidential, and is available only to the relevant participant. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
PARTICIPANTID |
|
SECURITY_DEPOSIT_ID |
|
WEEKNO |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
The billing contract year the SDA application is processed and interest calculated |
|
WEEKNO |
NUMBER(3,0) |
X |
The billing week no. the SDA application is processed and interest calculated |
|
BILLRUNNO |
NUMBER(3,0) |
X |
The billing run no. the SDA application is processed and interest calculated |
|
SECURITY_DEPOSIT_ID |
VARCHAR2(20) |
X |
The security deposit ID for which billing has calculated the Interest amount |
|
PARTICIPANTID |
VARCHAR2(20) |
X |
The participant ID of the security deposit for whom the interest is paid |
|
INTEREST_AMOUNT |
NUMBER(18,8) |
|
The security deposit interest amount calculated by billing |
|
INTEREST_CALC_TYPE |
VARCHAR2(20) |
|
FIXED or DAILY |
|
INTEREST_ACCT_ID |
VARCHAR2(20) |
|
The interest account ID used by billing for calculating the interest. |
|
INTEREST_RATE |
NUMBER(18,8) |
|
The STATIC Interest Rate used by Billing for calculating the interest. This is NULL if INTEREST_CALC_TYPE <> FIXED |
|
Name |
|
|
Comment |
The DAILY interest rates used by billing when calculating the interest amount |
|
Name |
Comment |
Value |
|
Visibility |
|
Public |
|
Name |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
EFFECTIVEDATE |
|
INTEREST_ACCT_ID |
|
WEEKNO |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
The billing contract year the SDA application is processed and interest calculated |
|
WEEKNO |
NUMBER(3,0) |
X |
The billing week no. the SDA application is processed and interest calculated |
|
BILLRUNNO |
NUMBER(3,0) |
X |
The billing run no. the SDA application is processed and interest calculated |
|
INTEREST_ACCT_ID |
VARCHAR2(20) |
X |
The interest account ID used by security deposit interest calculation |
|
EFFECTIVEDATE |
DATE |
X |
The effective date of the new interest change |
|
INTEREST_RATE |
NUMBER(18,8) |
|
The interest rate to apply from the effective date |
|
Name |
|
|
Comment |
The security deposit application details |
|
BILLING_SECDEPOSIT_APPLICATION data is confidential, and is available only to the relevant participant. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
PARTICIPANTID |
|
WEEKNO |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
The billing contract year where (security deposit application) SDA is applied |
|
WEEKNO |
NUMBER(3,0) |
X |
The billing week no. where the SDA is applied |
|
BILLRUNNO |
NUMBER(3,0) |
X |
The billing run no. where the SDA is applied |
|
PARTICIPANTID |
VARCHAR2(20) |
X |
The Participant ID lodging the SDA |
|
APPLICATION_AMOUNT |
NUMBER(18,8) |
|
The SDA application amount |
|
Name |
|
|
Comment |
Demand Values Substituted in Billing Calculation |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
PARTICIPANTID |
|
SETTLEMENTDATE |
|
TNI |
|
WEEKNO |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
Billing contract year |
|
WEEKNO |
NUMBER(3,0) |
X |
Billing week number |
|
BILLRUNNO |
NUMBER(3,0) |
X |
Billing run number |
|
SETTLEMENTDATE |
DATE |
X |
Settlement Date |
|
TNI |
VARCHAR2(20) |
X |
Unique identifier for the connection point |
|
PARTICIPANTID |
VARCHAR2(20) |
X |
Unique identifier for the participant |
|
REGIONID |
VARCHAR2(20) |
|
Unique identifier for the region to which the TNI belongs to on this settlement date |
|
SUBSTITUTEDEMAND |
NUMBER(18,8) |
|
Substitute metered quantity for non-energy recovery in MWh for the TNI and participant in the trading interval. A negative value indicates net consumption and a positive value indicates net generation |
|
Name |
|
|
Comment |
Details of settlement runs used as input in the substitute demand calculation |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
REFERENCESETTLEMENTDATE |
|
REFERENCESETTLEMENTRUNNO |
|
WEEKNO |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
Billing contract year |
|
WEEKNO |
NUMBER(3,0) |
X |
Billing week number |
|
BILLRUNNO |
NUMBER(3,0) |
X |
Billing run number |
|
REFERENCESETTLEMENTDATE |
DATE |
X |
Settlement Date |
|
REFERENCESETTLEMENTRUNNO |
NUMBER(3,0) |
X |
The settlement run number matching the settlement date for a settlement run included in the reference period |
|
Name |
|
|
Comment |
Billing WDR Transaction Weekly Summary |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
PARTICIPANTID |
|
WEEKNO |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
Contract year of the Billing run |
|
WEEKNO |
NUMBER(3,0) |
X |
Week number of the Billing run |
|
BILLRUNNO |
NUMBER(3,0) |
X |
Billing run number identifier |
|
PARTICIPANTID |
VARCHAR2(20) |
X |
DRSP or FRMP Participant Identifier |
|
WDR_CREDIT_AMOUNT |
NUMBER(18,8) |
|
WDR credit transaction amount |
|
WDR_DEBIT_AMOUNT |
NUMBER(18,8) |
|
WDR debit transaction amount |
|
Name |
|
|
Comment |
Billing WDR transaction detail summary |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
DRSP |
|
FRMP |
|
REGIONID |
|
WDRRRPERIOD |
|
WEEKNO |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
Contract year of the Billing run |
|
WEEKNO |
NUMBER(3,0) |
X |
Week number of the Billing run |
|
BILLRUNNO |
NUMBER(3,0) |
X |
Billing run number identifier |
|
WDRRRPERIOD |
VARCHAR2(20) |
X |
Unique identifier for the period to which the WDRRR applies. For quarter-based periods, this will be equal to YYYY[Q]NN, for example, 2020Q3 for 2020 Quarter 3. |
|
REGIONID |
VARCHAR2(20) |
X |
Region identifier |
|
FRMP |
VARCHAR2(20) |
X |
Financial Responsible Market Participant Identifier |
|
DRSP |
VARCHAR2(20) |
X |
Demand Response Service Provider Identifier |
|
WDRSQ |
NUMBER(18,8) |
|
WDR Settlement Quantity capped in MWh |
|
WDRRR |
NUMBER(18,8) |
|
WDR reimbursement rate in $/MWh |
|
WDRTA |
NUMBER(18,8) |
|
WDR transaction amount in $ for demand response |
|
Name |
|
|
Comment |
BILLINGAPCCOMPENSATION shows Administered Price Cap (APC) compensation amounts for the billing period. Data is for each participant by region. |
|
Updated with each billing run |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
PARTICIPANTID |
|
REGIONID |
|
WEEKNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
AEMO Contract Year number starting in week containing 1st January |
|
WEEKNO |
NUMBER(3,0) |
X |
Week no within the contract year. Week no 1 is the week containing 1st January |
|
BILLRUNNO |
NUMBER(3,0) |
X |
Unique run no within a given contract year and week no |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Unique participant identifier |
|
REGIONID |
VARCHAR2(10) |
X |
Region Identifier |
|
APCCOMPENSATION |
NUMBER(15,5) |
|
APC Compensation |
|
LASTCHANGED |
DATE |
|
Last changed date and time |
|
Name |
|
|
Comment |
BILLINGAPCRECOVERY shows the Administered Price Cap (APC) Recovery for the billing period. Data is for each participant by region. |
|
Source Obsolete; was updated weekly with each billing run. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
PARTICIPANTID |
|
REGIONID |
|
WEEKNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
Contract year |
|
WEEKNO |
NUMBER(3,0) |
X |
Billing week |
|
BILLRUNNO |
NUMBER(3,0) |
X |
Billing run number |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Participant identifier |
|
REGIONID |
VARCHAR2(10) |
X |
Region Identifier |
|
APCRECOVERY |
NUMBER(15,0) |
|
APC Recovery amount for week |
|
LASTCHANGED |
DATE |
|
Last date and time record changed |
|
Name |
|
|
Comment |
BILLINGASPAYMENTS shows Ancillary Service payments for each billing period by each of the Ancillary Service types for each participant’s connection points. |
|
BILLINGASPAYMENTS data is confidential to relevant participant. Source Updated with each billing run. Volume The volume is according to the number of Transmission ConnectionPointIDs a Participant may have subject to ancillary payment per billrunno. An indicative maximum is approximately 20 records are inserted per billrunno, or about 220 records inserted per week. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
BILLRUNNO |
|
CONNECTIONPOINTID |
|
CONTRACTYEAR |
|
PARTICIPANTID |
|
WEEKNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
REGIONID |
VARCHAR2(10) |
|
Region Identifier |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
Contract Year |
|
WEEKNO |
NUMBER(3,0) |
X |
Week No |
|
BILLRUNNO |
NUMBER(3,0) |
X |
Billing Run No. |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Participant Identifier |
|
CONNECTIONPOINTID |
VARCHAR2(10) |
X |
Connection point identifier |
|
RAISE6SEC |
NUMBER(15,5) |
|
Raise 6 Sec Payments |
|
LOWER6SEC |
NUMBER(15,5) |
|
Lower 6 Sec Payments |
|
RAISE60SEC |
NUMBER(15,5) |
|
Raise 60 Sec Payments |
|
LOWER60SEC |
NUMBER(15,5) |
|
Lower 60 Sec Payments |
|
AGC |
NUMBER(15,5) |
|
AGC Payments |
|
FCASCOMP |
NUMBER(15,5) |
|
Frequency Control Compensation Payments |
|
LOADSHED |
NUMBER(15,5) |
|
Load Shed Payments |
|
RGUL |
NUMBER(15,5) |
|
Rapid Generator unit Loading Payments |
|
RGUU |
NUMBER(15,5) |
|
Rapid Generator Unit Unloading Payments |
|
REACTIVEPOWER |
NUMBER(15,5) |
|
Reactive Power Payments |
|
SYSTEMRESTART |
NUMBER(15,5) |
|
System Restart Payments |
|
LASTCHANGED |
DATE |
|
The latest date and time that a file was updated or inserted |
|
LOWER5MIN |
NUMBER(15,5) |
|
Lower 5 Minute Payment |
|
RAISE5MIN |
NUMBER(15,5) |
|
Raise 5 Minute Payment |
|
LOWERREG |
NUMBER(15,5) |
|
Lower 5 Minute Regulation Payment |
|
RAISEREG |
NUMBER(15,5) |
|
Raise 5 Minute Regulation Payment |
|
AVAILABILITY_REACTIVE |
NUMBER(18,8) |
|
The total availability payment |
|
AVAILABILITY_REACTIVE_RBT |
NUMBER(18,8) |
|
The total availability payment rebate |
|
RAISE1SEC |
NUMBER(18,8) |
|
Payment amount for the very fast raise service |
|
LOWER1SEC |
NUMBER(18,8) |
|
Payment amount for the very fast lower service |
|
Name |
|
|
Comment |
BILLINGASRECOVERY shows participant charges for Ancillary Services for the billing period. This view shows the billing amounts for Ancillary Service Recovery. |
|
BILLINGASRECOVERY data is confidential to relevant participant. Source Updated with each billing run. Volume Approximately 5 records are inserted per billrunno, or about 55 records inserted per week. |
|
Name |
Comment |
Value |
|
Visibility |
|
Private |
|
Name |
|
BILLRUNNO |
|
CONTRACTYEAR |
|
PARTICIPANTID |
|
REGIONID |
|
WEEKNO |
|
Name |
|
LASTCHANGED |
|
Name |
Data Type |
Mandatory |
Comment |
|
REGIONID |
VARCHAR2(10) |
X |
Region Identifier |
|
CONTRACTYEAR |
NUMBER(4,0) |
X |
Contract Year |
|
WEEKNO |
NUMBER(3,0) |
X |
Week No |
|
BILLRUNNO |
NUMBER(3,0) |
X |
Billing Run No. |
|
PARTICIPANTID |
VARCHAR2(10) |
X |
Participant Identifier |
|
RAISE6SEC |
NUMBER(15,5) |
|
Raise 6 Sec Recovery. NULL for Billing Week post the IESS rule effective date |
|
LOWER6SEC |
NUMBER(15,5) |
|
Lower 6 Sec Recovery. NULL for Billing Week post the IESS rule effective date |
|
RAISE60SEC |
NUMBER(15,5) |
|
Raise 60 Sec Recovery. NULL for Billing Week post the IESS rule effective date |
|
LOWER60SEC |
NUMBER(15,5) |
|
Lower 60 Sec Recovery. NULL for Billing Week post the IESS rule effective date |
|
AGC |
NUMBER(15,5) |
|
AGC Recovery - Not used since circa 2000 |
|
FCASCOMP |
NUMBER(15,5) |
|
Frequency Control Compensation Recovery - Not used since circa 2000 |
|
LOADSHED |
NUMBER(15,5) |
|
Load Shed Recovery. Post-IESS the value in this column only represent the Testing Payment Recovery from Customers. 0 if no testing payment exists. |
|
RGUL |
NUMBER(15,5) |
|
Rapid Generator Unit Loading Recovery - Not used since December 2001 |
|
RGUU |
NUMBER(15,5) |
|
Rapid Generator Unit Unloading Recovery - Not used since December 2001 |
|
REACTIVEPOWER |
NUMBER(15,5) |
|
Reactive Power Recovery. Post-IESS the value in this column only represent the Testing Payment Recovery from Customers. 0 if no testing payment exists. |
|
SYSTEMRESTART |
NUMBER(15,5) |
|
System Restart Recovery. Post-IESS the value in this column only represent the Testing Payment Recovery from Customers. 0 if no testing payment exists |
|
LASTCHANGED |
DATE |
|
The latest date and time a file was updated/inserted |
|
RAISE6SEC_GEN |
NUMBER(15,5) |
|
Raise 6 Sec Recovery for Generator. NULL for Billing Week post the IESS rule effective date |
|
LOWER6SEC_GEN |
NUMBER(15,5) |
|
Lower 6 Sec Recovery for Generator. NULL for Billing Week post the IESS rule effective date |
|
RAISE60SEC_GEN |
NUMBER(15,5) |
|
Raise 60 Sec Recovery for Generator. NULL for Billing Week post the IESS rule effective date |
|
LOWER60SEC_GEN |
NUMBER(15,5) |
|
Lower 60 Sec Recovery for Generator. NULL for Billing Week post the IESS rule effective date |
|
AGC_GEN |
NUMBER(15,5) |
|
AGC Recovery for Generator |
|
FCASCOMP_GEN |
NUMBER(15,5) |
|
Frequency Control Compensation Recovery for Generator |
|
LOADSHED_GEN |
NUMBER(15,5) |
|
Load Shed Recovery for Generator. Post-IESS the value in this column only represent the Testing Payment Recovery from Generators. 0 if no testing payment exists. |
|
RGUL_GEN |
NUMBER(15,5) |
|
Rapid Generator unit Loading Recovery for. Generator - Not used since December 2001 |
|
RGUU_GEN |
NUMBER(15,5) |
|
Rapid Generator Unit Unloading Recovery for Generator - Not used since December 2001 |
|
REACTIVEPOWER_GEN |
NUMBER(15,5) |
|
Reactive Power Recovery for Generator. Post-IESS the value in this column only represent the Testing Payment Recovery from Generators. 0 if no testing payment exists. |
|
SYSTEMRESTART_GEN |
NUMBER(15,5) |
|
System Restart Recovery for Generator. Post-IESS the value in this column only represent the Testing Payment Recovery from Generators. 0 if no testing payment exists. |
|
LOWER5MIN |
NUMBER(15,5) |
|
Recovery amount for the Lower 5 Minute service attributable to customer connection points. NULL for Billing Week post the IESS rule effective date |
|
RAISE5MIN |
NUMBER(15,5) |
|
Recovery amount for the Raise 5 Minute service attributable to customer connection points. NULL for Billing Week post the IESS rule effective date |
|
LOWERREG |
NUMBER(18,8) |
|
Pre-IESS - Recovery amount for the Lower Regulation service attributable to customer connection points(MPF + Residue). Post-IESS the amount in this column represent only the Lower Regulation FCAS MPF Recovery Amount from Customer and Generator Connection Point MPFs, no Residue Amounts are added to this column value. |
|
RAISEREG |
NUMBER(18,8) |
|
Pre-IESS - Recovery amount for the Raise Regulation service attributable to customer connection points(MPF + Residue). Post-IESS the amount in this column represent only the Raise Regulation FCAS MPF Recovery Amount from Customer and Generator Connection Point MPFs, no Residue Amounts are added to this column value. |
|
LOWER5MIN_GEN |
NUMBER(16,6) |
|
Recovery amount for the Lower 5 Minute service attributable to generator connection points. NULL for Billing Week post the IESS rule effective date |
|
RAISE5MIN_GEN |
NUMBER(16,6) |
|
Recovery amount for the Raise 5 Minute service attributable to generator connection points. NULL for Billing Week post the IESS rule effective date |
|
LOWERREG_GEN |
NUMBER(16,6) |
|
Recovery amount for the Lower Regulation service attributable to generator connection points. NULL for Billing Week post the IESS rule effective date |
|
RAISEREG_GEN |
NUMBER(16,6) |
|
Recovery amount for the Raise Regulation service attributable to generator connection points. NULL for Billing Week post the IESS rule effective date. NULL for Billing Week post the IESS rule effective date. |
|
AVAILABILITY_REACTIVE |
NUMBER(18,8) |
|
The total availability payment recovery amount (customer).. NULL for Billing Week post the IESS rule effective date |
|
AVAILABILITY_REACTIVE_RBT |
NUMBER(18,8) |
|
The total availability payment rebate recovery amount (customer).. NULL for Billing Week post the IESS rule effective date |
|
AVAILABILITY_REACTIVE_GEN |
NUMBER(18,8) |
|
The total availability payment recovery amount (Generator).. NULL for Billing Week post the IESS rule effective date |
|
AVAILABILITY_REACTIVE_RBT_GEN |
NUMBER(18,8) |
|
The total availability payment rebate recovery amount (Generator).. NULL for Billing Week post the IESS rule effective date |
|
RAISE1SEC |
NUMBER(18,8) |
|
Customer recovery amount for the very fast raise service. NULL for Billing Week post the IESS rule effective date |
|
LOWER1SEC |
NUMBER(18,8) |
|
Customer recovery amount for the very fast lower service. NULL for Billing Week post the IESS rule effective date |
|
RAISE1SEC_GEN |
NUMBER(18,8) |
|
Generator recovery amount for the very fast raise service. NULL for Billing Week post the IESS rule effective date |
|
LOWER1SEC_GEN |
NUMBER(18,8) |
|
Generator recovery amount for the very fast lower service. NULL for Billing Week post the IESS rule effective date |
|
LOWERREG_ACE |
NUMBER(18,8) |
|
The Lower Regulation FCAS Residue Recovery Amount using ACE MWh values. NULL for Billing Week prior to the IESS rule effective date |
|
RAISEREG_ACE |
NUMBER(18,8) |
|
The Raise Regulation FCAS Residue Recovery Amount using ACE MWh values. NULL for Billing Week prior to the IESS rule effective date |
|
RAISE1SEC_ACE |
NUMBER(18,8) |
|
The Raise1Sec FCAS Recovery Amount for the Participant and Region from ACE MWh Portion. NULL for Billing Week prior to the IESS rule effective date |
|
RAISE1SEC_ASOE |
NUMBER(18,8) |
|
The Raise1Sec FCAS Recovery Amount for the Participant and Region from ASOE MWh Portion. NULL for Billing Week prior to the IESS rule effective date |
|
LOWER1SEC_ACE |
NUMBER(18,8) |
|
The Lower1Sec FCAS Recovery Amount for the Participant and Region from ACE MWh Portion. NULL for Billing Week prior to the IESS rule effective date |
|
LOWER1SEC_ASOE |
NUMBER(18,8) |
|
The Lower1Sec FCAS Recovery Amount for the Participant and Region from ASOE MWh Portion. NULL for Billing Week prior to the IESS rule effective date |
|
|
|