Help understanding empty fields in sn_hr_pa_profile_metric_result database view

[GhitaB]

Please i would like to know why the HR case number and HR service are not showing in  sn_hr_pa_profile_metric_result which is a database view that  connects asmt_metric, asmt_metric_result, asmt_assesment_instance and HR profile tables.

[pavani_paluri]

Hi @GhitaB ,

The sn_hr_pa_profile_metric_result view in ServiceNow is built mainly for Performance Analytics. Its job is to show how HR profiles (employees) are doing against certain metrics (like survey scores, completion rates, etc.).

Because of that design:
It only pulls together assessment metrics and HR profile information.
It does not include HR case details (like case number) or HR service details, because those live in different tables (`sn_hr_core_case` and `sn_hr_core_service`).
The view is profile‑centric, not case‑centric. That’s why those fields don’t appear.

If you want HR case numbers or HR service names to show up alongside the metric results, you have a couple of options:

1. Create your own custom view
Extend the existing view by joining it with the HR case table (`sn_hr_core_case`) and HR service table (`sn_hr_core_service`).
That way, you can pull in case number and service fields.

2. Use Performance Analytics data collectors
Configure PA to collect those extra fields when it gathers data, so they’re available in your datasets.

3. Build a report directly on HR cases
Instead of relying on the PA metric view, run a report on the HR case table and dot‑walk to HR service and HR profile. This gives you the case/service info without touching the PA view.

Mark it helpful if this helps you to understand. Accept solution if this give you the answer you're looking for

Kind Regards,

Pavani P

[GhitaB]

but what i've noticed that it's showing for some records the HR Case number and service but for some records no

[pavani_paluri]

you see the HR Case number and service, and sometimes those fields are blank. That’s not a mistake — it just depends on how the record is linked:
If the metric or assessment is tied to an HR Case, then the case number and service will show up.
If the metric is tied directly to an HR Profile (like a survey about the employee, not about a case), then there is no case attached, so those fields stay empty.

Mark it helpful if this helps you to understand. Accept solution if this give you the answer you're looking for

Kind Regards,

Pavani P