BUSINESS ARRANGEMENT AREA (BAA) – attribute description

hide details Export:  EXCEL

• Main level

  Main level

  Heading	Description	Tag	Data type
  NPDID Bsns. Arr. Area	NPD's unique id for business arrangement areas	baaNpdidBsnsArrArea	int
  Name	The business arrangement area's official name.	baaName	varchar(40)
  Kind	Kind of business arrangement area. Example of legal values: PARCELL, SEISMIC AREA, SLIDING SCALE, UNITIZED	baaKind	varchar(40)
  Date approved	The date the agreement for the business arrangement area was approved by the Norwegian authorities.	baaDateApproved	datetime
  Date valid from	The date the agreement for the business arrangement area is valid from, according to the approval of the Norwegian authorities.	baaDateValidFrom	datetime
  Date valid to	The date the agreement for the business arrangement area is valid to, according to the approval of the Norwegian authorities.	baaDateValidTo	datetime
  Active	Indicator which tells if the business arrangement area currently is active.	baaActive	varchar(1)
  Fact page	URL to the business arrangement area's FactPage on the NPD's FactWEB	baaFactPageUrl	varchar(200)
  Factmaps	URL to the business arrangement area's FactMap on the NPD's FactWEB	baaFactMapUrl	varchar(200)
  Publish on internet	Indicator which tells if information about the business arrangement area can be published on internet	baaPublishOnInternet	varchar(5)
  Operator	The operating company's official name.	cmpLongName	varchar(100)
  Company FactPage	URL to the operating company's FactPage on NPD's FactWeb	cmpFactPageUrl	varchar(200)
  NPDID company	NPD's unique id for companies	cmpNpdidCompany	int
  Date main level updated	Date when information about this business agreement area was last updated or inserted for the first time.The date will only be changed if the data in the 'Main level' in the tab 'BAA' will be changed.	baaDateUpdated	datetime
  Date all updated	Date when any information about this business area was last updated or inserted for the first time. The date also will bli change if some of the data in the 'Sub levels' in the tab 'BAA' will be changed.	baaDateUpdatedMax	datetime

• Sub level – Licencees

  Sub level – Licencees

  Heading	Description	Tag	Data type
  NPDID Bsns. Arr. Area	NPD's unique id for business arrangement areas	baaNpdidBsnsArrArea	int
  NPDID company	NPD's unique id for companies	cmpNpdidCompany	int
  Name	The business arrangement area's official name.	baaName	varchar(40)
  Company longname	The company's official name.	cmpLongName	varchar(100)
  Date valid from	The date the company's interest in the business arrangement area is valid from	baaLicenseeDateValidFrom	datetime
  Date valid to	The date the company's interest in the business arrangement area is valid to	baaLicenseeDateValidTo	datetime
  Interest [%]	The company's share in percent.	baaLicenseeInterest	decimal
  SDFI [%]	The Norwegian State's Direct Financial Interest in percent (only for the history)	baaLicenseeSdfi	decimal
  Company FactPage	URL to the company's FactPage on NPD's FactWeb	cmpFactPageUrl	varchar(200)
  Fact page	URL to the business arrangement area's FactPage on NPD's FactWEB	baaFactPageUrl	varchar(200)
  Date updated	Date when this record was updated last or inserted the first time.	baaLicenseeDateUpdated	datetime

• Sub level – Operators

  Sub level – Operators

  Heading	Description	Tag	Data type
  NPDID Bsns. Arr. Area	NPD's unique id for business arrangement areas	baaNpdidBsnsArrArea	int
  NPDID company	NPD's unique id for companies	cmpNpdidCompany	int
  Name	The business arrangement area's official name.	baaName	varchar(40)
  Company longname	The company's official name.	cmpLongName	varchar(100)
  Date valid from	The date the company's operatorship of the business arrangement area is valid from	baaOperatorDateValidFrom	datetime
  Date valid to	The date the company's operatorship of the business arrangement area is valid to	baaOperatorDateValidTo	datetime
  Company FactPage	URL to the company's FactPage on NPD's FactWeb	cmpFactPageUrl	varchar(200)
  Date updated	Date when this record was updated last or inserted the first time.	baaOperatorDateUpdated	datetime

• Sub level – Licencees transfer

  Sub level – Licencees transfer

  Heading	Description	Tag	Data type
  NPDID Bsns. Arr. Area	NPD's unique id for business arrangement areas	baaNpdidBsnsArrArea	int
  NPDID company	NPD's unique id for companies	cmpNpdidCompany	int
  Name	The business arrangement area's official name.	baaName	varchar(40)
  Fact page	URL to the business arrangement area's FactPage on NPD's FactWEB	baaFactPageUrl	varchar(200)
  Date valid from	The date the transfer is valid from	baaTransferDateValidFrom	datetime
  Transfer direction	Direction of the transfer. Example of legal values: FROM, TO	baaTransferDirection	varchar(4)
  Type of change	Type of change. Example of legal values: CHANGE OF COMPANY NAME, TRANSFER, MERGER/TAKEOVER.	baaTransferKind	varchar(40)
  Company name	The company's official name.	cmpLongName	varchar(100)
  Company fact page	URL to the company's FactPage on NPD's FactWEB	cmpFactPageUrl	varchar(200)
  Transferred interest [%]	Transferred interest in percent	baaTransferredInterest	decimal
  SDFI [%]	The Norwegian State's Direct Financial Interest in percent (only for the history)	baaTransferSdfi	decimal
  Date updated	Date when this record was updated last or inserted the first time.	baaTransferDateUpdated	datetime

• Sub level – Areas

  Sub level – Areas

  Heading	Description	Tag	Data type
  NPDID Bsns. Arr. Area	NPD's unique id for business arrangement areas	baaNpdidBsnsArrArea	int
  Name	The business arrangement area's official name.	baaName	varchar(40)
  Kind	Kind of business arrangement area. Example of legal values: PARCELL, SEISMIC AREA, SLIDING SCALE, UNITIZED	baaKind	varchar(40)
  Fact page	URL to the business arrangement area's FactPage on NPD's FactWEB	baaFactPageUrl	varchar(200)
  Date valid from	The date the polygon area is valid from	baaAreaPolyDateValidFrom	datetime
  Date valid to	The date the polygon area is valid to	baaAreaPolyDateValidTo	datetime
  Production licence	Name of the production licence	prlName	varchar(40)
  License Factpage	URL to the production licence's FactPage on NPD's FactWEB	prlFactPageUrl	varchar(200)
  Nation code	2 letter nation code (ISO) for the nation the polygon belongs to	baaAreaPolyNationCode2	varchar(2)
  Block name	Block name	baaAreaPolyBlockName	varchar(40)
  Polygon area [km2]	Polygon area in square kilometers	baaAreaPolyArea	decimal
  Date updated	Date when this record was updated last or inserted the first time.	baaAreaPolyDateUpdated	datetime