8.2 Audit Queries

Table 8-5 Audit Queries for ISO20022

Table Name Query Description
FCC_TF_XML_XS- D_CONF Select * from FCC_TF_XML_XS- D_CONF_HIST Run this query to see the history of all the actions that have been performed.
FCC_TF_XML_MS- G_TAG_FLD_X- PATH Select * from FCC_TF_XML_MS- G_TAG_FLD_XPATH _HIST Run this query to see the history of all the actions performed in the XML Message Configuration tab.
FCC_TF_XM- L_SCRENG_XPA- TH_GRP Select * from FCC_TF_XM- L_SCRENG_XPATH_GRP _HIST Run this query to see the XPath for each parent element.
FCC_TF_XM- L_SCRENG_- FLD_XPATH Select * from FCC_TF_XM- L_SCRENG_FLD_XPATH _HIST Run this query to see the XPath for each subfield.