Foreign Table Panel

As well as managing Asset Types for Asset Item data held within the main Asset table, the Foreign Table form can also be used to manage Asset Types for Asset Item data held in external tables or views or other tables or database views within the Exor database. For example, Skid Resistance values or Roadway Deflection figures collected from road machine surveys may be held externally. These could be integrated with AWLRS to take advantage of the full range of Asset Related functionality available, for example PBI or Asset Merge Queries.

Note:

This panel will only display for existing Asset Types.
Data from other products from within the AWLRS product set may be used in reports and queries, e.g., Asset Merge Queries, by creating an Asset Type for the data and utilising the Foreign Table functionality.

The Foreign Table is enabled if F-Foreign Table is selected as the Asset Type Category. The table then appears at the bottom of the Edit Asset Type dialog.

Foreign Table fields:

Table Name (Dropdown - Mandatory if using Foreign Tables): The name of the table or database view within which the ‘external’ Data is stored should be entered here. A maximum of 30 characters is allowed.

Primary Key Column (Dropdown - Mandatory if using Foreign Tables): If an external Table or database view is being used to hold the Asset Item data for this Asset Type the Column Name that holds the Asset Item Primary Key should be entered here.

Network Key Column (Dropdown): If an external Table or database view is being used to hold the Asset Item data for this Asset Type and the Asset are located on a Network, the Column Name that holds the Foreign Key to the Network Element, within the Exor database should be entered here. A maximum of 30 characters is allowed. The data type of this column must be numeric.

Start Offset Column (Dropdown): If an external Table or database view is being used to hold the Asset Item data for this Asset Type and the Asset are located on a Network, the Column Name that holds the Start Position of the Asset Item should be entered here. A maximum of 30 characters is allowed. The data type of this column must be numeric.

End Offset Column (List): If an external Table or database view is being used to hold the Asset Item data for this Asset Type and the Asset are located on a Network, the Column Name that holds the End Position of the Asset Item should be entered here. A maximum of 30 characters is allowed. The data type of this column must be numeric.