| Name | WG_Geophysical_Inventory |
|---|---|
| Entity Type | Extension of Geophysical_Inventory |
| Description | An extension table containing WesternGeco specific attributes for a geophysical inventory item. |
| Submodel | WesternGeco |
| Entity Scope | Project |
| Primary Key | Geophysical_Inventory_Id |
| Natural Key | |
| Generalizations | Tracked_Object |
| Specializations |
| Name | Value Domain | Property / Storage Unit | Description | Required / Default | Type |
|---|---|---|---|---|---|
| Data_Attribute_Desc | R_WG_Data_Attribute_Desc |
|
A significant attribute of data, defined in WDMS. Supplemental description to primary attributes. | No |
VARCHAR2(64) |
| Facility_Id | WG_Facility |
|
The WesternGeco facility in which the geophysical inventory item is stored. | No |
NUMBER(38) |
| First_Alternate_Desc | STRING255 | NA |
An alternate description of the inventory item, such as Migrated. The alternate description may be used to search for the item. | No |
VARCHAR2(255) |
| Geophysical_Inventory_Id | Geophysical_Inventory |
|
The inventory item to which the additional attributes in this extension apply. | Yes |
NUMBER(38) |
| 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) |
| Linear_Unit | R_Unit |
|
The unit of measurement on a plane or a projected coordinate system, often meters or feet. (ESRI GIS Dictionary) | No |
VARCHAR2(64) |
| Max_Easting | double | Length m |
The maximum grid easting for an inventory item. | No |
NUMBER |
| Max_Northing | double | Length m |
The maximum grid northing for an inventory item. | No |
NUMBER |
| Min_Easting | double | Length m |
The minimum grid easting for an inventory item. | No |
NUMBER |
| Min_Northing | double | Length m |
The minimum grid northing for an inventory item. | No |
NUMBER |
| Produced_By | STRING64 | NA |
The name of application role that created the entity, for data created programmatically. | No |
VARCHAR2(64) |
| Received_Date_String | STRING64 | NA |
The value of date when the inventory item was received expressed as a string. This attribute is necessary to preserve legacy dates that cannot be converted to dates. | No |
VARCHAR2(64) |
| SDAT_Label | int | No_Unit |
Label used by the security system for entitlements. SDAT is Secure Data Access Technology. | No |
NUMBER(10) |
| Second_Alternate_Desc | STRING255 | NA |
A second alternate description of the inventory item, such as Migrated. The alternate description may be used to search for the item. | No |
VARCHAR2(255) |
| Third_Alternate_Desc | STRING255 | NA |
A third alternate description of the inventory item, such as Migrated. The alternate description may be used to search for the item. | No |
VARCHAR2(255) |
| 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) |
| Link | To Entity | Description | Implementation Technique | Required |
|---|---|---|---|---|
| Facility | WG_Facility | The WesternGeco facility in which the geophysical inventory item is stored. | Cascade | No |
| Geophysical_Inventory | Geophysical_Inventory | The inventory item to which the additional attributes in this extension apply. | Cascade | Yes |
| Linear_Unit | R_Unit | The unit of measurement on a plane or a projected coordinate system, often meters or feet. (ESRI GIS Dictionary) | Restrict | No |
| Data_Attribute_Desc | R_WG_Data_Attribute_Desc | A significant attribute of data, defined in WDMS. Supplemental description to primary attributes. | Restrict | No |