Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Relationship between Company and Department Table

Go to solution
anubhavkapoor76
ServiceNow Employee
ServiceNow Employee

‎04-06-2020 06:08 AM

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

Cheers!!
Anu

Conect me at LinkedIn
0 Helpfuls
  • 2,447 Views
1 ACCEPTED SOLUTION

Go to solution
Pradeep Sharma
ServiceNow Employee
ServiceNow Employee

‎04-06-2020 06:30 AM

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

Go to solution
Onkar Pandav
Tera Guru

‎04-06-2020 06:32 AM

Hi,

I think there is no such OOTB relationship.

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