Cost Centers - Flat with Status for ExakTime Integration Import Layout

 The layout below can be used to import the Locations and Cost Codes, with Status from ExakTime into Core HR. Column Headers are provided in the Exported ExakTime Cost Code and Location file in the order of the columns specified in the table below. The import file must have the same number of columns as indicated in the table below, as well. If columns are added or removed, the entire file will stop and an error message will be shown to the user, resulting in no records processed and an error logged.

General Information on Importing Data

For general information on importing data including supported formats and common questions see Imports Overview

When is a Record Added vs Updated?

If an existing record is found using the key fields ([key]) identified below, the HRIS will update that record

 Order Column Header Type Max Field Length Required Notes
 1 Cost Center Level Name Text <= 200 Yes This will come over from ExakTime as either "Cost Code" or "Location"
which will designate (by row) if the record will go to Cost Center 1 
or Cost Center 2
2 Cost Center Name Text <= 200 Yes This will come from the ExakTime Cost Code or Location ID field. 
Values must be populated and unique
3 Cost Center Description Text <= 200 Yes This will come from the ExakTime Cost Code or Location Name field
 4 Cost Center Status  Text  Active/Inactive  Yes  This will come from the ExakTime Cost Code or Location Active/Inactive
Status flag.  
Was this article helpful?
0 out of 0 found this helpful