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

Estimated permanent totals

Contents

The system sends the estimated T&A totals of the end of period.

Tick a box to access the corresponding table

Table name: ESTIMATED_PERPETUAL_ABSENCE

Description: For each absence type, estimated permanent absence total declared each day

Data description	Type	Data exported
employee_key	Integer	Employee key
total_date	Date	Permanent total calculation date
absence_type_key	Integer	Absence type 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
abs_type_abbreviation	5-character string	Absence type abbreviation
abs_type_description	40-character string	Absence type description
days	Real number	Permanent absence total in days on the calculation day
hours	Real number	Permanent absence total in hours on the calculation day
PHYSICAL_HOURS	Real number	Hours 0- 24
units	Real number	Permanent absence total in number of hours on the calculation day
section_key	Integer	Employee section key on the calculation day
SECTION_ABBREVIATION	13-character string	Employee section abbreviation on the total calculation day
section_description	50-character string	Employee section description on the calculation day

Estimated permanent accounts totals

Table name: ESTIMATED_PERPETUAL_TOTAL

Description: For each account type, estimated permanent total declared each day

Data description	Type	Data exported
employee_key	Integer	Employee key
total_date	Date	Permanent total calculation date
type_key	Integer	T&A total type 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
type_abbreviation	5-character string	T&A total type abbreviation
type_description	40-character string	T&A total type description
days	Real number	Exported total in days
hours	Real number	Exported total in hours
PHYSICAL_HOURS	Real number	Hours 0- 24
units	Real number	Exported total in numbers
section_key	Integer	Employee section key on the calculation day
SECTION_ABBREVIATION	13-character string	Employee section abbreviation on the total calculation day
section_description	50-character string	Employee section description on the calculation day

Estimated permanent overtime totals

Table name: ESTIMATED_PERPETUAL_OVER_HOUR

Description: For each overtime type, estimated permanent total declared each day

Data description	Type	Data exported
employee_key	Integer	Employee key
total_date	Date	Permanent total calculation date
over_time_hour_type_key	Integer	Overtime type 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
over_time_hour_type_abb	5-character string	Overtime type abbreviation
over_time_hour_type_des	40-character string	Overtime type description
hours	Real number	Over hours total on the calculation day
section_key	Integer	Employee section key on the calculation day
SECTION_ABBREVIATION	13-character string	Employee section abbreviation on the total calculation day
section_description	50-character string	Employee section description on the calculation day

Estimated permanent special hours totals

Table name: ESTIMATED_PERPETUAL_SPEC_HOUR

Description: For each special hours type, estimated permanent total declared each day

Data description	Type	Data exported
employee_key	Integer	Employee key
total_date	Date	Permanent total calculation date
special_hour_type_key	Integer	Special hours type 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
special_hour_type_abbreviation	5-character string	Special hours type abbreviation
special_hour_type_description	40-character string	Special hours type description
hours	Real number	Special hours total on the calculation day
section_key	Integer	Employee section key on the calculation day
SECTION_ABBREVIATION	13-character string	Employee section abbreviation on the total calculation day
section_description	50-character string	Employee section description on the calculation day

Estimated permanent bonus totals

Table name: ESTIMATED_PERPETUAL_BONUS

Description: For each bonus type, estimated permanent total declared each day

Data description	Type	Data exported
employee_key	Integer	Employee key
total_date	Date	Permanent total calculation date
bonus_type_key	Integer	Bonus type 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
bonus_type_abbreviation	5-character string	Bonus type abbreviation
bonus_type_description	40-character string	Bonus type description
units	Real number	Permanent bonus value on the calculation day
section_key	Integer	Employee section key on the calculation day
SECTION_ABBREVIATION	13-character string	Employee section abbreviation on the total calculation day
section_description	50-character string	Employee section description on the calculation day

Estimated permanent late arrival/early departure totals

Table name: ESTIMATED_PERPETUAL_LATE_DEP

Description: For each late arrival or early departure type, estimated permanent total declared each day

Data description	Type	Data exported
employee_key	Integer	Employee key
total_date	Date	Permanent total calculation date
type_key	Integer	Late arrival/early departure type 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
type_abbreviation	5-character string	Late arrival/early departure type abbreviation
type_description	40-character string	Late arrival/early departure type description
hours	Real number	Totals late arrival/early departure hours
units	Real number	Permanent number of late arrivals/early departures
section_key	Integer	Employee section key on the calculation day
SECTION_ABBREVIATION	13-character string	Employee section abbreviation on the total calculation day
section_description	50-character string	Employee section description on the calculation day

