<< Click here to display Table of Contents >> Kelio Data > Table detail:

Employee-specific data

Contents

Tick a box to access the corresponding table

Table name: EMPLOYEE

Description: Information on employees

Data description	Type	Data exported
employee_key	Integer	Employee key
surname	24-character string	Employee’s surname
first_name	24-character string	Employee’s first name
identification_number	16-character string	Employee’s identification number
EMPLOYEE_IDENTIFICATION_CODE	80-character string	Employee ID number code
birthdate	Date	Date of birth
PRIVATE_MOBILE_PHONE	40-character string	Private mobile phone number
private_phone_number1	15-character string	Private telephone number 1
private_phone_number2	15-character string	Private telephone number 2
private_email	255-character string	Private email address
private_email_2	255-character string	Private email address 2
address	80-character string	Address
ADDRESS_COMPLEMENT_1	80-character string	Additional address field 1
ADDRESS_COMPLEMENT_2	80-character string	Additional address field 2
post_code	15-character string	Post code
town	40-character string	Town
photo	Binary file (photo)	Photo
emergency_contact	255-character string	Emergency contact
PROFESSIONAL_MOBILE_PHONE	40-character string	Business mobile phone number
professional_phone_number1	15-character string	Professional telephone number 1
professional_phone_number2	15-character string	Professional telephone number 2
professional_email	255-character string	Professional email address
employee_comment	255-character string	Comment
badge_code1	16-character string	Badge 1 number
badge_code2	16-character string	Badge 2 number
reader_group_description	40-character string	Reader group description
current_level_8_description	50-character string	Current level 8 description
current_level_7_description	50-character string	Current level 7 description
current_level_6_description	50-character string	Current level 6 description
current_level_5_description	50-character string	Current level 5 description
current_level_4_description	50-character string	Current level 4 description
current_firm_description	50-character string	Current member company description
current_depart_description	50-character string	Current member department description
current_sub_depart_desc	50-character string	Current member sub-department description
current_section_key	Integer	Current member section key
current_section_description	50-character string	Current member section description
current_section_appli_date	Date	Current section membership start date
employee_abbreviation	50-character string	Employee abbreviation
attached_document	254-character string	Attachment
national_insurance_number	16-character string	Social security number
arrival_in_company_date	Date	Date of entry into the company
seniority_start_date	Date	Date taken into account for the seniority calculation
EMPLOYEE_PERIOD_START_DATE	Date	Acknowledgement start date
EMPLOYEE_PERIOD_END_DATE	Date	Acknowledgement end date
taken_acc_period_start_date	Date	Time contract start date
taken_acc_period_end_date	Date	Time contract end date
taken_acc_period_reset_result	Boolean variable	Result reset date
time_saving_end_date	Date	Validity end date of time savings account
cur_schedule_abbreviation	5-character string	Current schedule abbreviation
cur_schedule_description	40-character string	Current schedule description
cur_shift_scheduler_desc	40-character string	Current shift description
cur_schedule_appli_date	Date	Current schedule application date
cur_time_contract_description	80-character string	Current schedule contract description
cur_time_contract_appli_date	Date	Current schedule contract application date
cur_time_contract_type	Integer	Current schedule contract type 0Weekly 1Monthly Otherwise the type is null.
cur_time_contract_value	Real number	Current time contract value
cur_job_description	80-character string	Current job description
cur_job_application_date	Date	Current job application date
cur_coefficient_description	80-character string	Current coefficient description
cur_coefficient_appli_date	Date	Current coefficient application date
cur_class_of_check_desc	40-character string	Current check class description
cur_class_of_check_appli_date	Date	Current check class application date
cur_end_period_calendar_desc	40-character string	Current pay calendar description
cur_end_period_calendar_date	Date	Current pay calendar application date
profile_description	40-character string	Profile description
personal_ws_profile_desc	40-character string	Personal workspace profile description
login	80-character string	Employee’s login
user_password	32-character string	Employee’s password encrypted as MD5
recipient_email	255-character string	Recipient email address
senders_email	255-character string	Sender email address
absence_validator	500-character string	Validator of absence requests
clocking_validator	500-character string	Validator of clocking declarations
REMOTE_WORKING_VALIDATOR_LOGIN	500-character string	Remote working validator's login
working_site	40-character string	Work site
access_auth_start_date	Date	Access authorisation start date
access_auth_start_time	Hour	Access authorisation start time
access_auth_end_date	Date	Access authorisation end date
access_auth_end_time	Hour	Access authorisation end time
personal_code	6-character string	Personal code
cur_access_profile_desc	40-character string	Current access profile description Only one current access profile by employee is exported among all profiles of the employee (as there can be an access profile per site). The access profile that has been in progress for the longest time can be exported by taking the 1st site (sorted by site descriptions in ascending order) if several access profiles start at the same time.
cur_access_profile_assig_date	Date	Current access profile application date
sex	Integer	Title: 0Mr 1Mrs 2Miss 3Not communicated
authenticate	Boolean variable	The employee must authenticate: 0no 1yes
public_hol_payment_type	Integer	Public holiday payment method 0never 1always 2if day before and day after worked
automatic_clocking_allowance	Boolean variable	Automatic clocking allowance: 0no 1yes
gives_up_splitting	Boolean variable	Splitting allowance 0no 1yes
to_be_scheduled	Boolean variable	Employee taken into account in planning 0no 1yes
clocking_without_badge	Boolean variable	Right to clock without badge: 0no 1yes
compensatory_leave_allowance	Boolean variable	Compensatory leave allowance 0no 1yes
flexi_leave_absence_allowance	Boolean variable	Flexi leave absence allowance: 0no 1yes
automatic_absence_allowance	Boolean variable	Automatic absence allowance 0no 1yes
automatic_clocking_out	Boolean variable	Right to automatic clocking out 0no 1yes
language	Integer	Software language for the employee 1 English (United States) 2 English (Canada) 3 French Canada) 7 Russian (terminal) 27 English (South Africa) 30 Greek 31 Dutch (Netherlands) 32 Dutch (Belgium) 33 French 34 Spanish 39 Italian 40 Romanian (terminal) 41 French (Switzerland) 44 English (United Kingdom) 45 Danish 47 Norwegian 48 Polish (terminal and employee self-service) 49 German 90 Turkish (terminal) 96 Basque (terminal) 97 Catalan (terminal) 99 Test language 101 Welsh 263 English (Cyprus) 351 Portuguese 353 English (Ireland) 371 Latvian (terminal) 420 Czech (terminal) 966 Arabic (Experimental) 971 English (United Arab Emirates)
duration_visualization	Integer	Duration visualization: 0hours and minutes 1hours and hundredths
concerned_by_anti_passbacks	Boolean variable	Concerned by anti pass-backs 0no 1yes
super_pass	Boolean variable	Right to activate super pass: 0no 1yes
specific_schedules	Boolean variable	Right to activate specific schedules 0no 1yes
central_alarm_sys_activ	Boolean variable	Right to activate alarm units manually: 0no 1yes
extended_time_out	Boolean variable	Extended timeout for this employee: 0no 1yes
super_pass_everywhere	Boolean variable	Right to activate super pass everywhere 0no 1yes
specific_schedules_everywhere	Boolean variable	Right to activate specific schedules everywhere: 0no 1yes
is_access_employee	Boolean variable	Access employee 0no 1yes
IS_HR_EMPLOYEE	Boolean variable	HR employee 0no 1yes
is_t_and_a_employee	Boolean variable	T&A employee 0no 1yes
is_job_costing_employee	Boolean variable	Job costing employee 0no 1yes
default_job_abbreviation	5-character string	Abbreviation of the current activity type
default_job_code	40-character string	Code of the current activity type
default_job_application_date	Date	Default activity assignment date
default_job_automatic	Boolean variable	Planned activity generates actual activity
default_job_description	40-character string	Description of the current activity type
receive_visitor	Boolean variable	Right to receive visitors
TAK_ACC_PER_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

