Log_Header_DOV


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

General Information

[Next]
Name Log_Header_DOV
Entity Type ObjectView
Description Data Object View. A well log is a record of information about the geological formations that have been drilled through. The Log Header DOV provides basic information about well logs.
Submodel Data_Object
Entity Scope Project
Primary Key Id
Natural Key
Generalizations
Specializations


Columns

[Previous] [Next] [Top]
NameValue DomainProperty /
Storage Unit
DescriptionRequired /
Default
Type
Axis_Flag boolean No_Unit
A flag value to indicate if this channel describes a coordinate axes of an array. 1 = Channel is an axis. 0 = Channel is not an axis. No
NUMBER(1)
Borehole_Id Borehole
READ ONLY: Unique identifier for the Borehole. No
NUMBER(38)
Borehole_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)
Borehole_Trace_Version int NA
The system generated sequence for the number of channels with this code loaded to this borehole. This number will not be reused if the channel is deleted. It is not shareable across projects. No
NUMBER(10)
Bulk_Array_Id Bulk_Array
READ ONLY: Unique identifier for the bulk array. No
NUMBER(38)
Direction CODE NA
The Direction attribute specifies the behavior of the signed value of the Index. If this Attribute is absent, then Index direction is unknown or irrelevant. Options are DECREASING (Index decreases monotonically) or INCREASING (Index increases monotonically). No
VARCHAR2(64)
Id ID No_Unit
Unique identifier for this entity. Yes
NUMBER(38)
Index_Maximum double No_Unit
Specifies the maximum value of the Index Channel. No
NUMBER
Index_Minimum double No_Unit
Specifies the minimum value of the Index Channel. No
NUMBER
Index_Type CODE NA
The index type attribute specifies the type of Index, if present. Typical options include ANGULAR-DRIFT (Index measures angle about the Vertical Generatrix), BOREHOLE-DEPTH, (Index measures depth along the borehole) NON-STANDARD (Index is not a standard measurement), RADIAL-DRIFT (Index measures distance from the Vertical Generatrix), TIME (Index measures elapsed time), VERTICAL-DEPTH (Index measures depth along the Vertical Generatrix). If index type is absent, then there is no Index Channel and attributes Direction and Spacing provide the implicit index method. No
VARCHAR2(64)
Index_UOM CODE
The unit for the index axis as stored in the bulk data or offline on the original tape. No
VARCHAR2(64)
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)
Log_Channel_Set_Id Log_Channel_Set
READ ONLY: Unique identifier for the log channel set. No
NUMBER(38)
Preferred_Flag CODE NA
The source of preferred usage. No
VARCHAR2(64)
Process_History CODE NA
Summary of the log channel processing that was applied to this log channel. Examples are, Edited, Raw, Composite and Digitized. No
VARCHAR2(64)
Rank int No_Unit
The rank of a Log_Channel in a Log_Channel_Set No
NUMBER(10)
Remarks REMARKS_STR NA
Any type of remarks added to an entity instance. No
VARCHAR2(999)
Sample_Count int No_Unit
The number of valid (not null) data values in the log channel. No
NUMBER(10)
Sampling_Rate double No_Unit
The Spacing attribute can be used to indicate a constant spacing of the Index. Its value is the signed difference of the later minus the earlier Index between any (and every) two successive channels of a given set. Thus, the Spacing Attribute is negative if the Index is decreasing (e.g., an up log) and is positive if the Index is increasing (e.g., a down log). No
NUMBER
Service_Name STRING255 NA
The name of the service associated with the object No
VARCHAR2(255)
Source STRING64 NA
Name of the Business_Associate 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)
Source_Trace_Version STRING255 NA
The curve version number meaningful to the user or in the exchange file. This is not the version number of the acquisition or processing software used to produce or modify the data. Yes
VARCHAR2(255)
Trace_Code CODE NA
A standard abbreviation, mnemonic, or short code that represents the reference value. Yes
VARCHAR2(64)
Trace_Maximum double No_Unit
Maximum value of data No
NUMBER
Trace_Minimum double No_Unit
Minimum value of data No
NUMBER
Trace_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)
Trace_Namespace CODE NA
The person, company or application that defined or specified the data (content) for this instance and is considered to be responsible for it. For example, POSC, EPSG, API, ISO, etc.. Yes
VARCHAR2(64)
UBHI WELL_IDENTIFIER NA
The Unique Identifier assigned to a borehole Yes
VARCHAR2(64)
Unit_Of_Measure CODE No_Unit
The unit for the measurement as stored in the bulk data or offline on the original tape. Yes
VARCHAR2(64)
Valid_Channel_Flag boolean No_Unit
A flag value that states whether or not this instance of the channel is valid. This allows questionable data to be preserved for cleanup or validation at a later time. An example of an invalid channel occurs when incoming data attempts to load an array with an invalid or missing unit of measure. The flag value is 1 (TRUE) if the channel is valid and 0 (FALSE) if the channel is invalid by some test. The default value is 1, stating that the parameter is valid. Error messages or comments addressing invalid parameter data should be made in the Remarks attribute. Invalid channels with AXIS_FLAG = 1 (TRUE) should be rejected at load time and never be added to the database. No
NUMBER(1)


