Table: GSH_SUPP_SETTLEMENT_RUN

GSH_SUPP_SETTLEMENT_RUN

Name

GSH_SUPP_SETTLEMENT_RUN

Comment

The Settlements Supporting Data Report is generated when Final and Revision settlement statements are issued; it is also generated daily with details of the latest initial settlement run of the day. The report contains settlements summary information as well as participant specific data from that settlement run for the relevant charges and payments per gas day. It provides a breakdown of all executed trades and delivered quantities records included in this settlement run to assist participant in their settlement statements reconciliation. The Settlement Run subreport provides header details of the settlement run.


Primary Key Columns

Name

SETTLEMENT_RUN_ID


Content

Name

Data Type

Mandatory

Comment

SETTLEMENT_RUN_ID

NUMBER(18,0)

X

The unique identifier for the settlement run

BILLING_PERIOD

VARCHAR2(20)

 

The billing period for the settlement run, note that the billing period will only have value for Final and Revision settlement run types, and it will be null for the initial settlement run

SETTLEMENT_RUN_TYPE

VARCHAR2(20)

 

The run type for the settlement, for example final, revision, initial

START_GAS_DATE

DATE

 

The first gas date of the period for which settlement is run

END_GAS_DATE

DATE

 

The last gas date of the period for which settlement is run

LASTCHANGED

DATE

 

The date and time the report was generated