DIC_DATAFILE_STORAGE_TYPE
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 |
C |
01-AUG-01 |
|
| OB |
Oracle table - BGS Schema |
C |
01-AUG-01 |
|
| OL |
Oracle table - User Schema |
C |
01-AUG-01 |
|
| OO |
Oracle table - Other Schema |
C |
01-AUG-01 |
|
| AC |
Access database |
C |
15-AUG-03 |
|
| AS |
Ascii comma separated file |
C |
15-AUG-03 |
|
| MI |
MAPINFO table |
C |
15-AUG-03 |
|
| DX |
DXF Mesh data |
C |
15-AUG-03 |
|