Employee free and predefined field

Table name: EMPLOYEE_FIELD_ASSIGNMENT

Description: Information regarding free and predefined field assignment to employees

Data description	Type	Data exported
ASSIGNMENT_KEY	Integer	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_field_key	Integer	Field key
employee_field_description	80-character string	Field description
employee_field_value	80-character string	Field value (content)
ASSIGNMENT_START_DATE	Date	Assignment start date
ASSIGNMENT_END_DATE	Date	Assignment end date

Light employee

Table name: LIGHT_EMPLOYEE

Description: Information on employees

Data description	Type	Data exported
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_PERIOD_START_DATE	Date	Acknowledgement start date
EMPLOYEE_PERIOD_END_DATE	Date	Acknowledgement end date
taken_acc_period_start_date	Date	Time contract start date
taken_acc_period_end_date	Date	Time contract end date
access_auth_start_date	Date	Current access authorisation start date
access_auth_start_time	Hour	Current access authorisation start time
access_auth_end_date	Date	Current access authorisation end date
access_auth_end_time	Hour	Current access authorisation end time
IS_HR_EMPLOYEE	Boolean variable	HR employee
is_t_and_a_employee	Boolean variable	T&A employee
is_access_employee	Boolean variable	Access employee

Employee personal data

Table name: EMPLOYEE_PRIVATE_DATA

