HR synchronisation

Table name: EMPLOYEE_PERIOD_START_END

Description: List of periods when the selected employees are taken into account

Data description	Type	Data exported
EMPLOYEE_PERIOD_START_END_KEY	Integer	Acknowledgement change key
employee_key	Integer	Employee key
employee_surname	24-character string	Employee’s surname
employee_first_name	24-character string	Employee’s first name
employee_identification_number	255-character string	Employee’s identification number
EMPLOYEE_IDENTIFICATION_CODE	80-character string	Employee ID number code
employee_badge_code	16-character string	Badge number
EMPLOYEE_PERIOD_START_DATE	Date	Acknowledgement start date
EMPLOYEE_PERIOD_END_DATE	Date	Acknowledgement end date

Back to top

Table name: TAKEN_INTO_ACCOUNT_PERIOD

Description: List of time contract periods for the employees selected

Data description	Type	Data exported
taken_into_account_period_key	Integer	Time contract change key
employee_key	Integer	Employee key
employee_surname	255-character string	Employee’s surname
employee_first_name	255-character string	Employee’s first name
employee_identification_number	255-character string	Employee’s identification number
EMPLOYEE_IDENTIFICATION_CODE	80-character string	Employee ID number code
employee_badge_code	255-character string	Badge number
start_date	Date	Time contract start date
end_date	Date	Time contract end date
reset_result	Boolean variable	Result reset 0no 1yes
reason_for_leaving_code	40-character string	Reason for leaving code
reason_for_leaving_desc	80-character string	Reason for leaving description
taken_into_acc_period_comment	255-character string	Comment
RESET_RESULT_END	Boolean variable	Results reset at end of contract
PERSONALIZED_RESET_RESULT_START	255-character string	Customised reset description at start of time contract
PERSONALIZED_RESET_RESULT_END	255-character string	Customised reset description at end of time contract

Back to top

Table name: SECTION_ASSIGNMENT

Description: List of section changes and related information for employees in the selected group

Data description	Type	Data exported
section_assignment_key	Integer	Employee assignment key
assignment_start_date	Date	Assignment start date
employee_key	Integer	Employee key
employee_surname	24-character string	Employee’s surname
employee_first_name	24-character string	Employee’s first name
employee_identification_number	16-character string	Employee’s identification number
EMPLOYEE_IDENTIFICATION_CODE	80-character string	Employee ID number code
employee_badge_code	16-character string	Badge number
company_key	Integer	Company key after change
company_description	50-character string	Company description after change
level_8_key	Integer	Level 8 key
level_8_description	50-character string	Level 8 description
level_7_key	Integer	Level 7 key
level_7_description	50-character string	Level 7 description
level_6_key	Integer	Level 6 key
level_6_description	50-character string	Level 6 description
level_5_key	Integer	Level 5 key
level_5_description	50-character string	Level 5 description
level_4_key	Integer	Level 4 key
level_4_description	50-character string	Level 4 description
firm_key	Integer	Firm key after change
firm_description	50-character string	Company description after change
department_key	Integer	Department key after change
department_description	50-character string	Department description after change
sub_department_key	Integer	Sub-department key after change
sub_department_description	50-character string	Sub-department description after change
section_key	Integer	Section key after change
SECTION_ABBREVIATION	13-character string	Section abbreviation after change
section_description	50-character string	Section description after change
assignment_end_date	Date	Assignment end date

Back to top

Table name: SECTION_ASSIGNMENT_DAY

Description: List of sections assigned to the employee day by day. To have the sections distributed day by day.

