Vocabularies — details

DIC_DATAFILE_STORAGE_TYPE

A Dictionary for the types of storage for derived data. Egs: Oracle table, Access table, ASCII text etc.

No. Column name Data type Notes
1 DERIVATION_DATAFILE_TYPE_CODE Varchar(2) Primary key
2 DERIVATION_DATAFILE_TYPE_DESC Varchar(30)  
3 STATUS Char(1)  
4 DATE_ENTERED Date  
5 DATE_UPDATED Date  


Sample data (rows 1 to 8 of 8)

DERIVATION_DATAFILE_TYPE_CODE DERIVATION_DATAFILE_TYPE_DESC STATUS DATE_ENTERED DATE_UPDATED
ME  Micrsoft Excel  01-AUG-01   
OB  Oracle table - BGS Schema  01-AUG-01   
OL  Oracle table - User Schema  01-AUG-01   
OO  Oracle table - Other Schema  01-AUG-01   
AC  Access database  15-AUG-03   
AS  Ascii comma separated file   15-AUG-03   
MI  MAPINFO table  15-AUG-03   
DX  DXF Mesh data  15-AUG-03