Estimated perpetual balance totals

Table name: ESTIMATED_PERPETUAL_BALANCE

Description: For each balance type, estimated permanent total declared each day

Data description	Type	Data exported
employee_key	Integer	Employee key
total_date	Date	Permanent total calculation date
type_key	Integer	Balance type 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
type_abbreviation	5-character string	Balance type abbreviation
type_description	40-character string	Balance type description
start_hour	Real number	Permanent balance at the beginning of the day
hours	Real number	Daily balance
end_hour	Real number	Permanent balance at the end of the day (before limitation)
limitation	Real number	Limitation of the day
limitation_on_total	Real number	Total limitation over the day
to_be_transferred	Real number	Permanent balance to be carried forward at the end of the day (after limitation)
section_key	Integer	Employee section key on the calculation day
SECTION_ABBREVIATION	13-character string	Employee section abbreviation on the total calculation day
section_description	50-character string	Employee section description on the calculation day

Estimated permanent on-call duty totals

Table name: ESTIMATED_PERPET_ON_CALL_DUTY

Description: For each on-call duty type, estimated permanent total declared each day

Data description	Type	Data exported
employee_key	Integer	Employee key
total_date	Date	Permanent total calculation date
on_call_duty_key	Integer	On-call duty type 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
on_call_duty_abbreviation	5-character string	On-call type abbreviation
on_call_duty_description	40-character string	On-call duty type description
days	Real number	Number of on-call duty days
hours	Real number	Number of on-call duty hours
transfer_count	Integer	Number of movements during on-call duties
working_time	Real number	Working time during on-call duties
section_key	Integer	Employee section key on the calculation day
SECTION_ABBREVIATION	13-character string	Employee section abbreviation on the total calculation day
section_description	50-character string	Employee section description on the calculation day

Estimated permanent hourly basis interval totals

Table name: ESTIMATED_PERPET_HOURLY_BASIS

Description: For each hourly basis type, permanent weekly total declared each day

Data description	Type	Data exported
employee_key	Integer	Employee key
total_date	Date	Permanent total calculation 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_BASIS	Real number	Hourly basis
HOURLY_BASIS_DIFFERENCE	Real number	Hourly basis interval
HOURLY_BASIS_DIFF_TOTAL	Real number	Total hourly basis variance
PERFORMED	Real number	Performed
section_key	Integer	Employee section key on the calculation day
SECTION_ABBREVIATION	13-character string	Employee section abbreviation on the total calculation day
section_description	50-character string	Employee section description on the calculation day

Estimated permanent periodic breaks totals

Table name: ESTIMATED_PERPETUAL_BREAK

Description: For each break type, estimated permanent total declared each day

Data description	Type	Data exported
employee_key	Integer	Employee key
TYPE_KEY	Integer	Technical break key
total_date	Date	Permanent total calculation 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
section_key	Integer	Employee section key on the calculation day
SECTION_ABBREVIATION	13-character string	Employee section abbreviation on the total calculation day
section_description	50-character string	Employee section description on the calculation day
TYPE_ABBREVIATION	5-character string	Break abbreviation
TYPE_DESCRIPTION	40-character string	Break description
BREAK_ALLOWANCE	Real number	Break allowance
BRK_ALLOWANCE_CARRIED_FORWARD	Real number	Break allowance carried forward
NUMBER_OF_BREAKS_TAKEN	Real number	Number of breaks
TAKEN_BREAK_TIME	Real number	Break time taken
PAID_BREAK_TIME	Real number	Paid break time
PAID_BREAK_TIME_DEDUCTED	Real number	Deducted paid break time

Estimated permanent daily work schedule totals

Table name: ESTIMATED_PERPET_WORK_SCHEDULE

Description: For each work schedule type, estimated permanent total declared each day

Data description	Type	Data exported
employee_key	Integer	Employee key
total_date	Date	Permanent total calculation date
TYPE_KEY	Integer	Work schedule 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
TYPE_ABBREVIATION	5-character string	Schedule abbreviation
TYPE_DESCRIPTION	40-character string	Schedule description
HOURS	Real number	Total in hours
DAYS	Real number	Total in days
section_key	Integer	Employee section key on the calculation day
SECTION_ABBREVIATION	13-character string	Employee section abbreviation on the total calculation day
section_description	50-character string	Employee section description on the calculation day