With DATABASICS and Deltek, federal contractors can solve their most difficult time and expense challenges, while providing the simple user experience, including mobile apps, that today’s organizations demand. DATABASICS has integrated with Deltek for more than a decade. The integration is highly efficient, can run automatically, and is totally reliable.
General Load Guidelines
DATABASICS allows data to be entered into the application two main ways, through load according to a specification given by DATABASICS or entered manually in to the screen.
The customer will be maintaining data from files according to specification in this document. Most data originates from CostPoint, but some may be maintained external to CostPoint. Data loads can be run manually, or on a scheduled basis, a “profile” will execute the load, from a predefined SFTP Location dedicated to the Customer.
Load files should not contain a header line
All load files should be presented as tab delimited .txt files
No double quotes [“] are allowed in any field
ID fields must be upper case and alpha numeric [0-9] [A-Z] [-_.], with no special characters or spaces (“&” cannot form part of the ID field in the loads).
File loads will be full. This means that all active records will be included in the load, and if a record is not included in the load this record will be set to inactive.
This load approach is configurable and has an alternative in a partial setting, where only new or changed records will be included in the load file, but the load itself includes an active y/n flag.
Organization Structure Mapping
Operating Unit will be mapped to Deltek Company Id
Department will be mapped to Org ID or PLC Code in Deltek
Employee data will be loaded from Deltek for the following fields:
Employee ID
Login ID
Department Code
First Name
Last Name
Start Date
End Date