The Minnesota County Well Index


Database Dictionary

Table: SCRNTYPE
Type of screen installed in the hole.

SCRNTYPE Table Description   Screen Type Codes
 Column Name   Format
 Code   CHAR 1 - Primary key  
 Descrptn   CHAR 30 NULL
 
Relationships
scrntype.code c5c1.screen_typ
 
Code   Descrptn
1    telescoping
2    telescoping(stainless)
3    telescoping(plastic)
4    telescoping(iron)
5    telescoping(galvanized)
6    slotted plastic
B    fiberglass
G    galvanized
I    iron
L    stainless steel
M    mixed (multiple)
N    punched pipe
O    other
P    plastic
Q    slotted pipe
R    brass
S    steel (non-stainless)
U    unknown
 
 Close