The system sends the completed totals of the period. If the required period is the current one, the systems sends the end of period totals completed the day before. There is no completed end of period total in the future.
Completed periodic absence totals
Table name:
Description: For each pay period, absence totals per employee and absence type
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
|
Back to top
|
Completed periodic absence balance totals
Table name:
Description: For each payroll period, absence balance totals per employee and per absence balance
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
|
Back to top
|
Completed periodic account totals
Table name:
Description: For each payroll period, account totals predefined by the application per employee and per account type.
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
|
Back to top
|
Completed periodic overtime totals
Table name:
Description: For each overtime account, total of hours 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
|
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
|
Back to top
|
Completed periodic special hours totals
Table name:
Description: For each special hours account, total of hours 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
|
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
|
Back to top
|
Completed periodic bonus totals
Table name:
Description: For each bonus account, 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
|
Back to top
|
Completed periodic late arrival/early departure totals
Table name:
Description: Balance 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
|
Back to top
|
Completed periodic balances
Table name:
Description: For each balance type, 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
|
Back to top
|
Completed periodic activity totals
Table name:
Description: For each activity and cost centre type, 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
|
Back to top
|
Completed periodic on-call duty totals
Table name:
Description: For each on-call duty type, 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
|
Back to top
|
Completed periodic hourly basis interval totals
Table name:
Description: For each hourly basis type, 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
|
Back to top
|
Completed periodic breaks totals
Table name:
Description: For each break type, 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
|
Back to top
|
Completed periodic work schedule totals
Table name:
Description: For each work schedule type, 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
|
Back to top
|
