What are Dynamic Lookup Codes?
Dynamic Lookup Codes are used to display the correct views, view categories, part categories and questions to an inspector.
Views, view categories and part categories are assigned to products but there will probably be more than one of each available for the product. When using dynamic lookups the system selects the correct items to display by checking a unit’s Build Codes in the unit_lookup_codes table. The codes are generally imported from an external system. Each unit can have more than one Build Code. The build information may include the serial number of the unit, body style, engine type, color, catalytic converter and much more.
Dynamic lookup codes are necessary only if there is more than one view or category of the same component. For example, if there is only one type of an anti-lock brake valve, dynamic lookup codes are not necessary as Inspect will display this view automatically.
Example
An inspector is carrying out final checks of vehicles coming off a production line. Each vehicle can have a different colour with different features, such as electric windows.
The inspector only wants to see images that relate to the vehicle he is looking at. In this case the vehicle has unit code 0336.
Inspect receives build information for the specific vehicle which is stored in the unit_lookup_codes table. It has two build codes associated to it.
Inspect checks which Dynamic Lookup Codes correspond to the Build Codes for the vehicle.
It then displays the views associated to those Dynamic Lookup Codes.
Procedure for Views, View Categories and Part Categories
Use this procedure to define when views, view categories, part categories should be displayed in Data Collect.
Associate codes to units in the unit_lookup_codes table.
Create Dynamic Lookup Codes (see here).
Associate Dynamic Lookup Codes to views, view categories and part categories (see here).
Enable products to use Dynamic Lookup Codes (see here).
Procedure for Question Inclusion
Use this procedure to define when a question should be included in a checklist in Data Collect.
Associate codes to units in the unit_lookup_codes table.
Create Dynamic Lookup Codes (see here).
Associate Dynamic Lookup Code to question (see here).