id | id | integer | NO | | Identifier of the related record. |
mas_id | mes_id | integer | NO | | Unique identifier for the monthly summary. |
tenant_id | tenant_id | integer | NO | | Identifier of the related tenant. |
mas_employment_id | mes_rap_id | integer | NO | | Identifier of the related mas employment. |
mas_reference_date | mes_data | date | NO | | The month/year the summary refers to (usually the first or last day of the month). |
mas_hiring_date | mes_data_assun | date | NO | | Date associated with mas hiring date. |
mas_termination_date | mes_data_licen | date | NO | | Date associated with mas termination date. |
mas_regular_hours | mes_ore_ordinarie | numeric(8,2) | NO | 0 | Total ordinary working hours calculated for the month. |
mas_excess_hours | mes_ore_esubero | numeric(8,2) | NO | 0 | Value of mas excess hours. |
mas_recovery_hours | mes_ore_recupero | numeric(8,2) | NO | 0 | Value of mas recovery hours. |
mas_overtime_hours | mes_ore_straordinarie | numeric(8,2) | NO | 0 | Total overtime hours calculated for the month. |
mas_absence_hours | mes_ore_assenza | numeric(8,2) | NO | 0 | Total hours of absence recorded in the month. |
mas_workable_hours | mes_ore_lavorabili | numeric(8,2) | NO | 0 | Value of mas workable hours. |
mas_worked_hours | mes_ore_lavorate | numeric(8,2) | NO | 0 | Value of mas worked hours. |
mas_department_code | mes_reparto | character(4) | NO | ''::bpchar | Code of mas department code. |
mas_job_title_code | mes_qualifica | character(4) | NO | ''::bpchar | Code of mas job title code. |
mas_role_code | mes_mansione | character(4) | NO | ''::bpchar | Code of mas role code. |
mas_cost_center_code | mes_cencos | character(4) | NO | ''::bpchar | Code of mas cost center code. |
mas_pay_grade_level | mes_livello | character(2) | NO | ''::bpchar | Value of mas pay grade level. |
mas_late_arrivals_count | mes_num_rita | numeric(2,0) | NO | 0 | Number of late arrival events occurred during the month. |
mas_late_arrivals_total_minutes | mes_tot_rita | numeric(4,0) | NO | 0 | Value of mas late arrivals total minutes. |
mas_worked_days | mes_giorni_lavorati | numeric(2,0) | NO | 0 | Value of mas worked days. |
mas_paid_days | mes_giorni_retribuiti | numeric(2,0) | NO | 0 | Value of mas paid days. |
mas_inps_weeks | mes_settimane_inps | numeric(2,0) | NO | 0 | Number of contribution weeks for social security (INPS). |
mas_compensated_hours | mes_ore_compensate | numeric(8,2) | NO | 0 | Value of mas compensated hours. |
mas_inail_position | mes_pos_inail | character(20) | NO | ''::bpchar | Value of mas inail position. |
mas_last_work_hours_value | mes_orlav_ultima | numeric(8,2) | NO | 0 | Value of mas last work hours value. |
mas_is_locked | mes_bollato | boolean | NO | false | Indicates if the month is finalized (bollato) and cannot be edited without authorization. |
mas_complementary_hours | mes_ore_complementari | numeric(8,2) | NO | 0 | Value of mas complementary hours. |
mas_missing_clockings_count | mes_omessebol | numeric(3,0) | NO | 0 | Number of missing clock-in/out events (omesse bollature). |
mas_supplementary_hours | mes_ore_supplementari | numeric(8,2) | NO | 0 | Value of mas supplementary hours. |