*=========================================================================================================== * The Norwegian Petroleum Directorate's Fact-Pages. Description of download file. *=========================================================================================================== * CONTENTS: Production licence. General information. *----------------------------------------------------------------------------------------------------------- * CSV SPECIFICATIONS: *----------------------------------------------------------------------------------------------------------- * - column delimiter : , * - text qualifier : " * - decimal separator : . * - date format : dd.mm.yyyy *----------------------------------------------------------------------------------------------------------- * COLUMN SPECIFICATIONS: *----------------------------------------------------------------------------------------------------------- * column name datatype description * .............................. .............. ............................................................ * production_licence_name varchar(40) Production licence name. * * licensing_activity varchar(40) The official designation of the licensing activity or * of the granting of production licences * outside such licensing activities (OLA). * * date_granted date The date the production licence was granted. * * date_valid_to date The date the production licence is valid to/expires * according to the latest approved extension. * * original_area real Original area of the production licence. * Unit of measure: km2 * * current_area real Current area after parts of the original area, if any, * have been relinquished. * Unit of measure: km2 * * 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. * *----------------------------------------------------------------------------------------------------------- * HISTORY: *----------------------------------------------------------------------------------------------------------- * date changed by description * .......... ........... ................................................................................... * 23.01.2003 OHO/NPD Initial version * * dd.mm.yyyy nnn/ccc description of changes *===========================================================================================================