*=========================================================================================================== * The Norwegian Petroleum Directorate's Fact-Pages. Description of download file. *=========================================================================================================== * CONTENTS: Company. Reserves. *----------------------------------------------------------------------------------------------------------- * CSV SPECIFICATIONS: *----------------------------------------------------------------------------------------------------------- * - column delimiter : , * - text qualifier : " * - decimal separator : . * - date format : dd.mm.yyyy *----------------------------------------------------------------------------------------------------------- * COLUMN SPECIFICATIONS: *----------------------------------------------------------------------------------------------------------- * column name datatype description * .............................. .............. ............................................................ * company_short_name varchar(40) Company short name used at the NPD. * * field_name varchar(40) Official field name. * * recoverable_oil real The total volume of crude oil which is and/or is expected * to be sold. * Unit of measure: mill Sm3 * * recoverable_gas real Quantities of gas which are physically delivered or planned * to be delivered (minus gas which the field may receive from * other fields). * Unit of measure: bill Sm3 * * recoverable_ngl real The total volume of NGL which is and/or is expected * to be sold. * NGL = butane + ethane + isobutane + propane + LPG. * Unit of measure: mill tonn * * recoverable_condensate real The total volume of condensate which is and/or * is expected to be sold. * Condensate = condensate + gasoline. * Unit of measure: mill Sm3 * * remaining_oil real Remaining reserves of oil which is not produced or sold. * Unit of measure: mill Sm3 * * remaining_gas real Remaining reserves of gas which is not produced or sold. * Unit of measure: bill Sm3 * * remaining_ngl real Remaining reserves of NGL which is not produced or sold. * Unit of measure: mill tonn * * remaining_condensate real Remaining reserves of condensate which is not * produced or sold. * Unit of measure: mill Sm3 * * date_generated date The date the download file was generated from the NPD's * databases. * * NPDID_company bigint NPD's unique company id. * * NPDID_field bigint NPD's unique field id. * *----------------------------------------------------------------------------------------------------------- * HISTORY: *----------------------------------------------------------------------------------------------------------- * date changed by description * .......... ........... ................................................................................... * 15.01.2003 OHO/NPD Initial version * * dd.mm.yyyy nnn/ccc description of changes *===========================================================================================================