WELLBORE – attribute description

Export:

Main level

Main level
Attibute heading	Description	Tag	Data type
Wellbore name	Official name of wellbore based on Norwegian Offshore Directorate guidelines for designation of wells and wellbores.	wlbWellboreName	varchar(40)
NPDID wellbore	Norwegian Offshore Directorate's unique id for the wellbore.	wlbNpdidWellbore	int
Well name	Official name of the parent well for the wellbore based on Norwegian Offshore Directorate 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 Norwegian Offshore Directorate's FactWEB	cmpFactPageUrl	varchar(200)
NPDID drilling operator	Norwegian Offshore Directorate'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 Norwegian Offshore Directorate. INJECTING: It was injected to the wellbore at the time of the operators last monthly report to the Norwegian Offshore Directorate. 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 Norwegian Offshore Directorate.	wlbDrillPermit	varchar(10)
Discovery	Name of the discovery the wellbore is related to.	wlbDiscovery	varchar(40)
Discovery wellbore	Indicator which tells if the wellbore made a new discovery. Legal values: YES, NO. Prior to press-release or other information regarding drilling results, the indicator will be “NO” as a default.	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	Norwegian Offshore Directorate'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'	wlbDrillingFacilityFixedOrMove	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 Norwegian Offshore Directorate'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 Norwegian Offshore Directorate 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	Norwegian Offshore Directorate'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 Norwegian Offshore Directorate 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 Norwegian Offshore Directorate 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 wellbore entry to wellbore completion.	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.	wlbEwDecDeg	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 Norwegian Offshore Directorate 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 Norwegian Offshore Directorate 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 Norwegian Offshore Directorate guidelines for designation of wells and wellbores.	wlbNamePart3	varchar(2)
Wellbore name, part 4	Part 4 of the wellbore name. Serial number for the wellbore. Based on Norwegian Offshore Directorate 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 Norwegian Offshore Directorate 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 Norwegian Offshore Directorate guidelines for designation of wells and wellbores.	wlbNamePart6	varchar(2)
FactPage url	URL to the wellbores's FactPage on Norwegian Offshore Directorate's FactWEB.	wlbFactPageUrl	varchar(200)
Factmaps	URL to the wellbores's FactMap on Norwegian Offshore Directorate's FactWEB.	wlbFactMapUrl	varchar(200)
Pressrelease url	URL to Norwegian Offshore Directorate 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	Norwegian Offshore Directorate's unique id for the discovery.	dscNpdidDiscovery	int
NPDID field	Norwegian Offshore Directorate's unique id for the field.	fldNpdidField	int
NPDID drilling facility	Norwegian Offshore Directorate's unique id for the facility that has drilled the wellbore.	fclNpdidFacilityDrilling	int
NPDID production facility	Norwegian Offshore Directorate's unique id for the production facility, for development wellbores.	fclNpdidFacilityProducing	int
NPDID wellbore reclassified from	Norwegian Offshore Directorate'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_legal_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 Norwegian Offshore Directorate'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 Norwegian Offshore Directorate core store. Legal values: YES, NO.	wlbCoreSampleAvailable	varchar(3)
Cutting samples available?	Tells if cuttings samples are available in the Norwegian Offshore Directorate 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 Norwegian Offshore Directorate 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 Norwegian Offshore Directorate 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 Norwegian Offshore Directorate 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 Norwegian Offshore Directorate 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

Commonly used abbreviations

Short account of purpose, operations and results.

Sub level – Wellbore history
Attibute heading	Description	Tag	Data type
NPDID wellbore	Norwegian Offshore Directorate's unique id for the wellbore.	wlbNpdidWellbore	int
Wellbore name	Official wellbore name based on Norwegian Offshore Directorate 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
Attibute heading	Description	Tag	Data type
NPDID wellbore	Norwegian Offshore Directorate's unique id for the wellbore.	wlbNpdidWellbore	int
Wellbore	Official wellbore name based on Norwegian Offshore Directorate 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 Norwegian Offshore Directorate.	wlbCuttingSampleAvailable	varchar(3)

Sub level – Cores at the NPD

Cores submitted from the operators according to NPD regulations.

