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 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