Data Dictionary

Well_Reports Database Program

All information in the Well_Reports database is in Imperial units.

Drillers Table
Driller_ID System generated number uniquely identifying the record
Last_Name Driller’s last name
Middle_Initial Driller’s middle initial
First_Name Driller’s First Name
Journeyman_Number Driller’s Journeyman number
Is_Active_Flag True if the driller is active

Drilling_Companies Table
Drilling_Company_ID System generated number uniquely identifying the record
Company_Name The drilling company name
PO_Box Post office Box
Street_Address Street address
City City
Province Province
Postal_Code Postal Code of the Drilling Company
e_Mail e-Mail address of the drilling company
GWRIS_ID Groundwater Information System ID number (historical reference only)
Is_Active_Flag True if the Drilling company is active

Driller_Drilling_Company_X_Refs
Drilling_Company_ID Foreign key to the Drilling Company table
Driller_ID Foreign key to the DrillersTable
Effective_Date Date this assignment became effective
Is_Active_Flag True if this assignment is still valid

Well_Owners Table
Well_Owner_ID System generated number uniquely identifying the record
Owner_Name The owner of the well at the time of drilling.
Address The well owner’s address.
PO_Box The postal box number of the well owner.
Postal_Code The postal code of the well owner.
Province The province of the well owner
Country The Country of the well owner

WELLS Table

1
Well_ID System generated number uniquely identifying the record
Drilling_Company_ID Foreign key to the Drilling Company table
GIC_WELL_ID Well Number that uniquely identifies a well
number for the Well.
GOA_Well_Tag_Number Currently not in use
Longitude Longitude of the well
well or the centre of the
section if not provided.
Latitude Latitude of the well
the centre of the section if not
provided.
Elevation Elevation above sea level
above mean sea level.
GPS_Obtained How the GPS coordinates were obtained
to obtain the GPS coordinates
for the well.
Distance_North Distance from the north boundary
Distance_South Distance from the south boundary
Distance_East Distance from the east boundary
Distance_West Distance from the west boundary
LSD Legal Subdivision
each Section, there are four
quarters (NW, NE, SW and
SE). These quarters are
broken down into LSD’s.
There are 16 LSD’s in a
Section. Each LSD is ¼ mile
square. Only numbers 1 to 16
may be entered.
Section Section
in a Township. Each Section is
1 square mile. Only numbers 1
to 36 may be entered.
Township Township
considered to be 6 miles by 6
miles square (Total of 36
Sections). Township numbers
increase from south to north.
Township 001 is at the bottom
of the province while
Township 126 is at the top of
the province. Only numbers
001 to 126 may be entered.
Range Range
in length and increases from
east to west. Ranges start at
the beginning of each
Meridian line and increase in
number as you go west.
Range numbers start again at
01 when a new meridian line
is encountered. Only numbers
from 1 to 31 may be entered.
Meridian Only numbers 4, 5 or 6 may be entered
meridians in Alberta. The 4th
Meridian is the border
between Saskatchewan and
Alberta. The 5th Meridian runs

2
north to south just west of
Edmonton and through
Calgary. The 6th Meridian
runs north to south
approximately halfway
between Grande Prairie and
Peace River.
Lot Lot
within a subdivision that the
water well is located on.
Block Block
number or letter within a
subdivision that the water well
is located on.
Plan Plan
number within a subdivision
that the water well is located
on.
Additional_Description Additional comments to aid in locating the well
Additional comments about
the Well.

Well_Reports Table
Well_Report_ID System generated number uniquely identifying the record
Well_ID Foreign key to the Wells Table.
Well_Owner_ID Foreign key to the Well Owners Table
Driller_ID Foreign key to the Drillers Table
Drilling_Company_ID Foreign key to the Drilling Company Table
Foreign
key to the Drilling
Company Table
Drilling_Method The method of drilling such as a boring rig, rotary rig, backhoe.
Type_of_Work The type of work done on the well such as New Well, Deepening,
Dry Hole.
Plug_Date Date the well was plugged
Plug_Material_Type Material the well was plugged with
Type of
material used to plug the
well
Plug_Material_Amount Amount of material used in plugging the well
amount
of material used to plug
with well.
Plug_Units Units of the plug material used to plug the well.
Well_Use The proposed use of the water well such as domestic, injection,
standby.
Total_Depth_Drilled Total depth drilled
Finished_Well_Depth Depth of the completed well
Drilling_Start_Date The date that drilling started
Drilling_End_Date The date that the well was completed

