Deployments
UAT_PCR_Deployment
Reports
Report Name: Pay Centre CASRU Progress Report
Overview

  • Queries: 4

    Layouts: 1

  • Model: /PCR/PCR Deployment/PCR Packages/packagePCR-RCP/ name: model
Queries
  • Queries 4
    Expressions:
  • Model: /PCR/PCR Deployment/PCR Packages/packagePCR-RCP/ name: model
  • Query
    Load Last Date Query
    Data Items
    1
    Latest Valid Data Load Date
    [Presentation].[Data Load Archive].[Latest Valid Data Load Date]
  • Query
    qry Pay Centre CAI Progress Summary - TBS CORE
    Data Items
    8
    Collective Agreement Group
    [Presentation].[VW_STG_PAY_CENTRE_CAI_PROGRESS_SUMMARY].[COLLECTIVE_AGREEMENT_GROUP]
    Label
    [Presentation].[VW_STG_PAY_CENTRE_CAI_PROGRESS_SUMMARY].[LABEL]
    Fully Paid
    [Presentation].[VW_STG_PAY_CENTRE_CAI_PROGRESS_SUMMARY].[FULLY_PAID]
    Partially Paid
    [Presentation].[VW_STG_PAY_CENTRE_CAI_PROGRESS_SUMMARY].[PARTIALLY_PAID]
    No Pay
    [Presentation].[VW_STG_PAY_CENTRE_CAI_PROGRESS_SUMMARY].[NO_PAY]
    Total
    [Presentation].[VW_STG_PAY_CENTRE_CAI_PROGRESS_SUMMARY].[TOTAL]
    % Fully Paid
    [Presentation].[VW_STG_PAY_CENTRE_CAI_PROGRESS_SUMMARY].[FULLY_PAID_PERCENTAGE] / 100
    TOTAL LINE - % FULLY PAID
    (
    total ([Total(Fully Paid)])
    / total ([Total(Total)] )
    )
    Aggregate
    calculated calculated
    Rollup
    calculated calculated
    • Detail Filters
      1
    • Required
      [Label] in ('TBS Core', 'Organizations centrales sous le SC')
  • Query
    qry Pay Centre CAI Progress Summary - SEPARATE EMPLOYER
    Data Items
    8
    Collective Agreement Group
    [Presentation].[VW_STG_PAY_CENTRE_CAI_PROGRESS_SUMMARY].[COLLECTIVE_AGREEMENT_GROUP]
    Label
    [Presentation].[VW_STG_PAY_CENTRE_CAI_PROGRESS_SUMMARY].[LABEL]
    Fully Paid
    [Presentation].[VW_STG_PAY_CENTRE_CAI_PROGRESS_SUMMARY].[FULLY_PAID]
    Partially Paid
    [Presentation].[VW_STG_PAY_CENTRE_CAI_PROGRESS_SUMMARY].[PARTIALLY_PAID]
    No Pay
    [Presentation].[VW_STG_PAY_CENTRE_CAI_PROGRESS_SUMMARY].[NO_PAY]
    Total
    [Presentation].[VW_STG_PAY_CENTRE_CAI_PROGRESS_SUMMARY].[TOTAL]
    % Fully Paid
    [Presentation].[VW_STG_PAY_CENTRE_CAI_PROGRESS_SUMMARY].[FULLY_PAID_PERCENTAGE] / 100
    TOTAL LINE - % Fully Paid
    (
    total ([Total(Fully Paid)])
    / total ([Total(Total)] )
    )
    • Detail Filters
      1
    • Required
      [Label] in ('Separate Employer', 'Employeur distinct')
  • Query
    qry Pay Centre CAI Progress Summary - GRAND TOTAL
    Data Items
    9
    Collective Agreement Group
    [Presentation].[VW_STG_PAY_CENTRE_CAI_PROGRESS_SUMMARY].[COLLECTIVE_AGREEMENT_GROUP]
    Label
    [Presentation].[VW_STG_PAY_CENTRE_CAI_PROGRESS_SUMMARY].[LABEL]
    Fully Paid
    [Presentation].[VW_STG_PAY_CENTRE_CAI_PROGRESS_SUMMARY].[FULLY_PAID]
    Aggregate
    total total
    Partially Paid
    [Presentation].[VW_STG_PAY_CENTRE_CAI_PROGRESS_SUMMARY].[PARTIALLY_PAID]
    Aggregate
    total total
    No Pay
    [Presentation].[VW_STG_PAY_CENTRE_CAI_PROGRESS_SUMMARY].[NO_PAY]
    Aggregate
    total total
    Total
    [Presentation].[VW_STG_PAY_CENTRE_CAI_PROGRESS_SUMMARY].[TOTAL]
    Aggregate
    total total
    % Fully Paid
    [Presentation].[VW_STG_PAY_CENTRE_CAI_PROGRESS_SUMMARY].[FULLY_PAID_PERCENTAGE] / 100
    Aggregate
    total total
    Column Spacer
    ' '
    TOTAL LINE
    total ([Fully Paid]) / total ([Total] )
Layouts