PPRS 2000
ANNEX
DATA SUBMISSION –
COMPUTING REQUIREMENTS
(16 Pages)
Data Submission - Computing Requirements
1 Background
1.1. Tables 1 – 6 in the Manual provide the Company Production Engineer with an overview of the physical data required by DTI each month. However, these are not sufficient to define exchange file structures and data types or the Validation Rules with which data must comply.
1.2The format of data files to be sent to the DTI is based on an Internet compliant standard called XML, (Extensible Mark up Language), which defines a method of exchanging structured data. The structure of an XML file is defined by another file called a Document Type Definition or DTD for short. The XML file includes actual data reported and the DTD defines the structure of the data expected. Each monthly PPRS return for a Reporting Unit must be sent to the DTI as a single XML text file and this must comply with a DTD given in this document.
1.1For IT purposes, Tables 1-3 for Field Reporting Units have therefore been combined into one table in this Annex (Table “A” Field Returns – Data Specifications) which shows the additional information defining data types and Validation Rules. Tables 4-6 for Terminal Reporting Units have been combined into a similar table (Table “B” – Terminal Returns – Data Specifications) which shows the additional information defining data types and Validation Rules.
1.4Validation Rules are listed in Table C and must be complied with when submitting data. The structure expected for a field return is defined in the DTDs and these can be found on the DTI Oil and Gas Web site.
1.5The DTDs and a comprehensive selection of sample XML files are available for downloading from the Web site ( Further information on XML is available on ( The Web site covers issues such as,
- How to report repeating groups with no data
- How to report PARTIAL returns
- How to report FULL returns
- How to report a zero return
2.Guide to DTD and XML Definitions
Entries in Tables “A” and “B” have been used to name the data tags within the DTD files and the XML files. Data nametags used in the DTD can be classified into the following types:
- Overall Return Tag has value ‘PPRS_RETURN’ used to tag the return as a whole
- Data Group Name tags used to tag a list of other Data Groups or Individual Data Items
- Data Group Name tags used to tag a Repeating Data Group
- Note. All data tags and any other character data within are in UPPER CASE.
- Individual Data Item tags – used to tag actual data to be reported
The tag names used in the DTD files are based on the Data/Stream Descriptions and Data Items given in Tables A and B as follows:
- if the Data/Stream Description is not a repeating group but has more than one Data Item associated with it, the Data Group Name tag used in the DTD is the same as the Data/ Stream Description. However, the spaces are replaced by underscores (e.g., Oil Production becomes tag OIL_PRODUCTION). Individual Data Item tags referenced by this group are the same as the corresponding Data Item names in Tables A and B, but again with spaces replaced by underscores. So for Oil Production the DTD syntax is:
<!ELEMENT OIL_PRODUCTION (OIL_PRODUCTION_VOLUME, OIL_PRODUCTION_DENSITY)>
<!ELEMENT OIL_PRODUCTION_VOLUME (#PCDATA)>
<!ELEMENT OIL_PRODUCTION_DENSITY (#PCDATA)>
- if the Data/Stream Description is a repeating group then the Repeating Data Group tag is the Data/Stream Description, with spaces replaced by underscores, followed by the text ‘_REPEATING_GROUP’. (E.g. Inter Field Transfer of Oil becomes INTER_FIELD_TRANSFER_OF_OIL_REPEATING_GROUP). This is then followed in brackets by the Data/ Stream Name, again with spaces replaced by underscores, and an asterisk to indicate repetition. Thus for Inter Field Transfer of Oil the entry in the DTD is,
<!ELEMENT INTERFIELD_TRANSFER_OF_OIL_REPEATING_GROUP (INTER_FIELD_TRANSFER_OF_OIL*)> followed by the DTD definition of the group INTER_FIELD_TRANSFER_OF_OIL
- if the Data/Stream Description refers to only one Data Item (e.g. Produced Water refers to Produced Water Volume), then the tag used in the DTD is the Data Item name with spaces replaced by underscores (e.g. PRODUCED_WATER_VOLUME)
3.Completeness of Data and Timing of Submission to DTI
3.1All PPRS returns for a given month’s production must arrive at the DTI by the 30th day of the following month. Some return types are expected to report some data earlier by the 16th of the month. Data required by the 16th of the month and that required on the 30th are identified in Tables 1 - 6. These early returns by the 16th are known as “PARTIAL” returns and can report only selected data items leaving the rest blank. The returns by the 30th are known as “FULL” and must report the data expected including that sent earlier.
Any additional data sent in a PARTIAL return but not required as early data may be ignored by DTI because it is still expected in a FULL return. The FULL return received by DTI will overwrite the PARTIAL data. A Company may send a FULL return at any time before the 30th of the month, there is no requirement to wait. The DTD defines a “RETURN_COMPLETENESS” tag that may have values ‘FULL’ or ‘PARTIAL’. The XML file to be sent must include this and identifies whether it is a FULL or PARTIAL return.
3.2The appropriate monthly XML file should be created separately for each individual Reporting Unit and contain the relevant monthly data. The XML file should be e-mailed as a text attachment to the following e-mail address: .
3.3It is planned by 1 October 2000 to provide two different methods of sending PPRS returns to the DTI.
1. Via email as a plain text attachment. It is envisaged that many of the larger companies with automated production allocation systems will prefer this method as it can be made fully automated. On receipt at the DTI, the attachment will be removed and processed – with success or failure resulting in an email acknowledgement being returned to a nominated list of company email addressees. If errors are encountered, the file will be returned via e-mail to correct and re-submit as a new XML file. The emphasis is on the Operators’ internal QC procedures to get the files in a format to load directly onto the DTI computers.
2. “Upload File” onto the DTI Oil and Gas Website. This will provide an instantaneous Validation and loading. Any errors will be reported at the time of the operation. This option will be available on the above website reference (see Section 1.5 above).
Page 1 of 16
Table A (Page 1 of 3)
Field Returns –Data Specification
Reporting Unit TypesData Types
P – Oil Field Exporting to PipelineCharacter (x) = UPPER CASE ALPHANUMERIC not longer than (x) characters
T – Onshore Oil Field or Offshore Tanker LoaderNumber (x) = Number with no more than (x) decimal places
G - Dry Gas FieldInteger = whole number, no decimal point
Reporting Unit Type / Data/Stream Description / Data Item / Units / Data Type / Validation/ RulesP,T,G / Return Date / RETURN_DATE_MONTH
RETURN_DATE_YEAR / Integer
Integer / Rule 14
P,T,G / Reporting Unit / REPORTING_UNIT_NAME
REPORTING_UNIT_IDENTIFIER
REPORTING_UNIT_TYPE
REPORTING_UNIT_OPERATOR / Character(30)
Integer
Character(1)
Character(60) / Rule 15
Rule 15
Rule 16
Rule 17
P,T,G / Return Completeness / RETURN_COMPLETENESS / Character(7) / Rule 8
P,T,G / Return UK Share / RETURN_UK_SHARE_OIL
RETURN_UK_SHARE_GAS / Number(5)
Number(5) / Rule 18
Rule 18
P,T / Oil Production / OIL_PRODUCTION_VOLUME
OIL_PRODUCTION_DENSITY / m3
Kg/m3 / Integer
Number(1) / Rule 1
P,T / Inter Field Transfer of Oil
(* Repeating Group) / INTER_FIELD_TRANSFER_OF_OIL_VOLUME
INTER_FIELD_TRANSFER_OF_OIL_DENSITY
INTER_FIELD_TRANSFER_OF_OIL_ORIGIN
INTER_FIELD_TRANSFER_OF_OIL_DESTINATION / m3
Kg/m3
Field Name Field Name / Integer
Number(1)
Character(30)
Character(30) / Rule 2
Rule 30
P / Oil Production to Pipeline / OIL_PRODUCTION_TO_PIPELINE_VOLUME
OIL_PRODUCTION_TO_PIPELINE_DENSITY / m3
Kg/m3 / Integer
Number(1) / Rule 1
P,T / Associated Gas Production / ASSOCIATED_GAS_PRODUCTION_VOLUME
ASSOCIATED_GAS_PRODUCTION_DENSITY / Ksm3
Kg/sm3 / Integer
Number(3) / Rule 3
P,T / Inter Field Transfer of Associated Gas
(* Repeating Group) / INTER_FIELD_TRANSFER_OF_ASSOCIATED_GAS_VOLUME
INTER_FIELD_TRANSFER_OF_ASSOCIATED_GAS_DENSITY
INTER_FIELD_TRANSFER_OF_ASSOCIATED_GAS_ORIGIN
INTER_FIELD_TRANSFER_OF_ASSOCIATED_GAS_DESTINATION / Ksm3
Kg/sm3
Field Name Field Name / Integer
Number(3)
Character(30)
Character(30) / Rule 4
Rule 30
P,T / Associated Gas to Pipeline / ASSOCIATED_GAS_TO_PIPELINE_VOLUME
ASSOCIATED_GAS_TO_PIPELINE_DENSITY
ASSOCIATED_GAS_TO_PIPELINE_CV / Ksm3
Kg/sm3 Mj/sm3 / Integer
Number(3)
Number(2) / Rule 5
Table A Continued (Page 2 of 3)
Field Returns –Data Specification
Reporting Unit TypesData Types
P – Oil Field Exporting to PipelineCharacter (x) = UPPER CASE ALPHANUMERIC not longer than (x) characters
T – Onshore Oil Field or Offshore Tanker LoaderNumber (x) = Number with no more than (x) decimal places
G - Dry Gas FieldInteger = whole number, no decimal point
Reporting Unit Type / Data/Stream Description / Data Item / Units / Data Type / Validation/ RulesG / Dry Gas Field Production / DRY_GAS_FIELD_PRODUCTION_VOLUME
DRY_GAS_FIELD_PRODUCTION_DENSITY / Ksm3 Kg/sm3 / Integer
Number(3) / Rule 3
G / Inter Field Transfer of Dry Gas
(* Repeating Group) / INTER_FIELD_TRANSFER_OF_DRY_GAS_VOLUME
INTER_FIELD_TRANSFER_OF_DRY_GAS_DENSITY
INTER_FIELD_TRANSFER_OF_DRY_GAS_ORIGIN
INTER_FIELD_TRANSFER_OF_DRY_GAS_DESTINATION / Ksm3 Kg/sm3 Field Name
Field Name / Integer
Number(3)
Character(30)
Character(30) / Rule 4
Rule 30
G / Dry Gas to Pipeline / DRY_GAS_TO_PIPELINE_VOLUME
DRY_GAS_TO_PIPELINE_CV / Ksm3 Mj/sm3 / Integer
Number(2) / Rule 6
G / Dry Gas Field Condensate Production / DRY_GAS_FIELD_CONDENSATE_PRODUCTION_VOLUME
DRY_GAS_FIELD_CONDENSATE_PRODUCTION_DENSITY / m3
Kg/m3 / Integer
Number(3) / Rule 19
G / Inter Field Transfer of Condensate
(* Repeating Group) / INTER_FIELD_TRANSFER_OF_CONDENSATE_VOLUME
INTER_FIELD_TRANSFER_OF_CONDENSATE_DENSITY
INTER_FIELD_TRANSFER_OF_CONDENSATE_ORIGIN
INTER_FIELD_TRANSFER_OF_CONDENSATE_DESTINATION / m3
Kg/m3
Field Name
Field Name / Integer
Number(1)
Character(30)
Character(30) / Rule 20
Rule 30
P,T,G / Gas Flared at Field / GAS_FLARED_AT_FIELD_VOLUME
GAS_FLARED_AT_FIELD_DENSITY / Ksm3 Kg/sm3 / Integer
Number(3) / Rule 3
P,T,G / Gas Vented at Field / GAS_VENTED_AT_FIELD_VOLUME
GAS_VENTED_AT_FIELD_DENSITY / Ksm3 Kg/sm3 / Integer
Number(3) / Rule 3
P,T,G / Gas Utilised in Field / GAS_UTILISED_IN_FIELD_VOLUME
GAS_UTILISED_IN_FIELD_DENSITY / Ksm3 Kg/sm3 / Integer
Number(3) / Rule 3
P,T,G / Gas Injected / GAS_INJECTED_VOLUME
GAS_INJECTED_CV / Ksm3
Mj/sm3 / Integer
Number(2) / Rule 32
G / Gas Utilised from Inter Field Transfer / GAS_UTILISED_FROM_INTER_FIELD_TRANSFER_VOLUME
GAS_UTILISED_FROM_INTER_FIELD_TRANSFER_DENSITY / Ksm3 Kg/sm3 / Integer
Number(3) / Rule 3
P,T,G / Produced Water / PRODUCED_WATER_VOLUME / m3 / Integer / Rule 7
P,T,G / Produced Water to Sea / PRODUCED_WATER_TO_SEA_VOLUME / m3 / Integer / Rule 7
Table A Continued (Page 3 of 3)
Field Returns –Data Specification
Reporting Unit TypesData Types
P – Oil Field Exporting to PipelineCharacter (x) = UPPER CASE ALPHANUMERIC not longer than (x) characters
T – Onshore Oil Field or Offshore Tanker LoaderNumber (x) = Number with no more than (x) decimal places
G - Dry Gas FieldInteger = whole number, no decimal point
Reporting Unit Type / Data/Stream Description / Data Item / Units / Data Type / Validation/ RulesP,T / Injected Water / INJECTED_WATER_VOLUME / m3 / Integer / Rule 7
P,T / Re Injected Produced Water / RE_INJECTED_PRODUCED_WATER_VOLUME / m3 / Integer / Rule 7
P / Stock of Oil in Field / STOCK_OF_OIL_IN_FIELD_VOLUME
STOCK_OF_OIL_IN_FIELD_DENSITY / m3
Kg/m3 / Integer
Number(1) / Rule 1
T / Stock of Oil in Tanker / STOCK_OF_OIL_IN_TANKER_VOLUME
STOCK_OF_OIL_IN_TANKER_DENSITY / m3
Kg/m3 / Integer
Number(1) / Rule 1
T / Stock of Oil in Pipeline / STOCK_OF_OIL_IN_PIPELINE_VOLUME
STOCK_OF_OIL_IN_PIPELINE_DENSITY / m3
Kg/m3 / Integer
Number(1) / Rule 1
T / Total Oil Tanker Disposals / TOTAL_OIL_TANKER_DISPOSALS_VOLUME
TOTAL_OIL_TANKER_DISPOSALS_DENSITY / m3
Kg/m3 / Integer
Number(1) / Rules 1
and 26
T / Individual Oil Tanker Disposal
(* Repeating Group) / INDIVIDUAL_OIL_TANKER_DISPOSAL_VOLUME
INDIVIDUAL_OIL_TANKER_DISPOSAL_DENSITY
INDIVIDUAL_OIL_TANKER_DISPOSAL_DESTINATION
INDIVIDUAL_OIL_TANKER_DISPOSAL_VESSEL / m3
Kg/m3
Code
Name / Integer
Number(1)
Character(3)
Character(30) / Rule 21
Rule 31
Rule 30
G / Sales Gas to NTS / SALES_GAS_TO_NTS_MASS
SALES_GAS_TO_NTS_DENSITY
SALES_GAS_TO_NTS_CV / Tonnes Kg/sm3 Mj/sm3 / Integer
Number(3)
Number(2) / Rule 13
G / Individual Sales Gas Non NTS
(* Repeating Group) / INDIVIDUAL_SALES_GAS_NON_NTS_MASS
INDIVIDUAL_SALES_GAS_NON_NTS_DENSITY
INDIVIDUAL_SALES_GAS_NON_NTS_CV
INDIVIDUAL_SALES_GAS_NON_NTS_DESTINATION / Tonnes Kg/sm3 Mj/sm3
Code / Integer
Number(3)
Number(2)
Character(3) / Rule 9
Rule 30
Table B (Page 1 of 4)
Terminal Returns – Data Specification
Reporting Unit TypesData Types
P – Oil Field Exporting to PipelineCharacter (x) = UPPER CASE ALPHANUMERIC not longer than (x) characters
T – Onshore Oil Field or Offshore Tanker LoaderNumber (x) = Number with no more than (x) decimal places
G - Dry Gas FieldInteger = whole number, no decimal point
Reporting Unit Type / Data/Stream Description / Data Item / Units / Data Type / Validation /RulesO,A,D / Return Date / RETURN_DATE_MONTH
RETURN_DATE_YEAR / Integer
Integer / Rule 14
O,A,D / Reporting Unit / REPORTING_UNIT_NAME
REPORTING_UNIT_IDENTIFIER
REPORTING_UNIT_TYPE
REPORTING_UNIT_OPERATOR / Character(30)
Integer
Character(1)
Character(60) / Rule 15
Rule 15
Rule 16
Rule 17
O,A,D / Return Completeness / RETURN_COMPLETENESS / Character(7) / Rule 8
O,A,D / Return UK Share / RETURN_UK_SHARE_OIL
RETURN_UK_SHARE_GAS / Number(5)
Number(5) / Rule 18
Rule 18
O / Pipeline Oil Entering Terminal / PIPELINE_OIL_ENTERING_TERMINAL_MASS / Tonnes / Integer / Rule 7
O,A / NGLs Condensate Entering Terminal / NGLS_CONDENSATE_ENTERING_TERMINAL_MASS
NGLS_CONDENSATE_ENTERING_TERMINAL_DENSITY / Tonnes Kg/m3 / Integer
Number(1) / Rule 22
O / SCO Receipts / SCO_RECEIPTS_MASS
SCO_RECEIPTS_DENSITY / Tonnes Kg/m3 / Integer
Number(1) / Rule 10
O / NGL Receipts / NGL_RECEIPTS_MASS / Tonnes / Integer / Rule 7
A / Associated Gas Entering Terminal / ASSOCIATED_GAS_ENTERING_TERMINAL_MASS
ASSOCIATED_GAS_ENTERING_TERMINAL_DENSITY / Tonnes Kg/sm3 / Integer
Number(3) / Rule 11
D / Pipeline Dry Gas Entering Terminal / PIPELINE_DRY_GAS_ENTERING_TERMINAL_MASS
PIPELINE_DRY_GAS_ENTERING_TERMINAL_DENSITY / Tonnes Kg/sm3 / Integer
Number(3) / Rule 11
D / Dry Gas Condensate Entering Terminal / DRY_GAS_CONDENSATE_ENTERING_TERMINAL_MASS
DRY_GAS_CONDENSATE_ENTERING_TERMINAL_DENSITY / Tonnes Kg/m3 / Integer
Number(3) / Rule 22
O / SCO Losses / SCO_LOSSES_MASS / Tonnes / Integer / Rule 23
O,A / Condensate and NGL Losses / CONDENSATE_AND_NGL_LOSSES_MASS / Tonnes / Integer / Rule 23
A,D / Gas Losses / GAS_LOSSES_MASS
GAS_LOSSES_DENSITY / Tonnes Kg/sm3 / Integer
Number(3) / Rule 24
D / Dry Gas Condensate Losses / DRY_GAS_CONDENSATE_LOSSES_MASS
DRY_GAS_CONDENSATE_LOSSES_DENSITY / Tonnes Kg/sm3 / Integer
Number(3) / Rule 25
Table B Continued (Page 2 of 4)
Terminal Returns – Data Specification
Reporting Unit TypesData Types
P – Oil Field Exporting to PipelineCharacter (x) = UPPER CASE ALPHANUMERIC not longer than (x) characters
T – Onshore Oil Field or Offshore Tanker LoaderNumber (x) = Number with no more than (x) decimal places
G - Dry Gas FieldInteger = whole number, no decimal point
Reporting Unit Type / Data/Stream Description / Data Item / Units / Data Type / Validation/ RulesO,A,D / Gas Flared at Terminal / GAS_FLARED_AT_TERMINAL_MASS
GAS_FLARED_AT_TERMINAL_DENSITY / Tonnes Kg/sm3 / Integer
Number(3) / Rule 11
O,A,D / Gas Vented at Terminal / GAS_VENTED_AT_TERMINAL_MASS
GAS_VENTED_AT_TERMINAL_DENSITY / Tonnes Kg/sm3 / Integer
Number(3) / Rule 11
O,A,D / Gas Utilised in Terminal / GAS_UTILISED_IN_TERMINAL_MASS
GAS_UTILISED_IN_TERMINAL_DENSITY / Tonnes Kg/sm3 / Integer
Number(3) / Rule 11
O / SCO Stock / SCO_STOCK_MASS
SCO STOCK_DENSITY / Tonnes Kg/m3 / Integer
Number(1) / Rule 10
O,A / NGL Production / NGL_PRODUCTION_MASS / Tonnes / Integer / Rule 7
O,A / Ethane Stock / ETHANE_STOCK_MASS / Tonnes / Integer / Rule 7
O,A / Propane Stock / PROPANE_STOCK_MASS / Tonnes / Integer / Rule 7
O,A / Butane Stock / BUTANE_STOCK_MASS / Tonnes / Integer / Rule 7
O,A / C5 Condensate Stock / C5_CONDENSATE_STOCK_MASS / Tonnes / Integer / Rule 7
D / Dry Gas Condensate Stock / DRY_GAS_CONDENSATE_STOCK_MASS
DRY_GAS_CONDENSATE_STOCK_DENSITY / Tonnes Kg/m3 / Integer
Number(1) / Rule 22
O / Total SCO Disposal / TOTAL_SCO_DISPOSAL_MASS
TOTAL_SCO_DISPOSAL_DENSITY / Tonnes Kg/m3 / Integer
Number(1) / Rule 10
O / Individual SCO Disposal
* Repeating Group) / INDIVIDUAL_SCO_DISPOSAL_MASS
INDIVIDUAL_SCO_DISPOSAL_DELIVERY INDIVIDUAL_SCO_DISPOSAL_DESTINATION / Tonnes Method Code / Integer
Character(1)
Character(3) / Rule 12
Rule 31
Rule 30, 33
O,A / Total Ethane Disposal / TOTAL_ETHANE_DISPOSAL_MASS
TOTAL_ETHANE_DISPOSAL_DENSITY / Tonnes Kg/m3 / Integer
Number(3) / Rule 22
O,A / Total Propane Disposal / TOTAL_PROPANE_DISPOSAL_MASS
TOTAL_PROPANE_DISPOSAL_DENSITY / Tonnes Kg/m3 / Integer
Number(3) / Rule 22
O,A / Total Butane Disposal / TOTAL_BUTANE_DISPOSAL_MASS
TOTAL_BUTANE_DISPOSAL_DENSITY / Tonnes Kg/m3 / Integer
Number(3) / Rule 22
O,A / Total C5 Condensate Disposal / TOTAL_C5_CONDENSATE_DISPOSAL_MASS
TOTAL_C5_CONDENSATE_DISPOSAL_DENSITY / Tonnes Kg/m3 / Integer
Number(3) / Rule 22
Table B Continued (Page 3 of 4)
Terminal Returns – Data Specification
Reporting Unit TypesData Types
P – Oil Field Exporting to PipelineCharacter (x) = UPPER CASE ALPHANUMERIC not longer than (x) characters
T – Onshore Oil Field or Offshore Tanker LoaderNumber (x) = Number with no more than (x) decimal places
G - Dry Gas FieldInteger = whole number, no decimal point
Reporting Unit Type / Data/Stream Description / Data Item / Units / Data Type / Validation/ RulesO,A / Individual Ethane Disposal
(* Repeating Group) / INDIVIDUAL_ETHANE_DISPOSAL_MASS
INDIVIDUAL_ETHANE_DISPOSAL_DELIVERY
INDIVIDUAL_ETHANE_DISPOSAL_DESTINATION / Tonnes
Method
Code / Integer
Character(1)
Character(3) / Rule 12
Rule 31
Rule 30
Rule 33
O,A / Individual Propane Disposal
(* Repeating Group) / INDIVIDUAL_PROPANE_DISPOSAL_MASS
INDIVIDUAL_PROPANE_DISPOSAL_DELIVERY
INDIVIDUAL_PROPANE_DISPOSAL_DESTINATION / Tonnes
Method
Code / Integer
Character(1)
Character(3) / Rule 12
Rule 31
Rule 30
Rule 33
O,A / Individual Butane Disposal
(* Repeating Group) / INDIVIDUAL_BUTANE_DISPOSAL_MASS
INDIVIDUAL_BUTANE_DISPOSAL_DELIVERY
INDIVIDUAL_BUTANE_DISPOSAL_DESTINATION / Tonnes
Method
Code / Integer
Character(1)
Character(3) / Rule 12
Rule 31
Rule 30
Rule 33
O,A / Individual C5 Condensate Disposal
(* Repeating Group) / INDIVIDUAL_C5_CONDENSATE_DISPOSAL_MASS
INDIVIDUAL_C5_CONDENSATE_DISPOSAL_DELIVERY
INDIVIDUAL_C5_CONDENSATE_DISPOSAL_DESTINATION / Tonnes
Method
Code / Integer
Character(1)
Character(3) / Rule 12
Rule 31
Rule 30
Rule 33
A / Total Mixed Condensate Disposal / TOTAL_MIXED_CONDENSATE_DISPOSAL_MASS
TOTAL_MIXED_CONDENSATE_DISPOSAL_DENSITY / Tonnes Kg/sm3 / Integer
Number(1) / Rule 22
A / Individual Mixed Condensate Disposal
(* Repeating Group) / INDIVIDUAL_MIXED_CONDENSATE_DISPOSAL_MASS
INDIVIDUAL_MIXED_CONDENSATE_DISPOSAL_DELIVERY
INDIVIDUAL_MIXED_CONDENSATE_DISPOSAL_DESTINATION / Tonnes Method
Code / Integer
Character(1)
Character(3) / Rule 12
Rule 31
Rule 30
Rule 33
A,D / Sales Gas from UK Production / SALES_GAS_FROM_UK_PRODUCTION_MASS
SALES_GAS_FROM_UK_PRODUCTION_DENSITY
SALES_GAS_FROM_UK_PRODUCTION_CV / Tonnes Kg/sm3 Mj/sm3 / Integer
Number(3)
Number(2) / Rule 13
Table B Continued (Page 4 of 4)
Terminal Returns – Data Specification
Reporting Unit TypesData Types
P – Oil Field Exporting to PipelineCharacter (x) = UPPER CASE ALPHANUMERIC not longer than (x) characters
T – Onshore Oil Field or Offshore Tanker LoaderNumber (x) = Number with no more than (x) decimal places
G - Dry Gas FieldInteger = whole number, no decimal point
Reporting Unit Type / Data/Stream Description / Data Item / Units / Data Type / Validation/ RulesA,D / Sales Gas from Non UK Production / SALES_GAS_FROM_NON_UK_PRODUCTION_MASS
SALES_GAS_FROM_NON_UK_PRODUCTION_DENSITY
SALES_GAS_FROM_NON_UK_PRODUCTION_CV / Tonnes Kg/sm3 Mj/sm3 / Integer
Number(3)
Number(2) / Rule 13
A,D / Sales Gas to NTS / SALES_GAS_TO_NTS_MASS
SALES_GAS_TO_NTS_DENSITY
SALES_GAS_TO_NTS_CV / Tonnes Kg/sm3 Mj/sm3 / Integer
Number(3)
Number(2) / Rule 13
A,D / Individual Sales Gas Non NTS
(* Repeating Group) / INDIVIDUAL_SALES_GAS_NON_NTS_MASS
INDIVIDUAL_SALES_GAS_NON_NTS_DENSITY
INDIVIDUAL_SALES_GAS_NON_NTS_CV
INDIVIDUAL_SALES_GAS_NON_NTS_DESTINATION / Tonnes Kg/sm3 Mj/sm3 Code / Integer
Number(3)
Number(2)
Character(3) / Rule 9
Rule 30
Rule 31
D / Dry Gas Condensate Disposal / DRY_GAS_CONDENSATE_DISPOSAL_MASS
DRY_GAS_CONDENSATE_DISPOSAL_DENSITY / Tonnes Kg/m3 / Integer
Number(3) / Rule 22
D / Individual Dry Gas Condensate Disposal
(* Repeating Group) / INDIVIDUAL_DRY_GAS_CONDENSATE_DISPOSAL_MASS
INDIVIDUAL_DRY_GAS_CONDENSATE_DISPOSAL_DELIVERY
INDIVIDUAL_DRY_GAS_CONDENSATE_DISPOSAL_DESTINATION / Tonnes Method Code / Integer
Character(1)
Character(3) / Rule 12
Rule 31
Rule 30
Rule 33
Table C
Validation Rules (Page 1 of 5)
When constructing a PPRS XML file, all tags defined in the relevant DTD must be included. This is even if reported data within the tags is blank or zero, with the exception of repeating data groups that are explained below in Rule 30. This applies to both ‘FULL’ returns and ‘PARTIAL’ returns. Tables A and B indicate which data items must be reported and which rules apply. If a data item is not required, report a blank or zero value within the XML tags.
Validation Rule / Rule Definition / Rule ScopeRule 1 – Oil volume reporting / (volume > 0 and < 9999999 and density >500 and < 1050) OR
(volume = 0 and density = 0) / Within Data/Stream Description
Rule 2 – Oil volume transfers / ( (volume > 0 and < 9999999) or (volume <0 and > -9999999) )
and density > 500 and < 1050 and
origin is not blank and destination is not blank)
The convention is that transfers from the reporting unit are positive, and transfers in are negative / Within Data/Stream Description
Rule 3 – Gas volume reporting / (volume >0 and < 999999999 and density > 0.5 and < 5) OR
(volume = 0 and density = 0 ) / Within Data/Stream Description
Rule 4 – Gas volume transfers / ( (volume > 0 and < 999999999) or (volume < 0 and > -999999999) )
density > 0.5 and < 5 and origin is not blank and destination is not blank)
The convention is that transfers from the reporting unit are positive, and transfers in are negative / Within Data/Stream Description
Rule 5 – Gas volume reporting with CV / (volume > 0 and < 999999999 and density > 0.5 and < 5 and calorific value (CV) > 0 and < 50) OR
(volume = 0 and density = 0 and CV = 0 ) / Within Data/Stream Description
Rule 6 – Gas volume reporting with CV only / (volume >0 and < 999999999 and CV > 0 and < 50)
OR (volume = 0 and CV = 0 ) / Within Data/Stream Description
Rule 7 – volume/ mass reporting only / (value >= 0 and < 999999999) / Within Data/Stream Description
Rule 8 – Return Completeness / Return Completeness Type = ‘FULL’ or ‘PARTIAL’ / Within Data/Stream Description
Rule 9 – Individual Gas mass disposals / (mass > 0 and < 9999999 and density > 0.5 and < 5 and
CV > 0 and < 50 and Destination is not blank) / Within Data/Stream Description
Rule 10 – Oil mass reporting / (mass > 0 and < 9999999 and density > 500 and < 1050)
OR (mass = 0 and density = 0 ) / Within Data/Stream Description
Rule 11 – Gas mass reporting / (mass > 0 and < 9999999 and density > 0.5 and < 5)
OR (mass = 0 and density = 0) / Within Data/Stream Description
Rule 12 – Mass disposal / (mass > 0 and < 9999999 and delivery not blank and destination is in Rule 31) / Within Data/Stream Description
Table C
Validation Rules Continued(Page 2 of 5)
Validation Rule / Rule Definition / Rule ScopeRule 13 – Gas mass reporting with CV / (mass > 0 and < 9999999 and density > 0.5 and < 5 and CV > 0 and < 50)
OR (mass = 0 and density = 0 and CV = 0) / Within Data/Stream Description
Rule 14 – Reporting month/ year / month >= 1 and <= 12 and year >= 1975 / Within Data/Stream Description
Rule 15 – Reporting Unit Details / Assigned by DTI at start of reporting – must be upper case if alphabetic. / Individual Data Item
Rule 16 – Reporting Unit Type / Reporting_Unit_Type = P or T or G or O or A or D and agreed with DTI at start of reporting / Individual Data Item
Rule 17 – Operating Company / Agreed with DTI at start of reporting and for subsequent changes – upper case / Individual Data Item
Rule 18 – UK Share / This represents the share of production attributable to UK, which may differ from the UK equity due to an underlift/ overlift situation. Values for Median line fields may result in negative values or values > 100. There is therefore limited validation: Value > -100 and < 200 / Individual Data Item
Rule 19 – NGL/ Condensate volume reporting / ( volume > 0 and < 9999999 and density > 300 and < 800 )
OR ( volume = 0 and density = 0 ) / Within Data/Stream Description
Rule 20 – NGL/ Condensate volume transfers / ( ( volume > 0 and < 9999999) or ( volume < 0 and > -9999999 ) ) and
density > 300 and < 800 and origin is not blank and destination is not blank
The convention is that transfers from the reporting unit are positive, and transfers in are negative / Within Data/Stream Description
Rule 21 – Individual oil volume disposal / Volume > 0 and < 9999999 and density > 500 and < 1050
and destination in Rule 31 and vessel is not blank / Within Data/Stream Description
Rule 22 – NGL and Condensate mass reporting / ( mass > 0 and < 9999999 and density > 300 and < 800 )
OR ( mass = 0 and density = 0 ) / Within Data/Stream Description
Rule 23 – Mass losses / ( mass > -9999999 and < 9999999 ) / Within Data/Stream Description
Rule 24 – Gas mass losses / ( ( ( mass > 0 and < 9999999 ) or ( mass > -9999999 and < 0 ) ) and density > 0.5 and < 5 )
OR ( mass = 0 and density = 0 ) / Within Data/Stream Description
Rule 25 – Condensate mass losses / ( ( ( mass > 0 and < 9999999 ) or ( mass > -9999999 and < 0 ) ) and density > 300 and < 800 )
OR ( mass = 0 and density = 0 ) / Within Data/Stream Description
Rule 26 – Total disposals and individual values / For each terminal product type: SCO, Ethane, Propane, Butane, C5 Condensate, Mixed Condensate, Dry Gas Condensate, the sum of individual disposals must equal total disposal within plus or minus 0.5%. Similarly for field Oil Tanker Disposals.
If the total value for a product type is zero, then no entries in the corresponding repeating group for the individual disposals should be included in the return. Only the tag for the repeating group should appear. / Consistency of total values and corresponding individual values
Table C