DIC_SOFTWARE_PRODUCT_MODULE
A Dictionary of Modules of Software products. Eg: Vulcan - Envisage etc. Where no Modular breakdown exists a single `dummy` record of code `GE` for General will be created to facilitate links.
| No. |
Column name |
Data type |
Notes |
| 1 |
PRODUCT_CODE |
Varchar(2) |
Primary key
|
| 2 |
PRODUCT_MODULE_CODE |
Varchar(2) |
|
| 3 |
PRODUCT_MODULE_DESCRIPTION |
Varchar(200) |
|
| 4 |
STATUS |
Char(1) |
|
| 5 |
DATE_ENTERED |
Date |
|
| 6 |
DATE_UPDATED |
Date |
|
Sample data (rows 1 to 10 of 28)
| PRODUCT_CODE |
PRODUCT_MODULE_CODE |
PRODUCT_MODULE_DESCRIPTION |
STATUS |
DATE_ENTERED |
DATE_UPDATED |
| VL |
EN |
Envisage |
C |
01-SEP-03 |
|
| VL |
BM |
Ore Block Modelling |
C |
01-SEP-03 |
|
| E2 |
GE |
General |
C |
01-SEP-03 |
|
| E3 |
GE |
General |
C |
01-SEP-03 |
|
| LA |
SE |
Seisworks |
C |
01-SEP-03 |
|
| LA |
ZM |
Zmap |
C |
01-SEP-03 |
|
| LA |
SW |
Stratworks |
C |
01-SEP-03 |
|
| LA |
OW |
Openworks |
C |
01-SEP-03 |
|
| HP |
GE |
General |
C |
01-SEP-03 |
|
| BM |
GE |
General |
C |
01-SEP-03 |
|