Stores risk characteristics for each offshore location.
Stores risk characteristics for each offshore location.
Creation Date | 4/11/2022 6:15 PM |
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 |