We need to check tables reference in Custom BI Publisher Data Model.

Summary:

We need to check tables reference in Custom BI Publisher Data Model.

Content (please ensure you mask any confidential information):

Hi Everyone,

As part of 23D update the tables "PAY_RANGE_ITEMS_F", "PAY_VALUE_DEFINITIONS_F" are updated/replaced with views "PAY_RANGE_DEFS_V", "PAY_RANGE_INST_V", "PAY_VALUE_DEFS_V", "PAY_VALUE_INSTANCES_V"

We tried using audit table : fusion_iau_viewer.bipublisher_v

Sql Query :

SELECT 

datasetname -- Data Model Set Name 

,datasettype -- Data Model Set Type 

,iau_resource -- Data Model name

--,sqltext -- Data Model SQL 

FROM 

fusion_iau_viewer.bipublisher_v