Skip to Main Content
Finance Innovation Ideas Portal
Status Needs Review
Created by Kelli Chidester
Created on Mar 31, 2021

Payroll Schedule Automation in ADP

Payroll schedule is currently not automated, it is a spreadsheet that is generated by the payroll team every year and is formatted in a way that Baymax can easily process. This payroll schedule does not include any new pay groups formed after the spreadsheet is created. This is the effort of automating the payroll schedule so that it can always be the most accurate and up to date, and so that every year the payroll calendar does not have to be manually created.

  • Attach files
  • Laura Mallea
    Reply
    |
    Apr 2, 2021

    Per Dena Rakestraw on 4/2:

    It is very common for an updated payroll schedule to be passed and uploaded more than once throughout the year.

    There are 3 fields on the table that will help you identify which rows are the “true” schedule.

    Table = PS_AL_ESS_TBL

    1st qualifier – TRANSMITTAL

    There are 3 available values for the transmittal field:

    0 – this is the main row for the Paygroup/Sched_Year/Week combination. This row could have been added via the scheduled or it could have been added through an Adjustment Payroll.

    1 – this signifies this is the current pay cycle being processed

    2 – this signifies this was the last pay cycle that was processed

    2nd qualifier – INPUT_DATE – If this field is populated with a date, then the row was added by loading the payroll schedule from the mainframe. If this field is NULL, then the row was added with an Adjustment Payroll.

    3rd qualifier – DELIVERY_DATE – If this is populated with a date, then the row was added by loading the payroll schedule from the mainframe. If this field is NULL, then the row was added with an Adjustment Payroll.

    Therefore, in order to find the rows actually added via the payroll schedule, the rows must meet this criteria:

    1. TRANSMITTAL = 0

    2. INPUT_DATE is not NULL

    3. DELIVERY_DATE is not NULL