Description: Information on the employee's private data

Data description	Type	Data exported
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_PERIOD_START_DATE	Date	Acknowledgement start date
EMPLOYEE_PERIOD_END_DATE	Date	Acknowledgement end date
taken_acc_period_start_date	Date	Time contract start date
taken_acc_period_end_date	Date	Time contract end date
access_auth_start_date	Date	Current access authorisation start date
access_auth_start_time	Hour	Current access authorisation start time
access_auth_end_date	Date	Current access authorisation end date
access_auth_end_time	Hour	Current access authorisation end time
IS_HR_EMPLOYEE	Boolean variable	HR employee
is_t_and_a_employee	Boolean variable	T&A employee
is_access_employee	Boolean variable	Access employee
title	Integer	Sex 0Mr (default value) 1Mrs 2Miss
title_description	40-character string	Title description
sex	Integer	Sex 0Male 1Female
employee_second_name	24-character string	Employee’s middle names
employee_maiden_name	24-character string	Maiden name
photo	Binary file (photo)	Photo
birthdate	Date	Date of birth
age_year	Integer	Age (years)
age_month	Integer	Age (months)
birth_place	255-character string	Place of birth
birth_country_code	5-character string	Birth country code
birth_country_description	80-character string	Birth country description
private_phone_number1	15-character string	Private telephone number 1
private_phone_number2	15-character string	Private telephone number 2
private_email	255-character string	Private email address
address	80-character string	Address
post_code	15-character string	Post code
town	40-character string	Town
emergency_contact	255-character string	Emergency contact
national_insurance_number	16-character string	N.I. number
national_insurance_company	255-character string	Local tax office
mutual_insurance_company	255-character string	Company health insurance
family_status_code	5-character string	Family status code
family_status_description	80-character string	Family status description
family_status_date	Date	Family status date
child_count	Integer	Number of children
PRIVATE_MOBILE_PHONE	40-character string	Private mobile phone number
private_email_2	255-character string	Private email address 2
ADDRESS_COMPLEMENT_1	80-character string	Additional address field 1
ADDRESS_COMPLEMENT_2	80-character string	Additional address field 2

Employee's children

Table name: CHILD

Description: Information on the employee's children

Data description	Type	Data exported
child_key	Integer	Child 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
child_surname	255-character string	Child's surname
child_first_name	255-character string	Child's first name
child_sex	Integer	Sex 0Male 1Female
child_birth_date	Date	Child's birth date
deleted	Integer	Not used
DEPENDENT_CHILD	Boolean variable	Dependent child

Employee professional data

Table name: EMPLOYEE_PROFESSIONAL_DATA

Description: Information on the employee's professional data

