<< Cliquez ici pour afficher la table des matières >> Kelio Data > Table detail:

Types parameters synchronisation

Contents

Table name: ABSENCE_TYPE

Description: Absence types for the application with their parameters

Data description	Type	Data exported
type_key	Integer	Absence type key
type_description	40-character string	Absence type description
type_abbreviation	5-character string	Absence type abbreviation
absence_balance_abbreviation	5-character string	Abbreviation of the absence balance debited by the absences of this absence type
absence_balance_description	40-character string	Description of the absence balance debited by the absences of this absence type
absence_balance_key	Integer	Absence balance key debited by the absences of this absence type
actual	Boolean variable	Effective absence type 0no 1yes
reset_date	Date	Reset day and month for the absence totals linked to this type
estimated	Boolean variable	Calculation of the absences of this type in the future 0no 1yes
calculat_exo_over_time_hr	Boolean variable	Exonerated overtime hours total modified by the absence total generated by the absences of this type 0no 1yes
calculat_over_time_hrs	Boolean variable	Absence total is taken in account in the calculation of overtime hours 0no 1yes
calculat_special_hrs_bonuses	Boolean variable	Calculation of the special hours and bonus windows with absence windows (the calculation with windows option must be activated) 0no 1yes
calculat_within_the_windows	Boolean variable	Acknowledgement of the absence files in the daily schedule window calculation 0no 1yes
colour	Integer	Colour associated with the absence type, defined by an integer
converted_an_absence_file	Boolean variable	Conversion of clocked absences into absence files (if the Clocked on terminal option is enabled for the type) 0no 1yes
enter_absences_on_terminal	Boolean variable	Absence file entry possible from the terminal for this type 0no 1yes
included_hrs_actual_total	Boolean variable	Absence duration taken into account in the actual annualised hours 0no 1yes
calculat_time_offinlieu	Boolean variable	Absence calculation with TOIL windows (if Calculation with windows is enabled) 0no 1yes
includ_rouding_time_windows	Boolean variable	Rounding on absences of this type by the daily schedule rounding windows (if the option Clocked on terminal is enabled) 0no 1yes
business_trip_limited_day	Boolean variable	Absence clocked on terminal limited to the day if leave is clocked without return to work during the day (if the option Clocked on terminal is activated) 0no 1yes
modifies_the_balance	Boolean variable	Balance modified by the absence total generated by the absences of this type 0no 1yes
out_of_controlled_total	Boolean variable	Not including annualised hour objective 0no 1yes
paid	Boolean variable	Absence of this type paid 0no 1yes
swiped_on_terminal	Boolean variable	Clocked on the terminal 0no 1yes
visualized_in_printouts	Boolean variable	Absences of this type can be viewed in printouts 0no 1yes
calculat_mode_annual_hrs_per	Boolean variable	Method for calculating the absence total during an annualised hour period 0contracted time 1distribution of annualised hours 2peak periods 3low periods
duration_type	Boolean variable	Absence duration type 0contracted time 1maximum 2imposed
grid	Boolean variable	Background grid used to represent the absence
total_mode	Boolean variable	Method for calculating the total generated by the absence type according to the nature of the day when the absence is applied 0working days 1week days 2calendar
duration_of_absence	Real number	Duration of the absence If duration_type is Maximum and the duration represents the maximum absence time. If duration_type is Imposed and the duration represents the imposed absence time.
NOTICE_CESS_WORK_TYPE_ASS	Boolean variable	Type associated with sick leave

Balances

Table name: ABSENCE_BALANCE_TYPE

Description: For each absence balance: key, description, abbreviation and other related information

