Payroll-Based Security

Payroll-based Security secures data via the Payroll dimension using Payroll list variable, with associated data roles and security filter[s] which are applied at the physical SQL level as IN (a, b, c,...) statement.

How to Choose and Assign the Duty Role

Each BI Apps Duty Role grants access to one or more subject areas, and is a member of at least one data security role.

You need to map a source role/responsibility to one or more BI Apps Duty Roles. For instructions on how this is done refer to the FSM task in How to Define New Groups and Mappings for Users and BI Roles.

HR Data Role to Duty Role Mapping

The following are applicable to Department security.

Data (Security) Role	Duty Role
Compensation Analyst (secured by Payroll List) AU BI Data	Compensation Analyst (secured by Payroll List) AU BI Duty
Compensation Manager (secured by Payroll List) AU BI Data	Compensation Manager (secured by Payroll List) AU BI Duty
Payroll Manager (secured by Payroll List) AU BI Data	Payroll Manager (secured by Payroll List) AU BI Duty

Initialization Blocks

The Payroll list values are determined at user sign-on via one or more Initialization Blocks:

Variable Name	Initialization Block Name
HR_SEC_PYRL_CMPALYST_LIST	Not applicable, this is a multi source variable population see below.
HR_SEC_PYRL_CMPALYST_LIST____EBS	HR - Compensation Analyst – Payroll List (EBS).
HR_SEC_PYRL_CMPALYST_LIST____PSFT_NA	HR - Compensation Analyst - Payroll List (PeopleSoft North American Payroll).
HR_SEC_PYRL_CMPALYST_LIST____PSFT_GP	HR - Compensation Analyst - Payroll List (PeopleSoft Global Payroll).
HR_SEC_PYRL_CMPMGR_LIST	Not applicable, this is a multi source variable population see below.
HR_SEC_PYRL_CMPMGR_LIST____EBS	HR - Compensation Manager - Payroll List (EBS).
HR_SEC_PYRL_CMPMGR_LIST____PSFT_NA	HR - Compensation Manager - Payroll List (PeopleSoft North American Payroll).
HR_SEC_PYRL_CMPMGR_LIST____PSFT_GP	HR - Compensation Manager - Payroll List (PeopleSoft Global Payroll).
HR_SEC_PYRL_LIST____FUSN	HR - Payroll Manager – Payroll List (Fusion).
HR_SEC_PYRL_PYRLMGR_LIST	Not applicable, this is a multi source variable population see below.
HR_SEC_PYRL_PYRLMGR_LIST____EBS	HR - Payroll Manager - Payroll List (EBS).
HR_SEC_PYRL_PYRLMGR_LIST____PSFT_NA	HR - Payroll Manager - Payroll List (PeopleSoft North American Payroll).
HR_SEC_PYRL_PYRLMGR_LIST____PSFT_GP	HR - Payroll Manager - Payroll List (PeopleSoft Global Payroll).