Line Manager (secured by HR Position Hierarchy List) AU BI Data Initialization Blocks

E- Business Suite and JD Edwards EnterpriseOne adapters:

A.1.25.2 Line Manager (secured by HR Position Hierarchy List) AU BI Data Initialization Blocks

The Line Manager HR Position Hierarchy list is determined at user sign-on via one or more Initialization Blocks:

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

Recruiting Manager (secured by HR Position Hierarchy List) AU BI Duty

Recruiting VP (secured by HR Position Hierarchy List) AU BI Data

Recruiting VP (secured by HR Position Hierarchy List) AU BI Duty

Time Collection Manager (secured by HR Position Hierarchy List) AU BI Data

Time Collection Manager (secured by HR Position Hierarchy List) AU BI Duty Human Resource VP (secured by HR Position

Hierarchy List) AU BI Data

Human Resource VP (secured by HR Position Hierarchy List) AU BI Duty

Human Resource Analyst (secured by HR Position Hierarchy List) AU BI Data

Human Resource Analyst (secured by HR Position Hierarchy List) AU BI Duty Human Resource Manager (secured by HR

Position Hierarchy List) AU BI Data

Human Resource Manager (secured by HR Position Hierarchy List) AU BI Duty Learning Manager (secured by HR Position

Hierarchy List) AU BI Data

Learning Manager (secured by HR Position Hierarchy List) AU BI Duty

Table A–63 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).

Table A–62 (Cont.) HR Data Role to Duty Role Mapping

Data Security Role Filters

The Line 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:

HR_SEC_POS_HIER_LVL_ POS_ID

HR Position Hierarchy Fixed Hier Level.

Table A–64 Data Security Role Filters

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 - Learning Calendar "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 - Learning Enrollment and Completion

"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 - Learning Enrollment Events

Fact - HR - Absence Event "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))

Table A–63 (Cont.) Initialization Blocks

Fact - HR - Recruitment Event Information

Fact - HR - Workforce Event Information

Fact - HR - Workforce Balance Information

Fact - HR - Accrual Transactions - Event Information

Fact - HR - Accrual Transactions - Balance Information

Fact - HR - Time and Labor - Reported Time

Fact - HR - Time and Labor - Processed Time

Table A–64 (Cont.) Data Security Role Filters

A.1.25.3 Payroll Manager (secured by HR Position Hierarchy List) AU BI Data

In document Oracle Business Intelligence Applications (Page 98-101)