Data description	Type	Data exported
type_key	Integer	Balance type key
type_description	40-character string	Balance type description
type_abbreviation	5-character string	Balance type abbreviation
unit	Boolean variable	Balance unit: 0hours 1days 2Number
anomaly_negative_absence	Boolean variable	Generation of an anomaly if the balance is negative: 0no 1yes
reset_date	Date	Balance reset date
estimated	Boolean variable	Calculation of the estimated balance value: 0no 1yes
visualized_the_printouts	Boolean variable	0cannot be viewed in printouts 1can be viewed in printouts
visualizable_in_result	Boolean variable	0cannot be viewed in results 1can be viewed in results
visual_add_deduct_bal_init	Boolean variable	Visible in balance initialisation, in add/deduct screens
entry_help_comment	255-character string	Entry help comment related to the balance
macro_command_balance	Boolean variable	0no calculation of this balance in the calculation rules 1calculation of this balance in the calculation rules
training_account	Boolean variable	Indicates whether the balance appears in the training account tab of the employee file
ROUNDING_ABSENCE_BALANCE	Boolean variable	Round off the balance

Bonus types

Table name: BONUS_TYPE

Description: For each bonus type: key, description, abbreviation and related information

Data description	Type	Data exported
type_key	Integer	Bonus type key
type_description	40-character string	Bonus type description
type_abbreviation	5-character string	Bonus type abbreviation
reset_date	Date	Associated account reset date
visualized_in_the_printouts	Boolean variable	0cannot be viewed in printouts 1can be viewed in printouts

Special hours types

Table name: SPECIAL_HOUR_TYPE

Description: For each special hours type: key, description, abbreviation and other related information

Data description	Type	Data exported
type_key	Integer	Special hours type key
type_description	40-character string	Special hours type description
type_abbreviation	5-character string	Special hours type abbreviation
reset_date	Date	Associated account reset date
to_deduct_from_blance	Boolean variable	0special hours not deducted from the balance 1special hours deducted from the balance
visualized_in_the_printouts	Boolean variable	0cannot be viewed in printouts 1can be viewed in printouts
to_deduct_from_normal_hours	Boolean variable	0special hours not deducted from normal hours 1special hours deducted from normal hours

Overtime hours types

Table name: OVER_TIME_HOUR_TYPE

Description: For each overtime hours type: key, description, abbreviation and other related information

Data description	Type	Data exported
type_key	Integer	Overtime type key
type_description	40-character string	Overtime type description
type_abbreviation	5-character string	Overtime type abbreviation
reset_date	Date	Associated type reset date
visualized_in_printouts	Boolean variable	0cannot be viewed in printouts 1can be viewed in printouts
calculat_frequency	Boolean variable	Number of hour calculation frequency 1day 2Week, period, cycle 3both
deduct_from_balance	Boolean variable	0overtime not deducted from the balance 1overtime deducted from the balance
select_terminal_suspend	Boolean variable	0no balance interruption from the terminal 1balance interruption possible from the terminal
calcul_over_time_italian	Boolean variable	0no Italian overtime calculation 1Italian overtime calculation
calculat_exo_over_time_hr	Boolean variable	0no exonerated overtime calculation 1exonerated overtime calculation

On-call duty types

Table name: ON_CALL_DUTY_TYPE

Description: For each on-call duty type: key, description and abbreviation

Data description	Type	Data exported
type_key	Integer	On-call type key
type_description	40-character string	On-call duty type description
type_abbreviation	5-character string	On-call type abbreviation

List of account types

Table name: ACCOUNT_TYPE

Description: For each account type: key, description, abbreviation and unit

Data description	Type	Data exported
type_key	Integer	Account type key
type_description	40-character string	Account type description
type_abbreviation	5-character string	Account type abbreviation
unit	Integer	Account type unit: 0Duration Hour 1Duration Day 2Number

Table name: BALANCE_TYPE

Description: For each account type: key, description, abbreviation

Data description	Type	Data exported
type_key	Integer	Account type key
type_description	40-character string	Account type description
type_abbreviation	5-character string	Account type abbreviation

Table name: BREAK_TYPE

Description: For each break type: key, description, abbreviation

Data description	Type	Data exported
type_key	Integer	Break type key
type_description	40-character string	Break type description
type_abbreviation	5-character string	Break type abbreviation

Table name: LATENESS_EARLY_DEPARTURE_TYPE

Description: For each account type: key, description, abbreviation

Data description	Type	Data exported
type_key	Integer	Account type key
type_description	40-character string	Account type description
type_abbreviation	5-character string	Account type abbreviation

