Tables used in HR when adding fields to form

[paradise611]

Hi All,

I have several forms with unique fields that I need to add to a table in HR in order to map the fields. Which table should I use? Should I create my own table and extend? Should I add to the HR profile table? Please help, which table should I add these unique fields too?

[sachin_namjoshi]

You should extend "sn_hr_core_case" table since this is core table and child tables ( e.g benefits, total awards ..) are extended from core case tables.

You can add all your custom fields on your extended table.Please do NOT customize OOB objects since it will impact for your future upgrades.

Please see below documentation for all tables installed with HR module.

https://docs.servicenow.com/bundle/london-hr-service-delivery/page/product/human-resources/reference/components-installed-with-case-and-knowledge-management.html

Also, you can see schema map of all HR core tables before thinking to add custom fields and custom table.

https://<<YOUR_INSTANCE_NAME>>.service-now.com/generic_hierarchy_erd.do?sysparm_attributes=table_history=,table=sn_hr_core_case,show_internal=true,show_referenced=true,show_referenced_by=true,show_extended=true,show_extended_by=true,table_expansion=,spacing_x=60,spacing_y=90,nocontext

Regards,

Sachin

[paradise611]

Thank you Sachin for the reply. For example I have over 50 forms, do you think its best to create a new table for each form and extend each new table from the HR Core case table? 

[Kiel Sanders]

I would not recommend creating a new table for each form.  In most situations you can create your new columns/fields on the delivered COE tables that match the categorization of the form (ex: payroll, benefits/total rewards).  This would allow you to create an HR Service utilizing those new fields in a PDF.

[paradise611]

Hi Kiel,

Thank you for replying. I'm pretty new to HR and I'm not quite following you. For example the project is based around "on boarding" . I plan to use the HR Case table as it is the base table for mostly everything. Are you stating I should add the new fields to the HR Case table?