How to find the table names

You could try the Data Dictionary in Alliance. I use a SQL query to quickly find the table(s) it is associated with it. 

SELECT t.name as 'Table', c.name 
FROM sys.tables t
JOIN sys.columns c ON c.object_id = t.object_id
WHERE c.name LIKE '%ccont_type%'
order by c.name,t.name

Thank you both.

I’ll just use the Data Dictionary for now and work up to the code later.

Phil, I can only access the DD in the employee portal, do you know if this will be available in the web portal anytime soon? (or am I not looking hard enough?)

Thanks

Chris

Hi Chris,

Sorry, forgot to mention that.  As for when it will be in the web portal, I am checking on that but I did not see anything in today’s official release of 15.4 SU4 regarding this module.

In web browser when you are in a field and select <Control> <Alt> <F1> keys at the same time it will bring up  a ‘state view’ popup, that will show the element id along with additional information.  If you are on a laptop, you may need to also select <function> key with the <F1>.

Hi Chris,

Sorry but I have inform the Data Dictionary is a discontinued module for the Web Employee Portal meaning it will not be migrated, below is a screen shot from the Browser Agnostic  Discontinued Modules.pdf file that you should have with your v15.4 release where the Data Dictionary is one of them (at the bottom of the snippet).