Vocabularies — details

DIC_QUARRY_PRODUCT

Dictionary table containing a listing of quarry products. (e.g Agricultural Fertilisers, building stone, concrete blocks, dry stone walling etc.)

No. Column name Data type Notes
1 CODE Varchar(6) Primary key
2 DESCRIPTION Varchar(250)  
3 TRANSLATION Varchar(50)  
4 STATUS Varchar(1)  
5 DATE_ENTERED Date  
6 DATE_UPDATED Date  


Sample data (rows 1 to 18 of 18)

CODE DESCRIPTION TRANSLATION STATUS DATE_ENTERED DATE_UPDATED
AGLM  AGRICULTURAL LIME/GROUND LIMESTONE  Agricultural Fertilisers  14-FEB-01  18-JUL-06 
BUST  BUILDING STONE  Building Stone  14-FEB-01  18-JUL-06 
CONB  PRODUCTS USED IN CONCRETE BLOCK PRODUCTION  Concrete Blocks  14-FEB-01  18-JUL-06 
DRYS  DRY STONE WALLING  Dry Stone Walling  14-FEB-01  18-JUL-06 
FLAG  FLAGSTONES  Flagstones  14-FEB-01  18-JUL-06 
IRSF  LIMESTONE AS FLUX IN IRON/STEEL MAKING  Flux in Steel Industry  14-FEB-01  18-JUL-06 
PPMA  LIMESTONE IN PAPER MAKING  Paper Making  14-FEB-01  18-JUL-06 
ROST  ROADSTONE  Roadstone  14-FEB-01  18-JUL-06 
SAGG  SANDSTONE AGGREGATES  Aggregates  14-FEB-01  18-JUL-06 
SBUI  SAND USED IN BUILDING TRADE  Sand (Building Trade)  14-FEB-01  18-JUL-06 
SDBU  SANDSTONE FOR BULK FILL  Bulk Fill  14-FEB-01  18-JUL-06 
SDCM  LIMESTONE DUSTING (COAL MINING)  Dusting (Coal Mining)  14-FEB-01  18-JUL-06 
SMIL  SANDSTONE USED AS MILLSTONES  Millstones(Sandstone)  14-FEB-01  19-JUL-06 
SSFY  SILICA SAND USED IN FOUNDRY WORK  Silica Sand (Foundry Work)  14-FEB-01  18-JUL-06 
WHET  WHETSTONE /ABRASIVE  Whetstones/Abrasives  14-FEB-01  18-JUL-06 
SIGL  SILICA SAND IN GLASS INDUSTRY  Silica Sand (Glass Industry)  14-FEB-01  18-JUL-06 
WMIL  WHINSTONE USED AS MILLSTONES  Millstones(Whin)  14-FEB-01  19-JUL-06 
OSBV  OSMOND STONE USED IN CONSTRUCTION OF BAKERS OVENS  Osmond Stone  14-FEB-01  18-JUL-06