Value Definitions and Range Items: Model Changes

Retrieve information for value definitions and range items using the supplied database views.

The model for value definitions and range items has been updated to deliver performance enhancements for high volume payroll processes and reports. In Update 24A, all data for value definitions and range items has been migrated to the new model. As communicated previously in Update 23D, a number of database views are available to support these model changes. These are stored queries that derive data from the value definition and range item tables. The views are designed to support the retrieval of data held in the original model or the new model.

Here are the database views:

Table	View	View Description
PAY_RANGE_ITEMS_F	PAY_RANGE_DEFS_V	Retrieves definition (set-up) details for the range item.
PAY_RANGE_ITEMS_F	PAY_RANGE_INST_V	Retrieves range item details for an individual employee. This includes employee level overrides such as tax overrides.
PAY_VALUE_DEFINITIONS_F	PAY_VALUE_DEFS_V	Retrieves details of a value definition. For example, retrieve set-up details for a value definition such as a timecard, absence, pension, or tax definition.
PAY_VALUE_DEFINITIONS_F	PAY_VALUE_INSTANCES_V	Retrieves value definition details for an individual employee.

It's highly recommended that you update all user defined features to use these new views. For example, all Value Sets and Business Intelligence Publisher (BI Publisher) reports that retrieve information directly from the PAY_VALUE_DEFINITIONS_F or PAY_RANGE_ITEMS_F tables should be updated to use these views.

This feature provides performance enhancements for high volume payroll processes and reports.

Steps to Enable

You don't need to do anything to enable this feature.

Tips And Considerations

NOTE: If you continue retrieving value definitions and range items directly from the tables, you may notice a degradation in performance due to the model changes delivered in Update 24A.  For this reason, it's highly recommended that you uptake the new view objects (VOs), if you have not done so already. This is particularly important for features that are time sensitive, such as the BI Publisher reports that are run during your company's critical payroll processing window.