Touchstone 4.0 Database Documentation
tLocOffshore Table
Description

Contains risk characteristics for each offshore location.

Properties
Creation Date5/31/2016 9:46 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows0
Data Space Used0.00 KB
Index Space Used0.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key LocationSID

Unique system-generated sequential identifier for the location record.

For a complete list of records, see tLocation Table.

Integer4   
 AIRStructureIDUnique AIR-assigned identifier for the platform.VarChar255  
 CompanySizeCode

Code that represents the size of the company.

For a complete list of codes, see tCompanySize Table.

UnsignedTinyInt1  
 DailyGasProductionRateRate of gas produced by the platform per day.Double9  
 DailyGasProductionUnitCode

Code for the unit of measure used to express the daily gas production, such as Thousands of Cubic Feet.

For a complete list of codes, see tUnit Table.

VarChar10  
 DailyOilProductionRateRate of oil produced by the platform per day.Double9  
 DailyOilProductionUnitCode

Code for the unit of measure used to express the daily oil production, such as Barrels.

For a complete list of codes, see tUnit Table.

VarChar10  
 DeckCountNumber of decks on the platform.SmallInt2  
 DeckHeightHeight of the deck above the water's surface.Double9  
 DeckHeightUnitCode

Code for the unit of measure used to express the daily oil height of the platform above the water, such as feet.

For a complete list of codes, see tUnit Table.

VarChar10  
 SlotCountNumber of wells the platform is licensed to drill.SmallInt2  
 SlotDrillCountNumber of wells currently drilled.SmallInt2  
 TopsideCostCost of the decks and equipment on the platform as a percentage of the platform replacement cost.Double9  
 TransverseFrameTypeCode

Code that represents the type of transverse framing used to brace the platform legs.

For a complete list of codes, see tTransverseFrameType Table.

UnsignedTinyInt1  
 LegCountTotal number of legs on the platform.SmallInt2  
 MannedCode

Code that indicates whether the platform is manned or unmanned.

For a complete list of codes, see tManned Table.

UnsignedTinyInt1  
 MMSComplexIDUnique Minerals Management Service (MMS) identifier assigned to a single structure or group of structures connected by a walkway.Integer4  
 MMSNumberUnique Minerals Management Service (MMS) number assigned to a specific structure within a complex.SmallInt2  
 WellCountNumber of wells connected to a platform.SmallInt2  
 PBNDefinitionCombination of protraction, block, and name of the offshore location.VarChar255  
 RowVersionUsed for version stamping.Binary8   
Objects that tLocOffshore depends on
 Database ObjectObject TypeDescriptionDep Level
tContract tabletContractTable

Contains records for primary insurance policies.

2
tExposureSet tabletExposureSetTableContains exposure set information. An exposure set is a collection of contracts, locations, and other related information.3
tLocation tabletLocationTable

Contains geographical attributes and primary risk characteristics for each location. It serves as a reference point between Location and Contract entities.  All locations entities are tied together by the same Location SID.

1
See Also

Related Objects

AIRExposure 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.