The .wlx File

<< Click to Display Table of Contents >>

EQuIS 7  >>  Professional > Interfaces > WinLoG >

The .wlx File

Header Text

WinLoG Database

EQuIS

Comments

Monitoring Well ID

Borehole_Text.Type = "Monitoring Well ID " Borehole_Text.Value

 
DT_LOCATION.SYS_LOC_CODE

 

Borehole ID

Borehole_Text.Type = "Borehole ID:"

Borehole_Text.Value

 
DT_LOCATION.SYS_LOC_CODE

 

PROJECT No:

Borehole_Text.Type = "PROJECT No:'"

Borehole_Text.Value

DT_FACILITY.FACILITY_NAME/FACILITY_CODE
joined with DT_LOCATION

 

SITE:

Borehole_Text.Type = "SITE:"

Borehole_Text.Value

 
DT_LOCATION.SUBFACILITY_CODE

 

CLIENT:

Borehole_Text.Type = "CLIENT:"

Borehole_Text.Value

 

DT_FACILITY.CLIENT joined with DT_LOCATION

 

DATE:

Borehole_Text.Type = "DATE:"

Borehole_Text.Value

 
DT_LOCATION.START_DATE

 

LOGGED BY:

Borehole_Text.Type = "LOGGED BY:"

Borehole_Text.Value

 
DT_LOCATION.GEOLOGIST

 

CONTRACTOR:

Borehole_Text.Type = "CONTRACTOR:"

Borehole_Text.Value

 
DT_LOCATION.DRILLING_SUBCONTRACTOR

UK IDEF uses DRILLING_SUBCONTRACTOR instead of DT_LOCATION.ENGINEER_SUBCONTRACTOR

EASTING:

Borehole_Text.Type = "EASTING:"

Borehole_Text.Value

 

VW_LOCATION.X_COORD

 

NORTHING:

Borehole_Text.Type = "NORTHING:"

Borehole_Text.Value

 
VW_LOCATION.Y_COORD

 

ELEVATION:

Borehole_Text.Type = "ELEVATION:"

Borehole_Text.Value

 
VW_LOCATION.SURF_ELEV

 
Limited to two decimal places

 

Footer Text

WinLoG Database

EQuIS

Comments

NOTES

Borehole_Memo.Type = "NOTES"

Borehole_Memo.Value

DT_LOCATION.REMARK_1

 

Drilling Method:

Borehole_Text.Type = "Drilling Method: "

Borehole_Text.Value

 
DT_LOCATION.DRILLING_METHOD

 

Borehole Diameter:

Borehole_Text.Type = "Borehole Diameter:"

Borehole_Text.Value

DT_DRILL_ACTIVITY.DIAMETER  AND DT_DRILL_ACTIVITY.DIAMETER_UNIT

 
If blank then WinLoG populates pdf with the Borehole ID

Screen Material:

Borehole_Text.Type = "Screen Material:"

Borehole_Text.Value

DT_WELL_SEGMENT.MATERIAL_TYPE_CODE where SEGMENT_TYPE = "CASING\SCREEN"

 

Screen Diameter:

Borehole_Text.Type = "Screen Diameter::"

Borehole_Text.Value

max(DT_WELL_SEGMENT.OUTER_DIAMETER) where SEGMENT_TYPE = "CASING\SCREEN"

 

Screen Slot Size:

Borehole_Text.Type = "Screen Slot Size:"

Borehole_Text.Value

max(DT_WELL_SEGMENT.SLOT_SIZE) +DT_WELL_SEGMENT.SLOT_SIZE_UNIT where SEGMENT_TYPE = "CASING\SCREEN"

 

Sand Particle Size:

Borehole_Text.Type = "Sand Particle Size:"

Borehole_Text.Value

DT_WELL_SEGMENT.MATERIAL_DENSITY where SEGMENT_TYPE = "SEAL\PACKING" and MATERIAL_TYPE_CODE = "SAND" or "GRAVEL" and max(END_DEPTH)

 

 

Lithology

WinLoG Database

EQuIS

Comments

LEGEND

Lithology.StatumCode Lithology.StratumLibrary Lithology.StratumFGColor = 0 Lithology.StratumBGColor = 16777215 Lithology.StratumFGColor2 = 0 Lithology.StratumBGColor2 = 16777215

 
 
 
 
RT_MATERIAL.PATTERN

 

DEPTH

Lithology.TopDepth, Lithology.BottomDepth

N_LITHOLOGY.START_DEPTH, FN.LITHOLOGY.END_DEPTH

 

DESCRIPTION

Lithology.Name, Lithology.Description

FN_LITHOLOGY.MATERIAL_NAME, FN.LITHOLOGY.REMARK_1

 

 

Well

