FACILITY – attribute description

Export:

Main level

Main level
Heading	Description	Tag	Data type
NPDID facility	NPD's unique id for facilities	fclNpdidFacility	int
NPDID operator	NPD's unique id for companies	fclNpdidCurrentOperator	int
NPDID responsible company	NPD's unique id for companies	fclNpdidCurrentRespCompany	int
Fixed or moveable	Indicator which tells if the facility is regarded as fixed or moveable. Legal values: FIXED, MOVEABLE	fclFixedOrMoveable	varchar(40)
Name	Name of the facility used by NPD	fclName	varchar(40)
Kind	Kind of facility. Example of legal values: CONCRETE STRUCTURE, CONDEEP 3 SHAFTS, CONDEEP 4 SHAFTS, CONDEEP MONOSHAFT, DORIS, FPSO, FSU, JACKET 12 LEGS, JACKET 4 LEGS, JACKET 6 LEGS, JACKET 8 LEGS, JACKET TRIPOD, JACK-UP 3 LEGS, JACK-UP 4 LEGS, LOADING SYSTEM, MONOTOWER, MULTI WELL TEMPLATE, ONSHORE FACILITY, SEMISUB CONCRETE, SEMISUB STEEL, SINGLE WELL TEMPLATE, SUBSEA STRUCTURE, TLP CONCRETE, TLP STEEL, VESSEL	fclKind	varchar(40)
Phase	Current phase for the facility. Example of legal values: ABANDONED IN PLACE, DECOMMISSIONED, FABRICATION, FUTURE, IN SERVICE, INSTALLATION, LAID UP, REMOVED	fclPhase	varchar(40)
Functions	Tells what functions the facility covers. Examples: DRILLING, DRILLING TEMPLATE, FIELD CONTROL CENTER, FISCAL METERING, FLARE STACK, FLOTEL, FULL STABILIZATION, GAS EXPORT, GAS INJECTION, GAS INJECTOR, GAS PRODUCER, ISOLATION VALVE, LOADING BOUY, MANIFOLD, MANIFOLD STATION, OFFLOADING, OIL PRODUCER, PIG RECIVER, PIPELINE END MANIFOLD, QUARTER, RISER, RISER BASE, RISER SUPPORT, SEPARATION, SILO, STORAGE, T-CONNECTION, TERMINAL, TRAWLGEAR PROTECTION, TUNNEL, UMBILICAL SUPPORT, WATER INJECTION, WATER/GAS INJECTION, WELLHEAD, Y-CONNECTION, PROCESSING, ACCOMMODATION, SUPPORT, BOOSTER, DISTRIBUTION, WATER PRODUCER or a combination of these.	fclFunctions	varchar(400)
Geodetic datum	Geodetic datum for the coordinates of the position of the facility.	fclGeodeticDatum	varchar(10)
NS degrees	Coordinate, north-south degrees	fclNsDeg	int
NS minutes	Coordinate, north-south minutes	fclNsMin	int
NS seconds	Coordinate, north-south milliseconds (decimal number)	fclNsSec	decimal
NS code	Indicator which tells if the coordinate is in the nothern or southern hemisphere. Example of legal values: N, S	fclNsCode	varchar(1)
EW degrees	Coordinate, east-west degrees	fclEwDeg	int
EW minutes	Coordinate, east-west minutes	fclEwMin	int
EW seconds	Coordinate, east-west milliseconds (decimal number)	fclEwSec	decimal
EW code	Indicator which tells if the coordinate is in the eastern or western hemisphere. Example of legal values: E, W	fclEwCode	varchar(1)
UTM hemisphere	Indicator which tells if the Universal Transverse Mercator coordinate is in the nothern or southern hemisphere. Example of legal values: 1, 2	fclUtmHemisphere	int
UTM zone	UTM zone for the UTM coordinates of the position of the facility.	fclUtmZone	int
NS UTM	Universal Transverse Mercator coordinate, north-south	fclNsUtm	decimal
EW UTM	Universal Transverse Mercator coordinate, east-west	fclEwUtm	decimal
RKB elevation [m]	Elevation above mean sea level in meters of rotary kelly bushing.	fclRkb	decimal
Water depth [m]	Water depth from mean sea level at well site.	fclWaterDepth	decimal
Startup date	The date the facility was set in production.	fclStartupDate	datetime
Design lifetime [year]	The number of years the facility was designed for.	fclDesignLifetime	int
AOC status	AOC status of the facility. Example of legal values: AOC ok, In queue for AOC	fclStatus	varchar(40)
Surface facility	Indicator telling if the facility is a surface facility. Example of legal values: Y, N. N means its a subsurface facility.	fclSurface	varchar(1)
Belongs to	Name of the information carrier the facility belongs to.	fclBelongsToName	varchar(41)
NPD belongs to	Primary key of the information carrier the facility belongs to	fclBelongsToS	varchar(19)
Belongs to, kind	Kind of information carrier the facility belongs to. Example of legal values: field, field part, ingen registering, TUF, TUF part	fclBelongsToKind	varchar(40)
Current operator	Name of the company that is currently operator of the facility.	fclCurrentOperatorName	varchar(100)
Current responsible company	Official name of currently responsible company for a moveable facility.	fclCurrentRespCompanyName	varchar(100)
Nation code	2 letter nation code (ISO) for the country the facility is currently registered in	fclNationCode2	varchar(2)
Nation	Name of the country the facility is currently registered in	fclNationName	varchar(40)
Belongs to, fact page	URL to the fact page for the information carrier the facility belongs to on NPD's FactWEB	fclBelongsToFactPageUrl	varchar(200)
Fact page	URL to the facility's fact page on NPD's FactWEB	fclFactPageUrl	varchar(200)
Factmaps	URL to the facility's fact map on NPD's FactWEB	fclFactMapUrl	varchar(200)
Date updated	Date when information about this facility was last updated or inserted for the first time.	fclDateUpdated	datetime
Formal name, part 1	Formal name, part 1: NCS quadrant number	fclFormalName1Quadrant	char(4)
Formal name, part 2	Formal name, part 2: NCS block number in the quadrant.	fclFormalName2Block	int