| 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 | Property / Storage Unit | 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 |
| 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) |
| 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 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 (+) |