WinLoG Database

EQuIS

Comments

DEPTH

WellType3.WellNumber = "WELL DETAIL"

WellType3_Components.WellNumber = "WELL DETAIL"

WellType3_Components.StartDepth

WellType3_Components.EndDepth

Remarks.RemarkType = "WELL DEPTH"

Remarks_Text.RemarkType = "WELL DEPTH"

Remarks_Text.Depth

Remarks_Text.Remark

 
WELLTYPE3_COMPONENTS

DT_WELL_SEGMENT.START_DEPTH

DT_WELL_SEGMENT.END_DEPTH

REMARKS_TEXT

DT_WELL_SEGMENT.END_DEPTH,

DT_WELL_SEGMENT.END_DEPTH + DT_WELL_SEGMENT.DEPTH_UNIT

 

DETAIL

WellType3.WellNumber = "WELL DETAIL" WellType3.WellDiameter

WellType3.WellWidth = "100"

WellType3_Components.WellNumber = "WELL DETAIL"

WellType3_Components.Component

WellType3_Components.InnerDiameter

WellType3_Components.OuterDiamter

WellType3_Components.Symbol

WellType3_Components.Library

WellType3_Components.FGColor = 0

WellType3_Components.BGColor = 16777215

 
 
 
WELLTYPE3

MAX(DT_WELL_SEGMENT.OUTER_DIAMETER)

WELLTYPE3_COMPONENTS

DT_WELL_SEGMENT.SEGMENT_TYPE

DT_WELL_SEGMENT.INNER_DIAMETER

DT_WELL_SEGMENT.OUTER_DIAMETER

RT_WELL_SEGMENT_TYPE.PATTERN

RT_WELL_SEGMENT_TYPE.PATTERN_LIBRARY

 
 
 
 
 
 
WellType3.WellWidth can be from 1 to 100

WellType3_Components.Component must be one of the following: Cover Cap, Joint/Misc, Casing/Screen Seal/Packing, Bottom Seal

16777215 = Color White, 0 = Color Black

 

Water Level

WinLoG Database

EQuIS

Comments

Water  Level

WellType3.WellNumber = "WATER LEVEL"

WellType3.WellDiameter = "10"

WellType3.WellWidth = "100"

WellType3_WaterLevels.WellNumber = "WATER LEVEL"

WellType3_WaterLevels.Depth

WellType3_WaterLevels.Text

WellType3_WaterLevels.Symbol

WellType3_WaterLevels.FGColor = "16711680"

WellType3_WaterLevels.Size

 
 
 
 
 
WELLTYPE3_WATERLEVELS

DT_WATER_LEVEL.CORRECTED_DEPTH \ WATER_LEVEL_DEPTH

DT_WATER_LEVEL.CORRECTED_DEPTH \ WATER_LEVEL_DEPTH + DT_WATER_LEVEL.DEPTH_UNIT

 
 
 
 
 
WellType3.WellWidth can be from 1 to 100

WellType3_WaterLevels.Symbol can be either 1 or 2

WellType3_WaterLevels.FGColor = 16711680 = Color Blue

WellType3_WaterLevels.Size can be from 1 to 10

 

PID

WinLoG Database

EQuIS

Comments

PID

TextIntervals.Type = "PID"

TextIntervals.TextData

TextIntervals.TopDepth

TextIntervals.BottomDepth

TextIntervalsSummary.Type = "PID"

DT_RESULT.RESULT_TEXT + DT_RESULT.RESULT_TYPE_CODE WHERE DT_RESULT.CAS_RN = "PID" AND DT_TEST.ANAYTIC_METHOD != "FIELD MEASURE"

DT_SAMPLE.START_DEPTH

DT_SAMPLE.END_DEPTH

 

 

Sample

WinLoG Database

EQuIS

Comments

Label

TextIntervals.Type = "SAMPLE LABEL"

TextIntervals.TextData

TextIntervals.TopDepth

TextIntervals.BottomDepth

TextIntervalsSummary.Type = "SAMPLE LABEL"

TEXTINTERVALS.TYPE = "SAMPLE LABEL"

TEXTINTERVALS.TEXTDATA

TEXTINTERVALS.TOPDEPTH

TEXTINTERVALS.BOTTOMDEPTH

TEXTINTERVALSSUMMARY.TYPE = "SAMPLE LABEL"

 

Depth

TextIntervals.Type = "SAMPLE DEPTH"

TextIntervals.TextData

TextIntervals.TopDepth

TextIntervals.BottomDepth

TextIntervalsSummary.Type = "SAMPLE DEPTH"

 
 
DT_SAMPLE.SYS_LOC_CODE

DT_SAMPLE.START-DEPTH

DT_SAMPLE.END_DEPTH