Data Model
Entity Relationship Model
Entity Relationship Model of the actual Rollup Updates
Tables of Time & Attendance
Overview of the Time & Attendance Tables
Entity Relationship Model
Here you find the Entity Relationship Model of the actual Rollup Update: ER-Model (PDF)
Back to top | Back to table of contents
Entities for Time & Attendance
In the following you find an overview of the entities for Time & Attendance.
Schema Name |
Entity Name |
Description |
|---|---|---|
| xrm1_attendance_detail | Attendance Detail | Used by employees to track their attendance (Start, Stop, Break, etc.). |
| xrm1_attendance | Attendance | Consolidates all attendance details per employee per day automatically; using all rules stored in the background like mandatory breaks, shifts, etc. |
| xrm1_time_entry | Time Entry | Used by employees to track work regarding processes or projects in hours per day. |
| xrm1_time_summary | Time Summary | Time Summaries consolidate all time and attendance related information of an employee on a monthly basis. |
| xrm1_time_sheet | Time Sheet | Consolidates time entries for an employee per week. |
| xrm1_time_summary_daily | Daily Summary | Consolidates all time related information of an employee on a daily basis (allocated hours, attendance, work hours, absence hours, holidays, etc.). |
| xrm1_employment_contract | Employment Terms | Defines the allocation of work hours for employees without work pattern. |
| xrm1_employment_contract_template | Employment Terms Template | Helps the users to predefine Employment Term regulations that can be applied to employees. |
| xrm1_work_pattern | Work Pattern | Defines a work pattern for an employee for a specific time period. |
| xrm1_work_pattern_detail | Work Pattern Detail | Defines the specific working hours allocation of an employee within a work pattern. |
| xrm1_work_pattern_template | Work Pattern Template | Helps the users to predefine Work Patterns that can be applied to employees. |
| xrm1_employee | Employee | The employee is the core file that connects to all functions and data for Time & Attendance and HR Management and has all the base information of the employee. |
| xrm1_area | Area | Specifies a geographic area (Country, Region, State, etc.) and connects employees with the regulations of that area in regards to time entry regulations like mandatory breaks, bank holidays, etc. |
| xrm1_calendar_rule | Calendar Entry | Calendar Entries are used to define bank holidays. Calendar Entries can be setup as one-time occurrence or as recurring event (e.g. New Years Day: always on 1st of January). |
| xrm1_calendar | Calendar | Calendars are used to group multiple Calendar Entries together. The Calendar can be linked towards one or many areas. |
| xrm1_absence_type_settings | Absence Type Settings | Absence Type settings are used to define all parameters for the different kind of absences and are used in the functions of multiple areas of the whole Hubdrive solutions. Absence Type settings are highly integrated with the global option set "Absence Type". |
| xrm1_leave_request | Leave Request | Leave requests are used to apply for planned leave of employees and track unplanned leave (e.g. sickness, accident, unexcused absence) for an employee. |
| xrm1_time_assignment | Leave Allocation | Leave allocations are used to distribute the leave time of a leave request towards to different leave entitlements. |
| xrm1_time_contingent | Leave Summary | Leave summaries are consolidating the leave entitlements incl. taken and remaining time for each employee for each fiscal year. Each absence type has a separate leave summary. |
| xrm1_time_slice | Leave Entitlement | Leave entitlements are the details of the leave summary. |
| xrm1_time_slice_offset | Leave Entitlement Offset | Leave entitlements offset is used to balance between positive and negative leave entitlements and to ensure a secure transfer of remaining leave amounts into the next fiscal period. |
| xrm1_business_closure | Business Closure | Business closures provide the framework to rollout leave requests to multiple employees on an automated basis without the necessity of approving the leave requests on a manual basis. |
| xrm1_attendance_calc_config | Attendance Calculation Configuration | With Attendance Calculation configuration, the specific setting for calculation of attendances incl. mandatory breaks and further regulations for different areas can be maintained. |
| xrm1_mandatory_break_rule | Mandatory Break Rule | Mandatory Break Rules are part of the Attendance Calculation Configuration and define after how many work hours a break has to be taken. |
| xrm1_time_account | Time Account | Time Accounts are used to define the collection of overtime hours based on settings. |
| xrm1_time_account_configuration | Time Account Configuration | Time Account Configuration is a detailed setting within the Time Account. |
| xrm1_time_account_config_template | Time Account Configuration Template | Time Account Configuration Templates can be used to pre-define Time Account Configurations. |
| xrm1_shift | Shift | Shifts define when an employee should work and also when an employee is not supposed to work (outside of the shift hours); Shifts are used within Daily Summaries on a daily level for all employees or can be provisioned to the system using the integration to Teams Shifts. |
| xrm1_process | Process | Processes are used within the time entry of work hours based on time sheets. Together with cost centers it can be used to create the basis to use the data within reports on activity-based costing. Processes can also be used as Projects (e.g. with renaming) in order to track the work hours against projects for project focused customers. |
| xrm1_process_resource | Process Resource | Process Resource connects Employees with Processes and also defines based on RACI in which role the employee acts in the process and how intensively based on FTE. Process Resources are the basis to prepopulate the time entry lines within a time sheet for each individual employee. |
Back to top | Back to table of contents