Custom Global Tables

[Mark Brogna]

I have a requirement that would require a custom table for use in catalog items.  The table will store metadata used to drive workflow based on training requirements, owner name for varying rooms, sites across their enterprise.  I know it is frowned upon to create global custom tables. As such, I am looking for alternatives on where to store this information across hundreds of sites.

[Sandeep Rajput · Accepted solution]

@Mark Brogna There is nothing to frowned up on about Global custom tables. There are genuine uses cases such as your's where the data needs to be stored in structured format hence there is no alternative but to store the data in a custom table.

You can verify if your data model matches with any of the existing tables in ServiceNow. If it doesn't then create a custom table.

If the number of rows are limited (5/10) then you can also choose it to store in form a Key/Value pair property in system property.

Hope this helps.

[Sandeep Rajput · Accepted solution]

@Mark Brogna There is nothing to frowned up on about Global custom tables. There are genuine uses cases such as your's where the data needs to be stored in structured format hence there is no alternative but to store the data in a custom table.

You can verify if your data model matches with any of the existing tables in ServiceNow. If it doesn't then create a custom table.

If the number of rows are limited (5/10) then you can also choose it to store in form a Key/Value pair property in system property.

Hope this helps.

[Ankur Bawiskar · Accepted solution]

@Mark Brogna 

why not use decision table and store information there?

Based on the decision table input you can get the output and perform the logic.

Decision Tables 

Remember custom tables come with license cost with them.

If my response helped please mark it correct and close the thread so that it benefits future readers.