Recruiting Manager (Secured by HR Supervisor Hierarchy List) BI Data

The Recruiting 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 Recruiting 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 - Recruitment Event Information

"Core"."Dim - HR Supervisor Hierarchy"."Top Level Source Person ID" = VALUEOF(NQ_SESSION.HR_SEC_PERSON_ID)