Data description	Type	Data exported
employee_key	Integer	Employee key
application_date	Date	Application date
employee_surname	24-character string	Employee’s surname
employee_first_name	24-character string	Employee’s first name
employee_identification_number	16-character string	Employee’s identification number
EMPLOYEE_IDENTIFICATION_CODE	80-character string	Employee ID number code
employee_badge_code	16-character string	Badge number
company_key	Integer	Company key
company_description	50-character string	Company description
level_8_key	Integer	Level 8 key
level_8_description	50-character string	Level 8 description
level_7_key	Integer	Level 7 key
level_7_description	50-character string	Level 7 description
level_6_key	Integer	Level 6 key
level_6_description	50-character string	Level 6 description
level_5_key	Integer	Level 5 key
level_5_description	50-character string	Level 5 description
level_4_key	Integer	Level 4 key
level_4_description	50-character string	Level 4 description
firm_key	Integer	Company key
firm_description	50-character string	Company description
department_key	Integer	Department key
department_description	50-character string	Department description
sub_department_key	Integer	Sub-department key
sub_department_description	50-character string	Sub-department description
section_key	Integer	Section key
SECTION_ABBREVIATION	13-character string	Section abbreviation
section_description	50-character string	Section description

Back to top

Table name: EMPLOYEE_JOB_ASSIGNMENT

Description: List of job changes and related information

Data description	Type	Data exported
employee_job_assignment_key	Integer	Job assignment key
employee_key	Integer	Employee key
employee_surname	24-character string	Employee’s surname
employee_first_name	24-character string	Employee’s first name
employee_identification_number	16-character string	Employee’s identification number
EMPLOYEE_IDENTIFICATION_CODE	80-character string	Employee ID number code
employee_badge_code	16-character string	Badge number
employee_job_key	Integer	Job key
employee_job_description	80-character string	Job description
assignment_date	Date	Job assignment start date
assignment_end_date	Date	Job assignment end date

Back to top

Table name: SKILL_ASSIGNMENT

Description: List of skills assignments for each employee

Data description	Type	Data exported
skill_assignment_key	Integer	Skill assignment key
employee_key	Integer	Employee key
employee_surname	24-character string	Employee’s surname
employee_first_name	24-character string	Employee’s first name
employee_identification_number	16-character string	Employee’s identification number
EMPLOYEE_IDENTIFICATION_CODE	80-character string	Employee ID number code
employee_badge_code	16-character string	Badge number
skill_key	Integer	Skill key
start_date	Date	Skill assignment start date
end_date	Date	Skill assignment end date
skill_description	80-character string	Skill description
skill_level	80-character string	Skill level

Back to top

Table name: HOURLY_CONTRACT_ASSIGNMENT

Description: List of contract assignments for each employee

Data description	Type	Data exported
employee_key	Integer	Employee key
HOURLY_CONTRACT_START	Date	Time contract start date
employee_surname	24-character string	Employee’s surname
employee_first_name	24-character string	Employee’s first name
employee_identification_number	16-character string	Employee’s identification number
EMPLOYEE_IDENTIFICATION_CODE	80-character string	Employee ID number code
employee_badge_code	16-character string	Badge number
HOURLY_CONTRACT_END	Date	Time contract end date
HOURLY_CONTRACT_ABBREVIATION	5-character string	Time contract abbreviation
HOURLY_CONTRACT_DESCRIPTION	40-character string	Time contract description
HOURLY_CONTRACT_INFORMATION	255-character string	Hourly contract Description
RESET_RESULT	Boolean variable	Result reset 0no 1yes
RESET_RESULT_END	Boolean variable	Results reset at end of contract
PERSONALIZED_RESET_RESULT_START	255-character string	Customised reset description at start of time contract
PERSONALIZED_RESET_RESULT_END	255-character string	Customised reset description at end of time contract

Table name: TIME_CONTRACT_ASSIGNMENT

Description: List of contract assignment for each employee (relates to the employee file contract of the old versions under Kelio Prima, Integral, Optima)

Data description	Type	Data exported
time_contract_assignment_key	Integer	Time contract assignment key
employee_key	Integer	Employee key
employee_surname	24-character string	Employee’s surname
employee_first_name	24-character string	Employee’s first name
employee_identification_number	16-character string	Employee’s identification number
EMPLOYEE_IDENTIFICATION_CODE	80-character string	Employee ID number code
employee_badge_code	16-character string	Badge number
time_contract_key	Integer	Time contract key after change
time_contract_code	40-character string	Time contract code
time_contract_description	80-character string	Time contract description
assignment_date	Date	Time contract assignment date
assignment_end_date	Date	Time contract assignment end date
time_contract_type	Integer	Time contract type after change 0Weekly 1Monthly
hourly_basis	Real number	Hourly basis
contract_charact_code	40-character string	Contract properties code
contract_charact_desc	80-character string	Contract properties description
contract_rate_code	40-character string	Contract rate code
contract_rate_desc	80-character string	Contract rate description
is_trial_period	Boolean variable	Probation 0no 1yes
trial_period_end_date	Date	Trail period end date
contract_comment	255-character string	Contract comment
WEEKLY_WORKED_DAY_RATE	Double	Proportion of days worked

