*=========================================================================================================== * The Norwegian Petroleum Directorate's Fact-Pages. Description of download file. *=========================================================================================================== * CONTENTS: Field. General information. *----------------------------------------------------------------------------------------------------------- * CSV SPECIFICATIONS: *----------------------------------------------------------------------------------------------------------- * - column delimiter : , * - text qualifier : " * - decimal separator : . * - date format : dd.mm.yyyy *----------------------------------------------------------------------------------------------------------- * COLUMN SPECIFICATIONS: *----------------------------------------------------------------------------------------------------------- * column name datatype description * .............................. .............. ............................................................ * field_name varchar(40) Official field name. * * current_activity_status varchar(40) The current status of the field. * Examples: * SHUT DOWN * PRODUCING * PDO APPROVED * * discovery_wellbore_name varchar(41) Official name of the discovery wellbore. * * date_disc_wb_completion date Completion date of the discovery wellbore. * * date_generated date The date the download file was generated from the NPD's * databases. * * NPDID_field bigint NPD's unique field id. * * NPDID_wellbore bigint NPD's unique discovery wellbore id. * * current_owner_type varchar(40) The type of current owner. Not available for SHUT DOWN * fields. * Examples: * PRODUCTION LICENCE * BUSINESS AREA * * current_owner_name varchar(40) Official name of current owner (PRODUCTION LICENCE or * BUSINESS AREA). Not available for SHUT DOWN fields. * * NPDID_current_owner bigint NPD's unique id for current owner (NPDID_production_licence * or NPDID_business_area). Not available for SHUT DOWN fields. * *----------------------------------------------------------------------------------------------------------- * HISTORY: *----------------------------------------------------------------------------------------------------------- * date changed by description * .......... ........... ................................................................................... * 15.01.2003 OHO/NPD Initial version * * 27.03.2007 OHO/NPD New columns: current_owner_type, current_owner_name, NPDID_current_owner * * dd.mm.yyyy nnn/ccc description of changes *===========================================================================================================