Data description	Type	Data exported
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_PERIOD_START_DATE	Date	Acknowledgement start date
EMPLOYEE_PERIOD_END_DATE	Date	Acknowledgement end date
taken_acc_period_start_date	Date	Time contract start date
taken_acc_period_end_date	Date	Time contract end date
access_auth_start_date	Date	Current access authorisation start date
access_auth_start_time	Hour	Current access authorisation start time
access_auth_end_date	Date	Current access authorisation end date
IS_HR_EMPLOYEE	Boolean variable	HR employee
access_auth_end_time	Hour	Current access authorisation end time
is_t_and_a_employee	Boolean variable	T&A employee
is_access_employee	Boolean variable	Access employee
employee_second_name	24-character string	Employee’s middle names
employee_maiden_name	24-character string	Maiden name
photo	Binary file (photo)	Photo
professional_phone_number1	15-character string	Professional telephone number 1
professional_phone_number2	15-character string	Professional telephone number 2
PROFESSIONAL_MOBILE_PHONE	40-character string	Business mobile phone number
professional_email	255-character string	Professional email address
employee_abbreviation	50-character string	Employee abbreviation
to_be_scheduled	Boolean variable	To be planned
arrival_in_company_date	Date	Date of entry into the company
seniority_start_date	Date	Seniority start date for the company
DEFAULT_LINE_MANAGER_FULL_NAME	50-character string	Default line manager Surname and First name
DEFAULT_LINE_MANAGER_LOGIN	80-character string	Default line manager Login
reason_for_leaving_code	40-character string	Reason for leaving code
reason_for_leaving_description	80-character string	Reason for leaving description
reason_for_leaving_comment	255-character string	Reason for leaving comment
taken_acc_period_reset_result	Boolean variable	Reset result of taken into account periods
current_level_8_description	50-character string	Current level 8 description
current_level_7_description	50-character string	Current level 7 description
current_level_6_description	50-character string	Current level 6 description
current_level_5_description	50-character string	Current level 5 description
current_level_4_description	50-character string	Current level 4 description
current_firm_description	50-character string	Current member company description
current_depart_description	50-character string	Current member department description
current_sub_depart_desc	50-character string	Current member sub-department description
CURRENT_SECTION_ABBREVIATION	40-character string	Current member section abbreviation
current_section_description	50-character string	Current member section description
current_section_key	Integer	Current member section key
current_section_appli_date	Date	Current member section application date
cur_time_contract_code	5-character string	Current schedule contract code
cur_time_contract_desc	80-character string	Current schedule contract description
cur_time_contract_appli_date	Date	Current schedule contract application date
cur_time_contract_type_code	Integer	Current schedule contract type code 0weekly contract 1monthly contract
cur_time_contract_type_desc	255-character string	Current schedule contract type description
cur_time_contract_value	Real number	Current time contract value
cur_contract_charact_code	5-character string	Current contract properties code
cur_contract_charact_desc	40-character string	Current contract properties description
cur_contract_rate_code	5-character string	Current contract rate code
cur_contract_rate_description	80-character string	Current contract rate description
is_trial_period	Boolean variable	Probation
trial_period_end_date	Date	Trail period end date
contract_comment	255-character string	Contract comment
cur_job_abbreviation	5-character string	Current job abbreviation
cur_job_description	80-character string	Current job description
cur_job_application_date	Date	Current job application date
cur_coef_code	5-character string	Current coefficient code
cur_coef_description	80-character string	Current coefficient description
cur_qualification_code	5-character string	Current qualification code
cur_qualification_desc	80-character string	Current qualification description
cur_professional_status_code	5-character string	Current professional status code
cur_professional_status_desc	80-character string	Current professional status description
cur_job_position_code	5-character string	Current job class code
cur_job_position_desc	80-character string	Current job class description
cur_coef_application_date	Date	Current coefficient application date
JOB_LEVEL_CODE	40-character string	Current level code (pro. classification)
JOB_LEVEL_DESC	80-character string	Current category level title (pro. classification)
JOB_STANDING_CODE	40-character string	Current position code (pro. classification)
JOB_STANDING_DESC	80-character string	Current position title (pro. classification)
JOB_INDEX_CODE	40-character string	Current index code (pro. classification)
JOB_INDEX_DESC	80-character string	Current index title (pro. classification)
STAFF_REPRESENT_CODE	40-character string	Employee representative type code
STAFF_REPRESENT_DESC	80-character string	Employee representative type title
STAFF_REPRESENT_START_DATE	Date	Start date of the employee representative type assignment
STAFF_REPRESENT_END_DATE	Date	End date of the employee representative type assignment
TAK_ACC_PER_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
CUR_STATE_FINAL_PAY	80-character string	Final balance status description of the current employment contract

Employee application data

Table name: EMPLOYEE_TIME_MANAGMENT_DATA

Description: Information on the employee's time and attendance data

