DIC_HYDROCARB_TYPE
Dictionary of the types of hydrocarbon. E.g. Gas, oil, condensate
| No. |
Column name |
Data type |
Notes |
| 1 |
CODE |
Varchar(6) |
Primary key
|
| 2 |
DESCRIPTION |
Varchar(500) |
|
| 3 |
STATUS |
Char(1) |
|
| 4 |
TRANSLATION |
Varchar(50) |
|
| 5 |
DATE_ENTERED |
Date |
|
| 6 |
DATE_UPDATED |
Date |
|
Sample data (rows 1 to 6 of 6)
| CODE |
DESCRIPTION |
STATUS |
TRANSLATION |
DATE_ENTERED |
DATE_UPDATED |
| - |
Not Applicable |
C |
NOT APPLICABLE |
30-JUL-04 |
|
| ! |
Not Available |
C |
NOT AVAILABLE |
30-JUL-04 |
|
| ? |
Not Entered |
C |
NOT ENTERED |
30-JUL-04 |
|
| GAS |
Gas |
C |
Gas |
28-APR-05 |
|
| OIL |
Oil |
C |
Oil |
28-APR-05 |
|
| COND |
Condensate |
C |
Condensate |
28-APR-05 |
|
