Upload file format for the Hourly Profile Declaration
This document describes the formats of the upload files for the Hourly Profile Declarations of Highly-Modulated Sites.
1. Definition
Every Day D-1 before 2:30 p.m, with the possibility of a further declaration before 4:30 p.m., the Highly-Modulated Site declares to GRTgaz for gas days D, D+1 and D+2:
- The schedule for the Highly Modulated Site;
- The Minimum Technical Hourly Flow Rate and the Maximum Technical Hourly Flow Rate;
- Maintenance forecast for the Highly-Modulated Site.
You can upload either a daily or a weekly file.
2. Upload screen
It is located at the top of the “Entry of a daily consumption declaration” and “Entry of a hourly consumption declaration” screens, accessible on the TRANS@ctions portal from the “Summary of CCGT status” page.
3. Upload file format
3.1. Extension
Only files with a .csv extension are allowed.
3.2. Content
The tables presented in this section contain the following columns:
· No.: Number of field in the line
· Name: Description of field content
· Type: Type of field
· Length
· Unit
· Format: Data format.
· Compulsory: Determines whether the field is mandatory or not; if not, the field is kept empty
· Value: type of values specific to the data or example(s) of values
· Comment: additional information
In the following tables, the types of values are as follows:
· N: numeric
· X, AN: alphanumeric
· D: date
· H: time
· E: 1-character enumeration
The length is given within brackets where applicable:
· X(n) is a sequence of n alphanumeric characters,
· 9(n) is a sequence of n numeric characters,
· S9(n) is a numeric sequence with sign + or -.
The decimal separator is a dot.
This guide does not constitute a contractual document – It is not binding on GRTgaz / 5/5Programme TRANS@ctions / Upload_V1.0.docx
No. / Name / Type / Length / Unit / Format / Compulsory / Value or Example / How? /
Header
1 / TYPE_MESSAGE / YEAR / X(4) / Text / Y / "CCGT" / Constant used to identify the kind of information contained in the file. For this message, the value is CCGT.
2 / NO_DOC / YEAR / X(11) / Text / Y / REQEST21348 / Document order number This no. is specific to the shipper. Its form is: REQUESTxxxxx.
3 / DATE_GENERATION / D / X(8) / Date / YYYYMMDD / Y / Ex: 20060401 for April 1, 2006 / Message generation data in the form: YYYYMMDD.
4 / HEURE_GENERATION / H / X(6) / Hour / HHMMSS / Y / Ex: 060000 for 6 a.m. / Message generation time in the form: HHMMSS (HH ranges from de 00 to 23).
5 / CODE_CONTRAT / YEAR / X(35) / Text / Y / GFCCGx01 / GRTgaz reference of the CCGT producer
6 / ORIGIN / YEAR / X(10) / Text / Y / TRANS / Constant used to identify the origin of the message In the event of a file being uploaded, the value is: TRANS.
7 / PERIOD / YEAR / X(35) / Date / DD1/MM1/YYYY1 HH1:MM1 – DD2/MM2/YYYY2 HH2:MM2 / Y / 18/05/2011 06:00 - 19/05/2011 06:00 / Period concerned by the message.
There is a space before et after “–”
File body – 1 line per GD/PLCd/time slot (i.e. 24 lines)
N.B.: The file body must contain 24 lines even in the case of time changes.
In the case of 23-hour days, the timeslot corresponding to the time change will be ignored.
In the case of 25-hour days, the value of the timeslot corresponding to the time change will be doubled.
1 / GRTgaz’s system Code / YEAR / X(20) / Text / Y / GDF T / Constant
2 / CCGT producer Code / D / X(4) / Date / YYYY / Y / GFCCGx01 / CCGT producer Code
3 / Time slot of the gas day considered / D / X(35) / Date / DD1/MM1/YYYY1 HH1:MM1 – DD2/MM2/YYYY2 HH1+1:MM2 / Y / 05/03/2010 06:00 – 06/03/2010 07:00 / Time slot
4 / Flow direction / YEAR / X(3) / Text / Y / Del / Direction of flow
5 / PLCd Code / YEAR / X(19) / Text / Y / LIxxxx / Code of Contractual Point
6 / Value / N / 9(15) / kWh25℃ / Whole / Y / 23456 / Gas consumption profile
7 / MAINTENANCE / YEAR / X(3) / Boolean / Y / YES/NO / Maintenance indicator
8 / Q MIN / N / 9(52) / kWh at 25℃ / Whole / Y / Minimum hourly flow rate in kWh at 25°C
9 / Q MAX / N / 9(52) / kWh at 25℃ / Whole / Y / Maximum hourly flow rate in kWh at 25°C
This guide does not constitute a contractual document – It is not binding on GRTgaz / 5/5
Programme TRANS@ctions / Upload_V1.0.docx
3.3. Example
CCCG;REQEST21348;20120921;170000;GFPRODCCCG;TRANS;27/10/2012 06:00 - 28/10/2012 06:00;
GDF T; GFPRODCCCG;27/10/2012 06:00 - 27/10/2012 07:00;Del; LI0790;12345;NON;12345;23456;
GDF T; GFPRODCCCG;27/10/2012 07:00 - 27/10/2012 08:00;Del; LI0790;12345;NON;12345;23456;
GDF T; GFPRODCCCG;27/10/2012 08:00 - 27/10/2012 09:00;Del; LI0790;12345;NON;12345;23456;
GDF T; GFPRODCCCG;27/10/2012 09:00 - 27/10/2012 10:00;Del; LI0790;12345;NON;12345;23456;
GDF T; GFPRODCCCG;27/10/2012 10:00 - 27/10/2012 11:00;Del; LI0790;12345;NON;12345;23456;
GDF T; GFPRODCCCG;27/10/2012 11:00 - 27/10/2012 12:00;Del; LI0790;12345;NON;12345;23456;
GDF T; GFPRODCCCG;27/10/2012 12:00 - 27/10/2012 13:00;Del; LI0790;12345;NON;12345;23456;
GDF T; GFPRODCCCG;27/10/2012 13:00 - 27/10/2012 14:00;Del; LI0790;12345;NON;12345;23456;
GDF T; GFPRODCCCG;27/10/2012 14:00 - 27/10/2012 15:00;Del; LI0790;12345;NON;12345;23456;
GDF T; GFPRODCCCG;27/10/2012 15:00 - 27/10/2012 16:00;Del; LI0790;12345;NON;12345;23456;
GDF T; GFPRODCCCG;27/10/2012 16:00 - 27/10/2012 17:00;Del; LI0790;12345;NON;12345;23456;
GDF T; GFPRODCCCG;27/10/2012 17:00 - 27/10/2012 18:00;Del; LI0790;12345;NON;12345;23456;
GDF T; GFPRODCCCG;27/10/2012 18:00 - 27/10/2012 19:00;Del; LI0790;12345;NON;12345;23456;
GDF T; GFPRODCCCG;27/10/2012 19:00 - 27/10/2012 20:00;Del; LI0790;12345;NON;12345;23456;
GDF T; GFPRODCCCG;27/10/2012 20:00 - 27/10/2012 21:00;Del; LI0790;12345;NON;12345;23456;
GDF T; GFPRODCCCG;27/10/2012 21:00 - 27/10/2012 22:00;Del; LI0790;12345;NON;12345;23456;
GDF T; GFPRODCCCG;27/10/2012 22:00 - 27/10/2012 23:00;Del; LI0790;12345;NON;12345;23456;
GDF T; GFPRODCCCG;27/10/2012 23:00 - 28/10/2012 00:00;Del; LI0790;12345;NON;12345;23456;
GDF T; GFPRODCCCG;28/10/2012 00:00 - 28/10/2012 01:00;Del; LI0790;12345;NON;12345;23456;
GDF T; GFPRODCCCG;28/10/2012 01:00 - 28/10/2012 02:00;Del; LI0790;12345;NON;12345;23456;
GDF T; GFPRODCCCG;28/10/2012 02:00 - 28/10/2012 03:00;Del; LI0790;12345;NON;12345;23456;
GDF T; GFPRODCCCG;28/10/2012 03:00 - 28/10/2012 04:00;Del; LI0790;12345;NON;12345;23456;
GDF T; GFPRODCCCG;28/10/2012 04:00 - 28/10/2012 05:00;Del; LI0790;12345;NON;12345;23456;
GDF T; GFPRODCCCG;28/10/2012 05:00 - 28/10/2012 06:00;Del; LI0790;12345;NON;12345;23456;
Example file with csv format:
This guide does not constitute a contractual document – It is not binding on GRTgaz / 5/5