*=========================================================================================================== * The Norwegian Petroleum Directorate's Fact-Pages. Description of download file. *=========================================================================================================== * CONTENTS: Business area. General information. *----------------------------------------------------------------------------------------------------------- * CSV SPECIFICATIONS: *----------------------------------------------------------------------------------------------------------- * - column delimiter : , * - text qualifier : " * - decimal separator : . * - date format : dd.mm.yyyy *----------------------------------------------------------------------------------------------------------- * COLUMN SPECIFICATIONS: *----------------------------------------------------------------------------------------------------------- * column name datatype description * .............................. .............. ........................................................ * business_area_name varchar(40) The designation of the business arrangement based area. * * business_area_kind varchar(40) Kind of business arrangement based area. * Examples: * - UNITIZED * - SLIDING SCALE * - PARCELL * - SEISMIC AREA * * date_approved date The date the business arrangement based area was approved * by the authorities. * * date_valid_from date The date the business arrangement based area is valid from. * * date_valid_to date The date the business arrangement based area is valid to * according to the approval of the authorities. * NULL indicates that the business area is active. * * date_generated date The date the download file was generated from the NPD's * databases. * * NPDID_business_area bigint NPD's unique business area id. * *----------------------------------------------------------------------------------------------------------- * HISTORY: *----------------------------------------------------------------------------------------------------------- * date changed by description * .......... ........... ................................................................................... * 01.01.2003 OHO/NPD Initial version * * dd.mm.yyyy nnn/ccc description of changes *===========================================================================================================