Do not delete any default information if your vendor is ADP. For ease in searching for extract files at a later date, you can add information for your own purpose, such as dates, if desired.
Before the Payroll tool can be used, the Master Files | Payroll Extract settings must be configured. Each Office Group that is set up in Master Files | Payroll Setup will appear in the Payroll Extract Settings grid. If your agency uses ADP for your payroll vendor, you must enter the ADP Company Code prior to generating Payroll batches.
The code will be an identifier that ADP has assigned to your agency and will need to appear in the data and file name for all batches that are submitted to ADP. If you do not know what your ADP Company Code is, you will need to contact ADP to retrieve the information.
To configure Payroll Extract settings:
1. On the main menu, select Master Files and then select Payroll Extract.
2. Select the appropriate extract entry in the grid.
3. Below the display grid, select the desired Extract Type for the applicable Office Group that is selected.
4. The following fields are editable (Click within each field to display additional help content ):
● File Name – The name to which the payroll extract files will be saved.
|
|
Do not delete any default information if your vendor is ADP. For ease in searching for extract files at a later date, you can add information for your own purpose, such as dates, if desired. |
● ID Column – Fill this out if you need an ID Column added to the extract field.
|
|
Do not modify this field if ADP is your payroll vendor. |
● ID Value – This data will pull to the ID Column in the extract file.
|
|
This should be the ADP Company Code if ADP is your payroll vendor. The code will be an identifier ADP assigned to your agency. If you do not know what your ADP Company Code is, you must contact ADP to retrieve the information. |
5. Click 
. The saved data will appear in the Payroll Extract Settings grid.
The Payroll Extract Settings grid will display the payroll extract settings that are established for each office group that is set up for the agency (in Master Files | Payroll Setup). The Payroll Extract Settings grid contains the following columns of data:
● ID — The number of the Office Group within Enterprise Edition.
● Extract Type — The type of Payroll Extract file the Office Group is defaulted to.
● Office Group — The name of the Office Group within Enterprise Edition.
● File Name — The name the Payroll Extract files will save to.
● Custom ID Column — The data field that will pull to the ID Column in the Payroll Extract file (This must be the ID Value (ADP Company Code), if ADP is your payroll vendor).
● Custom ID Value — The ID Value entered for the Office Group (This should be the ADP Company Code, if ADP is your payroll vendor).
Each payroll vendor has different specifications for what data they require for extract files in order to process payroll. Currently, ADP is the only supported payroll vendor in Enterprise Edition and data is configured to synchronize with payroll extract files based on their specifications.
The default File Name and ID Column fields are set up based on the information ADP requires to process payroll. Do not delete any of the information in the File Name field. If desired, you can add information (e.g. Dates) to allow for easier searching for extract files at a later date.