Stores risk characteristics for each offshore location.
Stores risk characteristics for each offshore location.
Creation Date | 4/12/2021 11:26 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. | 2 | |
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 |