*=========================================================================================================== * The Norwegian Petroleum Directorate's Fact-Pages. Description of download file. *=========================================================================================================== * CONTENTS: Discovery. General information. *----------------------------------------------------------------------------------------------------------- * CSV SPECIFICATIONS: *----------------------------------------------------------------------------------------------------------- * - column delimiter : , * - text qualifier : " * - decimal separator : . * - date format : dd.mm.yyyy *----------------------------------------------------------------------------------------------------------- * COLUMN SPECIFICATIONS: *----------------------------------------------------------------------------------------------------------- * column name datatype description * .............................. .............. ............................................................ * discovery_name varchar(40) Discovery name used at the NPD. * * current_activity_status varchar(40) The current status of the discovery. * Examples: * SHUT DOWN * PRODUCING * PDO APPROVED * DECIDED BY THE LICENSEES * PLANNING PHASE * DEVELOPMENT LIKELY BUT NOT CLARIFIED * DEVELOPMENT IS NOT VERY LIKELY * NEW DISCOVERIES, NOT EVALUATED * INCLUDED IN OTHER DISCOVERY/FIELD * * discovery_wellbore_name varchar(41) Official name of the discovery wellbore * * discovery_year int Normally the year in which the discovery wellbore was * completed or suspended, but in some instances the year * in which the resources were discovered and the discovery * announced, if the wellbore was completed or suspended at * a much later date. * * date_generated date The date the download file was generated from the NPD's * databases. * * NPDID_discovery bigint NPD's unique discovery id. * * NPDID_wellbore bigint NPD's unique discovery wellbore id. * *----------------------------------------------------------------------------------------------------------- * HISTORY: *----------------------------------------------------------------------------------------------------------- * date changed by description * .......... ........... ................................................................................... * 15.01.2003 OHO/NPD Initial version * * dd.mm.yyyy nnn/ccc description of changes *===========================================================================================================