Table name: LABOR_CONTRACT

Description: List of employment contract assignments for each employee

Data description	Type	Data exported
assignment_date	Date	Time contract assignment date
assignment_end_date	Date	Time contract assignment end date
employee_badge_code	16-character string	Badge number
employee_first_name	24-character string	Employee’s first name
EMPLOYEE_IDENTIFICATION_CODE	80-character string	Employee ID number code
employee_identification_number	16-character string	Employee’s identification number
employee_key	Integer	Employee key
employee_surname	24-character string	Employee’s surname
LABOR_CONTRACT_NUMBER	40-character string	Employment contract number
LABOR_contract_key	Integer	Employment contract key
LABOR_contract_desc	80-character string	Employment contract description
LABOR_contract_code	5-character string	Employment contract code
contract_comment	255-character string	Contract comment
CONTRACT_CHARACTERISTIC_DESC	80-character string	Contract properties description
CONTRACT_CHARACTERISTIC_CODE	5-character string	Contract properties code
ATTACHMENT_DESCRIPTION	255-character string	Attachment description
PROBATION	Boolean variable	Probation
PROBATION_END_DATE	Date	Trial period end date
PROBATION_DURATION	Integer	Trial period duration
PROBATION_DURATION_UNIT	Integer	Trial period duration unit: 0days 1weeks 2months
PROBATION_RENEWAL_DATE	Date	Trial period renewal date
PROBATION_STATUS	Integer	Trial period status: 0None 1In progress 2Performed 3To be done
CONTRACT_TYPE	Integer	Contract type: 0Employee 1Temporary worker
INITIAL_END	Date	Initial end date
NUMBER_OF_EXTENSION	Integer	Number of extensions
ATTACHMENT_AGENCY_DESCRIPTION	80-character string	Temporary employment agency description
ATTACHMENT_AGENCY_ABBREVIATION	5-character string	Temporary employment agency abbreviation
NUMBER_OF_WEEKLY_HOURS	Real number	Number of weekly hours
HOURLY_RATE	Real number	Hourly rate
WAGEBAND	Real number	Wage band
INVOICED_RATE	Real number	Invoice rate
USE_REASON_DESCRIPTION	80-character string	Use reason description
USE_REASON_CODE	5-character string	Use reason code
REPLACED_PERSON_NAME	24-character string	Replaced person’s first name
REPLACED_PERSON_SURNAME	24-character string	Replaced person’s surname
REPLACED_PERSON_IDENTIFICATION_CODE	40-character string	Replaced person’s identification code
REPLACED_PERSON_IDENTIFICATION_NUMBER	16-character string	Replaced person’s identification code
REPLACED_PERSON_BADGE_CODE	16-character string	Replaced person’s badge code
REPLACED_PERSON_KEY	Integer	Replaced person’s key
JOB_HELD_DESCRIPTION	80-character string	Job held description
JOB_HELD_CODE	5-character string	Job held code
BUSINESS_LEAVE_TYPE	40-character string	Mission type
PAYROLL_TRANSMISSION_DAY	Date	Payroll transmission date
COLL_LABOUR_AGREEMENT_DESC	80-character string	Collective agreement title
COLL_LABOUR_AGREEMENT_CODE	40-character string	Collective agreement code
COMPLEMENT_LABOR_CONTRACT_DESC	80-character string	Contract addendum title
COMPLEMENT_LABOR_CONTRACT_CODE	40-character string	Contract addendum code
WORKING_QUOTA_PERIODICITY_CODE	Integer	Working time frequency code
WORKING_QUOTA_HOURS_VALUE	Real number	Working time value in hours
WORKING_QUOTA_DAYS_VALUE	Real number	Working time value in days
WORKING_QUOTA_OTHER_VALUE	255-character string	Other working time detailed description
WORKING_QUOTA_UNIT_CODE	Integer	Working time unit code
FULL_TIME_EQUIVALENT	Real number	Full-time equivalent
WORKING_HOURS_COMMENT	255-character string	Working hours comment
REASON_FOR_LEAVING_CODE	5-character string	Reason for leaving code
REASON_FOR_LEAVING_DESCRIPTION	40-character string	Reason for leaving description
REASON_FOR_LEAVING_COMMENT	255-character string	Reason for leaving comment
STATE_FINAL_PAY_ABBREVIATION	40-character string	Final balance status abbreviation of the employment contract
STATE_FINAL_PAY_DESCRIPTION	80-character string	Final balance status description of the employment contract

