Vocabularies — details

DIC_BPD_CATEGORY

This table is a dictionary. It holds translations for the category codes which all the best practice documents fall into.

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


Sample data (rows 1 to 5 of 5)

CODE DESCRIPTION TRANSLATION STATUS DATE_ENTERED DATE_UPDATED
DBD  DATABASE DESIGN DOCUMENT  Database Design  13-JUN-06  13-JUN-06 
APD  APPLICATION DESIGN DOCUMENT  Application Design  13-JUN-06  13-JUN-06 
Not Available - Applicable but try as we might,we can't find a value.  Not Available  11-JUL-06   
Not Applicable  Not Applicable  11-JUL-06   
Not Entered - We haven't assigned a value yet  Not Entered  11-JUL-06   
OpenGeoscience
Maps and viewers
Apps
Data collections
Data downloads
Scans and photos
Web services