| 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 |
| Name | Value Domain / Measurement | Description | Required / 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 |
| 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_Maximum | double No_Unit |
Maximum value of data | No |
NUMBER |
| Trace_Minimum | double No_Unit |
Minimum value of data | No |
NUMBER |
| Trace_Name | CODE NA |
A standard abbreviation, mnemonic, or short code that represents the reference value. | Yes |
VARCHAR2(64) |
| 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) |
| Link | To Entity | Description | Implementation Technique | Required |
|---|---|---|---|---|
| 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 |
CREATE OR REPLACE VIEW Log_Header_DOV(ID, UBHI, BOREHOLE_NAME, TRACE_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.Code Trace_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
where bh.id = lcSet.borehole_id
and lcSet.id = lc.log_channel_set_id
and nvl(lc.axis_flag, -1) != 1
and lc.id = lcStat.log_channel_id (+)
and not exists (select 1 from bulk_array ba
where ba.id = lcSet.bulk_array_id
and ba.code_d1 = lc.code)
|