DIC_GRAIN_SORT_BGS
Dictionary of various grades 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) |
C |
BGS Very Well-Sorted |
5 |
04-JUN-03 |
|
| WS |
WELL-SORTED (0.35 TO 0.5 IGSD PHI UNITS) |
C |
BGS Well-Sorted |
10 |
04-JUN-03 |
|
| WSM |
MODERATELY WELL-SORTED (0.5 TO 0.71 IGSD PHI UNITS) |
C |
BGS Moderately Well-Sorted |
15 |
04-JUN-03 |
|
| MS |
MODERATELY-SORTED (0.71 TO 1.0 IGSD PHI UNITS) |
C |
BGS Moderately-Sorted |
20 |
04-JUN-03 |
|
| PS |
POORLY-SORTED (1.0 TO 2.0 IGSD PHI UNITS) |
C |
BGS Poorly-Sorted |
25 |
04-JUN-03 |
|
| PSV |
VERY POORLY-SORTED (2.0 TO 5.0 IGSD PHI UNITS) |
C |
BGS Very Poorly-Sorted |
30 |
04-JUN-03 |
|
| PSE |
EXTREMELY POORLY-SORTED (> 5.0 IGSD PHI UNITS) |
C |
BGS Extremely Poorly-Sorted |
35 |
04-JUN-03 |
|
| * |
NOT APPLICABLE |
C |
Not Applicable |
900 |
04-JUN-03 |
|
| ! |
NOT AVAILABLE |
C |
Not Available |
905 |
04-JUN-03 |
|
| ? |
NOT ENTERED |
C |
Not Entered |
910 |
04-JUN-03 |
|
