The completed weekly totals are the totals calculated each week for the past weeks. For the current week, the completed weekly totals are the totals of the current week declared the day before synchronisation.
Completed weekly absence totals
Table name: ACTUAL_WEEKLY_ABSENCE
Description: For each employee, completed weekly absence total per absence type.
An absence total for a type or a period is only sent if the absence total in days or hours or numbers is not null or different from 0.
Data description
|
Type
|
Data exported
|
employee_key
|
Integer
|
Employee key
|
start_date
|
Date
|
Start of the week date
|
end_date
|
Date
|
End of the week 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
|
Weekly absence totals expressed in days
|
hours
|
Real number
|
Weekly absence totals expressed in hours
|
PHYSICAL_HOURS
|
Real number
|
Hours 0- 24
|
units
|
Real number
|
Weekly absence totals expressed in numbers
|
section_key
|
Integer
|
Section key on the employee's end of week day
|
SECTION_ABBREVIATION
|
13-character string
|
Section description on the employee's end of week day
|
section_description
|
50-character string
|
Section description on the employee's end of week day
|
|
Completed weekly absence balance totals
Table name: ACTUAL_WEEKLY_ABS_BALANCE
Description: For each absence type, completed weekly absence balances for each week
Data description
|
Type
|
Data exported
|
employee_key
|
Integer
|
Employee key
|
start_date
|
Date
|
Start of the week date
|
end_date
|
Date
|
End of the week date
|
abs_balance_type_key
|
Integer
|
Absence 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
|
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 week
|
gained_hours
|
Real number
|
Hours acquired during the week
|
taken_hours
|
Real number
|
Hours taken during the week
|
end_hours
|
Real number
|
Balance in hours at the end of the week
|
ADJUSTMENT_HOURS
|
Real number
|
Hours adjusted at the end of the week
|
start_days
|
Real number
|
Balance in days at the start of the week
|
gained_days
|
Real number
|
Days acquired during the week
|
taken_days
|
Real number
|
Days taken during the week
|
end_days
|
Real number
|
Balance in days at the end of the week
|
ADJUSTMENT_DAYS
|
Real number
|
Days adjusted at the end of the week
|
section_key
|
Integer
|
Section key on the employee's end of week day
|
SECTION_ABBREVIATION
|
13-character string
|
Section description on the employee's end of week day
|
section_description
|
50-character string
|
Section description on the employee's end of week day
|
|
Completed weekly account totals
Table name: ACTUAL_WEEKLY_TOTAL
Description: For each pay period, completed account totals predefined by the application by employee and by account type
Data description
|
Type
|
Data exported
|
employee_key
|
Integer
|
Employee key
|
start_date
|
Date
|
Start of the week date
|
end_date
|
Date
|
End of the week 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
|
Section key on the employee's end of week day
|
SECTION_ABBREVIATION
|
13-character string
|
Section description on the employee's end of week day
|
section_description
|
50-character string
|
Section description on the employee's end of week day
|
|
Completed weekly overtime totals
Table name: ACTUAL_WEEKLY_OVER_HOUR
Description: For each overtime type, completed weekly total for each week
Data description
|
Type
|
Data exported
|
employee_key
|
Integer
|
Employee key
|
start_date
|
Date
|
Start of the week date
|
end_date
|
Date
|
End of the week 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
|
Weekly overtime hours duration
|
section_key
|
Integer
|
Section key on the employee's end of week day
|
SECTION_ABBREVIATION
|
13-character string
|
Section description on the employee's end of week day
|
section_description
|
50-character string
|
Section description on the employee's end of week day
|
|
Completed weekly special hours totals
Table name: ACTUAL_WEEKLY_SPEC_HOUR
Description: For each special hours type, completed weekly total for each week
Data description
|
Type
|
Data exported
|
employee_key
|
Integer
|
Employee key
|
start_date
|
Date
|
Start of the week date
|
end_date
|
Date
|
End of the week 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
|
Weekly special hours duration
|
section_key
|
Integer
|
Section key on the employee's end of week day
|
SECTION_ABBREVIATION
|
13-character string
|
Section description on the employee's end of week day
|
section_description
|
50-character string
|
Section description on the employee's end of week day
|
|
Completed weekly bonus totals
Table name: ACTUAL_WEEKLY_BONUS
Description: For each bonus type, weekly total achieved for each week
Data description
|
Type
|
Data exported
|
employee_key
|
Integer
|
Employee key
|
start_date
|
Date
|
Start of the week date
|
end_date
|
Date
|
End of the week 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
|
Weekly bonus value
|
section_key
|
Integer
|
Section key on the employee's end of week day
|
SECTION_ABBREVIATION
|
13-character string
|
Section description on the employee's end of week day
|
section_description
|
50-character string
|
Section description on the employee's end of week day
|
|
Completed weekly late arrival/early departure totals
Table name: ACTUAL_WEEKLY_LATE_DEP
Description: For each late arrival or early departure type, completed weekly total for each week
Data description
|
Type
|
Data exported
|
employee_key
|
Integer
|
Employee key
|
start_date
|
Date
|
Start of the week date
|
end_date
|
Date
|
End of the week 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 abbreviation
|
hours
|
Real number
|
Weekly total of late arrival/early departure hours
|
units
|
Real number
|
Weekly number of late arrival/early departure
|
section_key
|
Integer
|
Section key on the employee's end of week day
|
SECTION_ABBREVIATION
|
13-character string
|
Section description on the employee's end of week day
|
section_description
|
50-character string
|
Section description on the employee's end of week day
|
|
Completed weekly balance totals
Table name: ACTUAL_WEEKLY_BALANCE
Description: For each balance type, completed weekly total for each week
Data description
|
Type
|
Data exported
|
employee_key
|
Integer
|
Employee key
|
start_date
|
Date
|
Start of the week date
|
end_date
|
Date
|
End of the week 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 abbreviation
|
type_description
|
40-character string
|
Balance type description
|
start_hour
|
Real number
|
Permanent balance at the beginning of the week
|
hours
|
Real number
|
Balance of the week
|
end_hour
|
Real number
|
Permanent balance at the end of the week (before limitation)
|
limitation
|
Real number
|
Weekly limitation
|
limitation_on_total
|
Real number
|
Total limitation
|
to_be_transferred
|
Real number
|
Permanent balance to be carried forward at the end of the week (after limitation)
|
section_key
|
Integer
|
Section key on the employee's end of week day
|
SECTION_ABBREVIATION
|
13-character string
|
Section description on the employee's end of week day
|
section_description
|
50-character string
|
Section description on the employee's end of week day
|
|
Completed weekly activity totals
Table name: ACTUAL_WEEKLY_JOB
Description: For each activity and cost centre type, completed weekly total for each week
Data description
|
Type
|
Data exported
|
employee_key
|
Integer
|
Employee key
|
start_date
|
Date
|
Start of the week date
|
end_date
|
Date
|
End of the week date
|
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
|
section_key
|
Integer
|
Employee section key the last day of the week
|
SECTION_ABBREVIATION
|
13-character string
|
Section description on the employee's end of week day
|
section_description
|
50-character string
|
Employee section description the last day of the week
|
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
|
|
Completed weekly on-call duty totals
Table name: ACTUAL_WEEKLY_ON_CALL_DUTY
Description: For each on-call duty type, completed weekly total for each week
Data description
|
Type
|
Data exported
|
employee_key
|
Integer
|
Employee key
|
start_date
|
Date
|
Start of the week date
|
end_date
|
Date
|
End of the week 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 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 the last day of the week
|
SECTION_ABBREVIATION
|
13-character string
|
Section description on the employee's end of week day
|
section_description
|
50-character string
|
Employee section description the last day of the week
|
|
Completed weekly hourly basis interval totals
Table name: ACTUAL_WEEKLY_HOURLY_BASIS
Description: For each hourly basis type, completed weekly total for each week
Data description
|
Type
|
Data exported
|
employee_key
|
Integer
|
Employee key
|
start_date
|
Date
|
Start of the week date
|
end_date
|
Date
|
End of the week 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 on the employee's end of week day
|
HOURLY_BASIS_DIFFERENCE
|
Real number
|
Hourly basis interval on the employee's end of week day
|
HOURLY_BASIS_DIFF_TOTAL
|
Real number
|
Hourly basis interval total on the employee's end of week day
|
PERFORMED
|
Real number
|
Performed on the employee's end of week day
|
section_key
|
Integer
|
Section key on the employee's end of week day
|
SECTION_ABBREVIATION
|
13-character string
|
Section description on the employee's end of week day
|
section_description
|
50-character string
|
Section description on the employee's end of week day
|
|
Completed weekly breaks totals
Table name: ACTUAL_WEEKLY_BREAK
Description: For each break type, completed weekly total for each week
Data description
|
Type
|
Data exported
|
employee_key
|
Integer
|
Employee key
|
TYPE_KEY
|
Integer
|
Technical break key
|
start_date
|
Date
|
Start of the week date
|
end_date
|
Date
|
End of the week 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
|
Section key on the employee's end of week day
|
SECTION_ABBREVIATION
|
13-character string
|
Section description on the employee's end of week day
|
section_description
|
50-character string
|
Section description on the employee’s end of week day
|
TYPE_ABBREVIATION
|
5-character string
|
Break abbreviation on the employee's end of week day
|
TYPE_DESCRIPTION
|
40-character string
|
Break description on the employee's end of week day
|
BREAK_ALLOWANCE
|
Real number
|
Break allowance on the employee's end of week day
|
BRK_ALLOWANCE_CARRIED_FORWARD
|
Real number
|
Break allowance carried forward on the employee's end of week day
|
NUMBER_OF_BREAKS_TAKEN
|
Real number
|
Number of breaks on the employee's end of week day
|
TAKEN_BREAK_TIME
|
Real number
|
Break time taken on the employee's end of week day
|
PAID_BREAK_TIME
|
Real number
|
Paid break time on the employee's end of week day
|
PAID_BREAK_TIME_DEDUCTED
|
Real number
|
Paid break time deducted on the employee's end of week day
|
|
Completed weekly work schedule totals
Table name: ACTUAL_WEEKLY_WORK_SCHEDULE
Description: For each work schedule type, completed weekly total for each week
Data description
|
Type
|
Data exported
|
employee_key
|
Integer
|
Employee key
|
start_date
|
Date
|
Start of the week date
|
end_date
|
Date
|
End of the week 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
|
Work schedule abbreviation on the employee's end of week day
|
TYPE_DESCRIPTION
|
40-character string
|
Work schedule description on the employee's end of week day
|
HOURS
|
Real number
|
Total in hours on the employee's end of week day
|
DAYS
|
Real number
|
Total in days on the employee's end of week day
|
section_key
|
Integer
|
Section key on the employee's end of week day
|
SECTION_ABBREVIATION
|
13-character string
|
Section description on the employee's end of week day
|
section_description
|
50-character string
|
Section description on the employee’s end of week day
|
|
