Stores industry information for the offshore structures.
Touchstone Re 2022 Database Reference
TblOffshoreStructures Table
| Creation Date | 4/16/2011 12:41 PM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 19021 |
| Data Space Used | 3,784.00 KB |
| Index Space Used | 5,696.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | intAIRStructureID | Identifier for the offshore structure. | int | 4 | |||
| strStructureName | Name of the offshore structure. | varchar | 60 |  | |||
| intMMSComplexID | Unique Minerals Management Service (MMS) identifier assigned to a single structure or a group of structures connected by a walkway. | int | 4 | | |||
| intMMSNumber | Unique Minerals Management Service(MMS) number assigned to a specific structure within a complex. | smallint | 2 | | |||
| intCountry | ISO 2-character code for the country in which the offshore platform resides. For a complete list of codes, tCountry Table. | int | 4 | | |||
| strAdminstrationArea | Code that represents the Administrative geographic region. Options include:
| varchar | 3 | | |||
| strProtraction | Code that represents the Protraction geographic region. For a complete list of options, see the subarea codes in tGeography Table. | varchar | 2 | | |||
| strBlock | Code that represents the Block geographic region. For a complete list of options, see the postal codes in tGeography Table. | varchar | 4 | | |||
| fltLat | Latitude coordinate for the offshore structure. Values will be positive for locations north of the equator and negative south of the equator. | real | 4 | | |||
| fltLong | Longitude 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. | real | 4 | | |||
| fltDeckHeight | Height of the deck above the water, measured in meters. | float | 9 | | |||
| fltDailyOilProduction | Rate of oil produced by the platform per day, measured in barrels. | float | 9 | | |||
| fltDailyGasProduction | Rate of gas produced by the platform per day, measured in MCF (1,000 cubic feet). | float | 9 | | |||
| fltDailyRate | Rate of gas or oil produced by the offshore structure per day. | real | 4 | | |||
| fltReplacementValue | Replacement value for the offshore structure. | money | 8 | | |||
| intYearInstalled | Year the offshore structure was installed. | smallint | 2 | | |||
| intConstructionCode | Code that represents the AIR construction class. For a complete list of codes, see tAIRConstruction Table. | smallint | 2 | | |||
| intOccupancyCode | Code that represents the AIR occupancy class. For a complete list of codes, see tAIROccupancy Table. | smallint | 2 | | |||
| fltWaterDepth | Depth of the water at the location where the offshore structure is installed. | real | 4 | | |||
| fltDistancetoShore | Distance from the shore and where the offshore structure is installed. | real | 4 | | |||
| fltTopsideCost | Cost of the deck(s) and equipment on the offshore structure. | float | 9 | | |||
| intSlotCount | Number of wells the offshore structure is licensed to drill. | smallint | 2 | | |||
| intSlotDrillCount | Number of wells currently drilled. | smallint | 2 | | |||
| intTransFrameType | Type (or shape) of transverse framing used to brace the offshore structure's legs. | smallint | 2 | | |||
| intDeckCount | Number of decks on the offshore structure. | smallint | 2 | | |||
| intLegCount | Number of legs on the offshore structure. | smallint | 2 | | |||
| blDeckHeightFlag | Indicates whether the offshore structure contains a deck.
| bit | 1 | | |||
| blMannedUnmanned | Indicates whether the offshore structure is manned.
| bit | 1 | | |||
| strName | Name of the offshore structure. | varchar | 60 | | |||
| intCompanySize | Size of the company that operates the offshore structure. | int | 4 | | |||
| strNameWithoutSpaces | Same value as strName, except without spaces. | varchar | 60 | | |||
| guidExternal | GUID external associated with the offshore structure. | dbo.GUID | 16 | | |||
| | DateInstalled | Date and time the offshore structure was installed. | datetime | 4 | |||
| | DateRemoved | Date and time the offshore structure was installed. | datetime | 4 | |||
| intWellCount | Number of wells connected to the offshore platform. | smallint | 2 | | |||
| | blActive | Indicates whether the offshore structure is currently active.
| bit | 1 | ((1)) | ||
| blOnePlatformInBlock | Indicates whether there is more than one offshore structure within the same platform block geographic region.
| bit | 1 | ||||
| blCurrent | Indicates whether the offshore structure is currently in use.
| bit | 1 |