Can we create a custom table for the sys ids of the different Cmdb tables?

[VishakhaShi]

We have few tables in the instance for which sys_id table for the cis are already created. We want to create few more custom tables for sys_id's of the cis . How can we achieve this? 

[Ankur Bawiskar]

@VishakhaShi 

Why would you create a custom table just to hold sysId of the records?

The sysId is already stored in sys_id field on your business app table record

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

[Dr Atul G- LNG]

Hi @VishakhaShi 

Thanks for sharing the details. Now, what's the business need? What is the purpose of creating a table just to hold a sys_id that's already in a custom table? What's the use of the sys_id table?

[VishakhaShi]

That is requested by client so not really sure.
But can we achieve this? Any idea?

[Dr Atul G- LNG]

Hi @VishakhaShi 

As a BPC, my first question to the client would be: what is the business need for this system table, and what value does it derive? Once I have the answer, we can assess whether it's scalable or not. So, I would request clarity on this before worrying about the solution. Additionally, it's not a good practice to hold the sys_id in a separate table, as it would likely duplicate information.