Linking of external tables

The name of all externally linked tables is contained within an extra table called "T_links". In case of an online connection, tables are linked from ORACLE , otherwise, they are linked from the local Access database dvs_data.mdb

Please note, that in the source databases, all external tables are preceded by the Database OwnerOffline respectively Database OwnerOnline. In our case, this prefix is "JORDAN", but that could be changed in the configuration without modifying any code.

Note: The type of connection (online or offline) is decided at the start of the application and can not be modified later. If you want to transfer scenarios from offline to online or vice versa, you have to do this via the log files.

Depending on the individual sub-module used, the pre-processing module will only link those tables that are required.

Table "T_Links"

Modul Table_name DB_num
AddRes ADDITIONAL_RESOURCES 7
AddRes ADDITIONAL_RESOURCES_TYPES 7
AddRes SALINITY_CLASS 7
AddRes STP_ADDITIONAL_RESOURCES 7
Industrial FACILITIES 7
Industrial GOVERNORATES 7
Industrial QURT_BILLED_INDUSTRY 7
Industrial SERVICE_ZONE_DEMAND_CENTERS 7
Industrial SETT_LIST 7
Industrial SETT_TYPES 7
Industrial STP_INDUSTRY 7
Industrial STP_MUNICIPAL 7
Industrial STP_POPULATION 7
Industrial STP_TOURISTIC 7
Industrial WATER_USE_BILL_CAT 7
Industrial WATER_USE_BILLING 7
Log LOG_LOCATIONS 7
Log LOG_M 7
Log LOG_REF_VALUES 7
Log LOG_SESSIONS 7
Log LOG_Y 7
Losses FACILITIES 7
Losses GOVERNORATES 7
Losses QURT_BILLED_INDUSTRY 7
Losses SETT_LIST 7
Losses SETT_TYPES 7
Losses STP_INDUSTRY 7
Losses STP_LOSSES 7
Losses STP_MUNICIPAL 7
Losses STP_POPULATION 7
Losses STP_TOURISTIC 7
Losses WATER_USE_BILL_CAT 7
Losses WATER_USE_BILLING 7
Municipal SETT_LIST 7
Municipal STP_MUNICIPAL 7
Municipal STP_POPULATION 7
Municipal WATER_USE_BILL_CAT 7
Municipal WATER_USE_BILLING 7
Touristic BED_UNITS 7
Touristic OCCUPANCY 7
Touristic SETT_LIST 7
Touristic STP_TOURISTIC 7
Touristic WATER_USE_BILL_CAT 7
Touristic WATER_USE_BILLING 7
Wastewater FACILITIES 7
Wastewater FACILITY_PIPES 7
Wastewater MONTHLY_FACILITY_FLOW 7
Wastewater SERV_ZONE_POPU_COVERAGE 7
Wastewater SERVICE_ZONE_DEMAND_CENTERS 7
Wastewater SETT_LIST 7
Wastewater STP_INDUSTRY 7
Wastewater STP_MUNICIPAL 7
Wastewater STP_TOURISTIC 7
Wastewater STP_WWTP 7
Wastewater WATER_USE_BILL_CAT 7
Wastewater WATER_USE_BILLING 7
Wastewater WWTP_INDUSTRY_CONNECTION 7
Wastewater WWTP_OWNERSHIP 7
Wastewater WWTP_SERVICE_ZONE 7
Wastewater WWTP_TYPE 7