Table: BILLING_GST_SUMMARY

BILLING_GST_SUMMARY

Name

BILLING_GST_SUMMARY

Comment

BILLING_GST_SUMMARY shows the GST_Exclusive and GST amount (if any) attributable to a participant for each BAS class.


Description

BILLING_GST_SUMMARY data is confidential to NSP participants.

Source

Populated by the posting of a billing run.

Volume

Approximately 5 records are inserted per billrunno, or about 55 records inserted per week.


Primary Key Columns

Name

BAS_CLASS

BILLRUNNO

CONTRACTYEAR

PARTICIPANTID

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

BAS_CLASS

VARCHAR2(30)

X

The BAS classification

GST_EXCLUSIVE_AMOUNT

NUMBER(15,5)

 

The GST exclusive amount paid by/to the participant to/by AEMO for this BAS classification.

GST_AMOUNT

NUMBER(15,5)

 

The GST amount for this BAS classification.

LASTCHANGED

DATE

 

Last date and time record changed