Data Import – Data reconciliation

Overview

This section describes how a row in the excel file is reconciled .i.e. data to be inserted or update an existing record. Athri uses the ‘Key Field(s)” in the excel file to find out a record needs an insert or update.

Table below lists the entity and the corresponding key field

 

Entity Key Field Comment
User Sign-in name If a record with the given sign-in name exist, the record is updated or a new user record is inserted
Job position Jobposition code If a record with the given Jobposition code exist, the record is updated or a new job position is inserted
Job position Activity Jobposition code, Activity Code If a record with combination of jobposition code and activity code exist, the record is updated or a new job position activity is inserted
Skill Skill Code If a record with the given skill code exist, the record is updated or a new skill is inserted
Jobposition Activity Skill Activity code, Skill Code If a record with combination of the activity code,skill code exist, the record is updated or a new skill association is inserted
Company Company Code If a record with the given company code exist, the record is updated or a new company record is inserted
Candidate Email If a record with the given candidate email exist, the record is updated or a new candidate record is inserted

Previous Topic
Data Import - Introduction

Next topic
Data Import - Import Data