Table: BILLING_NMAS_TST_RECVRY_TRK

BILLING_NMAS_TST_RECVRY_TRK

Name

BILLING_NMAS_TST_RECVRY_TRK

Comment

BILLING_NMAS_TEST_RECVRY_TRK tracks the energy data used to allocate the test payment recovery over the recovery period.


Notes

Name

Comment

Value

Visibility

Data in this table is:

Public


Primary Key Columns

Name

BILLRUNNO

CONTRACTYEAR

RECOVERY_BILLRUNNO

RECOVERY_CONTRACTYEAR

RECOVERY_WEEKNO

WEEKNO


Content

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