Touchstone 4.0 Database Documentation
TblOffshoreStructures Table
Description
Stores industry information for the offshore structures.  
Properties
Creation Date4/16/2011 12:41 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows17079
Data Space Used3,376.00 KB
Index Space Used4,632.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key intAIRStructureIDIdentifier for the offshore structure.Integer4   
 strStructureNameName of the offshore structure.VarChar60  
 intMMSComplexIDUnique Minerals Management Service (MMS) identifier assigned to a single structure or a group of structures connected by a walkway.Integer4  
 intMMSNumber

Unique Minerals Management Service(MMS) number assigned to a specific structure within a complex.

SmallInt2  
 intCountry

ISO 2-character code for the country in which the offshore platform resides. 

For a complete list of codes, tCountry Table.

Integer4  
 strAdminstrationArea

Code that represents the Administrative geographic region. Options include:

  • OCS = Offshore Continental Shelf
  • 01- Alabama
  • 22 - Louisiana
  • 28 - Mississippi
  • 48 - Texas
VarChar3  
 strProtraction

Code that represents the Protraction geographic region.

For a complete list of options, see the subarea codes in tGeography Table.

VarChar2  
 strBlock

Code that represents the Block geographic region.

For a complete list of options, see the postal codes in tGeography Table.

VarChar4  
 fltLatLatitude coordinate for the offshore structure.  Values will be positive for locations north of the equator and negative south of the equator.Single4  
 fltLongLongitude coordinate for the offshore structure.  Values will be negative for locations west of the prime meridian up to the international date line. They will be positive for locations east of the prime meridian.Single4  
 fltDeckHeightHeight of the deck above the water, measured in meters.Double9  
 fltDailyOilProductionRate of oil produced by the platform per day, measured in barrels.Double9  
 fltDailyGasProductionRate of gas produced by the platform per day, measured in MCF (1,000 cubic feet).Double9  
 fltDailyRateRate of gas or oil produced by the offshore structure per day.Single4  
 fltReplacementValueReplacement value for the offshore structure.Currency8  
 intYearInstalledYear the offshore structure was installed.SmallInt2  
 intConstructionCode

Code that represents the AIR construction class.

For a complete list of codes, see tAIRConstruction Table.

SmallInt2  
 intOccupancyCode

Code that represents the AIR occupancy class.

For a complete list of codes, see tAIROccupancy Table.

SmallInt2  
 fltWaterDepthDepth of the water at the location where the offshore structure is installed.Single4  
 fltDistancetoShoreDistance from the shore and where the offshore structure is installed.Single4  
 fltTopsideCostCost of the deck(s) and equipment on the offshore structure.Double9  
 intSlotCountNumber of wells the offshore structure is licensed to drill.SmallInt2  
 intSlotDrillCountNumber of wells currently drilled.SmallInt2  
 intTransFrameTypeType (or shape) of transverse framing used to brace the offshore structure's legs.SmallInt2  
 intDeckCountNumber of decks on the offshore structure.SmallInt2  
 intLegCountNumber of legs on the offshore structure.SmallInt2  
 blDeckHeightFlag

Indicates whether the offshore structure contains a deck.

  • 1 = Yes (deck)
  • 0 = No (no deck)
Boolean1  
 blMannedUnmanned

Indicates whether the offshore structure is manned.

  • 1 = Yes (manned)
  • 0 = No (unmanned)
Boolean1  
 strNameName of the offshore structure.VarChar60  
 intCompanySizeSize of the company that operates the offshore structure.Integer4  
 strNameWithoutSpacesSame value as strName, except without spaces.VarChar60  
 guidExternalGUID external associated with the offshore structure.Binary16  
Primary Key DateInstalledDate and time the offshore structure was installed.DBTimeStamp4   
Primary Key DateRemoved

 Date and time the offshore structure was installed.

DBTimeStamp4   
 intWellCountNumber of wells connected to the offshore platform.SmallInt2  
Primary Key blActive

Indicates whether the offshore structure is currency active.

  • 1 = Yes (active)
  • 0 = No (closed)
Boolean1 
((1))
 
 blOnePlatformInBlock

Indicates whether there is more than one offshore structure within the same platform block geographic region.

  • 1 = Yes (more than one platform)
  • 0 = No (one platform)
Boolean1   
 blCurrent

Indicates whether the offshore structure is currently in use.

  • 1 = Yes (active)
  • 0 = No (decommissioned)
Boolean1   
See Also

Related Objects

AIRIndustry Database

 

 


AIR Client Confidential

© 2016. AIR Worldwide is a registered trademark. Touchstone is a registered trademark of AIR Worldwide.

Please contact AIR Worldwide with questions or comments. For database questions. For documentation comments.