Geologic_Layer

[Columns] [Composed Of] [Referenced By] [Refers To]

General Information

[Next]
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


Columns

[Previous] [Next] [Top]
NameValue DomainProperty /
Storage Unit		DescriptionRequired /
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)
Field_Id Field
Association between Field and Geologic_Layer No
 NUMBER(38)
GUID STRING128 NA
 Globally Unique IDentifier for an instance of a class. USAGE NOTES: There are two cases: 1) GUID is not populated or used; and 2) it is populated with a value that is globally unique. If the GUID is populated there are two means of doing so for a given project: 2a) Seabed automatically generates and populates the GUID when an instance is created (valid only on Oracle based systems); and 2b) the GUID is generated and populated by an application (other than Seabed) on instance creation. Whether Seabed automatically generates GUIDs for a project is determined by the Auto_GUID flag in SDS_Account. Note that techniques 2a and 2b can coexist in the same project. When GUIDs are automatically generated an application can override the automatically generated GUID with its own GUID by simply supplying the GUID value. Applications that generate their own GUIDs and populate the GUID column will function correctly on projects which have automatic GUID generation turned on. No
 VARCHAR2(128)
Geologic_Age double Geologic_Time
Ma		 The minimum geologic age of the feature in millions of years. No
 NUMBER
Geologic_Age_Duration double Geologic_Time
Ma		 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
 The name of application role that created the entity, 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 entitys 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)


Referenced By

[Previous] [Next] [Top]
From EntityLinkDescriptionImplementation TechniqueRequired
Borehole_Seismic_Result Geologic_Layer The layer to which the velocity results applies. Nullify No
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_Synonym A layer alias which is the same meaning as the key layer, but which has a different name. Cascade Yes
Layer_Synonym Geologic_Layer The primary layer which is the same as another layer with a different name. Cascade Yes
Lithology Geologic_Layer The geologic layer associated with this lithology. Nullify No
Paleontology Geologic_Layer The name of layer pertaining to this paleontology. 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
Stylolite Geologic_Layer The geologic layer to which to this stylolite belongs. Nullify No
Well_Test_Interpretation Geologic_Layer The layer that was targeted during the well test. Restrict No


Refers To

[Previous] [Next] [Top]
LinkTo EntityDescriptionImplementation TechniqueRequired
Type_Locality Position A type locality is the place where the geologic layer is best known or most clearly defined. Control 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
Primary_Lithology R_Lithology The primary lithology that defines this Geologic Layer. An example is Chalk for the Austin Chalk Formation. Restrict 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
Base_Strat_Surface Stratigraphic_Surface Reference to the unique identifier of the base bounding surface. Restrict No
Field Field Association between Field and Geologic_Layer Cascade No


[Seabed Objects] [Entities in Schema Seabed] [Index]

Copyright © 2018 Schlumberger. All rights reserved.