Refers To

[Previous] [Next] [Top]
LinkTo EntityDescriptionImplementation TechniqueRequired
Bulk_Array Bulk_Array READ ONLY: Unique identifier for the bulk array. Nullify No
Log_Channel_Set Log_Channel_Set READ ONLY: Unique identifier for the log channel set. Nullify No
Borehole Borehole READ ONLY: Unique identifier for the Borehole. Nullify No


View Definition

[Previous] [Top]

CREATE OR REPLACE FORCE VIEW Log_Header_DOV(ID, UBHI, BOREHOLE_NAME, TRACE_NAME, TRACE_CODE, SERVICE_NAME, TRACE_NAMESPACE, UNIT_OF_MEASURE, BOREHOLE_TRACE_VERSION, SOURCE_TRACE_VERSION, PREFERRED_FLAG, AXIS_FLAG, RANK, PROCESS_HISTORY, TRACE_MINIMUM, TRACE_MAXIMUM, VALID_CHANNEL_FLAG, DIRECTION, INDEX_MINIMUM, INDEX_MAXIMUM, INDEX_UOM, SAMPLING_RATE, SAMPLE_COUNT, INDEX_TYPE, SOURCE, REMARKS, INSERT_DATE, INSERT_USER, BULK_ARRAY_ID, BOREHOLE_ID, LOG_CHANNEL_SET_ID) AS select
  lc.Id                      Id,
  bh.UBHI                    UBHI,
  bh.Name                    Borehole_Name,
  lc.Name                    Trace_Name,
  lc.Code                    Trace_Code,
  lr.Name                    Service_Name,
  lc.Namespace               Trace_Namespace,
  lc.Property_UOM            Unit_Of_Measure,
  lc.Borehole_Copy_Number    Borehole_Trace_Version,
  lc.Version                 Source_Trace_Version,
  lc.Preferred               Preferred_Flag,
  lc.Axis_Flag               Axis_Flag,
 
 lc.Rank                    Rank,
  lc.Process_History_Summary Process_History,
  lcStat.Min_Value           Trace_Minimum,
  lcStat.Max_Value           Trace_Maximum,
  lc.Valid_Channel_Flag      Valid_Channel_Flag,
  lcSet.Direction	     Direction,
  lcSet.Index_Min            Index_Minimum,
  lcSet.Index_Max            Index_Maximum,
  lcSet.Index_UOM            Index_UOM,
  lcSet.Spacing              Sampling_Rate,
  lcStat.Sample_Count        Sample_Count,
  lcSet.Index_Type           Index_Type,
  lc.Source                  Source,
  lc.Remarks                 Remarks,
  lc.Insert_Date             Insert_Date,
  lc.Insert_User             Insert_User,
  lcSet.Bulk_Array_Id        Bulk_Array_Id,
  bh.Id                      Borehole_Id,
  lcSet.Id                   Log_Channel_Set_Id
from
  borehole bh,
  log_channel_set lcSet,
  log_channel lc,
  log_channel_statistics lcStat,
  logging_run lr,
  logging_pass lp
where bh.id = lcSet.borehole_id
  and lcSet.id = 
lc.log_channel_set_id
  and nvl(lc.Rank, -1) != 1
  and lc.id = lcStat.log_channel_id (+)
  and lcSet.log_acq_activity_id = lp.id (+)
  and lp.logging_run_id = lr.id (+)
   


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

Copyright © 2018 Schlumberger. All rights reserved.