Relation between user and Business Unit

nandup
Giga Contributor

Is there any way a user is related to Business Unit in ServiceNow.

2 ACCEPTED SOLUTIONS

Community Alums
Not applicable

Hi @nandup ,

Business units are parts of your organization that are in charge of certain operations, such as Finance, HR, IT.

Business units usually comprise departments and are associated with a company. By default, the Hierarchy of Segments includes a segment for business units, departments, and vendors, which are companies with the Vendor option selected.

 

While creating a Business unit, there is a "Business Unit Head" which references to sys_user table.

Also, in the user record, we can find Department, where in turn you can find the business unit.

SandeepDutta_0-1702300119047.png

 

View solution in original post

AnveshKumar M
Tera Sage
Tera Sage

Hi @nandup 

There is no direct relation between sys_user table and business_unit table except the Business Unit Head in business unit table which references sys_user.

 

If you ever want to check this kind of relationships you can try schema map. Navigate to Tables (sys_db_object) module and look for the table in your question and open that record. In the record opened, under related links click on Show schema map.

Once the schema map page is loaded, enable the check boxes Referenced Tables and Referencing tables and wait for the loading to be completed. It will show you relation between the table and other tables where it is referenced.

 

And also you can search in the dictionary table where field table is Reference and references the table name of your interest.

 

 

Please mark my answer helpful and accept as a solution if it helped 👍

Thanks,
Anvesh

View solution in original post

3 REPLIES 3

Maik Skoddow
Tera Patron
Tera Patron

Hi @nandup 

unfortunately it is not clear what your question is about. Please provide more details.

The only thing I can tell you is that there is a field "Department" on the sys_user table. And a department has a reference to a "Business Unit". So the OOTB relation between a user and a business unit goes over the department.

Maik

Community Alums
Not applicable

Hi @nandup ,

Business units are parts of your organization that are in charge of certain operations, such as Finance, HR, IT.

Business units usually comprise departments and are associated with a company. By default, the Hierarchy of Segments includes a segment for business units, departments, and vendors, which are companies with the Vendor option selected.

 

While creating a Business unit, there is a "Business Unit Head" which references to sys_user table.

Also, in the user record, we can find Department, where in turn you can find the business unit.

SandeepDutta_0-1702300119047.png

 

AnveshKumar M
Tera Sage
Tera Sage

Hi @nandup 

There is no direct relation between sys_user table and business_unit table except the Business Unit Head in business unit table which references sys_user.

 

If you ever want to check this kind of relationships you can try schema map. Navigate to Tables (sys_db_object) module and look for the table in your question and open that record. In the record opened, under related links click on Show schema map.

Once the schema map page is loaded, enable the check boxes Referenced Tables and Referencing tables and wait for the loading to be completed. It will show you relation between the table and other tables where it is referenced.

 

And also you can search in the dictionary table where field table is Reference and references the table name of your interest.

 

 

Please mark my answer helpful and accept as a solution if it helped 👍

Thanks,
Anvesh