*=========================================================================================================== * The Norwegian Petroleum Directorate's Fact-Pages. Description of download file. *=========================================================================================================== * CONTENTS: Company. General information. *----------------------------------------------------------------------------------------------------------- * CSV SPECIFICATIONS: *----------------------------------------------------------------------------------------------------------- * - column delimiter : , * - text qualifier : " * - decimal separator : . * - date format : dd.mm.yyyy *----------------------------------------------------------------------------------------------------------- * COLUMN SPECIFICATIONS: *----------------------------------------------------------------------------------------------------------- * column name datatype description * .............................. .............. ............................................................ * company_short_name varchar(40) Company short name used at the NPD. * * company_long_name varchar(100) Company long name. * * org_number_brreg varchar(100) Organisation number used in Brønnøysund-registeret * (www.brreg.no) * * date_generated date The date the download file was generated from the NPD's * databases. * * NPDID_company bigint NPD's unique company id. * * group_designation varchar(40) Group designation of the company. * *----------------------------------------------------------------------------------------------------------- * HISTORY: *----------------------------------------------------------------------------------------------------------- * date changed by description * .......... ........... ................................................................................... * 01.01.2003 OHO/NPD Initial version * * 22.09.2003 OHO/NPD Included group designation * * dd.mm.yyyy nnn/ccc description of changes *===========================================================================================================