Payroll Manager (Secured by HR Position Hierarchy List) AU BI Data
The Payroll 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 Payroll 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 – Payroll Balance Summary |
"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 - Payroll Balance Detail |
"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)) |