Calculating Budget Review Date and Current Review Date

The following are the three use cases for the calculation of Budget Review Date and Current Review Date using Payroll Upload Date, Scenario Start Date, and Scenario End Date when Employee data is loaded using Data load rules.

1. When Payroll Upload Date < Scenario Start Date The image below illustrates the end-to-end calculation process.

   

2. When Scenario start date <= Payroll upload date <= Scenario end dateThe image below illustrates the end-to-end calculation process.

   

3. When Scenario end date < Payroll upload dateThe image below illustrates the end-to-end calculation process.

   

Here is the definition of the terms used above:

• Payroll Data

  • Payroll Upload Date

    • Date on which payroll data was extracted from Payroll systems

    • Assumed to reflect the latest employee data as on that date

  • Review Date in Payroll Data (a.k.a. NRD)

    • Commonly included / provided field in employee data files

    • Can represent "Last pay increase date" or "Next pay increase date" etc

• Review Dates used by Host CPM Application

  • Current Year Review Date

    • Current year = Gap between now & Scenario Start Date

    • Intended to handle any Pay increases between now & Scenario Start Date

  • Budget Year Review Date

    • Can be one year or multiple years (based on app configuration)

    • Can be for budget or forecast scenarios

    • For multi-year budgeting, only one field is displayed and pay increase is assumed on anniversary dates for budget year 2, budget year 3 etc