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 if DB_num = 3 and boolOnlineOffline = Yes.
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 it 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 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.
Table T_Links
| Module | Table_name | DB_num | boolOnlineOffline |
|---|---|---|---|
| DBF | IRRI_CENTERS | 0 | Yes |
| Local_data_in | Hydro_Year_Crop_Group_Area | 1 | No |
| Local_data_in | T_Crop_Calendar_General | 1 | No |
| DVS_DATA | IRRIG_METHOD_DISTRIBUTION | 3 | Yes |
| DVS_DATA | LEACHING_REQUIREMENTS | 3 | Yes |
| DVS_DATA | YEAR_TYPE_NIR | 3 | Yes |
| DVS_DATA | FARMGATE_IRRIGATION_USE | 3 | Yes |
| DVS_DATA | GROSS_IRRIGATION_USE | 3 | Yes |
| DVS_DATA | STP_AGRICULTURE | 3 | Yes |
| DVS_DATA | STP_LOSSES_AGRODISTRIB | 3 | Yes |
| DVS_DATA | STP_LOSSES_ONFARM | 3 | Yes |
| DVS_DATA | LOG_SESSIONS | 3 | Yes |
| DVS_DATA | LOG_LOCATIONS | 3 | Yes |
| DVS_DATA | LOG_REF_VALUES | 3 | Yes |
| DVS_DATA | LOG_Y | 3 | Yes |
| DVS_DATA | LOG_CROP_VALUES | 3 | Yes |
| DVS_DATA | LOG_M | 3 | Yes |
| DVS_DATA | CROP_GROUP | 3 | Yes |