Linking Job and Survey

Triggering values based on Job related entities

For triggering/mirroring value from JMS related entities (e.g. Job Ref No.) to AMS entities (e.g. Survey Ref.) table [DCDictionaty] is used.

To set up source and target field:
Column [CommonData] = field id of the Source field
Column [StyckyFlag] = 1

For example, the above SQL statement sets F007 (Survey Ref) to get its data from Job ref no (Q002).