The system sends the estimated T&A totals of the end of week.
Estimated weekly absence totals
Table name: ESTIMATED_WEEKLY_ABSENCE
Description: For each absence type, estimated weekly absence total for each week
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
|
Estimated weekly absence totals expressed in days
|
hours
|
Real number
|
Estimated weekly absence totals expressed in hours
|
PHYSICAL_HOURS
|
Real number
|
Hours 0- 24
|
units
|
Real number
|
Estimated 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
|
|
Estimated weekly absence balance totals
Table name: ESTIMATED_WEEKLY_ABS_BALANCE
Description: For each absence type, estimated 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
|
|
Estimated weekly accounts totals
Table name: ESTIMATED_WEEKLY_TOTAL
Description: For each week, estimated 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
|
|
Estimated weekly overtime totals
Table name: ESTIMATED_WEEKLY_OVER_HOUR
Description: For each overtime type, estimated 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
|
Estimated 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
|
|
Estimated weekly special hours totals
Table name: ESTIMATED_WEEKLY_SPEC_HOUR
Description: For each special hours type, estimated 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
|
Estimated 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
|
|
Estimated weekly bonus totals
Table name: ESTIMATED_WEEKLY_BONUS
Description: For each bonus type, estimated 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
|
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
|
Estimated 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
|
|
Estimated weekly late arrival/early departure totals
Table name: ESTIMATED_WEEKLY_LATE_DEP
Description: For each late arrival or early departure type, estimated 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
|
Estimated weekly total of late arrival/early departure hours
|
units
|
Real number
|
Estimated 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
|
|
Estimated weekly balance totals
Table name: ESTIMATED_WEEKLY_BALANCE
Description: For each balance type, estimated 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
|
|
Estimated weekly activity totals
Table name: ESTIMATED_WEEKLY_JOB
Description: For each activity and cost centre type, estimated 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
|
|
Estimated weekly on-call duty totals
Table name: ESTIMATED_WEEKLY_ON_CALL_DUTY
Description: For each on-call duty type, estimated 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
|
|
Estimated weekly hourly basis interval totals
Table name: ESTIMATED_WEEKLY_HOURLY_BASIS
Description: For each hourly basis type, estimated 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
|
|
Estimated weekly breaks totals
Table name: ESTIMATED_WEEKLY_BREAK
Description: For each break type, estimated 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
|
|
Estimated weekly work schedule totals
Table name: ESTIMATED_WEEKLY_WORK_SCHEDULE
Description: For each work schedule type, estimated 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
|
Estimated total in hours on the employee's end of week day
|
DAYS
|
Real number
|
Estimated 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
|
|
