Get a first look at what's coming. The Developer Passport Australia Release Preview kicks off March 12. Dive in! 

Related Lists on the HR Profile table

Dave65
Tera Contributor

In my PDI, when I look at an HR Profile, there are related lists at the bottom of the form.
I can find all but 2 of them on the Relationships table or the sys_m2m table.
Can anyone tell me how these are created?
The 2 I am referring to have the labels 'Jobs' & 'Employee Documents'.

 

Thanks in advance for your help.

1 ACCEPTED SOLUTION

@Dave65 

the Jobs one you won't find in Relationships table since it's an OOTB related list i.e. "sn_hr_core_job" table has field pointing to HR Profile.

Only defined relationships are present in that Relationships Under System Definitions

I am not sure about the Employee Documents.

If you are unable to find that as well in sys_relationship table it means it's an OOTB related list

i.e. Employee Document table also has a field which points to HR Profile table

AnkurBawiskar_0-1762530218322.png

Example: Direct reports related list doesn't have any filter based on some field so it's a defined relationship and you will find that in Relationships

AnkurBawiskar_1-1762530236339.png

AnkurBawiskar_2-1762530288991.png

 

 

💡 If my response helped, please mark it as correct and close the thread 🔒— this helps future readers find the solution faster! 🙏

Regards,
Ankur
Certified Technical Architect  ||  10x ServiceNow MVP  ||  ServiceNow Community Leader

View solution in original post

5 REPLIES 5

@Dave65 

the Jobs one you won't find in Relationships table since it's an OOTB related list i.e. "sn_hr_core_job" table has field pointing to HR Profile.

Only defined relationships are present in that Relationships Under System Definitions

I am not sure about the Employee Documents.

If you are unable to find that as well in sys_relationship table it means it's an OOTB related list

i.e. Employee Document table also has a field which points to HR Profile table

AnkurBawiskar_0-1762530218322.png

Example: Direct reports related list doesn't have any filter based on some field so it's a defined relationship and you will find that in Relationships

AnkurBawiskar_1-1762530236339.png

AnkurBawiskar_2-1762530288991.png

 

 

💡 If my response helped, please mark it as correct and close the thread 🔒— this helps future readers find the solution faster! 🙏

Regards,
Ankur
Certified Technical Architect  ||  10x ServiceNow MVP  ||  ServiceNow Community Leader