| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOPH93: Data Base and Communications |
| 1 | F98611 | Data Source Master | 14 | OM | DSTP | Data Source Type | Character | UDC | 1 | 0 |
| TOPH95: Object and Environment Tech |
| 2 | F93091 | Unicode Data Conversion Master | 3 | UC | DSTP | Data Source Type | Character | UDC | 1 | 0 |
| TOPH96B: Package Build |
| 3 | F96608 | Disc Client MSDE Databases | 4 | SK | DSTP | Data Source Type | Character | UDC | 1 | 0 |
| TOPH96U: Upgrade |
| 4 | F9650 | Machine Master | 7 | MM | DSTP | Data Source Type | Character | UDC | 1 | 0 |
| 5 | F9841 | Simple Installation Planner | 7 | SP | DSTP | Data Source Type | Character | UDC | 1 | 0 |
| 6 | F98411 | Simple Installation Data Sources | 2 | SD | DSTP | Data Source Type | Character | UDC | 1 | 0 |
| 7 | F98412 | Simple Plan Host Information | 2 | SH | DSTP | Data Source Type | Character | UDC | 1 | 0 |
| 8 | F98514 | Previous Plan data sources | 7 | PP | DSTP | Data Source Type | Character | UDC | 1 | 0 |
| TOPH97: Benchmarking/Performance |
| 9 | F97220 | Autopilot Results Summary | 10 | RS | DSTP | Data Source Type | Character | UDC | 1 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
TOPUDC 98 / DD (Data Source Type) stock values
| Value | Description | Special Handling Code | Hard Coded |
|---|
| 1 | A | Access | | N |
| 2 | D | DB2 UDB on OS/390 | | N |
| 3 | E | Local Oracle | | N |
| 4 | I | DB2 UDB on OS/400 | | N |
| 5 | L | SQL Server / OLEDB | | N |
| 6 | M | MSDE / OLEDB | | N |
| 7 | N | MSDE / ODBC | | N |
| 8 | O | ORACLE | | N |
| 9 | S | SQL Server / ODBC | | N |
| 10 | W | DB2 UDB on UNIX or Window | | N |
| 11 | X | SQL Server Express / ODBC | | N |
