pres.weekly_attendance_summaries
Schema: pres
English table: pres.weekly_attendance_summaries
Italian original table: pres.cart_sett
Description: Weekly aggregation of attendance data, including overtime tiers and anomaly tracking.
Overview
- Columns: 20
- Primary key: id
- Outgoing foreign keys: 2
- Incoming foreign keys: 0
- Indexes: 0
Columns
| English column | Italian original column | Type | Null | Default / Generated | Description |
|---|---|---|---|---|---|
id | id | integer | NO | Identifier of the related record. | |
was_id | sett_id | integer | NO | Internal unique identifier for the weekly summary. | |
tenant_id | tenant_id | integer | NO | Identifier of the related tenant. | |
was_employment_id | sett_rap_id | integer | NO | Reference to the employee employment contract. | |
was_reference_date | sett_data | date | NO | Reference date for the week (usually the starting Monday). | |
was_worked_hours | sett_ore_lavorate | numeric(6,0) | YES | Total worked hours for the week. | |
was_regular_hours | sett_ore_ordinarie | numeric(6,0) | YES | Ordinary working hours within the weekly limit. | |
was_overtime_hours | sett_ore_straordin | numeric(6,0) | YES | Total overtime hours calculated for the week. | |
was_excess_hours | sett_ore_esubero | numeric(6,0) | YES | Value of was excess hours. | |
was_excess_tier1_hours | sett_esubero_f1 | numeric(6,0) | YES | Hours exceeding the standard in the first tier (F1). | |
was_excess_tier2_hours | sett_esubero_f2 | numeric(6,0) | YES | Hours exceeding the standard in the second tier (F2). | |
was_excess_tier3_hours | sett_esubero_f3 | numeric(6,0) | YES | Value of was excess tier3 hours. | |
was_excess_tier4_hours | sett_esubero_f4 | numeric(6,0) | YES | Value of was excess tier4 hours. | |
was_absence_hours | sett_ore_assenza | numeric(6,0) | YES | Total absence hours recorded during the week. | |
was_justifications_summary | sett_giustif | text | NO | Textual summary or serialized list of justifications applied. | |
was_clocked_hours | sett_ore_timbrature | numeric(6,0) | YES | Hours calculated based on rounded clocking events. | |
was_actual_clocked_hours | sett_ore_timbrature_reali | numeric(6,0) | YES | Raw hours calculated from actual clocking timestamps. | |
was_anomaly_code | sett_anomalia | character(2) | NO | ''::bpchar | Code identifying any weekly calculation anomalies. |
was_workable_hours | sett_ore_lavorabili | numeric(6,0) | YES | Value of was workable hours. | |
was_notes | sett_note | text | NO | Administrative notes for the week. |
Relationships
Outgoing foreign keys
| Constraint | Local columns | References | Referenced columns | On update | On delete |
|---|---|---|---|---|---|
fk_cart_sett_sett_rap_id_to_rapporti | tenant_id, was_employment_id | hr.employment_relationships | tenant_id, er_id | RESTRICT | CASCADE |
fk_was_tenant | tenant_id | cloud.tenants | ten_internal_id | CASCADE | CASCADE |
Referenced by
No incoming foreign keys found.
Constraints
- Primary key:
pk_weekly_attendance_summaries→id - Unique:
c_uk_was_employment_date_tenant→tenant_id, was_employment_id, was_reference_date - Unique:
c_uk_was_id_tenant→tenant_id, was_id
Indexes
No indexes detected.
Navigation
- Back to main index
- [Back to
presindex]../)