*=========================================================================================================== * The Norwegian Petroleum Directorate's Fact-Pages. Description of download file. *=========================================================================================================== * CONTENTS: Production licence. Licensees, complete history. *----------------------------------------------------------------------------------------------------------- * CSV SPECIFICATIONS: *----------------------------------------------------------------------------------------------------------- * - column delimiter : , * - text qualifier : " * - decimal separator : . * - date format : dd.mm.yyyy *----------------------------------------------------------------------------------------------------------- * COLUMN SPECIFICATIONS: *----------------------------------------------------------------------------------------------------------- * column name datatype description * .............................. .............. ............................................................ * production_licence_name varchar(40) The designation of the business arrangement based area. * * date_valid_from date The date the given area is valid from. * * date_valid_to date The date the given area is valid to. No date indicates * that the given area is still valid. * * company_short_name varchar(40) Company short name used at the NPD of the company holding * participating interests in the Norwegian part of * the business arrangement based area. * * interest real The companys’ participating interests in the business * arrangement based area. * * sdfi real The State’s direct financial interest in the business * arrangement based area. * * date_generated date The date the download file was generated from the NPD's * databases. * * NPDID_production_licence bigint NPD's unique production licence id. * * NPDID_company bigint NPD's unique company id. * *----------------------------------------------------------------------------------------------------------- * HISTORY: *----------------------------------------------------------------------------------------------------------- * date changed by description * .......... ........... ................................................................................... * 01.01.2003 OHO/NPD Initial version * * 07.03.2003 OHO/NPD Corrected column spesifications * * dd.mm.yyyy nnn/ccc description of changes *===========================================================================================================