Trigger Life Event when value updated in UNION field

Summary

How to trigger a Life Event when there is a UNION change on the assignment record?

Content

Hi All,

We are using the 'UNION' and 'Collective Agreement' field on the assignment page to store the Labor Relations information. [The Bargaining Unit field will be NULL].

On the Life Event Trigger creation page [data changes page], I see we have the table and column combination for  PER_ALL_ASSIGNMENTS_M.BARGAINING_UNIT_CODE only.

Question: Is there a way/work around to trigger a life event when there is a change in 'UNION' or 'Collective Agreement' field?

Thanks,

Rachan

Version