| Name | Geologic_Layer |
|---|---|
| Entity Type | Table |
| Description | A three-dimensional geologic feature. |
| Submodel | Geology |
| Entity Scope | Project |
| Primary Key | Id |
| Natural Key | |
| Generalizations | Geologic_Feature , Feature , Entity , IT_Object , Tracked_Object |
| Specializations | Geologic_Facies , Stratigraphic_Layer |
| Name | Value Domain / Measurement | Description | Required / Default | Type |
|---|---|---|---|---|
| Base_Strat_Surface_Id | Stratigraphic_Surface |
Reference to the unique identifier of the base bounding surface. | No |
NUMBER(38) |
| Default_Color | COLOR_RGB NA |
Default color to be used when rendering this geologic feature. | No |
VARCHAR2(64) |
| 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) |
| Fauna | R_Fauna |
The fauna found in this geologic layer. | No |
VARCHAR2(64) |
| 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) |
| Geologic_Age | double Geologic_Time |
The minimum geologic age of the feature in millions of years. | No |
NUMBER |
| Geologic_Age_Duration | double Geologic_Time |
The duration of the geologic event. | No |
NUMBER |
| Hydrocarbon_System_Role | CODE NA |
The characteristic role this geologic unit portrays in hydrocarbon system. The roles include, source, carrier, reservoir, seal or combination. | No |
VARCHAR2(64) |
| 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) |
| Lithologic_Description | STRING255 NA |
A free text description of the lithology or mix of assorted Lithology contained in this layer. | No |
VARCHAR2(255) |
| 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) |
| 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) |
| Primary_Lithology | R_Lithology |
The primary lithology that defines this Geologic Layer. An example is Chalk for the Austin Chalk Formation. | 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) |
| Standard_Layer_Name | R_Geologic_Layer |
The standard or formal geologic layer name. For lithostratigraphy this will be the identifier of the formation name. An example is Austin for the Austin Chalk Formation. | No |
VARCHAR2(64) |
| Sub_Type | Meta_Entity |
Sub type of Geologic_Layer | No |
VARCHAR2(30) |
| Top_Strat_Surface_Id | Stratigraphic_Surface |
Reference to the unique identifier of the top bounding surface. | No |
NUMBER(38) |
| Type_Locality_Id | Position |
A type locality is the place where the geologic layer is best known or most clearly defined. | No |
NUMBER(38) |
| 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) |
| From Entity | Link | Description | Implementation Technique | Required |
|---|---|---|---|---|
| Borehole_Zone | Geologic_Layer | Geologic layer which is intersected by the borehole across this borehole zone. | Restrict | No |
| Geologic_Layer_Parm | Geologic_Layer | The unique identifier of the layer to which the parameter or property applies. | Cascade | Yes |
| Geologic_Layer_Time | Geologic_Layer | The geologic layer related to a geochronologic time. | Cascade | Yes |
| Kick | Geologic_Layer | The geologic layer where the kick occurred. | Nullify | No |
| Land_Zone | Geologic_Layer | The identifier of a geologic layer. If a land zone is described in terms of a named formation or zone, this can be used to store the reference to it. | Restrict | No |
| Land_Zone_Substance | Geologic_Layer | The identifier of a geologic layer. If a zone is described in terms of a named formation or zone, this can be used to store the reference to it. | Restrict | No |
| Layer_Column_Assembly | Geologic_Layer | The layer occurring in these Strat columns | Restrict | Yes |
| Layer_Composite | Sub_Layer | A layer which is part of another layer. This is the part fraction of the whole-part relationship. | Cascade | Yes |
| Layer_Composite | Super_Layer | A layer which has other layers as parts. This is the whole portion of the whole-part relationship. | Cascade | Yes |
| Layer_Event_Environment | Geologic_Layer | The unique identifier of the geologic layer that was part of the environment in which the event occurred. | Cascade | Yes |
| Layer_Synonym | Geologic_Layer | The primary layer which is the same as another layer with a different name. | Cascade | Yes |
| Layer_Synonym | Geologic_Layer_Synonym | A layer alias which is the same meaning as the key layer, but which has a different name. | Cascade | Yes |
| Rock_Fluid_Feature | Geologic_Layer | The stratigraphic layer that contains this reservoir or aquifer. | Restrict | No |
| Rock_Sample_Stratigraphy | Geologic_Layer | Name of layer penetrated by the rock sample. | Restrict | Yes |
| Spatial_Correlation | Geologic_Layer | Only pairs of points that belong to this facies will be used in the variogram calculation. | Restrict | No |
| Well_Test_Interpretation | Geologic_Layer | The layer that was targeted during the well test. | Restrict | No |
| Link | To Entity | Description | Implementation Technique | Required |
|---|---|---|---|---|
| Primary_Lithology | R_Lithology | The primary lithology that defines this Geologic Layer. An example is Chalk for the Austin Chalk Formation. | Restrict | No |
| Base_Strat_Surface | Stratigraphic_Surface | Reference to the unique identifier of the base bounding surface. | Restrict | No |
| Standard_Layer_Name | R_Geologic_Layer | The standard or formal geologic layer name. For lithostratigraphy this will be the identifier of the formation name. An example is Austin for the Austin Chalk Formation. | Restrict | No |
| Type_Locality | Position | A type locality is the place where the geologic layer is best known or most clearly defined. | Control | No |
| Top_Strat_Surface | Stratigraphic_Surface | Reference to the unique identifier of the top bounding surface. | Restrict | No |
| Fauna | R_Fauna | The fauna found in this geologic layer. | Restrict | No |