|
Name |
|
|
Comment |
BILLING_NMAS_TEST_RECOVERY sets out the recovery of NMAS testing payments |
|
Name |
Comment |
Value |
|
Visibility |
Data in this table is: |
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 |
|
LASTCHANGED |
DATE |
|
The Last Updated date and time |
|
|
|