Estimated daily absence totals
Table name: ESTIMATED_DAILY_ABSENCE
Description: For each absence type, estimated daily absence total declared each day
Data description
|
Type
|
Data exported
|
employee_key
|
Integer
|
Employee key
|
total_date
|
Date
|
Total calculation day 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
|
Total in days
|
hours
|
Real number
|
Total in hours
|
PHYSICAL_HOURS
|
Real number
|
Hours 0- 24
|
units
|
Real number
|
Number of absences
|
section_key
|
Integer
|
Employee section key on the total 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 total calculation day
|
|
Estimated daily absence balance totals
Table name: ESTIMATED_DAILY_ABS_BALANCE
Description: For each absence balance type, estimated daily absence balances for each day
Data description
|
Type
|
Data exported
|
employee_key
|
Integer
|
Employee key
|
total_date
|
Date
|
Total calculation day 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 day
|
gained_hours
|
Real number
|
Hours acquired during the day
|
taken_hours
|
Real number
|
Hours taken during the day
|
end_hours
|
Real number
|
Balance in hours at the end of the day
|
ADJUSTMENT_HOURS
|
Real number
|
Hours adjusted at the beginning of the day
|
start_days
|
Real number
|
Balance in days at the beginning of the day
|
gained_days
|
Real number
|
Days acquired during the day
|
taken_days
|
Real number
|
Days taken during the day
|
end_days
|
Real number
|
Balance in days at the end of the day
|
ADJUSTMENT_DAYS
|
Real number
|
Days adjusted at the end of the day
|
section_key
|
Integer
|
Employee section key on the total 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 total calculation day
|
|
Estimated daily accounts totals
Table name: ESTIMATED_DAILY_TOTAL
Description: For each account type, estimated daily total for each day
Data description
|
Type
|
Data exported
|
employee_key
|
Integer
|
Employee key
|
total_date
|
Date
|
Total calculation day 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
|
Daily T&A totals in days
|
hours
|
Real number
|
Daily T&A totals in hours
|
PHYSICAL_HOURS
|
Real number
|
Hours 0- 24
|
units
|
Real number
|
Daily T&A totals in numbers
|
section_key
|
Integer
|
Employee section key on the total 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 total calculation day
|
|
Estimated daily overtime totals
Table name: ESTIMATED_DAILY_OVER_HOUR
Description: For each overtime type, estimated daily total for each day
Data description
|
Type
|
Data exported
|
employee_key
|
Integer
|
Employee key
|
total_date
|
Date
|
Total calculation day 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
|
Daily over time hours
|
section_key
|
Integer
|
Employee section key on the total 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 total calculation day
|
|
Estimated daily special hours totals
Table name: ESTIMATED_DAILY_SPEC_HOUR
Description: For each special hours type, estimated daily total for each day
Data description
|
Type
|
Data exported
|
employee_key
|
Integer
|
Employee key
|
total_date
|
Date
|
Total calculation day 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
|
Daily special hours
|
section_key
|
Integer
|
Employee section key on the total 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 total calculation day
|
|
Estimated daily bonus totals
Table name: ESTIMATED_DAILY_BONUS
Description: For each bonus type, estimated daily total for each day
Data description
|
Type
|
Data exported
|
employee_key
|
Integer
|
Employee key
|
total_date
|
Date
|
Total calculation day 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
|
Value of the daily bonus
|
section_key
|
Integer
|
Employee section key on the total 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 total calculation day
|
|
Estimated daily late arrival/early departure totals
Table name: ESTIMATED_DAILY_LATE_DEP
Description: For each late arrival or early departure type, estimated daily total for each day
Data description
|
Type
|
Data exported
|
employee_key
|
Integer
|
Employee key
|
total_date
|
Date
|
Total calculation day 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
|
Daily total of late arrival/early departure hours
|
units
|
Real number
|
Daily number of late arrivals/early departures
|
section_key
|
Integer
|
Employee section key on the total 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 total calculation day
|
|
Estimated daily balance totals
Table name: ESTIMATED_DAILY_BALANCE
Description: For each employee, estimated daily balance total for each day
Data description
|
Type
|
Data exported
|
employee_key
|
Integer
|
Employee key
|
total_date
|
Date
|
Total calculation day 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 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 period (after limitation)
|
section_key
|
Integer
|
Employee section key on the total 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 total calculation day
|
|
Estimated daily activity totals
Table name: ESTIMATED_DAILY_JOB
Description: For each activity and cost centre type, estimated daily total for each day
Data description
|
Type
|
Data exported
|
employee_key
|
Integer
|
Employee key
|
total_date
|
Date
|
Total calculation day 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 on the total 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 total calculation 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 daily on-call duty totals
Table name: ESTIMATED_DAILY_ON_CALL_DUTY
Description: For each on-call duty type, estimated daily total for each day
Data description
|
Type
|
Data exported
|
employee_key
|
Integer
|
Employee key
|
total_date
|
Date
|
Total calculation day 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 on the total 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 total calculation day
|
|
Estimated daily hourly basis interval totals
Table name: ESTIMATED_DAILY_HOURLY_BASIS
Description: For each hourly basis type, estimated daily total declared each day
Data description
|
Type
|
Data exported
|
employee_key
|
Integer
|
Employee key
|
total_date
|
Date
|
Total calculation day 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 on the total calculation day
|
HOURLY_BASIS_DIFF_TOTAL
|
Real number
|
Hourly basis interval total on the total calculation day
|
PERFORMED
|
Real number
|
Performed on the total calculation day
|
section_key
|
Integer
|
Employee section key on the total 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 total calculation day
|
|
Estimated daily breaks totals
Table name: ESTIMATED_DAILY_BREAK
Description: For each break type, estimated daily total declared each day
Data description
|
Type
|
Data exported
|
employee_key
|
Integer
|
Employee key
|
TYPE_KEY
|
Integer
|
Technical break key
|
total_date
|
Date
|
Total calculation day 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 total calculation day
|
TYPE_ABBREVIATION
|
5-character string
|
Break abbreviation on the total calculation day
|
TYPE_DESCRIPTION
|
40-character string
|
Break description on the total calculation day
|
BREAK_ALLOWANCE
|
Real number
|
Break allowance on the total calculation day
|
BRK_ALLOWANCE_CARRIED_FORWARD
|
Real number
|
Break allowance carried forward on the total calculation day
|
NUMBER_OF_BREAKS_TAKEN
|
Real number
|
Break number on the total calculation day
|
TAKEN_BREAK_TIME
|
Real number
|
Taken break time on the total calculation day
|
PAID_BREAK_TIME
|
Real number
|
Paid break time on the total calculation day
|
PAID_BREAK_TIME_DEDUCTED
|
Real number
|
Deducted paid break time on the total calculation day
|
|
Estimated weekly work schedule totals
Table name: ESTIMATED_DAILY_WORK_SCHEDULE
Description: For each work schedule type, estimated daily total declared each day
Data description
|
Type
|
Data exported
|
employee_key
|
Integer
|
Employee key
|
total_date
|
Date
|
Total calculation day 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 total calculation day
|
TYPE_DESCRIPTION
|
40-character string
|
Work schedule description on the total calculation day
|
HOURS
|
Real number
|
Hours total on the calculation day
|
DAYS
|
Real number
|
Days total on the calculation day
|
section_key
|
Integer
|
Employee section key on the total 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 total calculation day
|
|
