Import Employee Leave And Deductions
Use this preprocessor to import employee deduction, contribution, and leave data from a Comma Separated Values (.CSV) or Fixed Length format ASCII text file into the corresponding employee tables in Costpoint.
Data is imported into the following Costpoint employee tables:
- EMPL_DED
- EMPL_CNTRB
- EMPL_LV_ACCRL
Employee records must exist in Costpoint for the employees whose data is being imported. You must also set up employee deduction, contribution, and leave codes prior to using this preprocessor.
There are two ways to work with input files in Costpoint:
- You can access the input file from the network by using Alternate File Locations.
- You can upload the input file to the Costpoint database; in which case, no further access to network folders is necessary.
If you decide to use the first option, click 
in the File Location field to select an alternate file location. If you choose the second option, leave the File Location field blank and use the File Upload Manager to upload the input file to the Costpoint database.
Input File Excel Template
For Costpoint 2025.x and later releases, you can download the Excel template file specifically designed for this preprocessor from the Costpoint Preprocessor Guides page on the Deltek Learning Hub.
For Costpoint 8.1, the input file is available on the Developer Resources page in the Costpoint Information Center.
Excel templates for the other Costpoint preprocessors can be found in these same locations.
Related Topics:
Display the Import Employee Leave And Deductions Screen
You access the Import Employee Leave And Deductions screen from the People domain.
Contents of the Import Employee Leave And Deductions Screen
Use the fields and options to configure the Import Employee Data screen.
The Import Employee Leave And Deductions screen generates input file and error files which have the same file layout.
Costpoint performs multiple actions to import input file data into Costpoint Base Tables.
The following error messages may be displayed on the screen when you run this preprocessor.
Table Information for the Import Employee Leave And Deductions Screen
This preprocessor updates the following tables: