Why Idea in SPM has two tables "idea" + "im_idea_core", not getting the use of two?

[jameelsohail]

Our company has a requirement of creating a record producer for idea submission instead of idea portal.
When i create on i need to choose one table but some of fields are in idea table and some of them are in im_idea_core table!

confused in mapping out those fields and after submission it's not behaving they way it should be like creating an idea and idea being visible on idea portal.

#SPM #servicenow

[Anand2799]

Hi @jameelsohail ,

im_idea_core is a parent table for all the idea tables, as new idea tables can be created by extending this table.

So, if you are using idea as your table you will be able to select all fields which are in idea, im_idea_core and task (im_idea_core extends task table) table.

Don't use im_idea_core as these will not be visible on portal. Only records from table which is mapped in idea module record will be visible on idea portal (OOB - idea).