Table: BILLING_EFTSHORTFALL_AMOUNT

BILLING_EFTSHORTFALL_AMOUNT

Name

BILLING_EFTSHORTFALL_AMOUNT

Comment

The billing shortfall run amounts


Description

BILLING_EFTSHORTFALL_AMOUNT data is confidential, and is available only to the relevant participant.


Primary Key Columns

Name

BILLRUNNO

CONTRACTYEAR

PARTICIPANTID

WEEKNO


Content

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