id | id | integer | NO | | Internal surrogate primary key. |
ec_clocking_id | tim_id | integer | NO | | Unique business identifier for the clocking event. |
tenant_id | tenant_id | integer | NO | | Tenant identifier for data isolation. |
ec_terminal_code | tim_terminale | character(4) | NO | ''::bpchar | Identifier of the physical or virtual terminal used. |
ec_badge_number | tim_badge | character(6) | NO | ''::bpchar | The badge or RF-ID code of the employee. |
ec_clocking_date | tim_data | date | NO | | Actual date of the event as reported by the device. |
ec_clocking_time_hhmm | tim_ora | numeric(4,0) | NO | 0 | Actual time of the event (format HHMM). |
ec_reason_code | tim_causale | character(4) | NO | ''::bpchar | Reason code entered during clocking (e.g., business trip, medical). |
ec_direction | tim_verso | character(2) | NO | ''::bpchar | Original direction typed or sensed: E=Entry, U=Exit. |
ec_processed_date | tim_data_elab | date | NO | | The date assigned to this clocking by the calculation engine (handling overnight shifts). |
ec_processed_direction | tim_verso_elab | character(2) | YES | ''::bpchar | Direction determined by the engine (E=Entry, U=Exit) after shift analysis. |
ec_is_excluded | tim_esclusa | boolean | YES | false | If true, this clocking is bypassed by the calculation engine. |
ec_is_manual_correction | tim_correzione | boolean | YES | false | True if the clocking was manually added or modified by an admin. |
ec_source_position_type | tim_posiz | numeric(1,0) | YES | 0 | Metadata on how the position was acquired (e.g., 0=GPS, 1=Beacon, etc.). |
ec_mobile_app_note | tim_app_text | character varying(200) | YES | ''::character varying | Textual notes attached to the clocking via the mobile application. |
ec_longitude | tim_longitudine | numeric(10,8) | YES | 0 | GPS Longitude coordinate of the event. |
ec_latitude | tim_latitudine | numeric(10,8) | YES | 0 | GPS Latitude captured from mobile app. |
ec_is_time_confirmed | tim_ora_confermata | numeric(1,0) | YES | 0 | Flag indicating if the time has been validated against a trusted NTP source. |
ec_address_confirmed_flag | tim_conferma_indirizzo | numeric(1,0) | YES | 0 | Confirmation that the GPS coordinates match a known company address. |
ec_document_id | tim_doc_id | integer | YES | | Optional reference to a linked document or justification request. |
ec_employment_contract_id | tim_rap_id | integer | NO | 0 | Internal reference to the specific employment relationship ID. |
ec_point_of_interest_confirmed_flag | tim_conferma_puntotim | numeric(1,0) | YES | 0 | Confirmation that the clocking occurred within a Geofence area. |
ec_reference_table_name | tim_tab_riferimento | character varying(20) | YES | | Name of the source table if the clocking was imported. |
ec_reference_table_id | tim_id_tab_riferimento | integer | YES | | Primary key value in the reference source table. |
ec_requires_verification | tim_da_verificare | numeric(1,0) | YES | 0 | Flag for clockings that trigger an anomaly or need manager approval. |
ec_has_gps_error | tim_errore_geolocalizzazione | numeric(1,0) | YES | 0 | Flag indicating a low-accuracy or spoofed GPS signal. |