Data description	Type	Data exported
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_PERIOD_START_DATE	Date	Acknowledgement start date
EMPLOYEE_PERIOD_END_DATE	Date	Acknowledgement end date
taken_acc_period_start_date	Date	Time contract start date
taken_acc_period_end_date	Date	Time contract end date
access_auth_start_date	Date	Current access authorisation start date
access_auth_start_time	Hour	Current access authorisation start time
access_auth_end_date	Date	Current access authorisation end date
access_auth_end_time	Hour	Current access authorisation end time
IS_HR_EMPLOYEE	Boolean variable	HR employee
is_t_and_a_employee	Boolean variable	T&A employee
is_access_employee	Boolean variable	Access employee
cur_schedule_abbreviation	5-character string	Current schedule abbreviation
cur_schedule_description	40-character string	Current schedule description
cur_shift_scheduler_desc	40-character string	Current shift schedule description
cur_schedule_appli_date	Date	Current schedule application date
cur_end_period_calendar_desc	40-character string	Current pay calendar description
END_PERIOD_CALENDAR_START_DATE	Date	Payroll calendar start date
cur_overtime_rule_description	40-character string	Current overtime rule description
cur_overtime_rule_app_date	Date	Current overtime rule application date
CUR_OVERTIME_RULE_END_DATE	Date	Current overtime rule application end date
HOURLY_CONTRACT_DESCRIPTION	40-character string	Time contract description
HOURLY_CONTRACT_ABBREVIATION	5-character string	Time contract abbreviation
CUR_TIME_CONTRACT_TYPE_CODE	Integer	Current schedule contract code
CUR_TIME_CONTRACT_VALUE	Real number	Current time contract value
AUTHORISED_FUNCTION_START_DATE	Date	Authorised functions start date
AUTHORISED_FUNCTION_END_DATE	Date	Authorised functions end date
automatic_clocking_out	Boolean variable	Automatic clocking out allowance
automatic_absence_allowance	Boolean variable	Automatic absence allowance
compensatory_leave_allowance	Boolean variable	Compensatory leave allowance
flexi_leave_absence_allowance	Boolean variable	Flexileave allowance
cur_public_holiday_cal_desc	40-character string	Public holiday calendar description
cur_public_holiday_app_date	Date	Current public holiday calendar application date
attached_document	254-character string	Attachment
cur_class_of_check_desc	40-character string	Current check class description
cur_class_of_check_appli_date	Date	Current check class application date
TOIL_CALENDAR_ABBREVIATION	5-character string	Abbreviation of compensatory leave
TOIL_CALENDAR_DESCRIPTION	40-character string	Description of compensatory leave
TOIL_CALENDAR_START_DATE	Date	Compensatory leave start date
TOIL_CALENDAR_END_DATE	Date	Compensatory leave end date
PRESENCE_MANAGMENT_START_DATE	Date	Start date of the attendance management
PRESENCE_MANAGMENT_CODE	Boolean variable	Attendance management 0Clockings 1Automatic clockings 2Attendance indication 3Attendance indication and attendance time entry 4Attendance time entry 5Clockings from period activity files

Employee activity data

Table name: EMPLOYEE_JOB_DATA

Description: Information on the employee's activity data

Data description	Type	Data exported
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_PERIOD_START_DATE	Date	Acknowledgement start date
EMPLOYEE_PERIOD_END_DATE	Date	Acknowledgement end date
taken_acc_period_start_date	Date	Time contract start date
taken_acc_period_end_date	Date	Time contract end date
access_auth_start_date	Date	Current access authorisation start date
access_auth_start_time	Hour	Current access authorisation start time
access_auth_end_date	Date	Current access authorisation end date
access_auth_end_time	Hour	Current access authorisation end time
IS_HR_EMPLOYEE	Boolean variable	HR employee
is_t_and_a_employee	Boolean variable	T&A employee
is_access_employee	Boolean variable	Access employee
default_job_abbreviation	5-character string	Default activity abbreviation
default_job_code	40-character string	Default activity code
default_job_description	40-character string	Default activity description
default_job_application_date	Date	Default activity assignment date
default_cost_centre_abbrev	5-character string	Default cost centre abbreviation
default_cost_centre_code	40-character string	Default cost centre code
default_cost_centre_desc	40-character string	Default cost centre description
default_cost_centre_app_date	Date	Default cost centre application date
DEFAULT_CUSTOMER_ABBREV	5-character string	Default customer abbreviation
DEFAULT_CUSTOMER_CODE	40-character string	Default customer code
DEFAULT_CUSTOMER_DESC	40-character string	Default customer description
DEFAULT_CUSTOMER_APP_DATE	Date	Default customer application date
auto_job_generation_code	Boolean variable	Automatic generation mode code for the activity 1In duration proportional to the total completed 2Identical to the planned activity 3Identical to the planned activity, with period activity planned in duration 4As a percentage
auto_job_generation_desc	255-character string	Automatic generation mode description for the activity
auto_job_generation_app_date	Date	Automatic generation mode application date for the activity

