Vocabularies — details

DIC_GRAIN_SORT_BGS

Dictionary of grain sorting using the BGS RCS sorting scheme.

No. Column name Data type Notes
1 CODE Varchar(5) Primary key
2 DESCRIPTION Varchar(100)  
3 STATUS Char(1)  
4 TRANSLATION Varchar(50)  
5 ORDER_CTRL Numeric(22)  
6 DATE_ENTERED Date  
7 DATE_UPDATED Date  


Sample data (rows 1 to 10 of 10)

CODE DESCRIPTION STATUS TRANSLATION ORDER_CTRL DATE_ENTERED DATE_UPDATED
WSV  VERY WELL-SORTED (< 0.35 IGSD PHI UNITS)  BGS Very Well-Sorted  04-JUN-03   
WS  WELL-SORTED (0.35 TO 0.5 IGSD PHI UNITS)  BGS Well-Sorted  10  04-JUN-03   
WSM  MODERATELY WELL-SORTED (0.5 TO 0.71 IGSD PHI UNITS)  BGS Moderately Well-Sorted  15  04-JUN-03   
MS  MODERATELY-SORTED (0.71 TO 1.0 IGSD PHI UNITS)  BGS Moderately-Sorted  20  04-JUN-03   
PS  POORLY-SORTED (1.0 TO 2.0 IGSD PHI UNITS)  BGS Poorly-Sorted  25  04-JUN-03   
PSV  VERY POORLY-SORTED (2.0 TO 5.0 IGSD PHI UNITS)  BGS Very Poorly-Sorted  30  04-JUN-03   
PSE  EXTREMELY POORLY-SORTED (> 5.0 IGSD PHI UNITS)  BGS Extremely Poorly-Sorted  35  04-JUN-03   
NOT APPLICABLE  Not Applicable  900  04-JUN-03   
NOT AVAILABLE  Not Available  905  04-JUN-03   
NOT ENTERED  Not Entered  910  04-JUN-03