We've updated the ServiceNow Community Code of Conduct, adding guidelines around AI usage, professionalism, and content violations. Read more

Relationship between Company and Department Table

anubhavkapoor76
ServiceNow Employee

Hi All,

Where does the relationship between Company ( core_company) and Departments ( cmn_department) table exist?

Assumption: Department field gets autopopulated on filling the Company field

1 ACCEPTED SOLUTION

Pradeep Sharma
ServiceNow Employee

Hi Anubhav,

"cmn_department" table has a field "company" that refers to the company table. Most likely there could be a client script in your instance which is auto-populating the Department field.

 

- Pradeep Sharma

View solution in original post

5 REPLIES 5

Onkar Pandav
Tera Guru

Hi,

I think there is no such OOTB relationship.

You can populate those two fields on the basis of "Caller name".