| Name | Geophysical_Inventory |
|---|---|
| Entity Type | Table |
| Description | An Inventory of all tapes/files containing seismic, navigation data, or any other data associated with a seismic data set. |
| Submodel | Seismic |
| Entity Scope | Project |
| Primary Key | Id |
| Natural Key | |
| Generalizations | Entity , IT_Object , Tracked_Object |
| Specializations |
| Name | Value Domain / Measurement | Description | Required / Default | Type |
|---|---|---|---|---|
| Acquisition_2D_Id | Acquisition_2D |
Refers to 2D acquisition for which this data belongs to. | No |
NUMBER(38) |
| Acquisition_3D_Id | Acquisition_3D |
Refers to the 3D acquisition for which this data belongs to. | No |
NUMBER(38) |
| Author | STRING255 NA |
The system or the company generated the data on the tape. | No |
VARCHAR2(255) |
| Barcode | STRING255 NA |
A number similar to inventory id but could have duplicate number and this is one other way of identifying in Expeditor. | No |
VARCHAR2(255) |
| Bulk_Array_Id | Bulk_Array |
The bulk array for storage of the seismic data. | No |
NUMBER(38) |
| Existence_Kind | REF_EXISTENCE_KIND NA |
A reference value that describes the state of existence in the lifecycle of the entity, for example, Planned, Predicted, Required, Simulated, and Actual. | Yes Actual |
VARCHAR2(64) |
| File_Type | R_File_Type |
Refers to file type. Ex: "ASCII", "BINARY", "EBCDIC" | No |
VARCHAR2(64) |
| First_CDP | double No_Unit |
First Common Depth Point (CDP) of the file. | No |
NUMBER |
| First_Field_File | double No_Unit |
First Field file number of the acquisition seismic data file. | No |
NUMBER |
| First_I_Line | double No_Unit |
First I axis line number of the file. | No |
NUMBER |
| First_J_Line | double No_Unit |
First J axis line number of the file. | No |
NUMBER |
| First_Shotpoint | double No_Unit |
First Shotpoint of the file. | No |
NUMBER |
| Foreign_Rep_Object_Id | STRING255 NA |
Unique number to identify the object on a foreign system( Expeditor, SeisDB, SDMS). | No |
VARCHAR2(255) |
| Foreign_Repository_System | R_Foreign_Rep_System |
Refers to the foreign repository system from which the dataset has been migrated. | No |
VARCHAR2(64) |
| Full_Path_Filename | FILE_NAME_STR NA |
Full path of the disk file. | No |
VARCHAR2(999) |
| GUID | STRING128 NA |
Globally Unique IDentifier for an instance of a class. This GUID is not generated by the database, but is the GUID used by the application on first access of this object. Use of this property is optional and completely under the control of application developers. | No |
VARCHAR2(128) |
| Id | ID No_Unit |
Unique identifier for this entity. | 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) |
| Inventory_Item_Rank | int No_Unit |
An integer that represents the relative position of the inventory item in a sequentially ordered set of processed seismic data. | No 1 |
NUMBER(10) |
| Inventory_Type | R_Inventory_Type |
Refers to inventory type. Ex: File/Tape/Visual/map/report. | Yes |
VARCHAR2(64) |
| Last_CDP | double No_Unit |
Last Common Depth Point (CDP) of the file. | No |
NUMBER |
| Last_Field_File | double No_Unit |
Last Field file number of the acquisition seismic data file. | No |
NUMBER |
| Last_I_Line | double No_Unit |
Last I axis line number of the file. | No |
NUMBER |
| Last_J_Line | double No_Unit |
Last I axis line number of the file. | No |
NUMBER |
| Last_Shotpoint | double No_Unit |
Last shotpoint of the file. | No |
NUMBER |
| MMS_Tape | STRING255 NA |
Western Geco tape identification number on robotic system. | No |
VARCHAR2(255) |
| Media_Type | R_Media |
Define the storage media used to store inventory data. | No |
VARCHAR2(64) |
| Name | ENTITY_NAME NA |
The name given to any object or data item, e.g. Name of Well, Name of Field, etc. | No |
VARCHAR2(255) |
| Online_Flag | boolean NA |
Flag to indicate whether the file is ONLINE or OFFLINE. Value of 1 indicates online and 0 indicates offline. | No |
NUMBER(1) |
| Original_Source | STRING64 NA |
The name of the person, Organization or project source that originally provided this entity, e.g. "IHS-EnergyData" or "FinderUpper Stratton Deeper Pool 15" | No |
VARCHAR2(64) |
| Produced_By | STRING64 NA |
ID of the activity that was executing when the entity was created, for data created programmatically. | No |
VARCHAR2(64) |
| Remarks | STRING2000 NA |
Any type of remarks added to an entity instance. | No |
VARCHAR2(2000) |
| SDAT_Label | int No_Unit |
Label used by the security system for entitlements. SDAT is Secure Data Access Technology. | No |
NUMBER(10) |
| Source | STRING64 NA |
Name of the person or organization responsible for this entity"s E and P content and quality. Not the data technologist or IT expert creating the entity, for which see IT_Object.Insert_User and Update_User. | No |
VARCHAR2(64) |
| Tape_Creation_Date | DATE NA |
The inventory item creation date. | No |
DATE |
| Trace_Count | int No_Unit |
Number of traces in the geophysical inventory item | 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) |
| Version | STRING255 NA |
The form or variant of the entity. | Yes 1 |
VARCHAR2(255) |
| Visual_Flag | boolean NA |
Flag to indicate whether this file can be viewed or not. | No |
NUMBER(1) |
| Cardinality | Entity |
|---|---|
| Many | Header_Text |
| From Entity | Link | Description | Implementation Technique | Required |
|---|---|---|---|---|
| Archive_File_Inventory_X | Geophysical_Inventory | Specifies the file of geophysical inventory | Cascade | No |
| Dataset_Inventory_X | Geophysical_Inventory | Specifies the geophysical inventory item. | Restrict | No |
| Inventory_Boundary | Geophysical_Inventory | Refers to the geophysical inventory item for which this is the boundary defined | Cascade | No |
| Inventory_Line_Segment | Geophysical_Inventory | Refers to geophysical inventory associated with seismic line segment | Cascade | No |
| Seismic_Record | Geophysical_Inventory | Geophysical inventory (seismic data file) associated with the seismic record data. | Cascade | Yes |
| Link | To Entity | Description | Implementation Technique | Required |
|---|---|---|---|---|
| Inventory_Type | R_Inventory_Type | Refers to inventory type. Ex: File/Tape/Visual/map/report. | Restrict | Yes |
| Media_Type | R_Media | Define the storage media used to store inventory data. | Restrict | No |
| Foreign_Repository_System | R_Foreign_Rep_System | Refers to the foreign repository system from which the dataset has been migrated. | Restrict | No |
| Bulk_Array | Bulk_Array | The bulk array for storage of the seismic data. | Control | No |
| Acquisition_2D | Acquisition_2D | Refers to 2D acquisition for which this data belongs to. | Cascade | No |
| Acquisition_3D | Acquisition_3D | Refers to the 3D acquisition for which this data belongs to. | Cascade | No |
| File_Type | R_File_Type | Refers to file type. Ex: "ASCII", "BINARY", "EBCDIC" | Restrict | No |