DB- Interest Claims- Profit Centre Lookup

NOTE:       The Book value is manually entered by user and it is not affected by the Profit Centre lookup. Only the Profit Centre value is dependent on the Profit Centre data. Even though there is a book field in the profit center table, CM does not use this value. The book field is updated by user from the GUI. Check the audit trail for the claim and you can see who and when the value is changed. If you still have the claim, edit it, blank out the book, then trigger the profit center lookup by putting first 3 characters and click lookup. You will see the book is not populated from the lookup.

Below are sample queries to investigate issues reported with Profit Centre mapping.

Note: Book inside the edit dialogue is not populated from STATIC DATA>> Profit Centre

Select MRTPROFITCENTRE,MRTUBRLEVEL,MRTUBRTEXT,MRTPRODUCTID,MRT_CLOSEDFLD

from MRT_IDCLAIMSPROFITCENTRE

WHERE (UPPER(MRTDATAFEED) LIKE '%SWAPS%') AND (MRTPROFITCENTRE LIKE 'SEC1');

Select MRTPROFITCENTRE,MRTUBRLEVEL,MRTUBRTEXT,MRTPRODUCTID,MRT_CLOSEDFLD,MRTDATAFEED

from MRT_IDCLAIMSPROFITCENTRE

WHERE (UPPER(MRTDATAFEED) LIKE '%SWAPS%');

Select MRTPROFITCENTRE,MRT_CLOSEDFLD

from MRT_IDCLAIMSPROFITCENTRE

WHERE (UPPER(MRTDATAFEED) LIKE '%SWAPS%') AND (MRTBOOK='DB_LN_SECX');