Vocabularies — details

DIC_PRODUCT_FILE_EXTENSION

Dictionary table containing file extensions for files in the table MODEL_LOB_STORE_FILE, which are product specific. Eg: EarthVision has extns: 2GRPT=2D Grid data points; 2GRD=2D Grid data defined as Origin + Offsets.

No. Column name Data type Notes
1 PRODUCT_CODE Varchar(2) Primary key
2 PRODUCT_MODULE_CODE Varchar(2)  
3 EXTENSION_STRING Varchar(10)  
4 EXTENSION_DESCRIPTION Varchar(100)  
5 DATA_STORAGE_TYPE_IND Char(1)  
6 GLOS_FILETYPE_CODE Varchar(2)  
7 STATUS Char(1)  
8 DATE_ENTERED Date  
9 DATE_UPDATED Date  


Sample data (rows 1 to 20 of 186)

PRODUCT_CODE PRODUCT_MODULE_CODE EXTENSION_STRING EXTENSION_DESCRIPTION DATA_STORAGE_TYPE_IND GLOS_FILETYPE_CODE STATUS DATE_ENTERED DATE_UPDATED
VL  EN  LIST  Report listing  OT  01-SEP-03   
VL  EN  DBE_CMND  dbeute macro replay command  OT  01-SEP-03   
VL  EN  SYN  Database synonyms file  OT  01-SEP-03   
VL  EN  SCR_LIST  Error statements list  OT  01-SEP-03   
VL  EN  ERR  Error statements  OT  01-SEP-03   
VL  EN  STG  Structural thickness grid  OT  01-SEP-03   
VL  EN  VTG  Vertical thickness grid  GP  01-SEP-03  29-JUN-04 
VL  EN  DHD  Drillhole data sheet  OT  01-SEP-03   
VL  EN  DHX  Drillhole database index file  OT  01-SEP-03   
VL  EN  DSR  Downhole spatial representation database  OT  01-SEP-03   
VL  EN  DSX  Downhole spatial representation database index file  OT  01-SEP-03   
VL  EN  DBL  Database listing  OT  01-SEP-03   
E2  GE  2GRD  Grid file (origin + offset)  GP  01-SEP-03   
E3  GE  2GRD  Grid file  GP  01-SEP-03   
E3  GE  2GRPT    GP  01-SEP-03   
EM  GE  ALG    OT  01-SEP-03   
EM  GE  ERS  Header file containing projection information  PR  01-SEP-03   
EM  GE  ERV    OT  01-SEP-03   
E3  GE  FACES    OT  01-SEP-03  16-JAN-04 
E2  GE  LGD  Legend files, contain ascii text scripts specifying plot legend-box annotation  LE  01-SEP-03  29-JUN-04