`pres.daily_attendance_details`

Schema: pres
English table: pres.daily_attendance_details
Italian original table: pres.cartellino
Description: Atomic daily timesheet records containing raw clockings, theoretical shifts, and processed work/absence hours.

Overview

Columns: 46
Primary key: id
Outgoing foreign keys: 2
Incoming foreign keys: 1
Indexes: 4

Columns

English column	Italian original column	Type	Null	Default / Generated	Description
`id`	`id`	`integer`	NO		Identifier of the related record.
`dad_id`	`car_id`	`integer`	NO		Unique internal identifier for the daily record.
`tenant_id`	`tenant_id`	`integer`	NO		Identifier of the related tenant.
`dad_employment_id`	`car_rap_id`	`integer`	NO		Identifier of the related dad employment.
`dad_date`	`car_data`	`date`	NO		Reference date for the attendance record.
`dad_day_of_week`	`car_n_giorno`	`numeric(1,0)`	NO	`0`	Value of dad day of week.
`dad_is_holiday`	`car_festivo`	`boolean`	NO	`false`	Boolean flag for dad is holiday.
`dad_theoretical_clockings_str`	`car_timteo`	`character(100)`	NO	`''::bpchar`	Serialized string of expected clock-in/out times.
`dad_actual_clockings_str`	`car_timrea`	`character(100)`	NO	`''::bpchar`	Serialized string of raw clock-in/out events from terminals.
`dad_rounded_clockings_str`	`car_timarr`	`character(100)`	NO	`''::bpchar`	Value of dad rounded clockings str.
`dad_justifications_str`	`car_giustif`	`character(100)`	NO	`''::bpchar`	Value of dad justifications str.
`dad_shift_code`	`cod_ora`	`character(4)`	NO	`''::bpchar`	Code of dad shift code.
`dad_regular_hours`	`car_ore_ordinarie`	`numeric(6,2)`	NO	`0`	Value of dad regular hours.
`dad_excess_hours`	`car_ore_esubero`	`numeric(6,2)`	NO	`0`	Value of dad excess hours.
`dad_recovery_hours`	`car_ore_recupero`	`numeric(6,2)`	NO	`0`	Value of dad recovery hours.
`dad_overtime_hours`	`car_ore_straordin`	`numeric(6,2)`	NO	`0`	Time associated with dad overtime hours.
`dad_absence_hours`	`car_ore_assenza`	`numeric(6,2)`	NO	`0`	Value of dad absence hours.
`dad_workable_hours`	`car_ore_lavorabili`	`numeric(6,2)`	NO	`0`	Value of dad workable hours.
`dad_worked_hours`	`car_ore_lavorate`	`numeric(6,2)`	NO	`0`	Value of dad worked hours.
`dad_anomaly_code`	`car_anomalia`	`character(2)`	NO	`''::bpchar`	Two-character code identifying specific daily calculation errors.
`dad_is_locked`	`car_bollato`	`boolean`	NO	`false`	If true, the daily record is finalized and locked for payroll.
`dad_is_historical`	`car_storico`	`boolean`	NO	`false`	Boolean flag for dad is historical.
`dad_is_manually_forced`	`car_forzato`	`boolean`	NO	`false`	Boolean flag for dad is manually forced.
`dad_is_theoretical_forced`	`car_teo_forzato`	`boolean`	NO	`false`	Boolean flag for dad is theoretical forced.
`dad_department_code`	`car_reparto`	`character(4)`	NO	`''::bpchar`	Code of dad department code.
`dad_job_title_code`	`car_qualifica`	`character(4)`	NO	`''::bpchar`	Code of dad job title code.
`dad_role_code`	`car_mansione`	`character(4)`	NO	`''::bpchar`	Code of dad role code.
`dad_cost_center_code`	`car_cencos`	`character(4)`	NO	`''::bpchar`	Code of dad cost center code.
`dad_pay_grade_level`	`car_livello`	`character(4)`	NO	`''::bpchar`	Value of dad pay grade level.
`car_turno`	`car_turno`	`numeric(1,0)`	NO	`0`	Value of car turno.
`dad_late_entrance_1_mins`	`car_ritardo_1`	`numeric(3,0)`	NO	`0`	Value of dad late entrance 1 mins.
`dad_late_entrance_2_mins`	`car_ritardo_2`	`numeric(3,0)`	NO	`0`	Value of dad late entrance 2 mins.
`dad_is_missing_clocking`	`car_omessa`	`boolean`	NO	`false`	Boolean flag for dad is missing clocking.
`dad_excess_tier1_hours`	`car_esubero_f1`	`numeric(6,2)`	NO	`0`	Value of dad excess tier1 hours.
`dad_excess_tier2_hours`	`car_esubero_f2`	`numeric(6,2)`	NO	`0`	Value of dad excess tier2 hours.
`dad_excess_tier3_hours`	`car_esubero_f3`	`numeric(6,2)`	NO	`0`	Value of dad excess tier3 hours.
`dad_excess_tier4_hours`	`car_esubero_f4`	`numeric(6,2)`	NO	`0`	Value of dad excess tier4 hours.
`car_pausa_ok`	`car_pausa_ok`	`boolean`	YES	`false`	Boolean flag for car pausa ok.
`dad_clocked_minutes`	`car_ore_timbrature`	`numeric(4,0)`	NO	`0`	Value of dad clocked minutes.
`dad_actual_clocked_minutes`	`car_ore_timbrature_reali`	`numeric(4,0)`	NO	`0`	Value of dad actual clocked minutes.
`dad_is_theoretical_only`	`car_teorico`	`boolean`	NO	`false`	Boolean flag for dad is theoretical only.
`dad_paid_minutes`	`car_ore_retribuite`	`numeric(4,0)`	YES	`0`	Value of dad paid minutes.
`dad_week_number`	`car_n_settimana`	`integer`	YES	`0`	Numeric value for dad week number.
`dad_needs_review`	`car_controllo`	`boolean`	YES	`false`	Boolean flag for dad needs review.
`dad_is_workable_hours_forced`	`car_ore_lavorabili_forzate`	`boolean`	YES	`false`	Boolean flag for dad is workable hours forced.
`dad_forced_workable_hours_value`	`car_ore_lavorabili_forzate_val`	`integer`	YES	`0`	Value of dad forced workable hours value.