Employee administrative data

Table name: EMPLOYEE_ADMINISTRATIVE_DATA

Description: Information on the employee's administrative data

Data description	Type	Data exported
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_PERIOD_START_DATE	Date	Acknowledgement start date
EMPLOYEE_PERIOD_END_DATE	Date	Acknowledgement end date
taken_acc_period_start_date	Date	Time contract start date
taken_acc_period_end_date	Date	Time contract end date
access_auth_start_date	Date	Current access authorisation start date
access_auth_start_time	Hour	Current access authorisation start time
access_auth_end_date	Date	Current access authorisation end date
access_auth_end_time	Hour	Current access authorisation end time
IS_HR_EMPLOYEE	Boolean variable	HR employee
is_t_and_a_employee	Boolean variable	T&A employee
is_access_employee	Boolean variable	Access employee
nationality_code	5-character string	Nationality code
nationality_description	80-character string	Nationality description
residence_permit_number	255-character string	Residence permit number
residence_permit_issued_by	255-character string	Residence permit delivered by
residence_permit_issue_date	Date	Residence permit issue date
residence_permit_expiry_date	Date	Residence permit expiry date
identity_card_number	255-character string	ID number
identity_card_expiry_date	Date	ID expiry date
passport_number	255-character string	Passport number
passport_expiry_date	Date	Passport expiry date
private_bank_account_country	2-character string	State code for the personal bank account
private_bank_account_iban	2-character string	IBAN key for the personal bank account
private_bank_account_bank	30-character string	Personal bank account number
pro_bank_account_country	2-character string	State code for the business bank account
pro_bank_account_iban	2-character string	IBAN key for the business bank account
pro_bank_account_bank	30-character string	Business bank account number
bank_identity_comment	255-character string	Bank comment
work_to_home_distance	Integer	Distance Home-Workplace journey
work_to_home_transit_time	Real number	Duration Home-Workplace journey
driving_licence_number	255-character string	Driving licence No.
driving_licence_point_count	Integer	Number of points on the driving licence
company_vehicle	Boolean variable	Company vehicle
next_technical_control_date	Date	Next MOT date
vehicle_assignment_date	Date	Vehicle assignment date
vehicle_end_of_rent_date	Date	End of rental date
vehicle_type_code	5-character string	Vehicle model code
vehicle_type_description	80-character string	Vehicle type description
vehicle_registration_number	255-character string	Vehicle registration number
vehicle_comment	255-character string	Vehicle comment
is_handicapped	Boolean variable	Disability
handicap_code	5-character string	Disability code
handicap_description	80-character string	Disability description
handicap_end_date	Date	Handicap end date
handicap_comment	500-character string	Handicap comment
next_med_examination_date	Date	Next medical appointment date
next_med_examination_time	Hour	Next medical appointment time
next_med_examination_state	80-character string	Next medical appointment state
next_med_examination_comment	255-character string	Next medical appointment comment
MEDICAL_APPOINTMENT_REASON	80-character string	Medical appointment type
PRIVATE_BANK_ACCOUNT_TYPE1	Boolean variable	Private bank identity type 1 Possible values: 0IBAN 1Other standard
PRIVATE_BANK_ACCOUNT_BIC_SW1	11-character string	BIC/SWIFT code of private bank account 1
PRIVATE_BANK_ACCOUNT_KEY1	2-character string	Control key of private bank account 1
PRIVATE_BANK_ACCOUNT_HOLDER1	40-character string	Account holder of private bank account 1
PRIVATE_BANK_ACCOUNT_BBAN1	30-character string	BBAN code of private bank account 1
PRIVATE_BANK_ACCOUNT_COUNTRY2	2-character string	Country code of private bank identity 1
PRIVATE_BANK_ACCOUNT_IBAN2	40-character string	Account number of private bank identity 1
PRIVATE_BANK_ACCOUNT_TYPE2	Boolean variable	Private bank identity type 2 Possible values: 0IBAN 1Other standard
PRIVATE_BANK_ACCOUNT_BIC_SW2	11-character string	BIC/SWIFT code of private bank account 2
PRIVATE_BANK_ACCOUNT_KEY2	2-character string	Control key of private bank account 2
PRIVATE_BANK_ACCOUNT_HOLDER2	40-character string	Account holder of private bank account 2
PRIVATE_BANK_ACCOUNT_BBAN2	30-character string	BBAN code of private bank account 2
PRO_BANK_ACCOUNT_TYPE1	Boolean variable	Professional bank identity type 1 Possible values: 0IBAN 1Other standard
PRO_BANK_ACCOUNT_BIC_SW1	11-character string	BIC/SWIFT code of private bank account 1
PRO_BANK_ACCOUNT_KEY1	2-character string	Control key of professional bank account 1
PRO_BANK_ACCOUNT_HOLDER1	40-character string	Account holder of professional bank account 1
PRO_BANK_ACCOUNT_BBAN1	30-character string	BBAN code of professional bank account 1
PRO_BANK_ACCOUNT_COUNTRY2	2-character string	Country code of professional bank identity 1
PRO_BANK_ACCOUNT_IBAN2	40-character string	Account number of professional bank identity 2
PRO_BANK_ACCOUNT_TYPE2	Boolean variable	Professional bank identity type 2 Possible values: 0IBAN 1Other standard
PRO_BANK_ACCOUNT_BIC_SW2	11-character string	BIC/SWIFT code of private bank account 2
PRO_BANK_ACCOUNT_KEY2	2-character string	Control key of professional bank account 2
PRO_BANK_ACCOUNT_HOLDER2	40-character string	Account holder of professional bank account 2
PRO_BANK_ACCOUNT_BBAN2	30-character string	BBAN code of professional bank account 2
BOETH_CODE	5-character string	BOETH status code 01 Worker recognised as disabled by the Commission on the rights and autonomy of persons with disabilities 02 Victim of an accident at work or an occupational disease resulting in a permanent disability of at least 10% and receiving a pension 03 Recipient of a disability pension on condition that the disability reduces his/her capacity for work by at least two thirds 04 Beneficiary mentioned in Article L.241-2 of the Code of military disability and war victims' pensions 05 Beneficiary mentioned in articles L.241-3 and L.241-4 of the Code of military disability and war victims' pensions 06 Recipient of an of a disability allowance or pension under the conditions defined by Law no. 91-1389 of 31 December 1991 07 Holder of the "mobility inclusion" card bearing the word "'disability" (L.241-3 of the Code of social action and families) 08 Recipient of disabled adult allowance 09 Beneficiary mentioned in articles L.241-5 and L.241-6 of the Code of military disability and war victims' pensions 10 Reclassified public official (paragraph 3 of Article L.323-5 of the Labour Code) 11 Public official receiving a temporary disability assignment (paragraph 4 of Article L.323-5 of the Labour Code) 12 Entitled to disability compensation benefit, compensation allowance for a third person or education allowance for a disabled child receiving an internship (L.5212-7 of the Labour Code) 99 No BOETH status
BOETH_DESCRIPTION	500-character string	BOETH status description
BOETH_START_DATE	Date	BOETH status start date
BOETH_END_DATE	Date	BOETH status end date

