Using the Clean Mobile Shift Offer task

You can use the Clean Mobile Shift Offer task to remove bad shift data caused by errors within a third party Shift Offer tool.

The Clean Mobile Shift Offer task will load all the unassigned shift's shift offer records from SO_SHIFT_OFFER_SHIFT table for a specified location and for a specified period. Based on the shift offer record's SOSO_ID, SOSOSHFT_IDs data will be deleted from SO_SOFR_THRPTY_TRACK_INFO, SO_SHIFT_OFFER_EMP_SHIFT, SO_SHIFT_OFFER_SHIFT, SO_SHIFT_OFFER_EMPSHFT_CMPLWRN and SO_SHIFT_OFFER tables.

You can create and schedule this task in the Job Scheduler. For more information on how to do this, see Infor Workforce Management Time and Attendance Implementation and Administration Guide.

After you have created and scheduled this task, you can set the parameters for the task:

  1. Locate your Clean Mobile Shift Offer task in the list of tasks on the Task Schedules page in the Job Scheduler.
  2. Select Parameters. The Clean Mobile Shift Offer Settings page is displayed.
  3. Specify this information:
  4. Incl. Subteam: Specify Yes or No.
  5. Start Date: Start date for the clean up.
  6. End Date: End date for the clean up.
  7. Batch size: JDBC batch size. The JDBC API provides addBatch() method to add queries into a batch and then later execute them using executeBatch() method. This parameter decides the number of queries to be executed in a single batch.
  8. Buffer minutes: Decides which records need to be considered for clean up. These minutes are deducted from the current date, after deducting for those record's SOSO_DATETIME and SOSO_DURATION comes later to the current date value which will be considered for processing.

    Example: If the task is started at 26-Jun 1:00 pm and if the Buffer minutes value is 60, then records which are later than 26-Jun 12:00 pm will be considered for clean up.

    Note: SOSO_DURATION column time portion is added to SOSO_DATETIME column date portion for processing. These two columns belong to SO_SHIFT_OFFER table.
  9. In Clause Size: Specify an integer value for this field. This parameter determines the number of parameters inside the In clause for all the queries executed in this task.
  10. Workmail Notification: Select users to be notified via Workmail when the task is completed.
  11. Click Submit to save your parameters. Your task will run at the time and location that you specified.