HRSD Reporting - Best Practice?

[Justin W]

Hello, 

I recently read that "The HR Core Case [sn_hr_core_case] table is an extension of the Task table, but it is in its own application scope".

Regarding reporting, I'd heard that it is typically best practice to run reports off the Task table given that it is a parent table in the hierarchy. 

My question is:  Is this still the case for HRSD reporting (e.g - HRSD reports should pull from the Task Table), or due to the scope would it be better to run reports from the HR Core Case table?

Thanks in advance!

JW

[Manmohan K · Accepted solution]

Hi @Justin W 

The HR Core Case table is designed specifically for HR Service Delivery (HRSD) and includes additional HR-related fields and data. Running reports directly from this table enables more effective access and analysis of HR-specific information. It offers a targeted view of HR cases and tasks, allowing you to gain better insights into HR-related processes.

Therefore, it would be advised to run reports from the HR Core Case table for HRSD reporting to ensure accurate capturing of HR-specific data and obtain valuable insights.

[Justin W]

@Manmohan K  - Thanks so much!  Given that the Task table is a "parent", in theory would you still be able to pull the same fields?  Or could there be issue if Task table is Global and HR Core is scoped?

[Manmohan K]

@Justin W 

You cannot pull data from fields which only exist in the child table which is  HR Core Case table. Only fields which have been inherited from task table would be available for reporting 

However there may or may not be issues based on scope as it depend on how the security of the HR scope has been configured on the instance i.e.  if cross scope access is allowed or not