Recruiting Manager (Secured by HR Position Hierarchy List) AU BI Data

The Recruiting Manager HR Position Hierarchy list is determined at user sign-on via one or more initialization blocks.

Variable Name	Initialization Block Name
HR_SEC_POS_LIST	Not applicable, this is a multi source variable population see below.
HR_SEC_POS_HIER_VER	Not applicable, this is a multi source variable population see below.
HR_SEC_POS_HIER_ID	Not applicable, this is a multi source variable population see below.
HR_SEC_POS_LIST____EBS	HR Position Hierarchy ID Version and Position List (EBS).
HR_SEC_POS_LIST____PSFT	HR Position Hierarchy ID Version and Position List (PeopleSoft).
HR_SEC_POS_LIST____FUSN	HR Position Hierarchy ID Version and Position List (Fusion).
HR_SEC_POS_HIER_VER____EBS	HR Position Hierarchy ID Version and Position List (EBS).
HR_SEC_POS_HIER_VER____PSFT	HR Position Hierarchy ID Version and Position List (PeopleSoft).
HR_SEC_POS_HIER_VER____FUSN	HR Position Hierarchy ID Version and Position List (Fusion).
HR_SEC_POS_HIER_ID____EBS	HR Position Hierarchy ID Version and Position List (EBS).
HR_SEC_POS_HIER_ID____PSFT	HR Position Hierarchy ID Version and Position List (PeopleSoft).
HR_SEC_POS_HIER_ID____FUSN	HR Position Hierarchy ID Version and Position List (Fusion).
HR_SEC_POS_HIER_LVL_POS_ID	HR Position Hierarchy Fixed Hier Level.

Data Security Role Filters

The Recruiting Manager HR Position 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 Position Hierarchy	"Core"."Dim - HR Position Hierarchy"."Sec Filter Col - Hierarchy Based Position Id" = VALUEOF(NQ_SESSION.HR_SEC_POS_LIST) AND "Core"."Dim - HR Position Hierarchy"."Sec Filter Col - Hierarchy Version" = (VALUEOF(NQ_SESSION.HR_SEC_POS_HIER_VER)) AND "Core"."Dim - HR Position Hierarchy"."Sec Filter Col - Hierarchy ID" = (VALUEOF(NQ_SESSION.HR_SEC_POS_HIER_ID))
Fact - HR - Recruitment Event Information	"Core"."Dim - HR Position Hierarchy"."Sec Filter Col - Hierarchy Based Position Id" = VALUEOF(NQ_SESSION.HR_SEC_POS_LIST) AND "Core"."Dim - HR Position Hierarchy"."Sec Filter Col - Hierarchy Version" = (VALUEOF(NQ_SESSION.HR_SEC_POS_HIER_VER)) AND "Core"."Dim - HR Position Hierarchy"."Sec Filter Col - Hierarchy ID" = (VALUEOF(NQ_SESSION.HR_SEC_POS_HIER_ID))