Relationships

Outgoing foreign keys

Constraint	Local columns	References	Referenced columns	On update	On delete
`fk_cartellino_rap_id_to_rapporti`	`tenant_id, dad_employment_id`	`hr.employment_relationships`	`tenant_id, er_id`	RESTRICT	CASCADE
`fk_dad_shift_type`	`tenant_id, dad_shift_code`	`pres.shift_definitions`	`tenant_id, shd_code`	CASCADE	RESTRICT

Referenced by

From table	Foreign key	Source columns	Target columns
`pres.daily_attendance_hours_distribution`	`fk_dahd_daily_attendance`	`tenant_id, dahd_daily_attendance_id`	`tenant_id, dad_id`

Constraints

Primary key: pk_daily_attendance_details → id
Unique: c_uk_dad_employment_date_tenant → tenant_id, dad_employment_id, dad_date
Unique: c_uk_dad_id_tenant → tenant_id, dad_id

Indexes

Name	Unique	Method	Columns / expression
`idx_cartellino_car_anomalia`	NO	`btree`	`tenant_id, dad_anomaly_code`
`idx_cartellino_car_bollato`	NO	`btree`	`tenant_id, dad_is_locked`
`idx_cartellino_car_rap_id`	NO	`btree`	`tenant_id, dad_employment_id`
`idx_cartellino_car_teorico`	NO	`btree`	`tenant_id, dad_is_theoretical_only`

Back to main index
[Back to pres index]../)

Overview​

Columns​

Relationships​

Outgoing foreign keys​

Referenced by​

Constraints​

Indexes​

Navigation​