INT291 - Out of Merit Order Gas
|
Trigger type |
Event triggered |
|
Published |
Issue of Settlement Statements |
|
Audience |
Public |
|
Output file name |
int291_v[n]_out_of_merit_order_gas_[p]~yyyymmddhhmmss.csv |
Report purpose
This is a public report generated for actual volumes of gas that contribute to APs (volumes of out of merit order gas). Report A data report that loads into a data model table. Identified by its type, subtype, and version. For example: BILLING,BILLINGASPAYMENTS,2 to be on the issue of each settlement (M+7, M+18 and M+118).
Audience notes
Content notes
Data content
|
Name |
Data Type |
No Nulls |
Primary Key |
CQ |
Comments |
|---|---|---|---|---|---|
|
gas_date |
varchar(20) |
True |
True |
N |
Gas day dd mmm yyy e.g.30 Jun 2008 |
|
statement_version_id |
Int |
True |
True |
N |
|
|
ancillary_amt_gst_ex |
Numeric 15,4 |
True |
False |
Y |
Total estimated AP for the gas day (net position as at the last schedule of the day) ancillary_amt_gst_ex = SUM(payment_amt) FROM ap_daily_sched_mirn per gas_date for inj_wdl_flag = 'I' |
|
scheduled_out_of_merit_gj |
Numeric 18,3 |
True |
False |
Y |
Net out of merit order GJs scheduled and delivered over the day scheduled_out_of merit_gj = SUM(ap_qty_gj) FROM ap_constrained_up per gas_date for inj_wdl_flag = 'I' |
|
current_date |
varchar(20) |
False |
False |
N |
Current report run date time. Format dd Mmm yyyy hh:mi:ss e.g. 15 May 2008 12:22:12 |