Schema pres

Tables documented: 46

English table	Italian original table	Description
pres.attendance_alert_definitions	pres.tab_avvisi	User-defined rules for attendance alerts and anomaly detection.
pres.attendance_alerts	pres.avvisi	Alerts and anomalies generated during the timesheet calculation process (e.g., missing clock-ins, excessive lateness).
pres.attendance_configuration	``	Key-value store for attendance module settings and calculation engine parameters.
pres.attendance_counter_balances	pres.tot_numeri	Historical balances, accruals, and usage records for employee attendance counters.
pres.attendance_counter_definitions	pres.tab_contatori	Core configuration for attendance counters (accruals, carry-forwards, limits, and calculation formulas).
pres.attendance_reason_cascades	pres.tabgiu_collegate	Defines cascading rules where a parent attendance reason triggers the calculation of a child reason.
pres.attendance_reasons	pres.tabgiu	Master table for all attendance and absence reason codes (Justifications).
pres.attendance_status	pres.asspre	Real-time dashboard for employee attendance, monitoring presence, absence, late arrivals, and justification reasons.
pres.attendance_status_realtime	pres.asspre_auto	Real-time automated dashboard for employee presence monitoring, synchronized with live clock-in events.
pres.clocking_reason_mappings	pres.tabcaubol	Mappings between codes entered on hardware terminals and system justification/shift codes.
pres.collective_attendance_calendars	pres.tabcalen	Defines company-wide or group-wide closures and collective absences, avoiding individual manual entries.
pres.company_attendance_profiles	pres.prof_az	Company-level default profiles for punch rounding, lateness tracking, and overtime calculation rules.
pres.counter_groups	pres.tab_cont_grp	Definitions of counter groups used to categorize different types of attendance metrics (e.g., Leave, Overtime, Presence).
pres.custom_calculations	pres.calcoli	Configuration for end-of-month calculation rules, scripts, and filters for payroll variables.
pres.daily_attendance_details	pres.cartellino	Atomic daily timesheet records containing raw clockings, theoretical shifts, and processed work/absence hours.
pres.daily_attendance_hours_distribution	pres.cartellino_ore	Detailed breakdown of daily attendance hours into categories, activities, or pay-types.
pres.daily_attendance_justifications	pres.giust_giorno	Daily breakdown of justifications (leave, sickness, permits) linked to the attendance sheet.
pres.daily_shift_planning	pres.cartellino_turni	Planned daily shifts and schedule assignments for employees.
pres.dipendenti	pres.dipendenti	Records for dipendenti.
pres.employee_badges	pres.badge	Assignment table linking physical badge numbers to employee employment records with temporal validity ranges.
pres.employee_clockings	pres.timbra	Raw and processed employee clock-in/out events from hardware terminals or mobile apps.
pres.employee_counter_assignments	pres.dip_conta	Junction table linking employees to their specific attendance and leave counters (e.g., Vacation, PTO, Overtime Bank).
pres.employee_leave_balances	pres.progressivi	Historical balances and snapshots for employee leave (vacation, PTO, and other time-off types).
pres.employee_leave_balances_today	pres.ferie_today	Real-time leave and vacation balances, aggregating residues from past years and current year accruals.
pres.employee_overtime_profile_assignments	pres.profstr_assign	Historical assignments of overtime calculation profiles to employees.
pres.holiday_calendar	pres.festivita	Calendar of national and local holidays with rules for payroll calculation and work shifts.
pres.leave_accrual_rules	pres.cnf_ferie	Configuration table for leave and vacation accrual logic based on seniority, contract types, and job levels.
pres.leave_transformation_rules	pres.cnf_ferie_rule	Rules for automatically transforming generic absence reasons into specific ones based on priority and thresholds.
pres.long_term_absences	pres.giustif	Source table for multi-day absence events. Used to generate daily justification records.
pres.monthly_attendance_summaries	pres.cart_mese	Consolidated monthly attendance totals per employee, used for payroll processing and historical reporting.
pres.monthly_justification_aggregates	pres.giust_mese	Monthly aggregated values of leave and absence reasons, prepared for payroll processing.
pres.monthly_payroll_print_layouts	pres.descri_mese	Stores pre-formatted strings for monthly LUL (Libro Unico del Lavoro) and attendance reports generation.
pres.overtime_and_premium_rules	pres.tabstra	Configuration for automatic overtime and shift premium calculations based on time bands and progressive thresholds.
pres.payroll_additional_reasons	pres.causpaghe	Manual or additional payroll reasons (bonuses, expenses, etc.) that are not automatically derived from daily attendance clockings.
pres.profora	``	Records for profora.
pres.profora_assign	pres.profora_assign	Records for profora assign.
pres.shift_advanced_settings	pres.orari_adv	Advanced configuration for shifts, handling tolerances, rounding, and automatic period insertions.
pres.shift_attendance_profiles	pres.prof_orario	Shift-specific calculation profiles for punch rounding, lateness, and overtime. These override company-level defaults.
pres.shift_definitions	pres.orari	Master table for work shift models, theoretical punching times, and calculation logic.
pres.shift_flexibility_rules	pres.orari_flex	Extension table for shifts defining flexibility windows and mandatory presence slots.
pres.shift_planning_sort_order	pres.cartellino_turni_ordinamento	Storage for custom display sorting of employees within the shift planning interface.
pres.weekly_attendance_summaries	pres.cart_sett	Weekly aggregation of attendance data, including overtime tiers and anomaly tracking.
pres.weekly_justification_aggregates	pres.giust_sett	Weekly aggregates of absence and leave reasons, used for compliance checks and reporting.
pres.weekly_schedule_details	pres.tabsett	Detailed daily breakdown of weekly or multi-weekly shift rotation schemas.
pres.weekly_shift_schema_days	pres.profora_settimane	Detailed daily breakdown of a weekly shift schema. Defines which specific day of the cycle a date represents.
pres.weekly_shift_schema_profiles	pres.prof_profora	Profiles defining calculation rules specifically for a weekly shift schema (template). These override company-level defaults.

• Back to main index