Table: BILLINGAPCCOMPENSATION

BILLINGAPCCOMPENSATION

Name

BILLINGAPCCOMPENSATION

Comment

BILLINGAPCCOMPENSATION shows Administered Price Cap (APC) compensation amounts for the billing period. Data is for each participant by region.


Description

Updated with each billing run


Primary Key Columns

Name

BILLRUNNO

CONTRACTYEAR

PARTICIPANTID

REGIONID

WEEKNO


Index Columns

Name

LASTCHANGED


Content

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