Employee user data

Table name: EMPLOYEE_USER_DATA

Description: Information on the employee's user data

Data description	Type	Data exported
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_PERIOD_START_DATE	Date	Acknowledgement start date
EMPLOYEE_PERIOD_END_DATE	Date	Acknowledgement end date
taken_acc_period_start_date	Date	Time contract start date
taken_acc_period_end_date	Date	Time contract end date
access_auth_start_date	Date	Current access authorisation start date
access_auth_start_time	Hour	Current access authorisation start time
access_auth_end_date	Date	Current access authorisation end date
access_auth_end_time	Hour	Current access authorisation end time
IS_HR_EMPLOYEE	Boolean variable	HR employee
is_t_and_a_employee	Boolean variable	T&A employee
is_access_employee	Boolean variable	Access employee
profile_description	40-character string	Profile description
personal_ws_profile_desc	40-character string	Personal workspace profile description
badge_code2	16-character string	Badge code 2
reader_group_description	40-character string	Reader group description
login	80-character string	Login
user_password	32-character string	Password
recipient_email	255-character string	Recipient email address
senders_email	255-character string	Sender email address
email_server	255-character string	Email server
email_server_user	255-character string	Email server user account
language	Integer	Software language for the employee 1 English (United States) 2 English (Canada) 3 French Canada) 7 Russian (terminal) 27 English (South Africa) 30 Greek 31 Dutch (Netherlands) 32 Dutch (Belgium) 33 French 34 Spanish 39 Italian 40 Romanian (terminal) 41 French (Switzerland) 44 English (United Kingdom) 45 Danish 47 Norwegian 48 Polish (terminal and employee self-service) 49 German 90 Turkish (terminal) 96 Basque (terminal) 97 Catalan (terminal) 99 Test language 101 Welsh 263 English (Cyprus) 351 Portuguese 353 English (Ireland) 371 Latvian (terminal) 420 Czech (terminal) 966 Arabic (Experimental) 971 English (United Arab Emirates)
duration_visualization	Integer	Duration visualisation format
absence_validator	500-character string	Absence validator
ABSENCE_VALIDATOR_FULL_NAME	500-character string
clocking_validator	500-character string	Clocking validator
working_site	40-character string	Work site
PORTAL_PROFILE_DESC	40-character string	Portal user profile description
PROFILE_VALIDATOR_DESC	255-character string	Clocking validator Surname and First name (separated by a \| if multiple)
CLOCKING_VALIDATOR_FULL_NAME	500-character string	Attendance validator's surname
REMOTE_WORKING_VALIDATOR_LOGIN	500-character string	Remote working validator's login
REMOTE_WORKG_VALID_FULL_NAME	500-character string	Remote working validator's surname