Sub level – Cores at the NPD
Attibute heading	Description	Tag	Data type
NPDID wellbore	Norwegian Offshore Directorate's unique id for the wellbore.	wlbNpdidWellbore	int
Wellbore	Official wellbore name based on Norwegian Offshore Directorate 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 Norwegian Offshore Directorate. 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
Attibute heading	Description	Tag	Data type
NPDID wellbore	Norwegian Offshore Directorate's unique id for the wellbore.	wlbNpdidWellbore	int
Wellbore	Official wellbore name based on Norwegian Offshore Directorate 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
Attibute heading	Description	Tag	Data type
NPDID wellbore	Norwegian Offshore Directorate's unique id for the wellbore.	wlbNpdidWellbore	int
Wellbore	Official wellbore name based on Norwegian Offshore Directorate 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. Examples 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 NOD: Norwegian Offshore 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
Attibute heading	Description	Tag	Data type
NPDID wellbore	Norwegian Offshore Directorate's unique id for the wellbore.	wlbNpdidWellbore	int
Wellbore	Official wellbore name based on Norwegian Offshore Directorate 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 Norwegian Offshore Directorate.	wlbOilSampleTestNumber	varchar(10)
Bottle interval MD [m]	Test interval as specified on the bottles submitted to the Norwegian Offshore Directorate.	wlbOilSampleInterval	varchar(43)
Top depth MD [m]	Top depth of the test interval as specified on the bottles submitted to the Norwegian Offshore Directorate.	wlbOilSampleTopDepth	decimal
Bottom depth MD [m]	Bottom depth of the test interval as specified on the bottles submitted to the Norwegian Offshore Directorate.	wlbOilSampleBottomDepth	decimal
Fluid type	Sampled fluid as specified on the bottles submitted to the Norwegian Offshore Directorate.	wlbOilSampleFluidType	varchar(20)
Test time	Test date and time of day	wlbOilSampleTestDate	datetime
Received date	Date when the sample was received at the Norwegian Offshore Directorate.	wlbOilSampledateReceivedDate	datetime
Samples available	Tells if oil samples are available in the Norwegian Offshore Directorate 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

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
Attibute heading	Description	Tag	Data type
NPDID lithostrat. unit	Norwegian Offshore Directorate's unique id for lithostratigraphic units.	lsuNpdidLithoStrat	int
NPDID parent lithostrat. unit	Norwegian Offshore Directorate's unique id for the lithostratigraphic unit, referring to the parent unit. Will be empty if Level = GROUP.	lsuNpdidLithoStratParent	int
NPDID wellbore	Norwegian Offshore Directorate'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 . Norwegian Offshore Directorate 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 Norwegian Offshore Directorate 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
Attibute heading	Description	Tag	Data type
NPDID wellbore	Norwegian Offshore Directorate's unique id for the wellbore.	wlbNpdidWellbore	int
Wellbore	Official wellbore name based on Norwegian Offshore Directorate 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
Attibute heading	Description	Tag	Data type
NPDID wellbore	Norwegian Offshore Directorate's unique id for the wellbore.	wlbNpdidWellbore	int
Wellbore	Official wellbore name based on Norwegian Offshore Directorate 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
Attibute heading	Description	Tag	Data type
NPDID wellbore	Norwegian Offshore Directorate's unique id for the wellbore.	wlbNpdidWellbore	int
Wellbore	Official wellbore name based on Norwegian Offshore Directorate 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)
Attibute heading	Description	Tag	Data type
NPDID wellbore	Norwegian Offshore Directorate's unique id for the wellbore.	wlbNpdidWellbore	int
Wellbore	Official wellbore name based on Norwegian Offshore Directorate 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, older NPD WDSS reports and other related documents

Pdf-documents from old NPD WDSS reports and completion logs and other documents related to the wellbore. Interpretations presented in these documents may differ from updated interpretations shown on the fact page.

Sub level – Documents, older NPD WDSS reports and other related documents
Attibute heading	Description	Tag	Data type
NPDID wellbore	Norwegian Offshore Directorate's unique id for the wellbore.	wlbNpdidWellbore	int
Wellbore	Official wellbore name based on Norwegian Offshore Directorate 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)
Attibute heading	Description	Tag	Data type
NPDID wellbore	Norwegian Offshore Directorate's unique id for the wellbore.	wlbNpdidWellbore	int
Wellbore	Official wellbore name based on Norwegian Offshore Directorate 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
Attibute heading	Description	Tag	Data type
NPDID wellbore	Norwegian Offshore Directorate's unique id for the wellbore.	wlbNpdidWellbore	int
Wellbore	Official wellbore name based on Norwegian Offshore Directorate 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
Attibute heading	Description	Tag	Data type
NPDID wellbore	Norwegian Offshore Directorate's unique id for the wellbore.	wlbNpdidWellbore	int
Wellbore	Official wellbore name based on Norwegian Offshore Directorate 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