3
Casing_Material The type of casing material of the first string of casing used in
constructing the water well, i.e. steel, cribbing, culvert.
Casing_OD The outside diameter of the casing.
Casing_Thickness The thickness of the casing.
Casing_Bottom The depth from surface to the bottom of the casing
Liner_Material The type of liner material
Liner_OD Outside diameter of the liner
Liner_Thickness Thickness of the liner
Liner_Top Top of the liner as measured from ground level. If the liner is
above ground then a negative sign is used to indicate the distance
above ground
Liner_Bottom Bottom of the liner as measured from ground level
Perforation_By Object or tool used to perforate the liner
Annular_Seal_Material Material the first seal is composed of
Annular_Seal_From Top of the first seal as measured from ground level
Annular_Seal_To Bottom of the first seal as measured from ground level
Annular_Seal_Amount Amount of material used in the first seal
Annular_Seal_Units Units the amount of material is measured in
Screen_Material The screen material (Stainless Steel or PVC, etc.)
Screen_Size_OD The outside diameter of the screen
Screen_Attachment How the screen is attached (Telescoped, Washed Down, etc.)
Screen_Top_Fittings Material the top fittings of the screen is composed of
Screen_Bottom_Fittings Material the bottom fittings of the screen is composed of
Pack_Type Material the pack is made of
Pack_Grain_Size The grain size of the pack material
Pack_Amount The amount of packing material used
Pack_Units The units the packing material is measured (Bags, Kg, etc.)
Location_Verification_Me The method used to verify the well location
thod
Distance_Casing_Ground The distance the casing is from the ground level
Artesian_Flow_Flag Is the well an artesian well
Artesian_Flow_Rate The artesian flow rate
Encounter_Gas_Flag True if gas was encountered
Remedial_Action
Flow_Control_Installed_F True if artesian flow control was installed
lag
Flow_Control_Descriptio Description of the installed flow control
n
Recommended_Rate Driller recommended rate of water removal
Recommended_Intake_D Driller recommended depth of pump intake
epth
Pump_Type_Installed Type of pump installed
Pump_Model Pump model
Pump_Horsepower Pump horsepower
Well_Disinfected True if the well has been disinfected
Other_Log Type of additional log taken
Potability_Sample_Taken True if a potability sample was taken for chemical analysis
_Flag
Potablility_Sample_Sent_ True if the potability sample was sent to AENV
to_AENV_Flag
Diverted_Water_Source Source of the water diverted during drilling
Diverted_Water_Amount Amount of water diverted during drilling
4
Perforations Table
Perforation_ID System generated number uniquely identifying the record
Well_Report_ID Foreign key to the Well_Reports table
Distance_Between Distance between perforations
From Top of the perforations as measured from ground level
To Bottom of the perforations as measured from ground level
Diameter Diameter of each perforation hole or length of each slot
Interval Distance between perforations

Other_Seals Table
Other_Seal_ID System generated number uniquely identifying the record
Well_Report_ID Foreign key to the Well_Reports table
Other_Seal_Type Seal Type (other than annular)
From Top of the seal as measured from ground level
To Bottom of the seal as measured from ground level
At Depth at which the seal is placed

Screens Table
Screen_ID System generated number uniquely identifying the record
Well_Report_ID Foreign key to the Well_Reports table
Screen_Inside_Diameter The inside diameter of the screen
From The depth from surface of the top of the uppermost set of perforations in
the screen.
To The depth from surface of the bottom of the uppermost set of
perforations in the screen
Slot_Size The diameter of the slots in the screen

Geophysical_Logs Table
Geophysical_Log_ID System generated number uniquely identifying the record
Well_Report_ID Foreign key to the Well_Reports table
Log_Type Type of geophysical log
Log_Taken_Flag True if the log was taken
Sent_to_AENV_Flag True if the log was sent to AENV

Boreholes Table
BoreHole_ID System generated number uniquely identifying the record
Well_Report_ID Foreign key to the Well_Reports table
Diameter Diameter of the bore hole
From Top of the borehole as measured from ground level
To Bottom of the borehole as measured from ground level

5
Pump_Tests Table
Pump_Test_ID System generated number uniquely identifying the record
Well_Report_ID Foreign key to the Well_Reports table
Test_Date The date the well was tested. Use YYYY/MM/DD.
Start_Time The time of day the well was tested. Use a 24 hour clock.
Taken_From_Top_of_Cas True if the pump test depth measurements were taken from the
ing top of the casing. False if they were taken from ground level.
Static_Water_Level The non-pumping or static water level in the well. The
measurement is a positive number and is usually measured from
the top of the casing. For a flowing well, the S.W.L. is preceded by
a negative sign.
End_Water_Level The level of the water at the end of the pump test
Water_Removal_Type The method of testing the well i.e. pump, air.
Water_Removal_Rate The rate of water removal during a test
Removal_Depth_From The depth at which the bottom of the drill stem is placed when
testing the well with air (normally the bottom of the hole). If the
well is pump tested then it is the depth at which the pump is set
Reason_for_Short_Test Reason why the water removal test was shorter than required by
regulation.

Pump_Test_Items Table
Pump_Test_Item_ID System generated number uniquely identifying the record
Pump_Test_ID Foreign key to the Pump_Test table
Minutes The minutes from the start of the test of the drawdown or
recovery measurements.
Pumping_Depth The water level at a particular time during the drawdown period
(pumping) of the water removal test.
Recovery_Depth The water level at a particular time during the recovery period
(after the pump is turned off) of the water removal test.

Lithologies Table
Lithology_ID System generated number uniquely identifying the record
Well_Report_ID Foreign key to the Well_Reports table
Depth The depth to the bottom of a discrete lithologic material
encountered during drilling.
Water_Bearing True if the material is water bearing
Colour The colour of the material in the lithologic section
Material The lithologic material encountered during drilling
Description The type of lithologic material encountered during drilling