Factpages Norwegian petroleum directorate
Factpages Norwegian petroleum directorate
Factpages Norwegian petroleum directorate
NPD    Norsk
NPD          Norsk
04.12.2023 - 10:15
Time of last synchronization with NPD's internal systems

LICENCE – attribute description

Export: EXCEL icon EXCEL

  • Main level
    Main level
    Heading
    Description
    Tag
    Data type
    NPDID production licence
    NPD's unique id for production licences
    prlNpdidLicence
    int
    NPDID licensing activity
    NPD's unique id for licensing activities
    lcaNpdidLicensingActivity
    int
    Production licence
    Name of the production licence
    prlName
    varchar(40)
    Licensing activity
    Name of the licensing activity the production licence was awarded in.
    prlLicensingActivityName
    varchar(40)
    Status
    Current status of production licence. Example of legal values: ACTIVE, INACTIVE
    prlStatus
    varchar(40)
    Stratigraphical
    Indicates if the licence has vertical limitations based on stratigraphy. 'NO' means no such limitations, 'YES OR PARTLY' means that either whole or parts of the licence has such limitations.
    prlStratigraphical
    varchar(40)
    Active
    Indicator telling if the production licence is active. Example of legal values: Y, N
    prlActive
    varchar(1)
    Fact page
    URL to the production licence's FactPage on NPD's FactWEB
    prlFactPageUrl
    varchar(200)
    Factmaps
    URL to the production licence's FactMap on NPD's FactWEB
    prlFactMapUrl
    varchar(200)
    Date granted
    Date the production licence was granted by the Norwegian authorities.
    prlDateGranted
    datetime
    Date valid to
    Date the production licence is valid to.
    prlDateValidTo
    datetime
    Original area [km2]
    Original area of the production licence in square kilometres.
    prlOriginalArea
    decimal
    Current area [km2]
    Current area of the production licence in square kilometres.
    prlCurrentArea
    decimal
    Phase - current
    Current phase for the prodcution licence. Examples of legal values: INITIAL; INITIAL EXTENDED; PRODUCTION; PRODUCTION EXTENDED.
    prlPhaseCurrent
    varchar(40)
    Main area
    Name of the area on the Norwegian Continental Shelf where the wellbore is located. Example of legal values: Barents Sea, Norwegian Sea, North Sea
    prlMainArea
    varchar(40)
    Expiry date, initial period
    Expiry date of the initial period of the production licence
    prlDateInitialPeriodExpires
    datetime
    In initial period
    Indicator which tells if the production licence is in the initial period
    prlInitialPeriod
    varchar(4)
    Date last changed
    Date the production licence was changed in NPD's database
    prlDateLastChanged
    datetime
    Operator 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
    Operator
    The operating company's official name.
    cmpLongName
    varchar(200)
    Date main level updated
    Date when this production licences 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 'Licence' will be changed.
    prlDateUpdated
    datetime
    Date all updated
    Date when any information about this production licences 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 'Licence' will be changed.
    prlDateUpdatedMax
    datetime

  • Sub level – Phases
    Sub level – Phases
    Heading
    Description
    Tag
    Data type
    NPDID production licence
    NPD's unique id for production licences
    prlNpdidLicence
    int
    Production licence
    Name of the production licence
    prlName
    varchar(40)
    Active
    Indicator which tells if the production licence is active. Example of legal values: ACTIVE, INACTIVE
    prlActiveStatusIndicator
    varchar(40)
    Date granted
    Date the production licence was granted by the Norwegian authorities.
    prlDateGranted
    datetime
    Date valid to
    Date the production licence is valid to.
    prlDateValidTo
    datetime
    Expiry date, initial period
    Expiry date of the initial period of the production licence
    prlDateInitialPeriodExpires
    datetime
    Date phase valid from
    Date the phase is valid from
    prlDatePhaseValidFrom
    datetime
    Date phase valid to
    Date the phase is valid to
    prlDatePhaseValidTo
    datetime
    Phase
    Phase. Example of legal values: INITIAL, INITIAL EXTENDED, PRODUCTION, PRODUCTION EXTENDED
    prlPhase
    varchar(40)
    Date updated
    Date when this record was updated last or inserted the first time.
    prlPhaseDateUpdated
    datetime

  • Sub level – Work obligations
    Sub level – Work obligations
    Heading
    Description
    Tag
    Data type
    Description (norwegian)
    Name of task as given by the NPD. This task is a part of the work obligations (initial phase) or conditions(production phase) of the production licence.
    prlTaskName
    varchar(40)
    Type of task
    Type of task. Examples of legal values:Relinquishment report;Seismic acquisition;Seismic reprocessing;EM acquisition;Status workobligations to MPE/NPD;Study of geology and geophysics;Seismology - collecting, reprocessing, interpretation;Decision to drill;Drilling;Decision to prepare a plan for development;Hand in plan for development;The expiry of initial period.
    prlTaskTypeEn
    varchar(200)
    Category
    Category. Legal values are 'WORKOBLIGATION" or"DESICION".
    prlTaskCategory
    varchar(200)
    Task status
    Task status. Example of legal values: Approved; Dropped; Not to be drilled, Will be drilled.
    prlTaskStatusEn
    varchar(40)
    Expiry date
    Date when the task exprires.
    prlTaskExpiryDate
    datetime
    Production licence
    Name of the production licence.
    prlName
    varchar(40)
    Date valid to for production licence
    Date the production licence is valid to.
    prlDateValidTo
    datetime
    Licensing activity
    Name of the licensing activity the production licence was awarded in.
    prlLicensingActivityName
    varchar(40)
    Operator longname - current
    The operating company's official name. For inactive licences are last operator are given.
    cmpLongName
    varchar(200)
    Wellbore if drilled
    Result wellbore if positiv desicion to drill. If 'Task status' is 'Will be drilled', the name of the wellbore will be given here.
    wlbName
    varchar(40)
    Task ID
    Unique identification of the task.
    prlTaskID
    varchar(40)
    Referred task ID
    Unique key if this task is dependent of another task. An example: a task of type 'Drilling' is dependent of another task of type 'Decision to drill'. See production licence 085 D for example.
    prlTaskRefID
    varchar(40)
    NPDID production licence
    NPD's unique id for production licences.
    prlNpdidLicence
    int
    NPDID company - current
    NPD's unique id for companies.
    cmpNpdidCompany
    int
    Date updated
    Date when this record was updated last or inserted the first time.
    prlTaskDateUpdated
    datetime

  • Sub level – Licensees
    Sub level – Licensees
    Heading
    Description
    Tag
    Data type
    NPDID production licence
    NPD's unique id for production licences
    prlNpdidLicence
    int
    NPDID company
    NPD's unique id for companies
    cmpNpdidCompany
    int
    Production licence
    Name of the production licence
    prlName
    varchar(40)
    Company longname
    The company's official name.
    cmpLongName
    varchar(100)
    Date valid from
    Date the company's interest in the production licence is valid from
    prlLicenseeDateValidFrom
    datetime
    Date valid to
    Date the company's interest in the production licence is valid to
    prlLicenseeDateValidTo
    datetime
    Operator from date
    Date for when the company was operator in the production licence is valid from
    prlOperDateValidFrom
    datetime
    Operator to date
    Date for when the company was operator in the production licence is valid to
    prlOperDateValidTo
    datetime
    Interest [%]
    The company's share in percent.
    prlLicenseeInterest
    decimal
    SDFI [%]
    The Norwegian State's Direct Financial Interest in percent (only for the history)
    prlLicenseeSdfi
    decimal
    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.
    prlLicenseeDateUpdated
    datetime

  • Sub level – Licencees transfer
    Sub level – Licencees transfer
    Heading
    Description
    Tag
    Data type
    NPDID production licence
    NPD's unique id for production licences
    prlNpdidLicence
    int
    NPDID company
    NPD's unique id for companies
    cmpNpdidCompany
    int
    Production licence
    Name of the production licence
    prlName
    varchar(40)
    Date valid from
    Date the transfer is valid from
    prlTransferDateValidFrom
    datetime
    Transfer direction
    Direction of the transfer. Example of legal values: FROM, TO
    prlTransferDirection
    varchar(4)
    Type of change
    Type of change. Example of legal values: CHANGE OF COMPANY NAME, TRANSFER, MERGER/TAKEOVER.
    prlTransferKind
    varchar(40)
    Type of change, NPD
    Type of change, NPD internal. Example of legal values: CHANGE OF COMPANY NAME, TRANSFER, MERGER/TAKEOVER.
    prlNpdTransferKind
    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
    prlTransferredInterest
    decimal
    SDFI [%]
    The Norwegian State's Direct Financial Interest in percent (only for the history)
    prlTransferSdfi
    decimal
    Fact page
    URL to the FactPage on NPD's FactPages for the production licence
    prlFactPageUrl
    varchar(200)
    Date updated
    Date when this record was updated last or inserted the first time.
    prlTransferDateUpdated
    datetime

  • Sub level – Operatorships
    Sub level – Operatorships
    Heading
    Description
    Tag
    Data type
    NPDID production licence
    NPD's unique id for production licences
    prlNpdidLicence
    int
    NPDID company
    NPD's unique id for companies
    cmpNpdidCompany
    int
    Production licence
    Name of the production licence
    prlName
    varchar(40)
    Company shortname
    Company shortname, used by NPD.
    cmpShortName
    varchar(40)
    Company longname
    The company's official name.
    cmpLongName
    varchar(100)
    Date valid from
    Date the company's operatorship is valid from
    prlOperDateValidFrom
    datetime
    Date valid to
    Date the company's operatorship is valid to
    prlOperDateValidTo
    datetime
    Company FactPage
    URL to the company's FactPage on NPD's FactWeb
    cmpFactPageUrl
    varchar(200)
    FactPage
    URL to the FactPage on NPD's FactPages for the production licence
    prlFactPageUrl
    varchar(200)
    Date updated
    Date when this record was updated last or inserted the first time.
    prlOperDateUpdated
    datetime

  • Sub level – Area
    Sub level – Area
    Heading
    Description
    Tag
    Data type
    NPDID production licence
    NPD's unique id for production licences
    prlNpdidLicence
    int
    Production licence
    Name of the production licence
    prlName
    varchar(40)
    Stratigraphcal
    Indicator which tells if the production licence is stratigraphical or not. A stratigraphical production licence is vertically limited by stratigraphic units (upper an lower). This means that many production licences may cover the same area on a 2D map. Legal values: YES, NO
    prlAreaPolyStratigraphical
    varchar(4)
    Date valid from
    First day the area of a polygon in a production license is valid from. With changes in area while a production license is active, the new date of the polygon will be set in accordance with the Ministry of Oil and Energy’s decision. In the initial period, parts of a license may be relinquished with 3 months notice. Changes in area in a production license which is in the extension period can only be made at the end of each calendar year. The remaining area in the polygon is valid from January 1st the following year. Ref Petroleum Act, section 3.14.
    prlAreaPolyDateValidFrom
    datetime
    Date valid to
    Automatically set by the system. By relinquishment of an area in a production license this date is equal to the “Polygon valid from date” for the remaining area in the polygon.
    prlAreaPolyDateValidTo
    datetime
    Nation code
    2 letter nation code (ISO) for the nation the polygon belongs to
    prlAreaPolyNationCode
    varchar(2)
    Block name
    Block name
    prlAreaPolyBlockName
    varchar(40)
    Polygon area [km2]
    Polygon area in square kilometres
    prlAreaPolyPolyArea
    decimal
    Vertical limitations
    Description of vertical limitations of the polygon in English. Used only for stratigraphical production licences
    prlAreaPolyVertLimEn
    varchar(2000)
    Vertical limitation, from
    From relative depth (0 - 100)
    prlAreaPolyFromZvalue
    numeric
    Vertical limitation, to
    To relative depth (0 - 100)
    prlAreaPolyToZvalue
    numeric
    Operator Name
    Name of the company that is currently operator of the licence
    cmpLongName
    varchar(200)
    Date updated
    Date when this record was updated last or inserted the first time.
    prlAreaDateUpdated
    datetime

  • Sub level – Petroleum register , Main level
    Sub level – Petroleum register , Main level
    Heading
    Description
    Tag
    Data type
    Tillatelse
    Navn på tillatelsen i Petroleumsregisteret.
    ptlName
    varchar(40)
    NPDID for utvinningstillatelser
    ODs entydige nøkkel for utvinningstillatelser.
    prlNpdidLicence
    int
    Gyldig fra dato
    Dato tillatelsen er gyldig fra.
    ptlDateValidFrom
    datetime
    Gyldig til dato
    Dato tillatelsen er gyldig til.
    ptlDateValidTo
    datetime
    Dato for tildeling
    Dato tillatelsen ble tildelt av norske myndigheter.
    ptlDateAwarded
    datetime
    Dato hovednivå oppdatert
    Dato for når informasjon om denne Petroleumsregister tillatelsen ble oppdatert sist eller lagt inn for første gang. Datoen vil bare bli forandret dersom data i 'Hovednivå' blir forandret.
    ptlDateUpdated
    datetime
    Dato alle oppdatert
    Dato når noe informasjon om denne Petroleumsregister tillatelsen ble oppdatert sist eller lagt inn for første gang. Datoen vil også bli forandret dersom data i noen av 'Undernivåene' blir forandret.
    ptlDateUpdatedMax
    datetime

  • Sub level – Petroleum register , Licencees
    Sub level – Petroleum register , Licencees
    Heading
    Description
    Tag
    Data type
    Tillatelse
    Navn på tillatelsen i Petroleumsregisteret.
    ptlName
    varchar(40)
    NPDID for utvinningstillatelser
    ODs entydige nøkkel for utvinningstillatelser.
    prlNpdidLicence
    int
    NPDID for selskap
    ODs entydige nøkkel for selskap.
    cmpNpdidCompany
    int
    TUF
    Navn på transport og utnyttelsesanlegget.
    tufName
    varchar(40)
    Selskap
    Selskapets offisielle navn.
    cmpLongName
    varchar(100)
    Andel [%]
    Selskapets andel i prosent.
    ptlLicenseeInterest
    numeric
    Dato oppdatert
    Dato når denne posten ble oppdatert sist eller lagt inn for første gang.
    ptlLicenseeDateUpdated
    datetime

  • Sub level – Petroleum register , Operatorship
    Sub level – Petroleum register , Operatorship
    Heading
    Description
    Tag
    Data type
    Tillatelse
    Navn på tillatelsen i Petroleumsregisteret.
    ptlName
    varchar(40)
    NPDID for utvinningstillatelser
    ODs entydige nøkkel for utvinningstillatelser.
    prlNpdidLicence
    int
    NPDID for selskap
    ODs entydige nøkkel for selskap.
    cmpNpdidCompany
    int
    TUF
    Navn på transport og utnyttelsesanlegget.
    tufName
    varchar(40)
    Selskap
    Selskapets offisielle navn.
    cmpLongName
    varchar(100)
    Dato oppdatert
    Dato når denne posten ble oppdatert sist eller lagt inn for første gang.
    ptlOperDateUpdated
    datetime

  • Sub level – Petroleum register , Messages
    Sub level - Status reports
    Sub level – Petroleum register , Messages
    Heading
    Description
    Tag
    Data type
    Tillatelse
    Navn på tillatelsen i Petroleumsregisteret.
    ptlName
    varchar(40)
    NPDID for utvinningstillatelser
    ODs entydige nøkkel for utvinningstillatelser.
    prlNpdidLicence
    int
    Utdrag av dokument
    Utdrag av dokumentet, orginal dokumentet er registert i OD
    ptlMessage
    varchar(2000)
    Merknad
    Merknad. Hvis ikke meldingen er konferert (kvalitetskontrollert) i OD, vil det stå 'Ikke konferert', ellers er dette feltet blankt.
    ptlMessageRemark
    varchar(14)
    Type
    Type dokument. Eksempel på lovlig verdier: Heftelse,Ny tillatelse, Endring i tillatelse,Sletting av heftelse, Andre meldinger.
    ptlMessageKindDesc
    varchar(2000)
    Registreringsdato
    Dato dokumentet er registret i Petroleumsregisteret.
    ptlMessageRegisteredDate
    datetime
    TUF
    Navn på transport og utnyttelsesanlegget.
    tufName
    varchar(40)
    Dato oppdatert
    Dato når denne posten ble oppdatert sist eller lagt inn for første gang.
    ptlMessageDateUpdated
    datetime
    Sub level – Petroleum register , Messages
    Heading
    Description
    Tag
    Data type
    NPDID_licence
    NPD's unique ID for the licence
    prlNPDID_licence
    int
    Licence
    Official licence name
    prlName
    varchar(40)
    Document name
    Licence document name
    prlDocumentName
    varchar(200)
    Document type
    Licence document type
    prlDocumentType
    varchar(40)
    Document URL
    Licencen document URL
    prlDocumentUrl
    varchar(200)
    Document format
    Licence document format
    prlDocumentFormat
    varchar(40)
    Document size [MB]
    Licence document size
    prlDocumentSize
    numeric
    Date updated
    Date when this record was last updated
    prlDocumentDateUpdated
    datetime