Stores risk characteristics for each offshore location.
CEDE 2024 (12.0) Database Reference
tLocOffshore Table
Stores risk characteristics for each offshore location.
| Creation Date | 6/5/2024 11:42 AM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 0 |
| Data Space Used | 0.00 KB |
| Index Space Used | 0.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | LocationSID | Unique system-generated sequential identifier for the location record. For a complete list of records, see tLocation Table. | int | 4 | |||
| AIRStructureID | Unique AIR-assigned identifier for the platform. | varchar | 255 |  | |||
| CompanySizeCode | Code that represents the size of the company. For a complete list of codes, see tCompanySize Table. | tinyint | 1 | | |||
| DailyGasProductionRate | Rate of gas produced by the platform per day. | float | 9 | | |||
| 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. | varchar | 10 | | |||
| DailyOilProductionRate | Rate of oil produced by the platform per day. | float | 9 | | |||
| 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. | varchar | 10 | | |||
| DeckCount | Number of decks on the platform. | smallint | 2 | | |||
| DeckHeight | Height of the deck above the water's surface. | float | 9 | | |||
| 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. | varchar | 10 | | |||
| SlotCount | Number of wells the platform is licensed to drill. | smallint | 2 | | |||
| SlotDrillCount | Number of wells currently drilled. | smallint | 2 | | |||
| TopsideCost | Cost of the decks and equipment on the platform as a percentage of the platform replacement cost. | float | 9 | | |||
| TransverseFrameTypeCode | Code that represents the type of transverse framing used to brace the platform legs. For a complete list of codes, see tTransverseFrameType Table. | tinyint | 1 | | |||
| LegCount | Total number of legs on the platform. | smallint | 2 | | |||
| MannedCode | Code that indicates whether the platform is manned or unmanned. For a complete list of codes, see tManned Table. | tinyint | 1 | | |||
| MMSComplexID | Unique Minerals Management Service (MMS) identifier assigned to a single structure or group of structures connected by a walkway. | int | 4 | | |||
| MMSNumber | Unique Minerals Management Service (MMS) number assigned to a specific structure within a complex. | smallint | 2 | | |||
| WellCount | Number of wells connected to a platform. | smallint | 2 | | |||
| PBNDefinition | Combination of protraction, block, and name of the offshore location. | varchar | 255 | | |||
| RowVersion | Used for version stamping. | timestamp | 8 |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tContract | Table | Stores records for primary insurance policies. | 2 |
| tExposureSet | Table | Stores information about exposure sets. An exposure set is a collection of contracts, locations, and other related information. | 3 |
| tLocation | Table | Stores geographical attributes and primary risk characteristics for each location. The table serves as a reference point between Location and Contract entities.You can identify each location by the location sequential identifier (SID). | 1 |