Employee individual access file data

Table name: EMPLOYEE_ACCESS_DATA

Description: Information on the employee's access data

Data description	Type	Data exported
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
taken_acc_period_start_date	Date	Time contract start date
taken_acc_period_end_date	Date	Time contract end date
EMPLOYEE_PERIOD_START_DATE	Date	Acknowledgement start date
EMPLOYEE_PERIOD_END_DATE	Date	Acknowledgement end date
access_auth_start_date	Date	Current access authorisation start date
access_auth_start_time	Hour	Current access authorisation start time
access_auth_end_date	Date	Current access authorisation end date
access_auth_end_time	Hour	Current access authorisation end time
IS_HR_EMPLOYEE	Boolean variable	HR employee
is_t_and_a_employee	Boolean variable	T&A employee
is_access_employee	Boolean variable	Access employee
personal_code	6-character string	Personal code
cur_access_profile_desc	40-character string	Current access profile description
cur_access_profile_assig_date	Date	Current access profile application date
concerned_by_anti_passbacks	Boolean variable	Concerned by anti pass-backs 0no 1yes
super_pass	Boolean variable	Right to activate super pass: 0no 1yes
specific_schedules	Boolean variable	Right to activate specific schedules 0no 1yes
central_alarm_sys_activ	Boolean variable	Right to activate alarm units manually: 0no 1yes
extended_time_out	Boolean variable	Extended timeout for this employee: 0no 1yes
super_pass_everywhere	Boolean variable	Right to activate super pass everywhere 0no 1yes
specific_schedules_everywhere	Boolean variable	Right to activate specific schedules everywhere: 0no 1yes
receive_visitor	Boolean variable	Receive visitors 0no 1yes

Employee career data

Table name: EMPLOYEE_TRAIN_AND_CAR_DATA

Description: Information on the employee's training and career data

Data description	Type	Data exported
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_PERIOD_START_DATE	Date	Acknowledgement start date
EMPLOYEE_PERIOD_END_DATE	Date	Acknowledgement end date
taken_acc_period_start_date	Date	Time contract start date
taken_acc_period_end_date	Date	Time contract end date
access_auth_start_date	Date	Current access authorisation start date
IS_HR_EMPLOYEE	Boolean variable	HR employee
access_auth_start_time	Hour	Current access authorisation start time
access_auth_end_date	Date	Current access authorisation end date
access_auth_end_time	Hour	Current access authorisation end time
is_t_and_a_employee	Boolean variable	T&A employee
is_access_employee	Boolean variable	Access employee
education_level_code	5-character string	Level of studies code
education_level_description	80-character string	Level of studies description
next_pro_interview_date	Date	Next appraisal date