Table name: WORK_DURATION

Description: Work duration list for each employee

Data description	Type	Data exported
assignment_date	Date	Assignment date
assignment_end_date	Date	Assignment end date
employee_badge_code	16-character string	Badge number
employee_first_name	24-character string	Employee’s first name
EMPLOYEE_IDENTIFICATION_CODE	80-character string	Employee ID number code
employee_identification_number	16-character string	Employee’s identification number
employee_key	Integer	Employee key
employee_surname	24-character string	Employee’s surname
RATE_ABBREVIATION	5-character string	Rate value abbreviation
RATE_DESCRIPTION	80-character string	Rate value description
RATE_KEY	Integer	Rate value Key
hourly_basis	Real number	Hourly basis
HOURLY_BASIS_TYPE	Integer	Hourly rate type: 0Weekly 1Periodic
HOURLY_BASIS_DIST_DESC	80-character string	Hourly rate distribution description
HOURLY_BASIS_DIST_CODE	5-character string	Hourly rate distribution code
HOURLY_BASIS_DIST_KEY	Integer	Hourly rate distribution Key
WEEKLY_WORKED_DAY_RATE	Double	Proportion of days worked

Back to top

Table name: COEFFICIENT_ASSIGNMENT

Description: List of wage band, qualification, professional status and employment status assignments for each employee

Data description	Type	Data exported
coefficient_assignment_key	Integer	Coefficient assignment key
employee_key	Integer	Employee key
employee_surname	24-character string	Employee’s surname
employee_first_name	24-character string	Employee’s first name
employee_identification_number	16-character string	Employee’s identification number
EMPLOYEE_IDENTIFICATION_CODE	80-character string	Employee ID number code
employee_badge_code	16-character string	Badge number
coef_assignment_start_date	Date	Coefficient assignment start date
coef_assignment_end_date	Date	Coefficient assignment end date
coefficient_code	5-character string	Coefficient code
coefficient_description	80-character string	Coefficient description
qualification_code	5-character string	Qualification code
qualification_description	80-character string	Qualification description
professional_status_code	5-character string	Professional status code
professional_status_desc	80-character string	Professional status description
job_position_code	5-character string	Job class code
job_position_description	80-character string	Job class description

Back to top

Table name: MEDICAL_APPOINTMENT

Description: List of medical appointments assignments for each employee

Data description	Type	Data exported
MEDICAL_APPOINTMENT_KEY	Integer	Medical appointment key
employee_badge_code	16-character string	Badge number
employee_first_name	24-character string	Employee’s first name
employee_identification_number	16-character string	Employee’s identification number
EMPLOYEE_IDENTIFICATION_CODE	80-character string	Employee ID number code
employee_key	Integer	Employee key
employee_surname	24-character string	Employee’s surname
MEDICAL_APPOINTMENT_DATE	Date	Medical appointment date
MEDICAL_APPOINTMENT_TIME	Hour	Medical appointment time
MEDICAL_APPOINTMENT_STATE	Boolean variable	Medical appointment status
MEDICAL_APPOINTMENT_STATE_DESC	80-character string	Medical appointment description
MEDICAL_APPOINTMENT_COMMENT	2000-character string	Medical appointment comment
MEDICAL_APPOINTMENT_REASON	80-character string	Medical appointment type

Back to top

HR Synchro