Deployments
UAT_PCR_Deployment
Reports
Report Name: Pay Centre Employee Report
Overview

  • Queries: 3

    Layouts: 1

  • Model: /PCR/PCR Deployment/PCR Packages/packagePCR-RCP/ name: model
Queries
  • Queries 3
    Expressions:
  • Model: /PCR/PCR Deployment/PCR Packages/packagePCR-RCP/ name: model
  • Query
    Main Query
    Data Items
    12
    Business Unit
    [Presentation].[VW_PCR_MART_PAY_CENTER_EMPLOYEE_REPORT].[BUSINESS_UNIT]
    PRI
    [Presentation].[VW_PCR_MART_PAY_CENTER_EMPLOYEE_REPORT].[EMPLOYEE_ID]
    First Name
    [Presentation].[VW_PCR_MART_PAY_CENTER_EMPLOYEE_REPORT].[FIRST_NAME]
    Last Name
    [Presentation].[VW_PCR_MART_PAY_CENTER_EMPLOYEE_REPORT].[LAST_NAME]
    Job Code
    [Presentation].[VW_PCR_MART_PAY_CENTER_EMPLOYEE_REPORT].[JOB_CODE]
    Employee Sub-Category
    [Presentation].[VW_PCR_MART_PAY_CENTER_EMPLOYEE_REPORT].[EMPLOYEE_SUB_CATEGORY]
    Payroll Status
    [Presentation].[VW_PCR_MART_PAY_CENTER_EMPLOYEE_REPORT].[PAYROLL_STATUS]
    Payroll Status Order
    [Presentation].[VW_PCR_MART_PAY_CENTER_EMPLOYEE_REPORT].[PAYROLL_STATUS_ORDER]
    Preferred Language
    [Presentation].[VW_PCR_MART_PAY_CENTER_EMPLOYEE_REPORT].[PREFERRED_LANGUAGE]
    Paylist
    [Presentation].[VW_PCR_MART_PAY_CENTER_EMPLOYEE_REPORT].[PAY_LIST]
    Restricted Access
    [Presentation].[VW_PCR_MART_PAY_CENTER_EMPLOYEE_REPORT].[RESTRICTED_ACCESS]
    Effective Date
    [Presentation].[VW_PCR_MART_PAY_CENTER_EMPLOYEE_REPORT].[EFFECTIVE_DATE]
    • Detail Filters
      1
    • Required
      [Business Unit] in ?Param-Bus-Unit?
  • Query
    Load Last Date Query
    Data Items
    1
    Latest Valid Data Load Date
    [Presentation].[Data Load Archive].[Latest Valid Data Load Date]
  • Query
    Query-prompt
    Data Items
    2
    Business Unit
    [Presentation].[VW_STG_DEPARTMENT].[CODE]
    Department Name
    [Presentation].[VW_STG_DEPARTMENT].[NAME_1]
    • Detail Filters
      2
    • Required
      [Presentation].[VW_STG_DEPARTMENT].[PAY_CENTRE_DEPARTMENT] = 'Yes/Oui'
    • Required
      [Business Unit] is not null
Layouts