Table name: WORK_SCHEDULE_TYPE

Description: For each work schedule type: key, description, abbreviation

Data description	Type	Data exported
type_key	Integer	Work schedule type key
type_description	40-character string	Work schedule type description
type_abbreviation	5-character string	Work schedule type abbreviation

List of predefined account types

English abbreviation	English description	Unit
Act	Actual	0
ACTPH	Actual (public holiday)	0
COACT	Carried over actual time	0
NORHR	Normal hours	0
BRKAL	Break allowance	0
TNBRK	Taken break	0
PDBRK	Paid break	0
TBKAH	Taken break (annualised hours)	0
COBRK	Carried-over break	0
Paid	Paid	0
PADPH	Paid holiday	0
RE2CD	Rest between two consecutive days	0
RSOPD	Rest for a given period	0
ALRWK	TOIL hours already worked	0
Contr	Contracted	0
NUMPH	Number of public holidays	2
EXR2D	Rest exceeded for two consecutive days	0
EXREP	Rest exceeded in a period	0
RSNUM	Rest schedule (number)	2
WOSCN	Work schedule (number)	2
WKSHR	Work schedule (hours)	0
Dustb	Dustbin	0
DIFHB	Hourly basis difference	0
ANHRD	Distribution of annualised hours	0
BcAct	Activity calculation reference	0
BcAc1	1st half-day activity reference	0
BcAc2	2nd half-day activity reference	0

Activity types

Table name: JOB_TYPE

Description: For each activity type: key, description, abbreviation and other related information

Data description	Type	Data exported
type_key	Integer	Activity type key
type_description	40-character string	Activity type description
type_abbreviation	5-character string	Activity type abbreviation
code	40-character string	Activity type code number
colour	Integer	Activity type colour
grid	Boolean variable	Background grid used to represent the activity
icon_key	Integer	Icon used to represent the activity
USABILITY_START_DATE	Date	Start date of use
USABILITY_END_DATE	Date	End date of use
TYPE_EXTERNAL_REFERENCE	40-character string	External reference

Cost centre types

Table name: COST_CENTRE_TYPE

Description: For each cost centre type: key, description, abbreviation and other related information

Data description	Type	Data exported
type_key	Integer	Cost centre type key
type_description	40-character string	Cost centre description
type_abbreviation	5-character string	Cost centre abbreviation
code	40-character string	Cost centre type code
colour	Integer	Cost centre type colour
grid	Boolean variable	Background grid used to represent the cost centre
icon_key	Integer	Icon used to represent the cost centre
USABILITY_START_DATE	Date	Start date of use
USABILITY_END_DATE	Date	End date of use
TYPE_EXTERNAL_REFERENCE	40-character string	External reference

Client types

Table name: CUSTOMER_TYPE

Description: For each client type: key, description, abbreviation and other associated information

Data description	Type	Data exported
type_key	Integer	Customer type key
type_description	40-character string	Customer type description
type_abbreviation	5-character string	Customer type abbreviation
Code	40-character string	Customer type code
USABILITY_START_DATE	Date	Start date of use
USABILITY_END_DATE	Date	End date of use
TYPE_EXTERNAL_REFERENCE	40-character string	External reference

Hourly rates

Table name: HOURLY_RATE_VALUE

Description: List of hourly rate values

Data description	Type	Data exported
HOURLY_RATE_KEY	Integer	Hourly rate key
start_date	Date	Start date
end_date	Date	End date
VALUE_	Real number	Hourly rate value
hourly_rate_abbreviation	5-character string	Hourly rate abbreviation
hourly_rate_description	40-character string	Hourly rate description

Remote working types

Table name: REMOTE_WORKING_TYPE

Description: For each remote working type: key, description, abbreviation and other associated information

Data description	Type	Data exported
type_key	Integer	Remote working type key
type_description	40-character string	Remote working type description
type_abbreviation	5-character string	Remote working type abbreviation
COULOUR	Integer	Type colour
GRID	Boolean variable	Background grid used to represent the remote working type
SYNCHRO_CALENDAR	Boolean variable	Synchronise remote working in the mail calendar