This chapter provides an overview of absence processing and discusses how to:
Prepare for absence processing.
Enter processing instructions.
Create group lists.
Create process streams.
Note. Although the focus of this chapter is on-cycle processing, most of the concepts and procedures covered here also apply to off-cycle processing.
See Also
Viewing and Finalizing Absence Results
This section discusses:
The absence entitlement process.
The absence take process.
Absence processing features.
Absences and segmentation.
Absences and retroactive processing.
Preparing to run the entitlement or take process.
Absence processing preparations.
Absence processing sequence.
Absence processing phases and options.
This process updates frequency-based entitlements for payees and makes entitlement available. For example, if entitlement is granted monthly, you run the entitlement process once a month, even if you run weekly payrolls. You do not run this process for per-absence entitlements because they are updated by the Take process. You can run the entitlement process before or after the take process.
During this process, the system looks at each daily record and determines the amount of time that should be paid or unpaid, according to your absence rules. It converts paid and unpaid units to positive input and adjusts entitlement balances. The take process creates daily data and uses system elements in daily data. These two aspects of the take process are discussed below:
When you run the take process, one of the first things the program does is expand each absence event in the process list that occurred for a payee during the absence processing period (or current segment, if the processing period is segmented). Expanding the event means that the system creates a detailed row of data for each day of the absence in the GP_RSLT_ABS record. We call these rows daily data.
The take process expands each event that includes a date in the current segment. It creates a row for each day of the absence event, including days that fall outside the processing period. The system also populates the work schedule and holiday schedule system elements for the day before and after the absence, if the payee was not absent on those days. If the payee was absent the day before or the day after the reported absence, other absence-related system elements can be populated, depending on your rules.
For example, assume that the processing period is May 1 to 31, and there is no segmentation. If the payee is absent from May 5 to May 6 and again from May 29 to June 2, the take process creates two rows of daily data for the first absence and five rows for the second absence.
Daily data is created for each day of an absence event
Even though the system creates a row of daily data for each day of an absence event, this does not mean that each day is processed. The entire event is expanded so that the system has all the information it needs to accurately evaluate each absent day. Only those days that occurred during the processing period are processed. Using the above example, the system would process the following absent days: May 5, 6, 29, 30, and 31.
Sources of Daily Data
Data that populates the daily data row initially comes from two sources:
The payee’s work and holiday schedules, which provide the day of the week, scheduled hours, and holiday type.
The absence event, which provides the absence take, begin and end dates, partial days absent, if applicable, and other information.
Sources of daily data
The take process also contributes to the daily data. When it applies the absence rules—defined by your absence elements—to the event and schedule data, it derives a set of results that populates the daily data. The results include the beginning entitlement balance, absent units, paid and unpaid units, ending balance, and other information.
The day formula, which you create and assign to your take rule, is what drives the results. This formula interprets each day of the absence and returns the number of units that the absent day represents; for example, four hours or one day. Once the system knows the absence day count, it can compare the count to the entitlement balance, determine whether a wait period or any other requirements for payment have been met and determine whether any part of the absent day should be paid. It can also calculate the ending entitlement balance.
The Role of System Elements in Daily Data
Much of the daily absence data is stored by system elements—a collection of predefined elements.
Using System Elements in Formulas.
When you define a take element, you identify the day count formula that the system will use to calculate the number of units that the payee was absent for the day being processed. The formula makes use of any information that is stored in the daily data, including—in some cases—data from the day before or after the day that is being evaluated. For example, three system elements store a payee's scheduled hours:
SCHED_HRS captures the number of hours that the payee was scheduled to work for the day that is being evaluated.
SCHED_HRS_DB captures the number of hours that the payee was scheduled to work the day before.
SCHED_HRS_DA captures the number of hours that the payee was scheduled to work the day after.
You might create a day count formula that uses the prior or next day's values in its calculations. Or you might create a day count formula that uses the value of the SCHED_HRS element to calculate the day count.
Depending on what absence features you want to use, you might need to create other formulas. Any of these formulas can make use of the daily data that is captured by the system elements.
Using User-Defined Fields.
User-defined system elements enable you to capture and use absence data that is specific to your organization. Data that is entered into these fields is stored by system elements and added to the Daily Data records during the Take process. As is true of all system elements, the data captured by these elements can be used by any absence formula. Each of the following pages includes a set of user-defined fields:
Absence Event Entry
Take Calculation
Shift
This section discusses:
Process lists.
Iterative processing for preliminary absence runs.
Stream processing.
Group lists.
Troubleshooting tools.
Once you’ve finished setting up your absence system, you’re ready to run an absence process. Whether you’re running the process for absence take or absence entitlement, the steps are the same. Your process list and calendar definitions determine who and what gets processed. Useful features of process lists include:
The absence period can be the same as or different from the pay period. For example, January absences can be paid in January or February. You specify the target calendar pay for each absence process.
You can run the entitlement and take processes together or separately.
More than one take process can target the same pay calendar. For example, vacations taken in January and sick time taken in February can be paid in February. To accomplish this, create two absence process lists, one for vacations and another for sick time, and attach each process list to a separate absence calendar. On each absence calendar, select the pay calendar as the target calendar.
The system can process absence takes according to their sequence on the process list or in chronological order. To process absences in chronological order, you include take elements in an absence take section of a process list.
Iterative Processing for Preliminary Absence Runs
Iterative processing enables you to process complex, preliminary absence runs quickly with minimal demands on system resources. You launch an Identify phase that flags each payee that meets the selection criteria for your absence run, then launch a Calculate phase that computes absence take or entitlement, as applicable, for all identified payees. After reviewing the results and making the necessary corrections, you rerun the Calculate phase for payees that have had changes since the last run.
Stream Processing
Stream processing is an optional feature that you can use to reduce processing time. You divide payees into subsets, based on their employee IDs, so that the system can perform calculations for multiple sets of payees at the same time.
Group Lists
Group lists are user-defined subsets of the payee population that are scheduled for processing. This feature enables absence administrators to work concurrently with different sets of payees in the same pay group.
Troubleshooting Tools
When you run absence calculations, you can generate an element resolution chain that shows, by payee, how and in what order each element was resolved. This chain also shows how long it took to resolve each element on the process list. Significant system resources are needed to produce an element resolution chain, so we recommend that you use this feature for problem solving only.
See Also
Viewing an Element Resolution Chain
When you run the take process, the system assigns an instance number to each event, based on the following rules:
If Multiple Instances is selected on the Absence Take - Calculation page, the system assigns a separate instance number to each like event that falls within the same absence period.
If Multiple Instances is not selected, the system assigns the same instance number to all like events that fall within the same absence period.
When the absence element that is associated with the take element is segmented, the take process creates multiple instances, regardless of whether you selected Multiple Instances. Multiple instances are also created if the percent defined for the take element changes. (Percent is defined on the Generate Positive Input Member List on the Absence Take - Day Formula page.)
Example
Payee A is absent from January 10 to 17. The absence element is segmented as shown below. The event is divided into the two instances.
Events divided into multiple instances because of segmentation
This section describes how absences work with retroactive processing.
Setting Up Triggers for Absence Events.
Triggers are the mechanism that Absence Management uses to detect changes to data that result in some type of system action. We recommend that you create retro and iterative triggers so that the system recognizes the online changes that users make to absence events through the Absence Event Entry page (the GP_ABS_EVENT record). Then iterative or retro processing is triggered whenever you add, delete, or update events.
Retro Processing Method.
Retro processing of absence calendars is carried out using the corrective retro method. Retro processing creates a new version of the generated positive input results and new versions of the daily absence data (GP_RSLT_ABS). For example, if an absence event occurs from 1 to 5 January (when it was originally processed), the event is represented by five rows of data in the daily record, each named Version1. If you change the end date to 7 January, 7 rows appear in Version 2 of the results.
Following are the steps to prepare for running the entitlement and take processes:
Create one or more absence process lists to define the absence take elements or frequency-based entitlement elements that are to be resolved during processing.
Associate the process list with a run type.
Create a calendar for the absence processing period.
Attach the calendar to a calendar group ID.
Preparing for absence processes
Typically, you create process lists and attach them to run types when you implement Absence Management. Then perform the remaining tasks on a regular basis.
After defining the Calendar Run ID, you're ready to start the process. Complete the Run Control page and use PeopleSoft Process Scheduler to start the process.
The following illustration shows the steps to prepare for absence processing:
Here are the steps to prepare for absence processing:
Processing Steps
(Required) Create calendars.
Calendars tell the system which pay group, run type, process list, and calendar period to process. You define pay groups, run types, and process lists during system implementation. You can define calendar periods during implementation or when you set up your calendars.
Important! You should not edit fields on the Calendar Period, Calendar, or Calendar Group ID pages after you initiate processing (other than to add payees to the Calendar, if you selected the Listed Payees option). To make changes to those pages, you must cancel the absence run.
(Required) Create the calendar group ID.
The calendar group ID identifies the set of calendars to run together and the sequence in which to process the calendars. If you want to use stream processing, you must indicate that when setting up the calendar group ID.
(Optional) Create streams.
To use stream processing, identify the range of employee IDs for each stream. Stream set up is a one time process that may require the assistance of a database administrator.
(Optional) Create group lists.
To use the group list feature, clerks who run the absence process select the payees for each group list. (Group lists are tied to user IDs.)
The following illustration shows the absence processing steps:
Absence processing sequence
Here are the steps for processing absences (use the Payroll/Absence Run Control page for steps 1, 2, and 5):
Identify payees (Identify phase).
The absence cycle begins when you run a process that identifies all payees that are to be processed.
Perform calculations (Calculate phase).
This phase computes each payee’s absence take or entitlement units for an absence run.
Review results.
If the system encounters problems during the Calculate phase—for example, invalid element definitions or payee eligibility problems—it places the payee in error. You can use various pages to review summary results, errors, and warning messages.
Correct any errors and recalculate.
To correct errors, you may need to update the Positive Input pages or make changes to the data in other applications that are integrated with Absence Management, such as Human Resources or Time and Labor. You can then run the Calculate phase again to process only the payees that need to be recalculated.
Finalize the run.
When you’re satisfied with the processing results, run the Finalize phase to close the calendar group ID.
This section explains in detail some of the steps in absence processing.
You begin an absence run by selecting the Identify phase on the Payroll/Absence Run Control page. The Identify phase loops through each calendar that is linked to the calendar group ID and finds all the payees that belong to the pay group that you identified when setting up the calendars. It then identifies the subset of payees that meet the payee selection criteria on the calendars.
You run the Identify phase once per calendar group ID (or once for each stream, if you’re using stream processing). Later, if you add new hires, remove terminated payees, enter positive input, or make other changes that affect payee eligibility, the system detects the changes by looking for iterative triggers when you run the Calculate phase. (You must define iterative triggers for the types of changes to the Job record that you want the system to detect.)
For example, after running the Identify phase, you add five new hires to the pay group. As each new hire is added, the system creates a trigger. When you run the Calculate phase, the system sees the triggers for the new hires and includes them in the population of payees to be processed.
A calendar group ID is considered open from the time that you launch the Identify phase until you run the Finalize phase.
Once you identify payees, you can perform absence take or entitlement calculations. The system calculates one payee at a time, calendar by calendar. If a calendar that is associated with a payee is segmented, the system calculates absences each segment before calculating the payee’s absences in the next calendar. After the system has calculated a payee’s absences across all calendars, it continues to the next payee.
Usually you run the Calculate phase several times for the same calendar group ID, first for the entire population of payees that you selected during the Identify phase and then for payees with changes or errors. With each iteration, you identify which payees you want to calculate by selecting one of these options:
Calculate
This is the Calculate option that you’ll select most often. It instructs the system to identify all payees with iterative triggers, including new hires and transfers, payees placed in error during a previous calculation, and those for whom you’ve manually entered processing instructions using the process indicator.
Recalculate All
Occasionally, you might need to recalculate every payee that is associated with a calendar group ID, stream, or group list. The Recalculate All option instructs the system to delete existing calculations and calculate each payee again without identifying the payees; that is, without trying to determine whether each payee still meets the payee selection criteria.
Freezing and Unfreezing Calculations
If your organization is like most, you have a short window of time between the day that you start running the absence process and your cutoff date. At some point, you might want to stop processing payees with iterative triggers (for example, those with salary adjustments) and concentrate on correcting errors so that you can finalize your absence run. To do this, you instruct the system to freeze calculations for the population that you specify. The Calculate phase ignores any subsequent online changes that you make to payees during the pay run and any positive input that you enter later for these payees. (The system keeps the triggers in case the payee is unfrozen later.) However, if you run the Recalculate All option after payees are frozen, the payees are recalculated.
You can freeze or unfreeze all payees that are in the current process stream, group list, or calendar group ID by selecting the Freeze option on the Payroll/Absence Run Control page or you can freeze selected payees on the Payee Status page.
To freeze calculations for a payee, the following conditions must be met:
Each absence that is associated with the payee (for all segments of all calendars) must have a calculation status of Payment Calculated. If you freeze or unfreeze one segment for a payee, all of the payee’s segments for the calendar become frozen or unfrozen.
The selection status cannot be Suspended by User, Suspended by System,or Cancelled..
When submitting processing instructions, you have the option to automatically suspend all active payees under certain circumstances so that you can process a special run, such as a one time adjustment for a small group of payees. The Suspend Active option on the run control page controls this feature. For on-cycle processing, this option is available when you run the Identify or Calculate phase (including Recalculate All). For off-cycle processing, this option is selected automatically and cannot be changed.
When the Suspend Active option is activated, the system does the following when it processes each payee:
Checks to see if the payee is associated with another open on-cycle calendar group.
When this condition is true, the system checks the payee's calculation status in that calendar group:
If the status is Identified, the system suspends the payee from that run, so that the payee can be immediately identified and calculated in the new run.
If the calculation status is Frozen, the system suspends the payee in the new run that you're submitting.
Checks to see if the payee is associated with another open off-cycle calendar group.
When this condition is true, the system suspends the payee in the calendar group that you just submitted.
See Also
Status Codes and Process Indicators
Status codes and process indicators play an important role in absence processing. Status codes help you monitor and interpret the processing results; process indicators enable you to manually enter processing instructions for specific payees. This section focuses on how the codes are created and how to interpret them.
Status Codes
The system creates two sets of status codes as it identifies each payee for processing:
One selection status code for each payee for each calendar, which it stores on the Process Stat (process status) record. During the first run of the Identify phase, each payee’s selection status is set to Active or Inactive to explain why the payee was identified for processing. With each iteration of the Calculate phase, the system updates the status to explain why the payee was included in or excluded from processing.
The system keeps a record of excluded payees only if they were suspended or canceled. If the payee simply no longer qualifies for selection (for example, the payee is assigned to a different pay group), the system does not record this, and the payee's process and status records are deleted.
One calculation status code for each payee, per calendar segment, which is stored on the Segment Stat record. If a calendar has no period segmentation, a payee has one calculation status. Calculation status tells you the most recent action that has been completed for the segment, for example, identified, calculated, or frozen. Before you run the Calculate phase for the first time, the status code for each identified payee is Identified.
Status codes created when payees are identified for processing
Process Indicators
Sometimes you might need to cancel a payee from an absence run; temporarily suspend a payee from processing; freeze, unfreeze a payee; or take some other action at the payee level. You do this by entering a process indicator that tells the system what action to take during the next iteration of processing. For example, if the selection status for payee A is Active, and you need to cancel that payee from the absence run, set the payee’s process indicator to Cancel. The next time you run the Calculate phase, the system deletes all calculation results for payee A and changes payee A’s selection status to Cancelled. You update the process indicator on the Payee Status component.
Important! Changing a process indicator updates all of a payee’s segments that are in the same calendar group ID.
Status Code and Process Indicator Definitions
The tables below list the status codes and process indicators. Selection status (one per payee per calendar) and calculation status (one per calendar segment) are system-maintained; the process indicator is user-maintained.
Definition |
|
Active |
Payee was active for at least one day within the calendar. |
Inactive |
Payee was not active within the calendar, but was selected because of positive input, a retroactive trigger, or a forwarded adjustment. |
Cancelled |
You manually canceled the payee from the calendar run. The system doesn’t reselect the payee for the current calendar run or a retroactive run. |
Suspended by User |
You manually suspended the payee from the calendar run. The next time you run Calculate, the system tries to reidentify the payee and recalculate the net pay. |
Suspended by System |
The payee is linked to another open calendar group ID. (A payee can be selected for only one unfinalized calendar group ID at a time.) |
Definition |
|
Identified |
Segment has been identified for calculation but has not been calculated. |
Calculation Successful |
Segment has been calculated. |
Frozen For Further Calc |
Segment is not subject to further calculations unless you unfreeze it or run the Recalculate All phase. |
Finalized |
The calendar run has been finalized. You can no longer make changes. |
Calculation Error |
An error occurred during calculation. |
Calculation Error — Bypassed |
The system did not attempt to calculate the payee because of an error. |
Calculation Error — By Rule |
An error was produced because of a condition that you defined through a message element. |
Deleted by Process |
Segment has been deleted by the process. |
Has No Payment |
Note: This calculation status is not applicable to Absence Management. |
Definition |
|
Normal |
This initial setting appears after each calculation. It indicates that there are no special processing instructions for this payee. |
Cancel |
The payee will be canceled from the absence process during the next iteration of the Calculate phase. The selection status will be changed to Canceled. The payee will not be identified again unless you change the indicator to Uncancel before finalizing the absence run. |
Recalculate |
All calculations that are associated with the payee’s jobs (employee ID and employee record number combination) will be rerun the next time you run the Calculate phase. This is similar to the Recalculate All option on the Payroll/Absence Run Control page, but it applies only to payees that you select. |
Suspend |
The payee will be withheld from processing the next time you run the Calculate phase. The selection status will be changed to Suspended by, and all calculation results will be deleted. During subsequent calculations, the system will try to reidentify and recalculate the payee (until it succeeds or you cancel the payee). You do not need to take any action. |
Uncancel |
The system will change the selection status from Canceled to Active, Inactive, or whichever selection status is appropriate and will try to reidentify and recalculate the payee the next time the Calculate phase runs. |
Freeze |
The payee is not subject to recalculation unless you select Recalculate All or Un-freeze on the Payroll/Absence Run Control page or the Payee Status page. |
Unfreeze |
Reverses a payee’s freeze status. |
See Also
Viewing Payee Status and Updating a Payee’s Processing Instructions
When you're ready to begin an absence run, create a run control ID and enter your processing instructions:
Access the Payroll/Absence Run Control page.
Indicate which payees you want to process (options vary by processing phase).
Select the phase of processing to execute (always select the Identify phase the first time).
To produce an element resolution chain or generate performance statistics, select the appropriate option.
Select the language to use for the Log File.
Click the Run button.
Note. The Description and Process Name (as they appear on the Process Scheduler page) are Global Payroll & Absence Mgmt, GPPDPRUN. The same name applies to absence and pay runs.
Because processing is iterative, you return to the Payroll/Absence Run Control page several times throughout the run to update your instructions. For example, after the Calculate phase runs, you'll want to check the results, make corrections, access the Payroll/Absence Run Control page again (using the same run control ID), and enter instructions for the next phase of processing. Repeat this process as often as necessary until you're ready to finalize the run. The system deletes the run control record each time a processing phase is completed.
If an absence run is aborted, you can correct the problem, use the Restart Information link on the run control page to view the restart information, and resume where processing left off. You don’t have to start the absence run at the beginning. It is very important to continue using the same run control that was used when the process was aborted. The information needed for the system to start up where it left off is stored on the run control. A new run control should not be used.
In this section, we discuss how to:
Enter processing instructions for absence and entitlement processes.
View information about an aborted run and restart the process.
See Also
Enterprise PeopleTools PeopleBook: PeopleSoft Process Scheduler
Page Name |
Object Name |
Navigation |
Usage |
GP_RUNCTL |
Global Payroll & Absence Mgmt, Absence and Payroll Processing, Calculate Absence and Payroll, Calculate Absence and Payroll |
Enter processing instructions for a payroll process, an absence take process, or an absence entitlement process. This page is used to run both on-cycle and off-cycle payrolls. |
|
GP_RUNCTL_SEC |
Click the Restart Information link on the Calculate Absence and Payroll page. |
View information about an aborted run, including where the system resumes processing after you fix the problem and resubmit the process. |
|
GP_RUNCTL_DBUG_SEC |
Click the Debug and Tuning Options link on the Calculate Absence and Payroll page. |
Generate statistics to improve the performance of the pay run. |
Access the Calculate Absence and Payroll page.
Payroll/Absence Run
Calendar Group ID |
Select the ID for the set of calendars to process. (The prompt table excludes calendar group IDs that have been finalized.) |
Open |
This is an attribute of the calendar group. The field is stored on the calendar group table. When the calendar group is initially identified, it is considered open, and the check box is selected. Once it is finalized, it will no longer be open, and the check box will be cleared. |
Stream Number |
If you selected the stream processing option on the Calendar Group ID page, the Stream Number field is available. The following conditions apply:
|
Group List ID |
To calculate, freeze, or unfreeze only payees in a particular group list, enter the group list ID. You can process only group lists that you created with your user ID. |
Language Code |
Select the language the system uses to display the Log File (which helps the system administrator determine whether a run completes successfully). The default is the Preference Language that is defined for the user. |
Select the processing phase to run. You can run some phases together, such as Identify and Calculate. Sometimes selecting one option makes other options unavailable.
Identify |
Select the first time you run the process. It instructs the system to identify all payees (associated with the calendar group ID, or selected stream, if applicable) that meet the payee selection criteria that is defined on the calendar pages that are tied to the calendar group ID. If you are using stream processing, the Identify phase must be run by itself. Otherwise, you can run the Identify phase with the Calculate phase. Once you run the Identify phase, you cannot select this check box again for the same calendar group ID or stream, unless you cancel the entire run. With iterative processing, the system adds and removes payees based on changes that you make to the data, so you don’t have to run the Identify process more than once. |
Calculate |
Select when you are ready to calculate the absence units for an absence run. You can run the Calculate phase after or at the same time as the Identify phase. The first time you run Calculate, the system calculates every payee that is flagged by the Identify phase. For each subsequent run of the Calculate phase, you define the subset of payees that you want to process or reprocess by selecting the appropriate check boxes: Select the Calculate check box to reidentify payees and recalculate:
Select both Calculate and Recalculate All to recalculate the entire population of payees that have already been calculated, including frozen payees. The system reidentifies only payees with iterative triggers. |
Freeze |
Select to freeze payees that have been calculated. (Payees with Identified status are not frozen.) The system freezes all calculations for the selected population. When you run the Calculate phase for this payee again, the system ignores iterative triggers and positive input that were added while the payee was frozen. (If you select the Recalculate All option, however, the system processes the triggers and positive input.) |
Finalize |
Select to close the absence cycle for the entire calendar group ID. Once you finalize the run, no more calculations are possible. The Finalize phase must be run by itself. |
Un-freeze |
Select to lift the freeze for payees that were frozen. During the batch process, the system resets the calculation status to Calculated. In subsequent runs of the Calculate phase, the system again performs calculations for these payees. |
Suspend |
Select to pull payees from an open absence run. Suspended payees are given an iterative trigger with a status of unprocessed. You can then include these payees in another run, like an off-cycle or bonus run, before finalizing the open absence run. Once you return to the open absence run, the system reidentifies and recalculates the suspended payees. Suspended payees do not lose their associated retroactivity. |
Cancel |
Select to invalidate the entire pay run. The system deletes all calculations for payees, restores all data to prior values, and deletes all status indicators. Select this check box after you run the Identify or Calculate phase. If this check box is selected, no other options are available. You cannot cancel a run after absences are finalized. The Cancel phase must be run by itself. |
Suspend Active |
This check box specifies whether to suspend payees from other open calendar groups so that they can be processed in this run. (A payee can only be identified in one open calendar group ID at a time.) For on-cycle processing, the check box is available when you select the Identify, Calculate, or Recalculate All option. It is selected, by default. For off-cycle processing, the check box is always selected and you cannot change the setting. |
Recalculate All |
If you select this check box, also select Calculate. The system deletes the calculation results for all payees from prior runs, including frozen payees, and sets the status indicators to their original values. It then recalculates (but does not reidentify) every payee that has already been calculated. This option is appropriate if you’ve modified records that are used during processing and that do not create iterative triggers—for example, if you’ve changed an element’s definition. Warning! Recalculating all payees can place a heavy load on system resources. We suggest that you select Recalculate All only when you suspect that calculations are wrong for a large number of payees because of bad data, an erroneous element definition, or some other problem with far-reaching consequences. |
Identified |
Selected if the Identify phase has been run for all streams. Once all streams are identified, you can use group lists for other phases of processing. |
Restart Information |
If a fatal error, such as a database error, occurs during processing, the processing stops and an error message appears. Click this link to see where the process stopped and where it will resume after you address the problem. After correcting the error, restart the process. Usually you don’t need to cancel the run. |
Debug and Tuning Options |
Click to access the Debug and Tuning Options page, where you can generate statistics to improve the performance of the pay run. |
See Also
Viewing an Element Resolution Chain
Access the Restart Information page.
Phase, Identify Program Option, Step |
These fields identify where processing stopped, if the program made a commit during processing. Run Phase displays Initial, Iterative, Cancel, Identify, Calculate, Finalize, Complete. |
Restart Program, Next Step, Restart Number |
These fields contain information only if the process was aborted during the Identify phase. |
Restart EmplID |
If the failure occurred during the Calculate phase, this field displays the employee ID number of the first payee that is to be calculated when you restart the process. Note. When you restart the Calculate phase for a group list, the system uses the definition of the group list as of the restart time. |
Access the Debug and Tuning Options page.
Performance Tuning
Update Statistics |
This option helps the database administrator to fine-tune system performance. If you select this check box, the system generates statistics at the beginning of the Calculate phase that provide information about how the worktables are being used during processing. |
Several trace options are available during the Calculate phase. These options enable you to request an element resolution chain—a file with detailed results of the Calculate phase—for payees that will be calculated during the next run.
Note. If you are calculating a large number of payees, selecting Trace Cursor, Trace Elements in Error, or Trace All Elements can degrade system performance. We recommend that you use these options for troubleshooting only. (These options require the same level of system resources.)
Suppress Bulk Insert |
Select to prevent the application from caching up data for insert into a number of tables. If you receive a SQL error (such as duplicate insert) while inserting duplicate results into a results table, select this check box and run the process again. Doing so enables the system to display the EMPLID that is causing the error along with the SQL error message. Several trace options are available during the Calculate phase. These options enable you to request an element resolution chain—a file with detailed results of the Calculate phase—for payees that will be calculated during the next run. Note. If you are calculating a large number of payees, selecting Log SQL Time, Trace Elements in Error, or Trace All Elements can degrade system performance. We recommend that you use these options for troubleshooting only. (These options require the same level of system resources.) |
No Trace |
Select if you don’t want to produce an element resolution chain. |
Log SQL Time |
Select to have the Log File report each time the Payee Data Manager program opens cursors (SELECT statements that return more than one row) for the Job table, Job Dates table, Person Organization table, and the Person Organization Instance table during batch processing. This information can be useful for performance tuning. |
Trace Elements in Error |
Select to produce an element resolution chain that includes only those payees in error. |
Trace All Elements |
Select to produce an element resolution chain that shows how all elements were resolved for the calculated payees. You can determine the intermediate value of every element and the order in which the elements were resolved. |
A group list defines a subset of payees that you can process at the same time. Group lists are linked to user IDs. You can process any group list that you create. You can use group lists with the Calculate, Freeze, and Unfreeze phases of processing after you run the Identify phase for the calendar group. Groups lists and streams are mutually exclusive: if you select a group list for processing, you cannot also select a stream number, and vice versa.
Following are some key characteristics of group membership:
You can update the members of a group list at any time. The system uses the current definition of the group list.
The system ignores payees in a group list that are not associated with the absence calendars that are being processed.
You can include a payee in more than one group list; however, we recommend that you do not.
If users start concurrent processes for the same calendar group, but with different group lists that include the same members, the second process stops soon after it begins. This enables the user to remove duplicate payees from the group list.
Warning! If you run the Calculate phase by group list only, the system doesn’t detect changes to the payees that are added or removed from a calendar after the initial Identify phase. To process overlooked payees, run the Calculate phase for the entire population (without group lists) before finalizing the run.
Page Name |
Object Name |
Navigation |
Usage |
GP_GRP_LIST |
Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Payee Groups, Group Lists, Group List |
Create, edit, and view subsets of payees that you can process during an absence run. |
Access the Group List page.
EmplID |
Select the EmplID for each person to include in the group. |
Note. You can view or edit only groups that are created with your user ID.
This section provides an overview of stream processing, lists prerequisites, and discusses creating streams.
Stream processing is an optional feature that provides added flexibility to absence processing. You can divide payees into subsets, or streams, based on employee ID, and run calculations for either of the following:
Only those payees in the stream that you select.
Two or more streams at the same time.
By starting more than one stream at a time, you shorten the processing time significantly—the system processes the streams simultaneously, rather than going through a single, extended run. Using streams can also help control the sequence of each run and establish break points, to commit the results of your absence run to the database.
You must process each stream before you can finalize the calendar group ID. The Cancel and Finalize phases are not stream-oriented because they affect all payees that are processed with the same calendar group ID.
Stream processing requires preliminary steps. Perform steps 1 and 2 once. Perform steps 3 and 4 each time that you use stream processing while running absences.
To prepare for stream processing:
Create the streams.
Partition tables in the database.
A database administrator needs to partition tables, using employee ID as the key.
When creating calendars, select the Stream Processing check box on the Calendar Group ID page.
Select the streams to process through the Calculate Absence and Payroll page.
To process several streams at once:
Select the processing options for the first stream.
Using a different Run Control ID, enter the instructions for the next stream.
Repeat step (4b) for each stream.
You can run the streams all at once or at different times.
Page Name |
Object Name |
Navigation |
Usage |
GP_STREAM |
Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Payee Groups, Streams, Streams |
Set up a processing stream. Before you can use stream processing, you must partition tables in the database. |
Access the Streams page.
Enter a stream number and the EmplIDs of the first and last payees to include in the stream.
Note. You cannot include the same EmplID in more than one stream.