The system sends the estimated T&A totals of the end of period.
Estimated permanent absence totals
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
|
|
