The Payroll Manager HR Supervisor Hierarchy list is determined at user sign-on via one or more initialization blocks.
| Variable Name | Initialization Block Name |
|---|---|
|
HR_SEC_PERSON_ID |
Not applicable, this is a multi source variable population see below. |
|
HR_SEC_PERSON_ID____EBS |
HR Security Person ID List (EBS) |
|
HR_SEC_PERSON_ID____PSFT |
HR Security Person ID List (PeopleSoft) |
|
HR_SEC_PERSON_ID____FUSN |
HR Security Person ID List (Fusion) |
|
HR_SEC_PERSON_ID____FBI_SDS |
HR Security Person ID List (FBI SDS) |
Data Security Role Filters
The Payroll Manager HR Supervisor Hierarchy list Security is applied depending on the roles the user is granted, and when it is applied it is supported by the following HR logical facts and dimensions:
| Name | Filter |
|---|---|
|
Dim - HR Supervisor Hierarchy |
"Core"."Dim - HR Supervisor Hierarchy"."Top Level Source Person ID" = VALUEOF(NQ_SESSION.HR_SEC_PERSON_ID) |
|
Fact - HR – Payroll Balance Summary |
"Core"."Dim - HR Supervisor Hierarchy"."Top Level Source Person ID" = VALUEOF(NQ_SESSION.HR_SEC_PERSON_ID) |
|
Fact - HR - Payroll Balance Detail |
"Core"."Dim - HR Supervisor Hierarchy"."Top Level Source Person ID" = VALUEOF(NQ_SESSION.HR_SEC_PERSON_ID) |