DIC_VST_DETMAND
Dictionary of Determinands - e.g. LOI450, plastic limit, Cu. Langmuir and Freundlich KDs (for each element) should be included here as separate determinands. Note that if a determinand has to be quoted in a number of units then each determinand/units combination will have a separate entry in this dictionary
No. |
Column name |
Data type |
Notes |
1 |
CODE |
Varchar(15) |
Primary key
|
2 |
DESCRIPTION |
Varchar(250) |
|
3 |
STATUS |
Char(1) |
|
4 |
TRANSLATION |
Varchar(250) |
|
5 |
MAX_VALUE |
Numeric(22) |
|
6 |
MIN_VALUE |
Numeric(22) |
|
7 |
UNITS |
Varchar(10) |
|
8 |
DATE_ENTERED |
Date |
|
9 |
DATE_UPDATED |
Date |
|
Sample data (rows 1 to 17 of 17)
CODE |
DESCRIPTION |
STATUS |
TRANSLATION |
MAX_VALUE |
MIN_VALUE |
UNITS |
DATE_ENTERED |
DATE_UPDATED |
pH_H2O |
pH measured in water |
C |
pH (water) |
14 |
0 |
pH units |
11-DEC-03 |
|
pH_CaCl2 |
pH measured by CaCl2 method |
C |
pH (CaCl2) |
14 |
0 |
pH units |
11-DEC-03 |
|
pH_NaF |
pH measured by NaF method |
C |
pH (NaF) |
14 |
0 |
pH units |
11-DEC-03 |
|
pH_KCl |
pH measured by KCl method |
C |
pH (KCl) |
14 |
0 |
pH units |
11-DEC-03 |
|
CEC |
Cation Exchange Capacity. Method used may be noted in COMMENTS. |
C |
Cation Exchange Capacity |
1000 |
0 |
meq/100g |
11-DEC-03 |
|
TOC |
Total Organic Carbon (same as 'Organic Carbon') |
C |
Total Organic Carbon |
1000000 |
0 |
ppm |
11-DEC-03 |
|
KH_Ca |
Henry's coefficient for linear sorption isotherm for Calcium. |
C |
Calcium Henry's coeff |
1000000 |
0 |
L/kg |
11-DEC-03 |
|
KH_Na |
Henry's coefficient for linear sorption isotherm for Sodium. |
C |
Sodium Henry's coeff |
1000000 |
0 |
L/kg |
11-DEC-03 |
|
KH_K |
Henry's coefficient for linear sorption isotherm for Potassium. |
C |
Potassium Henry's coeff |
1000000 |
0 |
L/kg |
11-DEC-03 |
|
KH_Mg |
Henry's coefficient for linear sorption isotherm for Magnesium. |
C |
Magnesium Henry's coeff |
1000000 |
0 |
L/kg |
11-DEC-03 |
|
KH_Zn |
Henry's coefficient for linear sorption isotherm for Zinc. |
C |
Zinc Henry's coeff |
1000000 |
0 |
L/kg |
11-DEC-03 |
|
KH_Cd |
Henry's coefficient for linear sorption isotherm for Cadmium. |
C |
Cadmium Henry's coeff |
1000000 |
0 |
L/kg |
11-DEC-03 |
|
KH_Co |
Henry's coefficient for linear sorption isotherm for Cobalt. |
C |
Cobalt Henry's coeff |
1000000 |
0 |
L/kg |
11-DEC-03 |
|
KH_Al |
Henry's coefficient for linear sorption isotherm for Aluminium. |
C |
Aluminium Henry's coeff |
1000000 |
0 |
L/kg |
11-DEC-03 |
|
KH_Cu |
Henry's coefficient for linear sorption isotherm for Copper. |
C |
Copper Henry's coeff |
1000000 |
0 |
L/kg |
11-DEC-03 |
|
KH_Pb |
Henry's coefficient for linear sorption isotherm for Lead. |
C |
Lead Henry's coeff |
1000000 |
0 |
L/kg |
11-DEC-03 |
|
pH |
pH, unspecified measurement method |
C |
pH |
14 |
0 |
pH units |
11-DEC-03 |
|