Factpages Norwegian petroleum directorate
NPD          Norsk

WELLBORE – attribute description

Export: 
  • Main level

    Main level
    Heading
    Description
    Tag
    Data type
    Wellbore name
    Official name of wellbore based on NPD guidelines for designation of wells and wellbores.
    wlbWellboreName
    varchar(40)
    NPDID wellbore
    NPD's unique id for the wellbore.
    wlbNpdidWellbore
    int
    Well name
    Official name of the parent well for the wellbore based on NPD guidelines for designation of wells and wellbores.
    wlbWell
    varchar(40)
    Drilling operator
    Name of the licensee starting the drilling operation on behalf of the active production license (well head position). This will usually equal the operator of the production license.
    wlbDrillingOperator
    varchar(60)
    Drilling operator, url
    URL to the drilling opeators FactPage on NPD's FactWEB
    cmpFactPageUrl
    varchar(200)
    NPDID drilling operator
    NPD's unique id for companies
    cmpNpdidCompany
    int
    Production licence
    Official designation of the production licence the wellbore was drilled or planned to be drilled from ( well head posistion).
    wlbProductionLicence
    varchar(40)
    Purpose
    Final classification of the wellbore.

    Legal values for exploration wellbores:
    WILDCAT, APPRAISAL, WILDCAT-CCS, APPRAISAL-CCS.

    Legal values for development wellbores:
    OBSERVATION, PRODUCTION, INJECTION, INJECTION-CCS, OBSERVATION-CCS.

    Legal values for other wellbores:
    SOIL DRILLING (drilling in connection with track surveys and other subsurface surveys to investigate the soil conditions prior to placement of facilities),
    SHALLOW GAS (drilling to investigate shallow gas before the first 'real' drilling on the location),
    PILOT (drilling to investigate the geology and fluid connectors for location of the main wellbore),
    SCIENTIFIC (drilling according to Law of Scientific research and exploration),
    STRATIGRAPHIC (driling according to Law of Petroleum activities §2-1).
    wlbPurpose
    varchar(40)
    Status
    Status for the wellbore. Legal values are:

    BLOWOUT: A blowout has occurred in the well.
    CLOSED: A development wellbore that has been closed in a shorter or longer periode. Also applies to development wellbores where drilling is completed, but production/injection has not yet been reported.
    DRILLING: The well is in the drilling phase - can be active drilling, logging, testing or plugging,
    JUNKED: The drilling operation has been terminated due to technical problems.
    P&A: Exploration: The well is plugged and abandoned, and can not be reentered for further use. Development wells: The production/injection from/to the well is stopped and the well is plugged. The wellhead is removed or else made unavailable for further well operations.
    PLUGGED: The wellbore has been plugged, but the upper parts of the wellbore can be re-used. A sidetrack might be drilled at a later stage.
    PRODUCING: It was produced from the wellbore at the time of the operators last monthly report to the NPD.
    INJECTING: It was injected to the wellbore at the time of the operators last monthly report to the NPD.
    PREDRILLED: The upper part of the well has been drilled, usually as part of a batch-drilling campaign covering several wellbores.
    RE-CLASS TO DEV: Exploration wellbore that is reclassified to a development wellbore.
    RE-CLASS TO TEST: Exploration wellbore that is reclassified to test production.
    SUSPENDED: The drilling operation in the wellbore has been temporarily stopped. The current plan is to continue drilling later on.
    wlbStatus
    varchar(40)
    Content
    For exploration wellbores, status of discovery.

    Legal values:
    DRY, SHOWS (trace amounts of hydrocarbons), GAS, GAS/CONDENSATE, OIL or OIL/GAS.
    SHOWS (GAS SHOWS, OIL SHOWS or OIL/GAS SHOWS) are detected as fluorescent cut (organic extract), petroleum odour, or visual stain on cuttings or cores, or as increased gas reading on the mud-loggers gas detection equipment.
    Legal values for WILDCAT-CCS and APPRAISAL-CCS: WATER

    For development wellbores, type of produced/injected fluid.
    Legal values:
    WATER, CUTTINGS, NOT AVAILABLE, OIL, GAS/CONDENSATE, OIL/GAS, CO2, GAS, WATER/GAS, NOT APPLICABLE.
    wlbContent
    varchar(40)
    Type
    Wellbore type. Legal values: EXPLORATION, DEVELOPMENT, OTHER (see 'Purpose' for more information)
    wlbWellType
    varchar(20)
    Entered date
    The date when he wellbore was spudded. For sidetracks: The date when new formation was drilled by kicking off from the mother-wellbore,
    wlbEntryDate
    datetime
    Completed date
    Exploration wellbores from moveable facilities:
    For floating facilities - date when anchor handling is started. For jackups - date the jacking-down started. Exploration wellbores from fixed facilities and all development wellbores:
    Date when the wellbore is at total depth, and last casing, liner or screen is set. In case of immediate plugging of the wellbore, completed date equals the date the last plug i set in the wellbore.
    Date when the wellbore is at total depth, and last casing, liner or screen is set. In case of immediate plugging of the wellbore, completed date equals the date the last plug i set in the wellbore.
    wlbCompletionDate
    datetime
    Field
    Name of the field the wellbore is related to.
    wlbField
    varchar(40)
    Drill permit
    The drilling permit number together with the version of the drilling permit as stated in the drilling permit granted by the NPD.
    wlbDrillPermit
    varchar(10)
    Discovery
    Name of the discovery the wellbore is related to.
    wlbDiscovery
    varchar(40)
    Discovery wellbore
    Indicator which telles if the wellbore made a new discovery. Legal values: YES, NO.
    wlbDiscoveryWellbore
    varchar(3)
    Bottom hole temperature [°C]
    Estimated temperature at final total depth of the wellbore. Shown only for released wells. See discription.
    wlbBottomHoleTemperature
    int
    Seismic location
    Position of spud location on seismic survey lines. SP: shotpoint.
    wlbSeismicLocation
    varchar(200)
    Maximum inclination [°]
    Maximum deviation, in degrees, from a vertical well path.Shown only for released wells.
    wlbMaxInclation
    real
    Kelly bushing elevation [m]
    Elevation of the rotary kelly bushing (RKB) above mean sea level.
    wlbKellyBushElevation
    numeric
    Kick off point [m RKB]
    Depth (in mMD) where a new wellbore is kicked-off from the previous wellbore towards a new geological target. Kick-off depth is defined by the depth at which cutting samples shows more than 50% of new formation when drilling out of a casing, plug or kicking-off from the mother-wellbore. Other indications include measurements done near-bit.
    wlbKickOffPoint
    numeric
    Final vertical depth (TVD) [m RKB]
    Vertical elevation from total depth to kelly bushing. Shown only for released wells. Referred to as true vertical depth (TVD).
    wlbFinalVerticalDepth
    real
    Total depth (MD) [m RKB]
    Total measured length of wellbore from kelly bushing to total depth (driller's depth).
    wlbTotalDepth
    numeric
    Water depth [m]
    Depth in metres betweem mean sea level and sea floor.
    wlbWaterDepth
    numeric
    Oldest penetrated age
    Age (according to Geologic Time Scale 2004 by F. M. Gradstein, et al. (2004)) of the oldest penetrated formation. May differ from age at TD for example in deviated wellbores. Examples of legal values: CRETACEOUS, EARLY CRETACEOUS, LATE JURASSIC, EARLY PERMIAN, EARLY TRIASSIC, EOCENE.
    wlbAgeAtTd
    varchar(40)
    Oldest penetrated formation
    Name of the oldest lithostratigraphic unit penetrated by the wellbore. Shown only for released wells. In most wellbores this is formation or group at total depth. May differ from formation or group at TD for example in wellbores drilled with high deviation or through faults. Examples of legal values: AMUNDSEN FM, BALDER FM, BASEMENT, BLODØKS FM, BRYNE FM, BURTON FM, COOK FM, DRAKE FM, DRAUPNE FM, EKOFISK FM, DUNLIN GP.
    wlbFormationAtTd
    varchar(40)
    Main area
    Name of the area on the Norwegian Continental Shelf where the wellbore is located. Legal values: BARENTS SEA, NORWEGIAN SEA, NORTH SEA.
    wlbMainArea
    varchar(40)
    Drilling facility
    NPD's name of the facility which the wellbore was drilled from.
    wlbDrillingFacility
    varchar(50)
    Drilling facility category
    Indicates if a moveable or fixed facility drilled the well. Legal values ' FIXED' or 'MOVEABLE'
    wlbDrillingFacilityFixedOrMoveable
    varchar(10)
    Drilling facility type
    Kind of drilling facility. Example of legal values: CONCRETE STRUCTURE, CONDEEP 3 SHAFTS, CONDEEP 4 SHAFTS, CONDEEP MONOSHAFT, JACKET 12 LEGS, JACKET 4 LEGS, JACKET 6 LEGS, JACKET 8 LEGS, JACK-UP 3 LEGS, JACK-UP 4 LEGS, SEMISUB STEEL, TLP CONCRETE, TLP STEEL, VESSEL.
    wlbFacilityTypeDrilling
    varchar(40)
    Production facility
    The NPD's name for the production facility, for development wells.
    wlbProductionFacility
    varchar(50)
    Licencing activity (round/APA)
    Name of the licensing activity the production licence the wellbore was drilled in, was awarded in.
    wlbLicensingActivity
    varchar(40)
    Multilateral
    Indicator telling if the parent well is multilateral, meaning it has more than one branch radiating from the main borehole. Example of legal values: YES, NO. See also NPD guidelines for designation of wells and wellbores.
    wlbMultilateral
    varchar(3)
    Purpose - planned
    Pre-drill purpose of the wellbore. Legal values for exploration wellbores: WILDCAT, APPRAISAL, WILDCAT-CCS, APPRAISAL-CCS. Example of legal values for development wellbores: OBSERVATION, PRODUCTION, INJECTION.
    wlbPurposePlanned
    varchar(40)
    Content - planned
    Only relevant for development wellbores, planned type of produced or injected fluid. Examples of legal values: CO2, CUTTINGS, GAS, NOT APPLICABLE, NOT AVAILABLE, WATER, WATER/GAS
    wlbContentPlanned
    varchar(40)
    Entry year
    The year when the drill bit penetrated the earth's crust / sea floor.
    wlbEntryYear
    int
    Completed year
    Exploration wellbores: For semi-subs etc: The year the anchor handling started. For jack-ups: The year the jacking-down started. For development wellbores: The year the last casing, liner or screen was installed.
    wlbCompletionYear
    int
    Reentry
    Status whether the wellbore has been re-entered (YES) or not (NO). Re-entered wellbores are not included in the count when wellbores are presented in statistical overviews.
    wlbReentry
    varchar(3)
    Predrilled entry date
    Date when the predrilling activity of the wellbore started (see also Entry date).
    wlbEntryPreDrillDate
    datetime
    Predrilled completion date
    Date when the predrilling activity of the wellbore was completed (see also completion date).
    wlbCompPreDrillDate
    datetime
    Release date
    Date when raw data which has been reported to the authorities from the wellbore is not confidential any longer. Normally 2 years after finishing the drilling. May be earlier if the area of the production license is relinquished.
    wlbReleasedDate
    datetime
    Reclassified from/to wellbore
    The original wellbore that this wellbore is reclassified from. A wellbore can only be reclassified from exploration to development, not the other way.
    wlbReclassFromWellbore
    varchar(40)
    Reclassified date
    Date when the wellbore was reclassified.
    wlbDateReclass
    datetime
    Reentry activity
    Reason for reentry of the wellbore. Only relevant for exploration wellbores. Example of legal values: DRILLING, DRILLING/PLUGGING, LOGGING, PLUGGING, TESTING, TESTING/PLUGGING.
    wlbReentryExplorationActivity
    varchar(40)
    Plot symbol
    NPD's plot symbol number for wellbores.
    wlbPlotSymbol
    int
    1st level with HC, formation
    Name of lithostartigraphic unit, 1st level, where hydrocarbons were encountered. Shown only for released wells. Examples of legal values: BASEMENT, COOK FM, EKOFISK FM, HEIMDAL FM, SANDNES FM, SOGNEFJORD FM, TARBERT FM, BRENT GP. See also NPD bulletins.
    wlbFormationWithHc1
    varchar(20)
    1st level with HC, age
    Age of lithostratigraphic unit, 1st level, where hydrocarbons were encountered. Examples of legal values: CRETACEOUS, EARLY CRETACEOUS, LATE JURASSIC, EOCENE. See also NPD bulletins.
    wlbAgeWithHc1
    varchar(20)
    2nd level with HC, formation
    Name of lithostartigraphic unit, 2nd level, where hydrocarbons were encountered. Shown only for released wells. Examples of legal values: BASEMENT, COOK FM, EKOFISK FM, HEIMDAL FM, SANDNES FM, SOGNEFJORD FM, TARBERT FM, BRENT GP.
    wlbFormationWithHc2
    varchar(20)
    2nd level with HC, age
    Age of lithostratigraphic unit, 2nd level, where hydrocarbons were encountered. Examples of legal values: CRETACEOUS, EARLY CRETACEOUS, LATE JURASSIC, EOCENE.
    wlbAgeWithHc2
    varchar(20)
    3rd level with HC, formation
    Name of lithostartigraphic unit, 3rd level, where hydrocarbons were encountered. Shown only for released wells. Examples of legal values: BASEMENT, COOK FM, EKOFISK FM, HEIMDAL FM, SANDNES FM, SOGNEFJORD FM, TARBERT FM, BRENT GP.
    wlbFormationWithHc3
    char(20)
    3rd level with HC, age
    Age of lithostratigraphic unit, 3rd level, where hydrocarbons were encountered. Examples of legal values: CRETACEOUS, EARLY CRETACEOUS, LATE JURASSIC, EOCENE.
    wlbAgeWithHc3
    char(20)
    Drilling days
    Number of days from spud to completed. The first and last days of the operation is included in the count. Days where the drilling operations has been suspende, is not included. Days used for predrilling is not included. These are made available where applicable.
    wlbDrillingDays
    int
    Geodetic datum
    Reference system for coordinates. Example of legal values: ED50.
    wlbGeodeticDatum
    varchar(6)
    NS degrees
    Geographic coordinate of the wellhead, north-south degrees.
    wlbNsDeg
    int
    NS minutes
    Geographic coordinate of the wellhead, north-south minutes.
    wlbNsMin
    int
    NS seconds
    Geographic coordinate of the wellhead, north-south seconds (decimal number).
    wlbNsSec
    real
    NS code
    Indicator whcih tells if the coordinate of the wellhead is on the nothern or southern hemisphere. Legal values: N, S.
    wlbNsCode
    varchar(1)
    EW degrees
    Geographic coordinate of the wellhead, east-west degrees.
    wlbEwDeg
    int
    EW minutes
    Geographic coordinate of the wellhead, east-west minutes.
    wlbEwMin
    int
    EW seconds
    Geographic coordinate of the wellhead, east-west seconds (decimal number).
    wlbEwSec
    real
    EW code
    Indicator which tells if the coordinate of the wellhead is on the eastern or western hemisphere. Legal values: E, W.
    wlbEwCode
    varchar(1)
    NS decimal degrees
    Geographic coordinate of the wellhead, north-south, decimal degrees.
    wlbNsDecDeg
    decimal
    EW decimal degrees
    Geographic coordinate of the wellhead, east-west, decimal degrees.
    wlbEwDesDeg
    decimal
    NS UTM [m]
    Universal Transverse Mercator coordinate of the wellhead, north-south.
    wlbNsUtm
    decimal
    EW UTM [m]
    Universal Transverse Mercator coordinate of the wellhead, east-west.
    wlbEwUtm
    decimal
    UTM zone
    Universal Transverse Mercator zone. Examples of legal values: 31, 32, 33, 34.
    wlbUtmZone
    int
    Wellbore name, part 1
    Part 1 of the wellbore name. Tells quadrant number on the Norwegian Continental Shelf the wellbore was drilled in. Based on NPD guidelines for designation of wells and wellbores.
    wlbNamePart1
    int
    Wellbore name, part 2
    Part 2 of the wellbore name. Tells the block number the wellbore was drilled in. Based on NPD guidelines for designation of wells and wellbores.
    wlbNamePart2
    int
    Wellbore name, part 3
    Part 3 of the wellbore name. Tells the name of the installation the wellbore was drilled from. Not used for exploration wellbores. Based on NPD guidelines for designation of wells and wellbores.
    wlbNamePart3
    varchar(1)
    Wellbore name, part 4
    Part 4 of the wellbore name. Serial number for the wellbore. Based on NPD guidelines for designation of wells and wellbores.
    wlbNamePart4
    int
    Wellbore name, part 5
    Part 5 of the wellbore name. Used to indicate exploration wells planned deviated (S), sidetracks (A, B,...), re-entries (R) or planned multilaterals (Y). Based on NPD guidelines for designation of wells and wellbores.
    wlbNamePart5
    varchar(2)
    Wellbore name, part 6
    Part 6 of the wellbore name. Serial number of re-entries or serial number of the well tracks in multilatrals. Based on NPD guidelines for designation of wells and wellbores.
    wlbNamePart6
    varchar(2)
    FactPage url
    URL to the wellbores's FactPage on NPD's FactWEB.
    wlbFactPageUrl
    varchar(200)
    Factmaps
    URL to the wellbores's FactMap on NPD's FactWEB.
    wlbFactMapUrl
    varchar(200)
    Pressrelease url
    URL to NPD press release for the wellbore. Only relevant for exploration wells drilled after 1.1.1999.
    wlbPressReleaseUrl
    varchar(200)
    DISKOS Well Type
    Wellbore type - applicable for DISKOS.
    wlbDiskosWellboreType
    varchar(20)
    DISKOS Wellbore Parent
    Wellbore parent - applicable for DISKOS.
    wlbDiskosWellboreParent
    varchar(40)
    NPDID production licence target
    NPDs unique key for the production licence of the wellbore target. This can differ from the production licence of the wellhead/spud location.
    prlNpdidProdLicenceTarget
    int
    NPDID discovery
    NPD's unique id for the discovery.
    dscNpdidDiscovery
    int
    NPDID field
    NPD's unique id for the field.
    fldNpdidField
    int
    NPDID drilling facility
    NPD's unique id for the facility that has drilled the wellbore.
    fclNpdidFacilityDrilling
    int
    NPDID production facility
    NPD's unique id for the production facility, for development wellbores.
    fclNpdidFacilityProducing
    int
    NPDID wellbore reclassified from
    NPD's unique id for the wellbore this wellbore was reclassified from.
    wlbNpdidWellboreReclass
    int
    NPDID production licence drilled in
    The NPDs unique ID for the production licence the wellbore was drilled from (well head position).
    prlNpdidProductionLicence
    int
    Entry day
    The number of the day in the month when the drill bit penetrated the earth's crust / sea floor.
    wlbEntryDay
    int
    Entry month
    The number of month in the year when the drill bit penetrated the earth's crust / sea floor.
    wlbEntryMonth
    int
    Completed day
    For exploration wellbores: Floating and semi-submersible vessels: The number of the day in the month when the anchor handling or rig move started. In case of jack-ups: the day the jacking-down started.
    For development wellbores: The number of day in the month when the last casing or liner was set.
    wlbCompletionDay
    int
    Completed month
    For exploration wellbores: Floating and semi-submersible vessels: The number of the day in the month when the anchor handling or rig move started. In case of jack-ups: the day the jacking-down started.
    For development wellbores: The number of day in the month when the last casing or liner was set.
    wlbCompletionMonth
    int
    Date drillpermit approved
    Description not defined
    wlbDrillPerApprovedPermitDate
    datetime
    Planned position - EW
    Description not defined
    wlbDrillPerEwDeg
    int
    Legal reference
    Description not defined
    wlbDrillPerLegalRefEnLegalNote
    varchar(8000)
    N/A - drillper_legal_ref_nb_note
    Description not defined
    wlbDrillPerLegalRefNbLegalNote
    varchar(8000)
    N/A drillper_nb_comment_EN
    Description not defined
    wlbDrillPerNbComment
    varchar(4000)
    Planned position - NS
    Description not defined
    wlbDrillPerNsDeg
    int
    Planned entry date
    Description not defined
    wlbEntryDatePlanned
    datetime
    Wellbore alias name
    Alias name of the wellbore. Can be the projectname the it had when it was drilled, This name does not have to be according to the Norwegian convention starting with quadrant/ block.
    wlbAliasName
    varchar(50)
    Publication date
    Date quality control of the wellbore information was completed, so it can be published on the internet as a 'Well Data Summary Sheet' wellbore with more information available than other wellbores.
    wlbWdssQcDate
    datetime
    Subsea
    Indicates if the well is completed on the seabed. Legal values are 'YES' or 'NO'.
    wlbSubSea
    varchar(3)
    WDSS volume reference
    Reference to NPD's Well Data Summary Sheet volume number where the wellbore is described. Example of legal values: 1, 2, 3,...
    wlbWdssVolumeReference
    int
    Cores available for sampling?
    Tells if core samples are available in the NPD core store. Legal values: YES, NO.
    wlbCoreSampleAvailable
    varchar(3)
    Cutting samples available?
    Tells if cuttings samples are available in the NPD core store. Legal values: YES, NO.
    wlbCuttingsSamplesAvailable
    varchar(3)
    With casing and lot
    Indicator telling if the wellbore has this kind of information
    wlbWithCasingAndLot
    bit
    With composite log
    Indicator telling if the wellbore has this kind of information
    wlbWithCompositeLog
    bit
    With core photo
    Indicator telling if the wellbore has this kind of information
    wlbWithCorePhoto
    bit
    With cores
    Indicator telling if the wellbore has this kind of information
    wlbWithCores
    bit
    With cuttings
    Indicator telling if the wellbore has this kind of information
    wlbWithCuttings
    bit
    With doc reported by licensee
    Indicator telling if the wellbore has this kind of information
    wlbWithDocReportedByLicensee
    bit
    With dst
    Indicator telling if the wellbore has this kind of information
    wlbWithDst
    bit
    With lithostratigraphy
    Indicator telling if the wellbore has this kind of information
    wlbWithFormationTops
    bit
    With geochem info
    Indicator telling if the wellbore has this kind of information
    wlbWithGeochemInfo
    bit
    With log
    Indicator telling if the wellbore has this kind of information
    wlbWithLog
    bit
    With mud
    Indicator telling if the wellbore has this kind of information
    wlbWithMud
    bit
    With NPD papers
    Indicator telling if the wellbore has this kind of information
    wlbWithNpdPapers
    bit
    With oil samples
    Indicator telling if the wellbore has this kind of information
    wlbWithOilSamples
    bit
    With old WDSS
    Indicator telling if the wellbore has this kind of information
    wlbWithOldWdss
    bit
    With paly slides
    Indicator telling if the wellbore has this kind of information
    wlbWithPalySlides
    bit
    With wellbore history
    Indicator telling if the wellbore has this kind of information
    wlbWithWellboreHistory
    bit
    Plugged date
    Date when plugging operations was finished, as reported by the operator to the NPD through DDRS (Daily Drilling Reporting System).
    wlbPluggedDate
    datetime
    Prod. licence for drilling target
    The active production licence of the planned end-point of the wellbore (TD). This production licence might differ from the production licence drilling of the wellbore started from.
    wlbLicenceTargetName
    varchar(10)
    Plugged and abondon date
    Date when the P&A-operations of the wellbore was finished, as reported by the operator to the NPD throught DDRS (Daily Drilling Reporting System). Only applied once pr. wellhead/surface location.
    wlbPluggedAbandonDate
    datetime
    NPDID site survey
    NPDID for the sitesurvey
    wlbNpdidSiteSurvey
    int
    Sitesurvey
    Name of the sitesurvey as reported to NPD in system for reporting sitesurveys, seismic and electromagnetic activities
    wlbSiteSurvey
    varchar(100)
    Date main level updated
    Date when information about this wellbore 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 'Wellbore' will be changed.
    wlbDateUpdated
    datetime
    Date all updated
    Date when any information about this wellbore 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 'Wellbore' will be changed.
    wlbDateUpdatedMax
    datetime
  • Sub level – Wellbore history

    Short account of purpose, operations and results.
    Sub level – Wellbore history
    Heading
    Description
    Tag
    Data type
    NPDID wellbore
    NPD's unique id for the wellbore.
    wlbNPDID_wellbore
    int
    Wellbore name
    Official wellbore name based on NPD guidelines for designation of wells and wellbores.
    wlbName
    varchar(40)
    History
    Short account of purpose, operations and results of the wellbore. The text is in html-format and is displays normally in an internet browser.
    wlbHistory
    varchar(-1)
    Date updated
    Date when this record was updated last or inserted the first time.
    wlbHistoryDateUpdated
    datetime
  • Sub level – Cuttings at the NPD

    Cuttings samples submitted from the operators according to NPD regulations.
    Sub level – Cuttings at the NPD
    Heading
    Description
    Tag
    Data type
    NPDID wellbore
    NPD's unique id for the wellbore.
    wlbNPDID_wellbore
    int
    Wellbore
    Official wellbore name based on NPD guidelines for designation of wells and wellbores.
    wlbName
    varchar(40)
    Cutting sample, top depth [m]
    Top depth of cutting sample [m].
    wlbCuttingTopDepth
    numeric
    Cutting samples, bottom depth [m]
    Bottom depth of cutting samples [m].
    wlbCuttingBottomDepth
    numeric
    WDSS QC date
    The date the quality control of the wellbore information was completed, so that it can be pulished on internet as a 'Well Data Summary Sheet' wellbore with more information available than other wellbores.
    wlbWdssQcDate
    datetime
    Cuttings available for sampling?
    Indicator which tells if there are cuttings samples available at NPD.
    wlbCuttingSampleAvailable
    varchar(3)
  • Sub level – Cores at the NPD

    Cores submitted from the operators according to NPD regulations.
    Sub level – Cores at the NPD
    Heading
    Description
    Tag
    Data type
    NPDID wellbore
    NPD's unique id for the wellbore.
    wlbNPDID_wellbore
    int
    Wellbore
    Official wellbore name based on NPD guidelines for designation of wells and wellbores.
    wlbName
    varchar(40)
    Core sample number
    Sequence number of the core sample in the wellbore.
    wlbCoreNumber
    int
    Number of cores samples
    Total number of cores samples in the wellbore.
    wlbNumberOfCores
    int
    Total core sample length [m]
    Total length of core samples in the wellbore.
    wlbTotalCoreLength
    numeric
    Core sample - top depth
    Top depth of core sample.
    wlbCoreIntervalTop
    numeric
    Core sample - bottom depth
    Bottom depth of core sample.
    wlbCoreIntervalBottom
    numeric
    Core sample depth - uom
    Unit of measurement for core sample depth. Legal values: m, ft.
    wlbCoreIntervalUom
    varchar(6)
    WDSS QC date
    Date the quality control of the wellbore information was completed, so that it can be pulished on internet as a 'Well Data Summary Sheet' wellbore with more information available than other wellbores.
    wlbWdssQcDate
    datetime
    Cores available for sampling?
    Indicator which tells if core samples are available at the NPD. Legal values: YES, NO.
    wlbCoreSampleAvailable
    varchar(3)
    Comments
    Comments.
    wlbCoreComments
    varchar(250)
    Date updated
    Date when this record was updated last or inserted the first time.
    wlbCoreDateUpdated
    datetime
  • Sub level – Core photographs

    Core photographs scanned by the NPD.
    Sub level – Core photographs
    Heading
    Description
    Tag
    Data type
    NPDID wellbore
    NPD's unique id for the wellbore.
    wlbNPDID_wellbore
    int
    Wellbore
    Official wellbore name based on NPD guidelines for designation of wells and wellbores.
    wlbName
    varchar(40)
    Core sample number
    Sequence number of the core sample in the wellbore.
    wlbCoreNumber
    int
    Core photo URL
    URL to the core photo on the fact-pages.
    wlbCorePhotoImgUrl
    varchar(200)
    Core photo title
    Title of the core photo.
    wlbCorePhotoTitle
    varchar(200)
    Date updated
    Date when this record was updated last or inserted the first time.
    wlbCorePhotoDateUpdated
    datetime
  • Sub level – Palynolgical slides at NPD

    Palynological slides submitted from the operators according to NPD regulations.
    Sub level – Palynolgical slides at NPD
    Heading
    Description
    Tag
    Data type
    NPDID wellbore
    NPD's unique id for the wellbore.
    wlbNPDID_wellbore
    int
    Wellbore
    Official wellbore name based on NPD guidelines for designation of wells and wellbores.
    wlbName
    varchar(40)
    Sample type
    Sample type the palynological slide is taken from. Examples of legal values: DC. ditch cuttings, C: core, SWC: sidewall core.
    wlbPalySlideType
    varchar(6)
    Sample depth
    Depth at which the sample was taken.
    wlbPalySlideDepth
    numeric
    Depth unit
    Depth unit is meter (M) or feet (F).
    wlbPalySlideDepthUnit
    varchar(9)
    Laboratory
    Laboratory that prepared the sample. Exsamples of legal values: APT: Applied Petroleum Technology BIOST(RAT): Biostrat FUGRO: Fugro/Robertson GEOCH: Geochem GEOST(R): Geostrat HYDRO: Norsk Hydro IKU: Institutt for kontinentalsokkelundersøkelser LAP: Laboratory for applied palynology OD: Norwegian Petroleum Directorate PALEO/PAS: Paleoservices RRI: Robertson Research International SAGA: Saga Petroleum STATO: Statoil STRAT: Stratlab UOS: University of Sheffield WESTL.: West Lab
    wlbPalySlideLab
    varchar(8)
    WDSS QC date
    The date the quality control of the wellbore information was completed, so that it can be pulished on internet as a 'Well Data Summary Sheet' wellbore with more information available than other wellbores.
    wlbWdssQcDate
    datetime
  • Sub level – Oil samples at the NPD

    De-pressurized formation fluid samples submitted from the operators according to NPD regulations.
    Sub level – Oil samples at the NPD
    Heading
    Description
    Tag
    Data type
    NPDID wellbore
    NPD's unique id for the wellbore.
    wlbNPDID_wellbore
    int
    Wellbore
    Official wellbore name based on NPD guidelines for designation of wells and wellbores.
    wlbName
    varchar(40)
    Test type
    Technology used to acquire the sample.
    wlbOilSampleTestType
    varchar(4)
    Bottle number
    Test number as specified on the bottles submitted to the NPD.
    wlbOilSampleTestNumber
    varchar(10)
    Bottle interval MD [m]
    Test interval as specified on the bottles submitted to the NPD.
    wlbOilSampleInterval
    varchar(43)
    Top depth MD [m]
    Top depth of the test interval as specified on the bottles submitted to the NPD.
    wlbOilSampleTopDepth
    decimal
    Bottom depth MD [m]
    Bottom depth of the test interval as specified on the bottles submitted to the NPD.
    wlbOilSampleBottomDepth
    decimal
    Fluid type
    Sampled fluid as specified on the bottles submitted to the NPD.
    wlbOilSampleFluidType
    varchar(20)
    Test time
    Test date and time of day
    wlbOilSampleTestDate
    datetime
    Received date
    Date when the sample was received at the NPD.
    wlbOilSampledateReceivedDate
    datetime
    Samples available
    Tells if oil samples are available in the NPD for this spesific oil sample. Legal values: YES, NO.
    wlbOilSampleAvailable
    varchar(3)
    WDSS QC date
    The date the quality control of the wellbore information was completed, so that it can be pulished on internet as a 'Well Data Summary Sheet' wellbore with more information available than other wellbores.
    wlbWdssQcDate
    datetime
    Date updated
    Date when this record was updated last or inserted the first time.
    wlbOilSampleDateUpdated
    datetime
  • Sub level – Lithostratigraphy

    NPD interpretations of lithostratigraphic units penetrated by the wellbore. May be subject to changes. Descriptions of the lithostartigraphic units can be found on the NPD-factpages under the startigraphy-topic or in the NPD-bulletins.
    Sub level – Lithostratigraphy
    Heading
    Description
    Tag
    Data type
    NPDID lithostrat. unit
    NPD's unique id for lithostratigraphic units.
    lsuNpdidLithoStrat
    int
    NPDID parent lithostrat. unit
    NPD's unique id for the lithostratigraphic unit, referring to the parent unit. Will be empty if Level = GROUP.
    lsuNpdidLithoStratParent
    int
    NPDID wellbore
    NPD's unique id for the wellbore.
    wlbNpdidWellbore
    int
    Lithostrat. unit
    The lithostratigraphic unit's official name.
    lsuName
    varchar(20)
    Lithostrat. unit, parent
    The parent lithostratigraphic unit's official name. See also level. Will be empty if Level = GROUP.
    lsuNameParent
    varchar(20)
    Level
    Indicates the level of the unit. Legal values: GROUP, FORMATION, MEMBER.
    lsuLevel
    varchar(9)
    Top depth [m]
    Measured length along the wellbore from kelly bushing to start of lithostratigraphic unit. Always the group/formation/member which the bit goes into. Note that in some situations, for example highly deviated wells, faults, drilling beyond salt walls, this might not be a true stratigraphic top. The start of a unit will be its stratigraphic base when drilled from underneath. In case of intercalating formations several top depths may occur for the same formation designating the top depths of the sub-packages. For some intervals in some wells only groups are interpreted and no formation tops have been assigned. Members have been assigned only near the type well area. In some cases informal names have been used for formations that are not described in the official nomenclature yet. These are marked with . NPD interpretations. May be subject to changes.
    lsuTopDepth
    numeric
    Bottom depth [m]
    Depth in meters to the bottom of the lithostratigraphic unit.
    lsuBottomDepth
    numeric
    Wellbore name
    Official name of the wellbore based on NPD guidelines for designation of wells and wellbores.
    wlbName
    varchar(40)
    Date updated
    Date when this record was updated last or inserted the first time.
    IsuWellboreUpdatedDate
    datetime
  • Sub level – Composite logs

    A composite log for the wellbore compiled by the NPD.
    Sub level – Composite logs
    Heading
    Description
    Tag
    Data type
    NPDID wellbore
    NPD's unique id for the wellbore.
    wlbNPDID_wellbore
    int
    Wellbore
    Official wellbore name based on NPD guidelines for designation of wells and wellbores.
    wlbName
    varchar(40)
    Document name
    Wellbore document name.
    wlbDocumentName
    varchar(200)
    Document type
    Wellbore document type.
    wlbDocumentType
    varchar(40)
    Document URL
    URL to the wellbore document.
    wlbDocumentUrl
    varchar(200)
    Document format
    Wellbore document format.
    wlbDocumentFormat
    varchar(40)
    Document size [MB]
    Wellbore document size in MegaBytes
    wlbDocumentSize
    numeric
    Date updated
    Date when this record was updated last or inserted the first time.
    wlbDocumentDateUpdated
    datetime
  • Sub level – Geochemical information

    Raw data from organic geochemical analyses of samples of fluids and rocks from the well (.pdf and .txt format).
    Sub level – Geochemical information
    Heading
    Description
    Tag
    Data type
    NPDID wellbore
    NPD's unique id for the wellbore.
    wlbNPDID_wellbore
    int
    Wellbore
    Official wellbore name based on NPD guidelines for designation of wells and wellbores.
    wlbName
    varchar(40)
    Document name
    Wellbore document name.
    wlbDocumentName
    varchar(200)
    Document type
    Wellbore document type.
    wlbDocumentType
    varchar(40)
    Document URL
    URL to the wellbore document.
    wlbDocumentUrl
    varchar(200)
    Document format
    Wellbore document format.
    wlbDocumentFormat
    varchar(40)
    Document size [MB]
    Wellbore document size in MegaBytes
    wlbDocumentSize
    numeric
    Date updated
    Date when this record was updated last or inserted the first time.
    wlbDocumentDateUpdated
    datetime
  • Sub level – Documents, NPD papers

    Pdf-documents from the wellbore published by NPD.
    Sub level – Documents, NPD papers
    Heading
    Description
    Tag
    Data type
    NPDID wellbore
    NPD's unique id for the wellbore.
    wlbNPDID_wellbore
    int
    Wellbore
    Official wellbore name based on NPD guidelines for designation of wells and wellbores.
    wlbName
    varchar(40)
    Document name
    Wellbore document name.
    wlbDocumentName
    varchar(200)
    Document type
    Wellbore document type.
    wlbDocumentType
    varchar(40)
    Document URL
    URL to the wellbore document.
    wlbDocumentUrl
    varchar(200)
    Document format
    Wellbore document format.
    wlbDocumentFormat
    varchar(40)
    Document size [MB]
    Wellbore document size in MegaBytes
    wlbDocumentSize
    numeric
    Date updated
    Date when this record was updated last or inserted the first time.
    wlbDocumentDateUpdated
    datetime
  • Sub level – Documents, reported by the production licence (period for duty of secrecy expired)

    Selected scanned documents (pdf-format) for wellbores older than 20 years, for example final well reports, completion logs, reports on biostratigraphy.
    Sub level – Documents, reported by the production licence (period for duty of secrecy expired)
    Heading
    Description
    Tag
    Data type
    NPDID wellbore
    NPD's unique id for the wellbore.
    wlbNPDID_wellbore
    int
    Wellbore
    Official wellbore name based on NPD guidelines for designation of wells and wellbores.
    wlbName
    varchar(40)
    Document name
    Wellbore document name.
    wlbDocumentName
    varchar(200)
    Document type
    Wellbore document type.
    wlbDocumentType
    varchar(40)
    Document URL
    URL to the wellbore document.
    wlbDocumentUrl
    varchar(200)
    Document format
    Wellbore document format.
    wlbDocumentFormat
    varchar(40)
    Document size [MB]
    Wellbore document size in MegaBytes
    wlbDocumentSize
    numeric
    Date updated
    Date when this record was updated last or inserted the first time.
    wlbDocumentDateUpdated
    datetime
  • Sub level – Drill stem tests (DST)

    The basic drill stem test tool consists of packers, valve or ports that may be opened and closed from the surface, and two or more pressure-recording devices. The tool is lowered on the drill string to the zone to be tested. The packers are set to isolate the zone from the drilling fluid column. The valves or ports are then opened to allow for formation flow while the recorders chart static pressures. A sampling chamber traps clean formation fluids at the end of the test. A DST typically consists of several flow periods separated by shut-in periods where pressure is allowed to restore (buildup) towards static conditions. The first flow period is the cleanup period.The initial shut-in period is usually followed immediately by an extended period of flow. The well is then shut-in for the final or main buildup period. Data obtained during this period are analyzed to determine permeability and skin effect. Final flow periods commonly range from 4 to 24 hours, and final buildup periods from 6 to 48 hours.
    Sub level – Drill stem tests (DST)
    Heading
    Description
    Tag
    Data type
    NPDID wellbore
    NPD's unique id for the wellbore.
    wlbNPDID_wellbore
    int
    Wellbore
    Official wellbore name based on NPD guidelines for designation of wells and wellbores.
    wlbName
    varchar(40)
    Test number
    Usually assiciated with a specific test interval, but may also represent tests under different conditions from the same interval.
    wlbDstTestNumber
    decimal
    From depth MD [m]
    Top depth of the zone that is opened up for flow, measured depth.
    wlbDstFromDepth
    decimal
    To depth MD [m]
    Bottom depth of the zone that is opened up for flow, measured depth.
    wlbDstToDepth
    decimal
    Choke size [mm]
    The choke is a type of orifice installed in a well flow line for the purpose of restricting the flow and controlling the rate of production. During testing of a well, the flow will often be measured through a series of different choke diameters.
    wlbDstChokeSize
    decimal
    Final shut-in pressure [MPa]
    Pressure as recorded at the wellhead when the valve is closed and the well is shut-in in the final build-up period.
    wlbDstFinShutInPress
    decimal
    Final flow pressure [MPa]
    The pressure determined at the formation face just prior to shut-in for a build-up test.
    wlbDstFinFlowPress
    decimal
    Bottom hole pressure [MPa]
    The downhole pressure opposite a formation of interest when the valves at the surface (or downhole) are completely closed. The pressure is transmitted by fluids which exist in a formation and are in communication with the wellbore.
    wlbDstBottomHolePress
    decimal
    Downhole temperature [°C]
    The downhole temperature opposite a formation of interest, typically measured as the final or maximum temperaure in the main flow period.
    wlbDstDownholeTemperatur
    int
    Oil [Sm3/day]
    The rate of oil produced from the formation.
    wlbDstOilProd
    int
    Gas [Sm3/day]
    The rate of gas produced from the formation.
    wlbDstGasProd
    int
    Oil density [g/cm3]
    Oil density.
    wlbDstOilDensity
    decimal
    Gas grav. rel.air
    Gas gravity relative to air. Air gravity is by definition = 1.0.
    wlbDstGasDensity
    decimal
    GOR [m3/m3]
    Gas to oil ratio.
    wlbDstGasOilRelation
    int
    WDSS QC date
    The date the quality control of the wellbore information was completed, so that it can be pulished on internet as a 'Well Data Summary Sheet' wellbore with more information available than other wellbores.
    wlbWdssQcDate
    datetime
    Date updated
    Date when this record was updated last or inserted the first time.
    wlbDstDateUpdated
    datetime
  • Sub level – Logs

    Listing of wireline and MWD logs that have been run in the well.
    Sub level – Logs
    Heading
    Description
    Tag
    Data type
    NPDID wellbore
    NPD's unique id for the wellbore.
    wlbNPDID_wellbore
    int
    Wellbore
    Official wellbore name based on NPD guidelines for designation of wells and wellbores.
    wlbName
    varchar(40)
    Log type
    Assembly of log tools in a run. Abbreviations as reported from the companies.
    wlbLogType
    varchar(32)
    Log top depth [m]
    Intervals logged, top depth.
    wlbLogTopDepth
    decimal
    Log bottom depth [m]
    Intervals logged, bottom depth.
    wlbLogBottomDepth
    decimal
    WDSS QC date
    The date the quality control of the wellbore information was completed, so that it can be pulished on internet as a 'Well Data Summary Sheet' wellbore with more information available than other wellbores.
    wlbWdssQcDate
    datetime
  • Sub level – Casing and leak–off tests

    A casing is a metal or plastic tubing set in the wellbore. A leak-off test is a test to determine the strength of the fracture pressure of the open formation. This test is usually conducted immediately after drilling below a new casing shoe. During the test, the well is shut-in and fluid is pumped into the wellbore to gradually increase the pressure that the formation experience. At some pressure, fluid will enter the formation, or leak off, either moving through permeable parts in the rock or by creating space by fracturing the rock. The results of the leak-off test dictate the maximum pressure or mud weight that may be applied to the well during drilling operations. To maintain a small safety factor to permit safe well control operations, the maximum operating pressure is usually slightly below the leak-off test result.
    Sub level – Casing and leak–off tests
    Heading
    Description
    Tag
    Data type
    NPDID wellbore
    NPD's unique id for the wellbore.
    wlbNPDID_wellbore
    int
    Wellbore
    Official wellbore name based on NPD guidelines for designation of wells and wellbores.
    wlbName
    varchar(40)
    Casing type
    A typical wellbore will be cased with CONDUCTOR and SURFACE CONDUCTOR types of casing in the upper section, INTERMEDIATE casing through non-reservoir sections, and a PRODUCTION or plastic LINER types of casing, or even OPEN HOLE, in potential reservoir sections towards final total depth of the wellbore.
    wlbCasingType
    varchar(10)
    Casing diam. [inch]
    Inner diameter of casing.
    wlbCasingDiameter
    varchar(6)
    Casing depth [m]
    Total depth below kelly bushing of a cased section (casing shoe).
    wlbCasingDepth
    decimal
    Hole diam. [inch]
    Diameter of wellbore (the drill bit).
    wlbHoleDiameter
    varchar(6)
    Hole depth[m]
    Total depth below kelly bushing of a wellbore section drilled with a certain diameter.
    wlbHoleDepth
    decimal
    LOT/FIT mud eqv. [g/cm3]
    Maximum mud equivalent at the leak-off test (LOT) or formation integrity test (FIT):
    A LOT measures the formation-integrity by increasing the pump pressure stepwise (thus increasing the equivalent mud density) to the point where the mud starts to leak into the formation.
    A FIT is similarily performed, but only up to a pre-decided pressure the formation has to withstand prior to expected Leak-off.
    wlbLotMudDencity
    decimal
    WDSS QC date
    The date the quality control of the wellbore information was completed, so that it can be pulished on internet as a 'Well Data Summary Sheet' wellbore with more information available than other wellbores.
    wlbWdssQcDate
    datetime
    Formation test type
    Type of formation test. Example of legal values: LOT (Leak Off Test), FIT (Formation Integration Test)
    wlbFormationTestType
    varchar(10)
    Date updated
    Date when this record was updated last or inserted the first time.
    wlbCasingDateUpdated
    datetime
  • Sub level – Drilling mud

    The physical properties of the mud used to drill the bore hole.
    Sub level – Drilling mud
    Heading
    Description
    Tag
    Data type
    NPDID wellbore
    NPD's unique id for the wellbore.
    wlbNPDID_wellbore
    int
    Wellbore
    Official wellbore name based on NPD guidelines for designation of wells and wellbores.
    wlbName
    varchar(40)
    Track number
    Internal number for technical directional drilling.
    wlbTrack
    smallint
    Depth MD [m]
    Measured depth.
    wlbMD
    decimal
    Mud weight [g/cm3]
    The density of the mud used.
    wlbMudWeightAtMD
    decimal
    Visc. [mPa.s]
    The viscosity of the mud used.
    wlbMudViscosityAtMD
    decimal
    Yield point [Pa]
    The resistance to initial flow, represents the stress required to start fluid movement.
    wlbYieldPointAtMD
    decimal
    Mud type
    Mud type as reported in the Daily Drilling Report System (DDRS).
    wlbMudType
    varchar(40)
    Date measured
    Date, during drilling operations, when mud properties are measured and logged.
    wlbMudDateMeasured
    datetime
    WDSS QC date
    The date the quality control of the wellbore information was completed, so that it can be pulished on internet as a 'Well Data Summary Sheet' wellbore with more information available than other wellbores.
    wlbWdssQcDate
    datetime
    Date updated
    Date when this record was updated last or inserted the first time.
    wlbMudDateUpdated
    datetime
  • Sub level – CO2

    CO2 content in wellbore samples. A list of samples where CO2 > 3% is shown. Beware that there might be several wells with high CO2 level in addition to those in this list, which only contains wells where the CO2 content is analysed and reported.
    Sub level – CO2
    Heading
    Description
    Tag
    Data type
    NPDID wellbore
    NPD's unique id for the wellbore.
    wlbNpdidWellbore
    int
    Wellbore name
    Official name of wellbore based on NPD guidelines for designation of wells and wellbores.
    wlbWellboreName
    varchar(40)
    Sample sequence number
    Sequence number of measurements in sample interval.
    wlbCo2SampleNumber
    varchar(40)
    Sample top depth [m]
    Top depth of sample interval (measured depth).
    wlbCo2SampleTopDepth
    numeric
    Sample bottom depth [m]
    Bottom depth of sample interval (measured depth).
    wlbCo2SampleBottomDepth
    numeric
    CO2 [vol %]
    Measured CO2 content, in percentage of the sample volume.
    wlbCo2Percent
    numeric
    Sample method
    Sample method.
    wlbCo2SampleMethod
    varchar(40)
    Sample type
    Sample type. Examples of test types: DST: Drillstem Test, FMT: Formation Multi-Tester, RFT: Repeat Formation Test, MDT: Modular Dynamics Formation Tester.
    wlbCo2SampleType
    varchar(40)
  • Sub level – Thin section at NPD

    Listing av thin sections from well cores stored at NPD
    Sub level – Thin section at NPD
    Heading
    Description
    Tag
    Data type
    Wellbore
    Official wellbore name based on NPD guidelines for designation of wells and wellbores.
    wlbName
    varchar(40)
    Number
    Unique sequence number of the thin section
    wlbThinSectionNumber
    int
    Depth
    Depth, in measure depth, where the thin section is taken in the wellbore
    wlbThinSectionDepth
    numeric
    Unit
    Unit (meter or feet)
    wlbThinSectionDepthUom
    varchar(6)
    NPDID wellbore
    NPD's unique id for the wellbore.
    wlbNpdidWellbore
    int
    Date updated
    Date when this record was updated last or inserted the first time.
    wlbThinSectionDateUpdated
    datetime