The system sends the estimated T&A totals of the end of period. A T&A total for a type and a period is only sent if the T&A total in days, hours or numbers is not null or different from 0.
Estimated periodic absence totals
Table name: ESTIMATED_PERIODIC_ABSENCE
Description: For each absence type, estimated absence total over each payroll period
Data description
|
Type
|
Data exported
|
employee_key
|
Integer
|
Employee key
|
period_start_date
|
Date
|
End of period calendar start date assigned to the employee
|
period_end_date
|
Date
|
End of period calendar end date assigned to the employee
|
absence_type_key
|
Integer
|
Absence type key
|
employee_start_date
|
Date
|
Date when the employee starts to be taken into account in the pay period
|
employee_end_date
|
Date
|
Date when the employee is no longer taken into account in the pay period.
|
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
|
Periodic absence totals expressed in days
|
hours
|
Real number
|
Periodic absence totals expressed in hours
|
PHYSICAL_HOURS
|
Real number
|
Hours 0- 24
|
units
|
Real number
|
Periodic absence totals expressed in numbers
|
section_key
|
Integer
|
Section key on the employee's end of period day
|
SECTION_ABBREVIATION
|
13-character string
|
Section description on the employee's end of period day
|
section_description
|
50-character string
|
Section description on the employee's end of period day
|
payroll_calendar_key
|
Integer
|
Employee’s end of period calendar key
|
payroll_calendar_description
|
40-character string
|
Employee’s end of period calendar description
|
|
Estimated periodic absence balance totals
Table name: ESTIMATED_PERIODIC_ABS_BALANCE
Description: For each absence type, estimated absence balances over each pay period
Data description
|
Type
|
Data exported
|
employee_key
|
Integer
|
Employee key
|
period_start_date
|
Date
|
End of period calendar start date assigned to the employee
|
period_end_date
|
Date
|
End of period calendar end date assigned to the employee
|
abs_balance_type_key
|
Integer
|
Absence balance type key
|
employee_start_date
|
Date
|
Date when the employee starts to be taken into account in the pay period
|
employee_end_date
|
Date
|
Date when the employee is no longer taken into account in the pay period.
|
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_balance_type_abbreviation
|
5-character string
|
Absence balance abbreviation
|
abs_balance_type_description
|
40-character string
|
Absence balance description
|
start_hours
|
Real number
|
Balance in hours at the start of the pay period
|
gained_hours
|
Real number
|
Hours earned during the pay period
|
taken_hours
|
Real number
|
Hours taken during the pay period
|
end_hours
|
Real number
|
Balance in hours at the end of the pay period
|
ADJUSTMENT_HOURS
|
Real number
|
Hours adjusted
|
start_days
|
Real number
|
Balance in days at the start of the pay period
|
gained_days
|
Real number
|
Number of days acquired during the pay period
|
taken_days
|
Real number
|
Number of days taken during the pay period
|
end_days
|
Real number
|
Balance in days at the end of the pay period
|
ADJUSTMENT_DAYS
|
Real number
|
Days adjusted
|
section_key
|
Integer
|
Section key on the employee's end of period day
|
SECTION_ABBREVIATION
|
13-character string
|
Section description on the employee's end of period day
|
section_description
|
50-character string
|
Section description on the employee's end of period day
|
payroll_calendar_key
|
Integer
|
Employee’s end of period calendar key
|
payroll_calendar_description
|
40-character string
|
Employee’s end of period calendar description
|
|
Estimated periodic accounts totals
Table name: ESTIMATED_PERIODIC_TOTAL
Description: For each account type, estimated total over each pay period
Data description
|
Type
|
Data exported
|
employee_key
|
Integer
|
Employee key
|
period_start_date
|
Date
|
End of period calendar start date assigned to the employee
|
period_end_date
|
Date
|
End of period calendar end date assigned to the employee
|
type_key
|
Integer
|
T&A total type key
|
employee_start_date
|
Date
|
Date when the employee starts to be taken into account in the pay period
|
employee_end_date
|
Date
|
Date when the employee is no longer taken into account in the pay period.
|
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
|
Periodic T&A totals in days
|
hours
|
Real number
|
Periodic T&A totals in hours
|
PHYSICAL_HOURS
|
Real number
|
Hours 0- 24
|
units
|
Real number
|
Periodic T&A totals in numbers
|
section_key
|
Integer
|
Section key on the employee's end of period day
|
SECTION_ABBREVIATION
|
13-character string
|
Section description on the employee's end of period day
|
section_description
|
50-character string
|
Section description on the employee's end of period day
|
payroll_calendar_key
|
Integer
|
Employee’s end of period calendar key
|
payroll_calendar_description
|
40-character string
|
Employee’s end of period calendar description
|
|
Estimated periodic overtime totals
Table name: ESTIMATED_PERIODIC_OVER_HOUR
Description: For each overtime account, estimated total hours over each pay period
Data description
|
Type
|
Data exported
|
employee_key
|
Integer
|
Employee key
|
period_start_date
|
Date
|
End of period calendar start date assigned to the employee
|
period_end_date
|
Date
|
End of period calendar end date assigned to the employee
|
over_time_hour_type_key
|
Integer
|
Overtime type key
|
employee_start_date
|
Date
|
Date when the employee starts to be taken into account in the pay period
|
employee_end_date
|
Date
|
Date when the employee is no longer taken into account in the pay period.
|
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
|
Periodic overtime hours duration
|
section_key
|
Integer
|
Section key on the employee's end of period day
|
SECTION_ABBREVIATION
|
13-character string
|
Section description on the employee's end of period day
|
section_description
|
50-character string
|
Section description on the employee's end of period day
|
payroll_calendar_key
|
Integer
|
Employee’s end of period calendar key
|
payroll_calendar_description
|
40-character string
|
Employee’s end of period calendar description
|
|
Estimated periodic special hours totals
Table name: ESTIMATED_PERIODIC_SPEC_HOUR
Description: For each special hours account, estimated total hours over each pay period
Data description
|
Type
|
Data exported
|
employee_key
|
Integer
|
Employee key
|
period_start_date
|
Date
|
End of period calendar start date assigned to the employee
|
period_end_date
|
Date
|
End of period calendar end date assigned to the employee
|
special_hour_type_key
|
Integer
|
Special hours type key
|
employee_start_date
|
Date
|
Date when the employee starts to be taken into account in the pay period
|
employee_end_date
|
Date
|
Date when the employee is no longer taken into account in the pay period.
|
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
|
Periodic special hours duration
|
section_key
|
Integer
|
Section key on the employee's end of period day
|
SECTION_ABBREVIATION
|
13-character string
|
Section description on the employee's end of period day
|
section_description
|
50-character string
|
Section description on the employee's end of period day
|
payroll_calendar_key
|
Integer
|
Employee’s end of period calendar key
|
payroll_calendar_description
|
40-character string
|
Employee’s end of period calendar description
|
|
Estimated periodic bonus totals
Table name: ESTIMATED_PERIODIC_BONUS
Description: For each bonus account, estimated number of bonuses over each pay period
Data description
|
Type
|
Data exported
|
employee_key
|
Integer
|
Employee key
|
period_start_date
|
Date
|
End of period calendar start date assigned to the employee
|
period_end_date
|
Date
|
End of period calendar end date assigned to the employee
|
bonus_type_key
|
Integer
|
Bonus type key
|
employee_start_date
|
Date
|
Date when the employee starts to be taken into account in the pay period
|
employee_end_date
|
Date
|
Date when the employee is no longer taken into account in the pay period.
|
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
|
Periodic bonus value
|
section_key
|
Integer
|
Section key on the employee's end of period day
|
SECTION_ABBREVIATION
|
13-character string
|
Section description on the employee's end of period day
|
section_description
|
50-character string
|
Section description on the employee's end of period day
|
payroll_calendar_key
|
Integer
|
Employee’s end of period calendar key
|
payroll_calendar_description
|
40-character string
|
Employee’s end of period calendar description
|
|
Estimated periodic late arrival/early departure totals
Table name: ESTIMATED_PERIODIC_LATE_DEP
Description: Estimated total of late arrivals and early departures over each pay period
Data description
|
Type
|
Data exported
|
employee_key
|
Integer
|
Employee key
|
period_start_date
|
Date
|
End of period calendar start date assigned to the employee
|
period_end_date
|
Date
|
End of period calendar end date assigned to the employee
|
type_key
|
Integer
|
Late arrival/early departure type key
|
employee_start_date
|
Date
|
Date when the employee starts to be taken into account in the pay period
|
employee_end_date
|
Date
|
Date when the employee is no longer taken into account in the pay period.
|
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 abbreviation
|
hours
|
Real number
|
Total late arrival/early departure hours
|
units
|
Real number
|
Number of late arrivals/early departures
|
section_key
|
Integer
|
Section key on the employee's end of period day
|
SECTION_ABBREVIATION
|
13-character string
|
Section description on the employee's end of period day
|
section_description
|
50-character string
|
Section description on the employee's end of period day
|
payroll_calendar_key
|
Integer
|
Employee’s end of period calendar key
|
payroll_calendar_description
|
40-character string
|
Employee’s end of period calendar description
|
|
Estimated periodic balance totals
Table name: ESTIMATED_PERIODIC_BALANCE
Description: For each balance type, estimated total over each pay period
Data description
|
Type
|
Data exported
|
employee_key
|
Integer
|
Employee key
|
period_start_date
|
Date
|
End of period calendar start date assigned to the employee
|
period_end_date
|
Date
|
End of period calendar end date assigned to the employee
|
type_key
|
Integer
|
Balance type key
|
employee_start_date
|
Date
|
Date when the employee starts to be taken into account in the pay period
|
employee_end_date
|
Date
|
Date when the employee is no longer taken into account in the pay period.
|
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 abbreviation
|
type_description
|
40-character string
|
Balance type description
|
start_hour
|
Real number
|
Balance at the start of the period
|
hours
|
Real number
|
Number of hours acquired during the period
|
end_hour
|
Real number
|
Permanent balance at the end of the period (before limitation)
|
limitation
|
Real number
|
Limited value on the period balances
|
limitation_on_total
|
Real number
|
Total limited value since the start of the end of period calendar, at the end of the period
|
to_be_transferred
|
Real number
|
Permanent balance to be carried forward at the end of the period (after limitation)
|
section_key
|
Integer
|
Section key on the employee's end of period day
|
SECTION_ABBREVIATION
|
13-character string
|
Section description on the employee's end of period day
|
section_description
|
50-character string
|
Section description on the employee's end of period day
|
payroll_calendar_key
|
Integer
|
Employee’s end of period calendar key
|
payroll_calendar_description
|
40-character string
|
Employee’s end of period calendar description
|
|
Estimated periodic activity totals
Table name: ESTIMATED_PERIODIC_JOB
Description: For each activity and cost centre type, estimated total over each pay period
Data description
|
Type
|
Data exported
|
employee_key
|
Integer
|
Employee key
|
period_start_date
|
Date
|
End of period calendar start date assigned to the employee
|
period_end_date
|
Date
|
End of period calendar end date assigned to the employee
|
job_type_key
|
Integer
|
Activity type key
|
cost_centre_type_key
|
Integer
|
Cost centre type key
|
CUSTOMER_TYPE_KEY
|
Integer
|
Customer 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
|
hours
|
Real number
|
Totals in hours
|
days
|
Real number
|
Totals in days
|
COST
|
Real number
|
Cost
|
employee_start_date
|
Date
|
Date when the employee starts to be taken into account in the pay period
|
employee_end_date
|
Date
|
Date when the employee is no longer taken into account in the pay period.
|
payroll_calendar_key
|
Integer
|
Employee’s end of period calendar key
|
payroll_calendar_description
|
40-character string
|
Employee’s end of period calendar description
|
section_key
|
Integer
|
Section key on the employee's end of period day
|
SECTION_ABBREVIATION
|
13-character string
|
Section description on the employee's end of period day
|
section_description
|
50-character string
|
Section description on the employee's end of period day
|
job_code
|
40-character string
|
Activity type code number
|
job_abbreviation
|
5-character string
|
Activity type abbreviation
|
job_description
|
40-character string
|
Activity type description
|
cost_centre_code
|
40-character string
|
Cost centre type code
|
cost_centre_abbreviation
|
5-character string
|
Cost centre abbreviation
|
cost_centre_description
|
40-character string
|
Cost centre description
|
CUSTOMER_CODE
|
40-character string
|
Customer type code
|
CUSTOMER_ABBREVIATION
|
5-character string
|
Customer type abbreviation
|
CUSTOMER_DESCRIPTION
|
40-character string
|
Customer description
|
JOB_EXTERNAL_REFERENCE
|
40-character string
|
External job reference
|
COST_CENTRE_EXTERNAL_REFERENCE
|
40-character string
|
External cost centre reference
|
CUSTOMER_EXTERNAL_REFERENCE
|
40-character string
|
External customer reference
|
|
Estimated periodic on-call duty totals
Table name: ESTIMATED_PERIOD_ON_CALL_DUTY
Description: For each on-call duty type, estimated total over each pay period
Data description
|
Type
|
Data exported
|
employee_key
|
Integer
|
Employee key
|
period_start_date
|
Date
|
End of period calendar start date assigned to the employee
|
period_end_date
|
Date
|
End of period calendar end date assigned to the employee
|
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
|
payroll_calendar_key
|
Integer
|
Employee’s end of period calendar key
|
payroll_calendar_description
|
40-character string
|
Employee’s end of period calendar description
|
employee_start_date
|
Date
|
Date when the employee starts to be taken into account in the pay period
|
employee_end_date
|
Date
|
Date when the employee is no longer taken into account in the pay period.
|
on_call_duty_abbreviation
|
5-character string
|
On-call type abbreviation
|
on_call_duty_description
|
40-character string
|
On-call 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
|
Section key on the employee's end of period day
|
SECTION_ABBREVIATION
|
13-character string
|
Section description on the employee's end of period day
|
section_description
|
50-character string
|
Section description on the employee's end of period day
|
|
Estimated periodic hourly basis interval totals
Table name: ESTIMATED_PERIOD_HOURLY_BASIS
Description: For each hourly basis type, estimated total over each pay period
Data description
|
Type
|
Data exported
|
employee_key
|
Integer
|
Employee key
|
period_start_date
|
Date
|
End of period calendar start date assigned to the employee
|
period_end_date
|
Date
|
End of period calendar end date assigned to the employee
|
employee_start_date
|
Date
|
Date when the employee starts to be taken into account in the pay period
|
employee_end_date
|
Date
|
Date when the employee is no longer taken into account in the pay period.
|
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 interval
|
PERFORMED
|
Real number
|
Performed
|
section_key
|
Integer
|
Section key on the employee's end of period day
|
SECTION_ABBREVIATION
|
13-character string
|
Section description on the employee's end of period day
|
section_description
|
40-character string
|
Section description on the employee's end of period day
|
payroll_calendar_key
|
Integer
|
Employee’s end of period calendar key
|
payroll_calendar_description
|
50-character string
|
Employee’s end of period calendar description
|
|
Estimated periodic breaks totals
Table name: ESTIMATED_PERIODIC_BREAK
Description: For each break type, estimated total over each pay period
Data description
|
Type
|
Data exported
|
employee_key
|
Integer
|
Employee key
|
TYPE_KEY
|
Integer
|
Break key
|
period_start_date
|
Date
|
End of period calendar start date assigned to the employee
|
period_end_date
|
Date
|
End of period calendar end date assigned to the employee
|
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
|
Section key on the employee's end of period day
|
SECTION_ABBREVIATION
|
13-character string
|
Section description on the employee's end of period day
|
section_description
|
50-character string
|
Section description on the employee's end of period day
|
payroll_calendar_key
|
Integer
|
Employee’s end of period calendar key
|
payroll_calendar_description
|
40-character string
|
Employee’s end of period calendar description
|
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 daily work schedule totals
Table name: ESTIMATED_PERIOD_WORK_SCHEDULE
Description: For each work schedule type, estimated total over each pay period
Data description
|
Type
|
Data exported
|
employee_key
|
Integer
|
Employee key
|
period_start_date
|
Date
|
End of period calendar start date assigned to the employee
|
period_end_date
|
Date
|
End of period calendar end date assigned to the employee
|
TYPE_KEY
|
Integer
|
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
|
Section key on the employee's end of period day
|
SECTION_ABBREVIATION
|
13-character string
|
Section description on the employee's end of period day
|
section_description
|
50-character string
|
Section description on the employee's end of period day
|
payroll_calendar_key
|
Integer
|
Employee’s end of period calendar key
|
payroll_calendar_description
|
40-character string
|
Employee’s end of period calendar description
|
|
