Schema hr

Tables documented: 293

English table	Italian original table	Description
hr._app_config	hr._config_app	Application configuration key/value entries scoped by tenant (page/feature/key).
hr._app_config_employment	hr._config_app_dip	Per-employment overrides for application configuration values (tenant-scoped).
hr._app_config_fields	hr._config_app_fields	Application configuration field definitions (tenant-scoped).
hr._control_functions	hr._control_function	Tenant-scoped control functions used for application validation logic.
hr._data_area_attributes	hr._dataarea_attr	Localized attributes for data areas (tenant-scoped).
hr._data_area_buttons	hr._dataarea_button	Button definitions for data areas (tenant-scoped).
hr._data_area_field_links	hr._dataarea_link	Layout links between data areas and fields (tenant-scoped).
hr._data_areas	hr._dataarea	Application data-area definitions used by forms and UI components (tenant-scoped).
hr._document_templates	hr._doc_template	Document template definitions used for generating and managing HR documents (tenant-scoped).
hr._email_templates	hr._email_template	Email templates used for system notifications and communications (tenant-scoped).
hr._field_attributes	hr._field_attr	Localized attributes and metadata for fields (tenant-scoped).
hr._fields	hr._fields	Configuration table that defines application fields and their validation, rendering and reporting metadata.
hr._fields_table	hr._fields_table	Configuration table that defines how fields are displayed and rendered in table/list views.
hr._forms	hr._forms	Configuration table that defines application forms and their grid layout settings.
hr._forms_link	hr._forms_link	Configuration table that links forms to data areas and defines their placement within the form grid.
hr._log	hr._log	Internal configuration and control data for log.
hr._payslip_marker	hr._cedolini_marker	Definitions used by the payslip PDF parser: markers/tokens to search and their expected positions (coordinates and offsets) to extract values.
hr._payslip_template	hr._cedolino_template	Payslip PDF template configuration used by the parser. Defines template metadata and parsing behavior.
hr._q_data_sync	hr._q_sincro_dati	Technical queue table for inbound data synchronization events (raw payloads and processing status).
hr._q_documenti	hr._q_documenti	Queue table for document generation and processing, including status and output metadata.
hr._q_elab_meridiana	hr._q_elab_meridiana	Queue table for Meridiana processing jobs, including payload, session reference and execution tracking.
hr._q_events	hr._q_events	Queue table for event-related processing, tracking status, source and change dates.
hr._q_events_fasi	hr._q_events_fasi	Queue table for scheduled processing of event type phases, tracking execution and confirmation status.
hr._q_mail	hr._q_mail	Internal configuration and control data for q mail.
hr._report_functions	hr._report_function	Technical configuration table defining report functions, their parameters, and execution metadata.
hr._table_relationships	hr._relazioni_tabelle	Technical metadata table defining relationships between tables and their key/date columns for processing.
hr._widget_profiles	hr._widget_profili	Technical table assigning widgets to user profiles with dashboard layout configuration.
hr._widgets	hr._widget	Technical catalog of UI widgets with rendering configuration and report bindings.
hr.activated_training_courses	hr.corsi_attivati	Records for activated training courses.
hr.activities	hr.attivita	Activities (tasks/notifications) associated with people, companies and employment relationships.
hr.activity_groups	hr.gruppi_attivita	Catalog of activity groups used to organize activity types.
hr.activity_types	hr.tipi_attivita	Catalog of activity types used to classify activities and drive related workflow behavior.
hr.addresses	hr.recapiti	Polymorphic table storing physical addresses for various entities (employees, companies, etc.) with temporal validity.
hr.agreement_levels	hr.con_livelli	Graduated steps (Levels/Grades) within an agreement qualification, defining the pay grid and seniority progression.
hr.agreement_qualifications	hr.con_qualifiche	Legal qualifications (Operaio, Impiegato, etc.) defined within a Collective Labor Agreement.
hr.agreement_seniority_steps	hr.con_scatti	Definitions for automatic seniority-based salary increases (scatti di anzianità) within a Collective Labor Agreement.
hr.ana_multe_automezzo	hr.ana_multe_automezzo	Records for ana multe automezzo.
hr.attachment_types	hr.tipi_allegati	Definitions of document categories for attachments (e.g., ID, Contract, Medical Certificate).
hr.attachments	hr.allegati	Attachments linked to HR entities (people, employments, events and document types), with soft-delete support.
hr.banks	hr.banche	Banks and branch references used for IBAN and payment details.
hr.benefits	hr.benefit	Benefit types / catalogue (lookup) used to assign benefits to employees.
hr.business_trip_reasons	hr.in_trasferta_causali	Lookup table for business trip reasons or categories (e.g., Sales, Technical Support, Training).
hr.business_trips	hr.in_trasferta	Management of employee business trips, including vehicle usage, cash advances, and customer/project linking.
hr.canteen_companies	hr.me_mensa_azienda	External or internal companies whose members use the canteen service, used for service cost billing.
hr.canteen_members	hr.me_mensa_anagrafica	Registry of individuals authorized to use the canteen services, including employees, consultants, and guests.
hr.clocking_points	hr.in_punti_timbratura	Geofencing and location definitions for valid employee clock-in/out points.
hr.collective_agreements	hr.contratti	Master table for National Collective Labor Agreements (CCNL) and their general regulatory parameters.
hr.companies	hr.aziende	Companies managed in the HR system, including legal and payroll identifiers.
hr.company_account_payment_methods	hr.azienda_conti_mezzipag	Payment method details linked to a company bank account.
hr.company_accounts	hr.azienda_conti	Company bank accounts used for payments and accounting references.
hr.company_announcement_reads	hr.comunicati_aziendali_link	Read/acknowledgement tracking for company announcements per employment relationship.
hr.company_announcements	hr.comunicati_aziendali	Company announcements visible to employees within a configured date range, optionally scoped by company and site.
hr.company_deadlines	hr.aziende_scadenze	Deadlines associated with a company, including date range and repetition count, within the tenant.
hr.company_entity_links	hr.azienda_enti_link	Links a company to related external entities (e.g., institutions or counterparties).
hr.company_work_sites	hr.sedi_link	Many-to-many relationship mapping between legal companies and their operational work sites/branches.
hr.competencies	hr.competenze	Competencies used for evaluations, roles, and training mappings.
hr.competency_types	hr.competenze_tipi	Lookup table for competency types (tenant-scoped).
hr.contact_details	hr.recapiti_tel	Polymorphic table storing contact information (phone, email, social) for various entities with temporal validity.
hr.contract_level_job_links	``	Association table linking contract levels to job roles (mansioni) within a tenant.
hr.cost_group_details	hr.gruppi_costi_det	Cost group detail records linking cost groups to elements and their hierarchical relationships.
hr.cost_groups	hr.gruppi_costi	Cost groups for categorizing and organizing costs and expenses. Used to group related costs for reporting, budgeting, and analysis purposes (e.g., "Personnel Costs", "Operational Costs", "Training Costs", "Benefits Costs").
hr.customer_activity_calendar	hr.in_clienti_attivita_calendario	Detailed calendar of scheduled activities for customers, derived from activity plans.
hr.customer_activity_schedules	hr.in_clienti_pianifica_att	Master schedule for recurring customer activities and service planning.
hr.customer_employment_links	hr.in_clienti_link	Links employees (employment relationships) to customers for a specific time period.
hr.customer_fixed_activities	hr.in_clienti_attivita_fissi	Defines recurring/fixed activity schedules for customers (e.g., standard weekly assignments).
hr.customer_group_assignments	hr.in_clienti_gruppi	Link table between customers and element groups for categorization purposes.
hr.customer_location_group_assignments	hr.in_clienti_sedi_gruppi	Link table between customer locations and element groups for categorization.
hr.customer_profora_assignments	hr.in_clienti_profora	Links customers to hour profiles (profora) for specific time periods.
hr.customer_project_activities	hr.in_commesse_attivita	Specific activities defined within a customer project or sub-link.
hr.customer_project_activity_custom_fields	hr.in_commesse_attivita_fieldcustom	Links between activities and their specific custom field definitions.
hr.customer_project_activity_groups	hr.in_commesse_attivita_gruppi	Associations between project activities and element groups for classification or visibility.
hr.customer_project_links	hr.in_commesse_link	Detailed links or sub-entities associated with customer projects.
hr.customer_projects	hr.in_commesse	Management of projects or work orders linked to specific customers.
hr.customers	hr.in_clienti	Registry of company customers and their master data.
hr.deadline_types	hr.scadenze	Catalog of deadline types and scheduling rules (notice, repetition and shifting) within the tenant.
hr.delegations	hr.in_deleghe	Management of formal delegations between employees or managers.
hr.document_model_fields	hr.in_docmodel_fields	Configuration of fields within a document model, including UI properties and validation rules.
hr.document_model_justifications	hr.in_docmodel_giustif	Rules and validation settings for leave justifications linked to specific document models.
hr.document_model_permissions	hr.in_permission	Defines time windows during which specific document models can be requested for a given validity period.
hr.document_model_step_actions	hr.in_docmodel_step_action	Actions available in each workflow step and their impact on document status and ownership.
hr.document_model_step_emails	hr.in_docmodel_step_email	Configuration for email notifications triggered during document workflow steps.
hr.document_model_steps	hr.in_docmodel_step	Workflow steps definition for document models, managing statuses and sequencing.
hr.document_models	hr.i_docmodel	Document models used to configure document workflows, visibility rules, and validation options.
hr.documents	hr.in_documents	Core table for all document instances (requests, justifications, etc.) and their workflow state.
hr.documents_field_definitions	hr.in_fields	Master dictionary of field definitions used for dynamic document models and forms.
hr.dynamic_list_details	hr.lista_dinamic_det	Individual filter conditions and logical rules that define a dynamic list.
hr.dynamic_lists	hr.lista_dinamic	Definitions for dynamic employee filtering and listing criteria.
hr.education_degree_types	hr.tipi_titoli_studio	Lookup table for types of education degrees (e.g., Bachelor, Master, PhD).
hr.education_degrees	hr.titoli_studio	Specific education degrees and certifications (e.g., Degree in Computer Science).
hr.element_group_types	hr.gruppi_tipi	Lookup/configuration of element group types. Controls selection behavior and integration rules (e.g., org chart linkage).
hr.element_groups	hr.gruppi_elementi	Element groups catalog (hierarchical). Groups are typed and can be used for classification and accounting mappings (e.g., expense reimbursements, customers, projects, org chart).
hr.employment_agreement_assignments	hr.rapporti_contratti_link	Assignments of specific Collective Labor Agreements (CCNL) to employment relationships, with validity periods.
hr.employment_compensation_budgets	hr.retribuzioni_budget	Annual compensation budget planning per employment relationship, tracking expected vs actual paid amounts.
hr.employment_compensation_costs	hr.retribuzioni_costi	Detailed monthly labor costs per employment relationship. Values from 1 to 40 represent specific cost components mapped via system configuration.
hr.employment_inail_positions	hr.rapporti_posizioni_inail	Assignment of INAIL (Italian National Institute for Insurance against Accidents at Work) insurance positions to employment relationships.
hr.employment_job_role_assignments	hr.rapporti_mansioni	Assigns official CCNL job roles to employees for legal and safety compliance.
hr.employment_pay_accumulators	hr.retribuzioni_progressivi	Year-to-date (YTD) payroll accumulators for each employment relationship, used for tax brackets and contribution thresholds.
hr.employment_pay_components	hr.retribuzioni_elementi	Specific payroll components (base pay, allowances, etc.) for each employment relationship per period.
hr.employment_payslip_body_items	hr.retribuzioni_voci_corpo_cedolino	Detailed breakdown of items within the body of a payslip (e.g., specific allowances, overtime, or deductions).
hr.employment_position_assignments	hr.rapporti_ruoli	Links employment relationships to internal organizational positions, including time validity and allocation percentage.
hr.employment_relationship_deadlines	``	Employment relationship deadlines / due dates. Stores event date and the recalculated/new due date for an employment relationship (multi-tenant).
hr.employment_relationship_details	hr.rapporti_det	Time-bound details for an employment relationship, including contractual level, time type and weekly hours (multi-tenant).
hr.employment_relationships	hr.rapporti	Employment relationships (employment periods/contracts) linked to a person and a company.
hr.employment_special_regulation_assignments	hr.rapporti_leggi_speciali	Links employment relationships to special regulations (laws, benefits, exemptions) within specific timeframes.
hr.employment_variable_compensations	hr.retribuzioni_variabili	Tracks variable pay components, performance bonuses (MBO), and their relationship with the base annual salary (RAL).
hr.equipment	hr.dotazioni	Company equipment and assets catalog. Defines equipment items that can be assigned to employees (e.g., laptops, phones, vehicles, tools, protective gear, uniforms). Each item has a type, description, and optional expiration tracking.
hr.equipment_assignments	hr.dotazioni_link	Equipment assignments to employees. Tracks which equipment is assigned to which employee, the assignment period, expiration date, and notes. Examples: laptop assigned to developer, safety helmet to construction worker, company car to sales manager.
hr.equipment_types	hr.tipi_dotazioni	Definitions of equipment categories and assets (e.g., Laptop, Safety Shoes, Mobile Phone).
hr.evacuation_points	hr.punti_evacuazione	Evacuation points used for safety and emergency management (multi-tenant).
hr.event_actions	hr.eventi_azioni	Available actions for event types. Defines the possible actions that can be triggered or performed for each event type (e.g., "Send contract" for hiring events, "Request documents" for onboarding, "Schedule interview" for recruitment).
hr.event_details	hr.eventi_det	Event detail records storing additional data linked to events and their type definitions.
hr.event_type_details	hr.x_tipi_eventi_det	Configuration details for event types, defining additional data requirements and behavior.
hr.event_type_phase_detail_links	hr.x_tipi_eventi_fasi_link	Link table associating event type phases with event type details.
hr.event_type_phases	hr.x_tipi_eventi_fasi	Phase configuration for event types, including timing offsets and conditional rules.
hr.event_types	hr.x_tipi_eventi	Catalog of event types used by events, activity types and related workflows.
hr.events	hr.eventi	Events associated with employment relationships and classified by event type.
hr.expense_note_attachments	hr.in_notaspese_allegati	Expense note attachments linked to expense note lines (binary payload stored in table). Soft-delete via _deleted.
hr.expense_note_currencies	hr.in_notaspese_valute	Currencies used in the expense note module (multi-tenant).
hr.expense_note_lines	hr.in_notaspese_det	Expense note line items (multi-tenant). Each row represents a single reimbursable/non-reimbursable expense line linked to an expense note.
hr.expense_note_payment_methods	hr.in_notaspese_metodi_pagamento	Lookup/configuration table for expense note payment methods.
hr.expense_note_travel_mean_custom_fields	hr.in_notaspese_mezzi_fieldcustom	Bridge table that assigns/whitelists custom fields to specific expense note travel means.
hr.expense_note_travel_means	hr.in_notaspese_mezzi	Lookup/configuration of travel/transport means used in expense notes. Controls required inputs (driver, km, trip token) and availability.
hr.expense_notes	hr.in_notaspese	Expense notes (headers) for employees/people, with date range, totals and workflow flags (multi-tenant).
hr.expense_reimbursement_type_account_links	hr.in_notaspese_rimborsi_link	Mapping table linking expense reimbursement types to element groups and accounting codes (e.g., GL account).
hr.expense_reimbursement_type_custom_fields	hr.in_notaspese_rimborsi_fieldcustom	Bridge table that assigns/whitelists custom fields to specific expense reimbursement types.
hr.expense_reimbursement_types	hr.in_notaspese_rimborsi	Expense reimbursement types/configuration (multi-tenant). Defines rules, limits and accounting code for expense reimbursements.
hr.external_entities	hr.soggetti	Table for external subjects, organizations, or individuals interacting with the system (e.g., vendors, partners).
hr.fitness_types	hr.idoneita	Fitness and work suitability types used for medical examinations and job requirement mappings.
hr.geolocations	hr.geolocalizzazione	Geolocation tracking records. Captures GPS coordinates, addresses, and optional images for start/end points of activities such as clock-in/clock-out events, field work, client visits, or delivery routes. Used for attendance verification, field workforce management, and activity tracking.
hr.in_articoli_magazzino	hr.in_articoli_magazzino	Records for in articoli magazzino.
hr.in_clienti_sedi	``	Records for in clienti sedi.
hr.in_documents_log	hr.in_documents_log	Audit and history records for in documents log.
hr.inventory_items	hr.x_tipi_articoli	Inventory items (articles) with stock quantities and classification by type and unit of measure.
hr.job_profiles	hr.profilo_job	Job profiles used for internal job configuration and cost allocation percentages (multi-tenant).
hr.job_role_profile_links	``	Links official CCNL job roles to their standardized technical profiles/competencies.
hr.job_role_suitability_requirements	hr.mansioni_idoneita_link	Mapping between official job roles and mandatory medical suitability types.
hr.job_role_training_requirements	hr.mansioni_corsi_link	Mapping between official job roles and mandatory training courses.
hr.job_roles	hr.mansioni	Master data for official CCNL job roles, used as the primary driver for compliance, medical suitability, and training requirements.
hr.language_levels	hr.lingue_livelli	Proficiency levels defined for each language (e.g., A1, B2, Native).
hr.languages	hr.lingue	System-wide language registry used for UI localization, templates, and reporting.
hr.medical_exam_type_parameters	hr.visite_mediche_parametri	Parameters and applicability rules for medical examination types, including thresholds, period settings, and contract/level/qualification scope.
hr.notifications	hr.notifiche	System and user notifications, tracking delivery, read status, and source references.
hr.occupational_diseases	hr.malattie_professionali	Registry of officially recognized occupational diseases and work-related illnesses.
hr.organigramma_gruppi	hr.organigramma_gruppi	Records for organigramma gruppi.
hr.organization_charts	hr.organigrammi	Organization charts defined for a company with validity dates (multi-tenant).
hr.organization_unit_links	hr.organigramma_link	Links employment relationships to organization units with a validity period (multi-tenant).
hr.organization_units	hr.organigramma_det	Organization chart units/nodes (tenant-scoped).
hr.payslips	hr.in_cedolini	Stores employee payslips (PDF and metadata) imported from payroll systems.
hr.performance_evaluation_form_items	hr.scheda_valutazione_link	Link table connecting evaluation templates to specific competencies or skills to be assessed.
hr.performance_evaluation_forms	hr.scheda_valutazione	Templates for performance evaluations, typically linked to specific job positions.
hr.person_availability_slots	hr.ana_fasce_disponibilita	Defines recurring availability time slots for persons (employees), including daily time windows, weekdays, and date ranges.
hr.person_bank_accounts	hr.ana_iban	Bank accounts (IBAN) associated with a person, with validity dates, within the tenant.
hr.person_benefits	hr.ana_benefit	Records for person benefits.
hr.person_children	hr.ana_figli	Children records associated with a person, including personal data and validity period, within the tenant.
hr.person_citizenship	hr.ana_cittadinanza	Person citizenship history (periodized). Each row links a person to a citizenship type/lookup and defines validity dates (multi-tenant).
hr.person_competency_assessments	hr.competenze_score	Competency assessment scores assigned to a person within an organizational context and validity period.
hr.person_competency_scores	hr.competenze_link	Competency scores assigned to a person over a validity period.
hr.person_costs	hr.ana_costi	Stores person-related costs, typically linked to employment relationships and payroll elements.
hr.person_deadline_schedule	hr.ana_scadenziario	Operational schedule of deadlines for an employment relationship and company, including completion status and notes, within the tenant.
hr.person_deadlines	hr.ana_scadenze	Deadlines associated with an employment relationship and company, including date range and repetition count, within the tenant.
hr.person_education_records	hr.ana_titoli_studio	Education title records associated with a person, including score and honors, within the tenant.
hr.person_equipment_assignments	hr.ana_dotazioni	Tracks assignment and return of equipment items to persons (employees).
hr.person_evaluation_competency_scores	hr.ana_valutazione_link	Link between a person evaluation and a competency, storing the assigned score within a tenant context.
hr.person_evaluation_goals	hr.ana_valutazione_obiettivi	Goals defined within a person evaluation, including description, planned actions and the assigned score, within a tenant context.
hr.person_evaluations	hr.ana_valutazione	Person evaluation record containing notes and ratings, linked to a person and compiled within a tenant context.
hr.person_fitness_certifications	hr.ana_idoneita	Records medical/health fitness certifications for persons (employees), tracking last visits, expiry dates, and visit outcomes.
hr.person_group_assignments	hr.ana_gruppi	Temporal assignment of persons (employees) to groups with a percentage allocation, typically linked to employment relationships.
hr.person_health_conditions	hr.ana_situazione_sanitaria	Records temporal health conditions, disabilities, and special health situations for persons (employees), including disability types and statuses.
hr.person_language_certifications	hr.ana_lingue	Language certifications associated with a person, including level, certification type and date, within the tenant.
hr.person_medical_examinations	hr.ana_visite_mediche	Person medical examination records, including booking details, last visit, outcome code, and expiration date.
hr.person_payment_method_assignments	hr.ana_mezzi_pagamento	Temporal assignment of company payment methods (bank accounts, etc.) to persons via their employment relationships for payroll purposes.
hr.person_registry	hr.anagrafico	Person master data (registry) for HR management.
hr.person_training_courses	hr.ana_corsi	Links a person to a training course attended/completed, with date, hours and expiry information.
hr.person_training_path_course_links	hr.corsi_percorsi_ana_link	Links people to training paths and courses, with a reference date, within the tenant.
hr.person_union_memberships	hr.ana_sindacati	Temporal membership of persons (employees) in trade unions (sindacati), linked to their employment relationships.
hr.person_vehicle_assignments	hr.ana_auto	Vehicle assignments to a person (company car or private). Stores assignment/return dates, odometer readings, return compliance and notes (multi-tenant).
hr.person_wallet_ledger	hr.ana_borsellino	Person wallet ledger entries (multi-tenant). Stores amounts by date and type, linked to expense notes and source records.
hr.person_workplace_assignments	hr.ana_sedi	Temporal assignment of persons (employees) to workplace locations (sedi) via their employment relationships.
hr.position_competency_requirements	hr.ruoli_competenze	Defines the minimum competency levels required for a specific organizational position (hr.positions).
hr.position_equipment_requirements	``	Links job positions to the required equipment or assets (e.g., car, laptop, safety gear) that should be provided.
hr.positions	hr.ruoli	Master data for internal organizational positions and functional roles, independent of legal/CCNL job roles.
hr.rapporti_distaccati	hr.rapporti_distaccati	Records for rapporti distaccati.
hr.rapporti_posizioni_inps	hr.rapporti_posizioni_inps	Records for rapporti posizioni inps.
hr.rapporti_ruoli	hr.rapporti_ruoli	Records for rapporti ruoli.
hr.report_groups	hr.gruppi_reports	Report groups used to categorize and organize reports.
hr.room_amenities	hr.in_riu_properties_luoghi	Link table between rooms and properties, specifying the quantity of each amenity available in a specific room.
hr.room_booking_statuses	hr.in_riu_prenotazioni_status	Lookup table for room reservation statuses (e.g., Pending, Confirmed, Cancelled).
hr.room_booking_types	hr.in_riu_tipo_prenotazione	Lookup table for room booking modalities (e.g., Immediate, Requires Approval, Recurring).
hr.room_bookings	hr.in_riu_prenotazioni	Records of actual room and shared space bookings/reservations.
hr.room_properties	hr.in_riu_properties	Definitions of attributes or amenities that can be associated with a room (e.g., Projector, AC, Capacity Details).
hr.room_types	hr.in_riu_tipo_luogo	Lookup table for room categories (e.g., Meeting Room, Canteen, Shared Desk).
hr.rooms	hr.in_riu_luoghi	Master registry for reservable spaces such as meeting rooms, canteen, or shared workstations.
hr.rooms_timeslot_assignments	hr.in_riu_assegna_fasce	Assigns specific time slots for shared rooms (meeting rooms, canteen, etc.) to individuals, defining guest access permissions.
hr.rooms_timeslot_definitions	hr.in_riu_fasce_orarie	Configuration of availability windows, capacity, and scheduling rules for shared rooms.
hr.sequence_counters	hr.contatori	Business sequence counters for generating progressive numbers in various tables. Unlike PostgreSQL sequences, these are application-managed counters for user-visible progressive identifiers (e.g., document numbers, employee codes).
hr.shortcut_types	hr.in_tipi_shortcut	Defines UI or operational shortcuts for quick data entry (e.g., quick codes for specific activities).
hr.smtp_settings	hr._smtp	SMTP configuration settings used to send application emails per tenant.
hr.special_regulations	hr.leggi_speciali	Registry of special labor laws, employment regulations, or tax incentive schemes.
hr.static_lists	hr.lista_static	Definitions of static lists containing fixed sets of identifiers or values.
hr.system_diagrams	hr.sysdiagrams	Storage for database schema diagrams and visual representations.
hr.system_logs	hr.log	Audit trail and system logs tracking user activities and functional executions.
hr.time_accounting_entries	hr.in_rendiconto_ore	Detailed logs of time accounting, including hours worked per project, travel data, and GPS locations.
hr.training_certifications	hr.corsi_certificazioni	Training certifications master data.
hr.training_course_attendance	hr.corsi_presenze	Attendance records for people in training course sessions.
hr.training_course_certification_links	hr.corsi_certificazioni_link	Links training courses to certifications that can be obtained or associated with the course.
hr.training_course_competencies	hr.corsi_competenze	Links training courses to competencies, with a step/level increment associated to the course.
hr.training_course_enrollments	hr.corsi_iscritti	Records for training course enrollments.
hr.training_course_path_links	hr.corsi_percorsi_link	Links training courses to training paths, with an ordering within the path.
hr.training_course_sessions	hr.corsi_sessioni	Records for training course sessions.
hr.training_courses	hr.corsi	Records for training courses.
hr.training_paths	hr.corsi_percorsi	Training paths (programs) defined for the tenant, with validity dates.
hr.user_profiles	``	Definition of permission templates and visibility scopes for user accounts.
hr.user_session	hr._session	User sessions (authentication/session tracking).
hr.user_session_var	hr._sessionvar	User session variables / key-value pairs bound to a session and optionally to a user.
hr.user_widget	``	User widget configuration (dashboard/layout preferences).
hr.users	hr.utenti	Application users (credentials, permissions, profile and related person).
hr.vehicles	hr.auto	Company vehicles / fleet registry (multi-tenant).
hr.visite_mediche	hr.visite_mediche	Records for visite mediche.
hr.visite_mediche_link	hr.visite_mediche_link	Association records for visite mediche link.
hr.work_report_details	hr.in_rapportino_det	Detail lines for work reports, linking them to specific accounting entries or service items.
hr.work_reports	hr.in_rapportino	Header table for work reports, interventions, and project-based activity summaries.
hr.work_site_stations	hr.sedi_postazioni_lavoro	Specific work stations or desks located within a work site.
hr.work_site_time_terminals	hr.sedi_terminali_link	Relational link between operational work sites and time-tracking hardware terminals.
hr.work_sites	hr.sedi_operative	Operational sites and branches with geofencing data for attendance tracking.
hr.x_absence_reason_types	hr.x_tipo_giustif	Lookup table for main absence and leave categories (e.g., Vacation, Sick Leave, Personal Time).
hr.x_aggregation_function_types	hr.x_tipi_funzioni_aggregazione	Metadata for SQL aggregation functions (SUM, AVG, etc.) used in reporting engines.
hr.x_areas	hr.x_aree	I18n translation table for organizational areas (Service table).
hr.x_attachment_groups	hr.x_gruppi_allegati	Grouping categories for attachments (e.g., Personal Docs, Medical, Contracts). Service table.
hr.x_calculation_variables	hr.x_tipi_variabili	Lookup table for calculation variables and expressions used for dynamic HR/Payroll processing.
hr.x_category_types	hr.x_tipo_tipologia	Generic lookup table for secondary classifications or categories (e.g., contract groupings).
hr.x_chart_types	hr.x_tipi_grafico	Lookup table for chart visualization types (e.g., Pie, Bar, Line) for reporting dashboards.
hr.x_citizenship	hr.x_cittadinanza	Lookup table for citizenship types (multi-tenant).
hr.x_contact_method_types	hr.x_tipi_recapito	Lookup table for contact method types (e.g., Office Email, Personal Mobile, Home Phone).
hr.x_counter_usage_types	hr.x_tipo_utilizzo_contatore	Defines how HR counters are affected by justifications (e.g., subtract from balance, add to used).
hr.x_deadline_types	hr.x_tipo_scadenze	Lookup table for HR deadline types (e.g., medical checks, contract expirations).
hr.x_delegation_notification_types	hr.x_tipi_notifica_delega	Lookup table for delegation-related notification types (e.g., creation, revocation, expiry).
hr.x_disability_status_types	hr.x_tipi_stato_invalidita	Lookup table for disability status and protected categories (e.g., Civil Disability, Work Invalides).
hr.x_disability_types	hr.x_tipi_invalidita	Lookup table for disability types and recognized medical conditions for HR compliance.
hr.x_document_check_types	hr.x_tipo_documents_check	Lookup table for document verification statuses and check results.
hr.x_email_types	hr.x_tipi_email	Lookup table for email categories used in templates and automated notifications.
hr.x_employment_agreement_types	hr.x_tipi_rapporto	Lookup table for employment agreement categories (indeterminato, apprendistato, etc.) with specific payroll/time tracking rules.
hr.x_employment_deadline_types	hr.x_tipi_rapporti_scadenze	Lookup table for employment-related deadline types (e.g., Probation End, Contract Expiry).
hr.x_employment_status_types	hr.x_tipi_inforza	Lookup table for headcount status (e.g., Active, Suspended, Terminated). Used for workforce reporting.
hr.x_event_groups	hr.x_gruppi_eventi	Classification groups for events (e.g., Training, Medical Checks). Service table.
hr.x_event_phases	hr.x_eventi_fasi	Records for x event phases.
hr.x_event_tables_registry	hr.x_tabella_eventi	Registry mapping logical system events to physical database tables and their display names (Service table).
hr.x_family_relationship_types	hr.x_tipo_fam	Multilingual lookup table for family relationship types (e.g., Spouse, Child).
hr.x_field_defaults	hr.x_defaults	Localization table for default field values across the application (Service table).
hr.x_field_types	hr.x_tipo_campi	Metadata table defining data types and widgets for dynamic fields (e.g., Integer, String, Date).
hr.x_gender_types	hr.x_tipo_sesso	Multilingual lookup table for gender/sex types.
hr.x_health_status_types	hr.x_tipi_situazione_sanitaria	Lookup table for medical fitness and health status categories (e.g., Fit for work, Fit with restrictions).
hr.x_hiring_categories	hr.x_tipi_categorie_assunzione	Lookup table for employment contract categories (e.g., Apprenticeship, Permanent, Fixed-term).
hr.x_hiring_sources	hr.x_tipi_provenienza	Lookup table for hiring/recruitment sources (e.g., Agency, Direct, Referral).
hr.x_holder_types	hr.x_tipo_detentore	Lookup table for workflow holders/approvers (e.g., Direct Manager, HR Office).
hr.x_inail_positions	hr.x_posizioni_inail	Lookup table for INAIL insurance positions (PAT). Service table.
hr.x_inps_positions	hr.x_posizioni_inps	Lookup table for INPS social security positions. Service table.
hr.x_item_units_of_measure	hr.x_tipi_articoli_unita_misura	Lookup table for item units of measure (e.g., PCS, KG, Boxes). Service table.
hr.x_justification_doc_types	hr.x_tipo_docgiustif	Lookup table for supporting document types required for leave or expense justifications.
hr.x_languages	hr.x_lingue	System languages for UI localization and translations (Service table).
hr.x_marital_statuses	hr.x_stato_civile	Lookup table for marital status (e.g., Single, Married, Divorced). Service table.
hr.x_medical_exam_outcome_types	hr.x_tipi_esiti_vm	Specific types of medical exam outcomes (Secondary/Detailed lookup).
hr.x_medical_exam_parameter_types	hr.x_tipi_param_visite_mediche	Lookup table for clinical parameters and tests included in medical examinations (e.g., Spirometry, Blood Test).
hr.x_medical_exam_periods	hr.x_tipi_periodo_vm	Lookup table for medical examination frequency (e.g., Annual, Biennial, Pre-employment).
hr.x_months	hr.x_mesi	Lookup table for months of the year (Service table).
hr.x_municipalities	hr.x_comune	Master table for municipalities/cities, used for tax code calculations and addresses (Service table).
hr.x_notification_types	hr.x_tipi_notifiche	Master lookup table for system notification types and their default message templates.
hr.x_outcome_types	hr.x_tipi_esiti	Lookup table for outcome types (e.g., Approved, Rejected, Pending) used in various HR processes.
hr.x_payment_method_types	hr.x_tipi_mezzi_pagamento	Lookup table for salary and reimbursement payment methods (e.g., Bank Transfer, Cash).
hr.x_payslip_body_items	hr.x_retribuzioni_voci_corpo_cedolino	Records for x payslip body items.
hr.x_pdf_extraction_type	hr.x_tipi_estrazione_pdf	Lookup table for PDF extraction types/strategies used by the payslip parser.
hr.x_period_types	hr.x_tipo_periodo	Lookup table for time period frequencies (e.g., Monthly, Weekly, Yearly).
hr.x_properties	hr.x_properties	General key-value configuration settings for the tenant (Service table).
hr.x_protected_categories	hr.x_categorie_prot_dipendente	Lookup table for protected employee categories (e.g., disabilities, special legal status).
hr.x_protected_hiring_types	hr.x_tipi_assunzione_protetta	Lookup table for protected hiring categories (e.g., disabilities, protected status under Law 68/99).
hr.x_proxy_types	hr.x_tipo_deleghe	Lookup table for proxy/delegation types (e.g., Union, Signing Authority).
hr.x_reference_doc_types	hr.x_tipo_docrif	Lookup table for reference or internal policy document types.
hr.x_reference_types	hr.x_tipo_riferimento	Lookup table for reference types used to categorize entities or metadata (e.g., Internal, External, System).
hr.x_regions	hr.x_regione	Lookup table for administrative regions (Service table).
hr.x_report_columns	hr.x_reports_column	Configuration of individual columns for system reports (Service table).
hr.x_report_criteria	hr.x_reports_criteria	Filtering conditions and logical criteria for reports (Service table).
hr.x_report_sorting	hr.x_reports_sorting	Defines sorting rules (ORDER BY) for system reports (Service table).
hr.x_reports	hr.x_reports	Master table for system reports configuration, including SQL logic and chart settings (Service table).
hr.x_salary_costs_settings	hr.x_retribuzioni_costi	Metadata for payroll and labor cost fields formatting and reporting (Service table).
hr.x_salary_elements_settings	hr.x_retribuzioni_elementi	Metadata for individual salary elements (base pay, allowances) formatting and visibility (Service table).
hr.x_salary_progressives_settings	hr.x_retribuzioni_progressivi	Records for x salary progressives settings.
hr.x_secondment_types	hr.x_tipi_distaccati	Lookup table for secondment types (e.g., intra-group secondment, technical secondment).
hr.x_sign_types	hr.x_tipi_segno	Lookup table for mathematical signs (Positive, Negative) using xsgn_ prefix to avoid collision with secondments.
hr.x_states_provinces	hr.x_provincia	Lookup table for provinces or states (Service table).
hr.x_termination_reasons	hr.x_causale_fine_rapporto	Lookup table for employment termination reasons (Service table).
hr.x_tipi_articoli	hr.x_tipi_articoli	Records for x tipi articoli.
hr.x_user_types	hr.x_tipi_utenti	Lookup table for user categories and roles (e.g., Employee, Manager, HR Admin).
hr.x_weekdays	hr.x_giorni	Lookup table for days of the week (Service table).
hr.x_working_time_types	hr.x_tipi_tempo	Lookup table for working time regimes (Full-Time, Part-Time, etc.).

• Back to main index