HR related Table list

Kohei Tominaga1
Tera Expert

Hi,

 

I would like to have a table list which is used by HR related application.

At first, I thought that Docs article include table list while installed by HR related plugin but the Docs does not list not all tables.

So, I am thinking that to filter the tables by application scope in sys_db_object but sometimes HR application uses the tables in Global or other common scope. ex) Attachment, Email, Knowledge Article, Interaction

Is there any document or do you have any idea to list all tables HR application can use?

2 REPLIES 2

Ravi Chandra_K
Kilo Patron
Kilo Patron

Hello @Kohei Tominaga1 

There's another way you can do this.

 

In the navigation filter, enter: sys_metadata.list

The list of Application Files records is displayed.

Click the personalize list icon (gear icon), and add the Package column to the list.

Filter the list with these conditions to show only the components for the plugin:

[Package] [is] [ <plugin name>] (for example, Human Resource Core).

 

In the Class column heading, click the menu icon (menu icon) and select Group by Class (or Show matching on Table).

 

Select the class of information that you want to view.

 

This will give all the Tables installed with the plugin. You can get all the Tables related to HR related Plugins 

 

Please Mark this answer as helpful and correct if helped.

Kind Regards,

Ravi Chandra.

smithjohns405
Giga Contributor

To identify tables used by HR applications in ServiceNow:

1. Consult plugin documentation for specific HR modules.
2. Explore tables in ServiceNow under **System Definition > Tables & Columns > Tables**.
3. Query `sys_db_object` for tables in HR application and global scopes.
4. Engage ServiceNow community for insights.
5. Seek vendor documentation for detailed schema information.