| Name | Offshore_Position |
|---|---|
| Entity Type | Extension of Position |
| Description | Properties of a position located offshore. |
| Submodel | Spatial |
| Entity Scope | Project |
| Primary Key | Position_Id |
| Natural Key | |
| Generalizations | Tracked_Object |
| Specializations |
| Name | Value Domain | Property / Storage Unit | Description | Required / Default | Type |
|---|---|---|---|---|---|
| Block_Fraction | STRING255 | NA |
Block fraction. | No |
VARCHAR2(255) |
| Block_Prefix | STRING255 | NA |
Alpha prefix to block number; e.g., A in addition area in U.S. OCS. | No |
VARCHAR2(255) |
| Block_Suffix | STRING255 | NA |
Block number suffix; e.g., to denote license or relinquishment of a block | No |
VARCHAR2(255) |
| Grid_Block_E_W | STRING255 | NA |
East or west direction. | No |
VARCHAR2(255) |
| Grid_Block_N_S | STRING255 | NA |
North or south direction. | No |
VARCHAR2(255) |
| Grid_Block_Range | STRING255 | NA |
Measure of UTM grid-number of range blocks from central meridian. | No |
VARCHAR2(255) |
| Grid_Block_Tier | STRING255 | NA |
Number of tiers of blocks measured from the equator. | No |
VARCHAR2(255) |
| Insert_Date | DATE | NA |
Date the entity was created in the repository | No |
DATE |
| Insert_User | STRING64 | NA |
The name of the user responsible for the creation of this entity in the repository. | No |
VARCHAR2(64) |
| Offshore_Area | STRING255 | NA |
Name of an offshore area or concession; e.g., Green Canyon or Haltenbank | No |
VARCHAR2(255) |
| Offshore_Block | STRING255 | NA |
Block or parcel number within a specified quadrant. | No |
VARCHAR2(255) |
| Position_Id | Position |
|
Properties of a Position located offshore. | Yes |
NUMBER(38) |
| Produced_By | STRING64 | NA |
The name of application role that created the entity, for data created programmatically. | No |
VARCHAR2(64) |
| Quadrant | STRING255 | NA |
Name or number of a quadrant. | No |
VARCHAR2(255) |
| Quadrant_Prefix | STRING255 | NA |
Quadrant prefix denoting name if designated by letters or abbreviation of offshore area | No |
VARCHAR2(255) |
| SDAT_Label | int | No_Unit |
Label used by the security system for entitlements. SDAT is Secure Data Access Technology. | No |
NUMBER(10) |
| Update_Date | DATE | NA |
Date of the most-recent modification to the entity. | No |
DATE |
| Update_User | STRING64 | NA |
The name of the user responsible for the last modification to this entity. | No |
VARCHAR2(64) |
| Water_Bottom_Zone | ZONE_NAME | NA |
Zone or water bottom identifier. | No |
VARCHAR2(255) |
| Water_Depth | double | Length m |
Distance from the mudline or seafloor to Sea Level. | No |
NUMBER |
| Water_Ref | STRING255 | NA |
Sea level reference used for the Water Depth property (e.g., Mean Sea Level, Least Astronomic Tide, Caspian Sea Level, etc.) | No |
VARCHAR2(255) |
| Link | To Entity | Description | Implementation Technique | Required |
|---|---|---|---|---|
| Position | Position | Properties of a Position located offshore. | Cascade | Yes |