INT252 - Culcairn Operational and Market Schedules
|
Trigger type |
Event triggered |
|
Published |
Approval of Operating Schedule (AOS) |
|
Audience |
Private (Allocation Agent) |
|
Output file name |
int252_v[n]_op_sched_culcairn_[p]~yyyymmddhhmmss.csv |
Report purpose
This report provides confirmation of the quantities that the specified Market participant is scheduled to flow over the gas day at Culcairn, split into hourly intervals from the start of the gas day.
Audience notes
-
The report is for allocating flows at Culcairn.
-
This report contains details of the latest approved operational and pricing schedules for:
-
the current gas day
-
1 day in the future and
-
2 gas days in the future (if an approved 2-day ahead schedule exists at the time the report is run).
-
Culcairn injection quantities reported for each hour will match with the corresponding hourly quantity reported in the INT145 for the same schedule and injection point.
-
For the purposes of INT252:
-
‘type’ will always contain the value ‘a’
-
a ‘flag’ value of ‘MS’ refers to a Pricing Schedule (previously termed a Market Schedule).
Content notes
As a report is generated each time an operational or pricing schedule is approved there will be at least 9 issues of INT252 each day (with an additional report generated for each ad hoc schedule required).
The number of schedules covered by a report will depend on the time at which the particular report version is produced. In general, reports produced by the approval of standard schedules at:
-
06:00 AM will list 3 pricing and 3 operational schedules covering the current and next 2 gas days
-
08:00 AM will list 2 pricing and 2 operational schedules covering the current and next gas days
-
10:00 AM will list 2 pricing and 2 operational schedules covering the current and next gas days
-
noon will list 3 pricing and 3 operational schedules covering the current and next 2 gas days
-
02:00 PM will list 3 pricing and 3 operational schedules covering the current and next 2 gas days
-
04:00 PM will list 3 pricing and 3 operational schedules covering the current and next 2 gas days
-
06:00 PM will list 3 pricing and 3 operational schedules covering the current and next 2 gas days
-
10:00 PM will list 3 pricing and 3 operational schedules covering the current and next 2 gas days
-
midnight will list 3 pricing and 3 operational schedules covering the current and next 2 gas days
-
Each row in the report will specify a MIRN and schedule, and detail the associated hourly quantities (in GJ) for either:
-
the scheduled injections for the MIRN/schedule combination, or
-
the scheduled controllable withdrawals for the MIRN/schedule combination
Data content
|
Name |
Data Type |
No Nulls |
Primary Key |
CQ |
Comments |
|---|---|---|---|---|---|
|
gas_date |
varchar 20 |
True |
True |
N |
Starting hour of gas day being reported e.g. 30 Jun 2007 06:00:00 |
|
type |
char 1 |
True |
True |
N |
a = injection record e = EOD linepack record f = Comment record NB: Used for grouping and ordering |
|
flag |
char 3. |
True |
True |
N |
OS = Last Operational Schedule MS = Last Market Schedule |
|
participant_id |
integer |
True |
True |
N |
Number identifying participant |
|
pipeline_id |
integer |
True |
False |
N |
Number identifying pipeline. (Note: apart from a comment record this will always be 1.) -1 for comment record |
|
pipeline_point_id |
integer |
True |
True |
N |
NA. A number used to represent the MIRN. of no use to participants -1 for comment record. (this was NULL but requested to be a value to produce a primary key. -1 for comment record -1 for comment record |
|
pipeline_point_code |
varchar 16. |
True |
False |
N |
MIRN for injection or withdrawal point -1 for comment record |
|
pipeline_point_name |
varchar 40 |
True |
False |
N |
MIRN for injection or withdrawal point -1 for comment record |
|
offer_type |
varchar 5 |
False |
False |
N |
CTLW (withdrawal) or INJEC (injection) |
|
hour_1 |
Numeric(18,3) |
False |
False |
N |
Energy value for 6:00 AM - 3 decimal places |
|
hour_2 |
Numeric(18,3) |
False |
False |
N |
Energy value for 7:00 AM - 3 decimal places |
|
hour_3 |
Numeric(18,3) |
False |
False |
N |
Energy value for 8:00 AM - 3 decimal places |
|
hour_4 |
Numeric(18,3) |
False |
False |
N |
Energy value for 9:00 AM - 3 decimal places |
|
hour_5 |
Numeric(18,3) |
False |
False |
N |
Energy value for 10:00 AM - 3 decimal places |
|
hour_6 |
Numeric(18,3) |
False |
False |
N |
Energy value for 11:00 AM - 3 decimal places |
|
hour_7 |
Numeric(18,3) |
False |
False |
N |
Energy value for 12:00 PM - 3 decimal places |
|
hour_8 |
Numeric(18,3) |
False |
False |
N |
Energy value for 1:00 PM - 3 decimal places |
|
hour_9 |
Numeric(18,3) |
False |
False |
N |
Energy value for 2:00 PM - 3 decimal places |
|
hour_10 |
Numeric(18,3) |
False |
False |
N |
Energy value for 3:00 PM - 3 decimal places |
|
hour_11 |
Numeric(18,3) |
False |
False |
N |
Energy value for 4:00 PM - 3 decimal places |
|
hour_12 |
Numeric(18,3) |
False |
False |
N |
Energy value for 5:00 PM - 3 decimal places |
|
hour_13 |
Numeric(18,3) |
False |
False |
N |
Energy value for 6:00 PM - 3 decimal places |
|
hour_14 |
Numeric(18,3) |
False |
False |
N |
Energy value for 7:00 PM - 3 decimal places |
|
hour_15 |
Numeric(18,3) |
False |
False |
N |
Energy value for 8:00 PM - 3 decimal places |
|
hour_16 |
Numeric(18,3) |
False |
False |
N |
Energy value for 9:00 PM - 3 decimal places |
|
hour_17 |
Numeric(18,3) |
False |
False |
N |
Energy value for 10:00 PM - 3 decimal places |
|
hour_18 |
Numeric(18,3) |
False |
False |
N |
Energy value for 11:00 PM - 3 decimal places |
|
hour_19 |
Numeric(18,3) |
False |
False |
N |
Energy value for 12:00 AM - 3 decimal places |
|
hour_20 |
Numeric(18,3) |
False |
False |
N |
Energy value for 1:00 AM - 3 decimal places |
|
hour_21 |
Numeric(18,3) |
False |
False |
N |
Energy value for 2:00 AM - 3 decimal places |
|
hour_22 |
Numeric(18,3) |
False |
False |
N |
Energy value for 3:00 AM - 3 decimal places |
|
hour_23 |
Numeric(18,3) |
False |
False |
N |
Energy value for 4:00 AM - 3 decimal places |
|
hour_24 |
Numeric(18,3) |
False |
False |
N |
Energy value for 5:00 AM - 3 decimal places |
|
sort_order |
integer |
False |
False |
N |
NA |
|
comment |
varchar 255. |
False |
False |
N |
Comments on schedule |
|
transmission_id |
integer |
True |
True |
N |
Unique identifier associated with each schedule Note the value in this column is actually the transmission_doc_id |
|
current_date |
varchar 20 |
True |
False |
N |
Time Report Produced e.g. 30 Jun 2007 06:00:00 |