|
Name |
|
|
Comment |
BILLING_NMAS_TEST_RECOVERY sets out the recovery of NMAS testing payments |
|
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 |
|
|
|