Syntax to fetch pending transfer details from Data_cache column in hrc_txn_data

Summary

Syntax to fetch pending transfer details from Data_cache column in hrc_txn_data

Content

Hi,

We need to fetch the pending transaction Transfer details like New Location,New Position,New Grade,New Job etc. We are aware that We can capture these details in data_cache column in hrc_txn_data table. As these column captures many entries, how can we fetch only one value(say New location, New Position,New Grade,New job etc.)? Is there any syntax to fetch that alone? Please suggest.

Thanks,
Nirmal kumar