Vocabularies — details

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 10 of 17)

CODE DESCRIPTION STATUS TRANSLATION MAX_VALUE MIN_VALUE UNITS DATE_ENTERED DATE_UPDATED
pH_H2O  pH measured in water  pH (water)  14  pH units  11-DEC-03   
pH_CaCl2  pH measured by CaCl2 method  pH (CaCl2)  14  pH units  11-DEC-03   
pH_NaF  pH measured by NaF method  pH (NaF)  14  pH units  11-DEC-03   
pH_KCl  pH measured by KCl method  pH (KCl)  14  pH units  11-DEC-03   
CEC  Cation Exchange Capacity. Method used may be noted in COMMENTS.  Cation Exchange Capacity  1000  meq/100g  11-DEC-03   
TOC  Total Organic Carbon (same as 'Organic Carbon')  Total Organic Carbon  1000000  ppm  11-DEC-03   
KH_Ca  Henry's coefficient for linear sorption isotherm for Calcium.  Calcium Henry's coeff  1000000  L/kg  11-DEC-03   
KH_Na  Henry's coefficient for linear sorption isotherm for Sodium.  Sodium Henry's coeff  1000000  L/kg  11-DEC-03   
KH_K  Henry's coefficient for linear sorption isotherm for Potassium.  Potassium Henry's coeff  1000000  L/kg  11-DEC-03   
KH_Mg  Henry's coefficient for linear sorption isotherm for Magnesium.  Magnesium Henry's coeff  1000000  L/kg  11-DEC-03