Processing Details

The Import Employee Leave And Deductions screen generates input file and error files which have the same file layout.

Input File Excel Template

Go to the Developer Resources page of the Costpoint Information Center to download the Excel template file specifically designed for this preprocessor. Templates for other Costpoint preprocessors are also available at the same location.

Input File and Error File Layout

You supply the name for the input file. The input file can be a fixed-format file or a comma-separated file. The error file has the same name as the input file with an “.ERR” extension. The input and error files share the same layout.

If the input file is a fixed-format file, you must fill every position with either an appropriate character or a space. It is not necessary to zero-fill numbers; you can use spaces to maintain the proper format.

If the input file is a comma-separated file, you do not need to fill every position. However, the file must contain the correct number of commas.

A record in the input file must be in one of three formats: Deduction Record (D), Contribution Record (C), or Leave Record (L). The input file layouts are shown below.

Input File Deduction Record (‘D’)

Field Name Costpoint Table/Column Data Type and Size Required/Optional Format or Validation Table
RECORD_CD Character 1 Required D
EMPL_ID EMPL_DED.EMPL_ID Character 12 Required From EMPL
DED_CD EMPL_DED.DED_CD Character 6 Required From DED_CD
S_DED_MTHD_CD EMPL_DED.S_DED_MTHD_CD Character 6 Required Valid Deduction Code Methods are set up on the Manage Deductions screen.
DED_RT_AMT EMPL_DED.DED_RT_AMT Numeric 12 Required 99999999.99
DED_ANN_CEIL_AMT EMPL_DED.DED_ANN_CEIL_AMT Numeric 10 Required 999999.99
DED_START_DT EMPL_DED.DED_START_DT Date 10 Optional mm/dd/yyyy  format
DED_END_DT EMPL_DED.DED_END_DT Date 10 Optional mm/dd/yyyy  format
DED_END_CVG_DT EMPL_DED.DED_END_CVG_DT Date 10 Optional mm/dd/yyyy  format
DED_PRIORITY_NO EMPL_DED.DED_PRIORITY_NO Numeric 2 Optional 99

Input File Contribution Record (‘C’)

Field Name Costpoint Table/Column Data Type and Size Required/Optional Format or Validation Table
RECORD_CD Character 1 Required 'C'
EMPL_ID EMPL_CNTRB.EMPL_ID Character 12 Required From EMPL
CONTRIB_DED_CD EMPL_CNTRB.CNTRB_DED_CD Character 6 Required From DED_CD
S_CNTRB_MTHD_CD EMPL_CNTRB.S_CNTRB_MTHD_CD Character 6 Required Valid Contribution Code Methods are set up on the Manage Deductions screen.
CNTRB_RT_AMT EMPL_CNTRB.CNTRB_RT_AMT Numeric 12 Optional 99999999.99
CNTRB_ANN_CEIL_AMT EMPL_CNTRB.CNTRB_ANN_CEIL_AMT Numeric 10 Optional 999999.99
CNTRB_START_DT EMPL_CNTRB.CNTRB_START_DT Date 10 Optional mm/dd/yyyy  format
CNTRB_END_DT EMPL_CNTRB.CNTRB_END_DT Date 10 Optional mm/dd/yyyy  format

Input File Leave Record (‘L’)

Field Name Costpoint Table/Column Data Type and Size Required/Optional Format or Validation Table
RECORD_CD Character 1 Required 'L'
EMPL_ID EMPL_LV_ACCRL.EMPLD Character 12 Required From EMPL
LV_CD EMPL_LV_ACCRL.LV_CD Character 12 Required From LV
LV_TYPE_CD EMPL_LV_ACCRL.LV_TYPE_CD Character 4 Required Required Valid Leave Types are set up on the Configure Leave Types screen.
LV_HIRE_DT EMPL_LV_ACCRL.LV_HIRE_DT  Date 10 Optional mm/dd/yyyy  format