pres.attendance_status

Schema: pres
English table: pres.attendance_status
Italian original table: pres.asspre
Description: Real-time dashboard for employee attendance, monitoring presence, absence, late arrivals, and justification reasons.

Overview

• Columns: 17
• Primary key: id
• Outgoing foreign keys: 2
• Incoming foreign keys: 0
• Indexes: 2

Columns

English column	Italian original column	Type	Null	Default / Generated	Description
id	id	integer	NO		Identifier of the related record.
ast_id	ass_id	integer	NO		Internal unique identifier for the attendance record.
tenant_id	tenant_id	integer	NO		Identifier of the related tenant.
ast_employment_id	ass_rap_id	integer	NO	0	Reference to the employee employment contract (rapporto di lavoro).
ast_is_absent	ass_assente	boolean	NO	false	Flag indicating if the employee is currently marked as absent.
ast_entrance_time	ass_ora_ingresso	character(10)	YES	''::bpchar	Actual or expected entrance time recorded for the day.
ast_reason_code	ass_causale	character(4)	YES	NULL::bpchar	Code representing the reason for presence/absence (causale).
ast_date_from	ass_periodo_dal	date	NO		Date associated with ast date from.
ast_date_to	ass_periodo_al	date	NO		Date associated with ast date to.
ast_theoretical_schedule_code	ass_teorico	character(4)	NO	''::bpchar	Code for the theoretical work schedule assigned to the employee.
ast_full_name	ass_nominativo	character(50)	YES	''::bpchar	Name of ast full name.
ast_company_name	ass_ragione_soc	character(60)	YES	''::bpchar	Name of ast company name.
ast_late_minutes	ass_ritardo	numeric(4,0)	YES	0	Total minutes of late arrival calculated for the shift.
ast_department_code	ass_reparto	character(4)	NO	''::bpchar	Code of ast department code.
ast_department_description	ass_desrep	character(100)	YES	''::bpchar	Description of ast department description.
ast_justification_description	ass_desgiust	character(100)	YES	''::bpchar	Description of ast justification description.
ast_is_present	ass_presente	boolean	NO	false	Flag indicating if the employee is currently physically present.

Relationships

Outgoing foreign keys

Constraint	Local columns	References	Referenced columns	On update	On delete
fk_asspre_ass_rap_id_to_rapporti	tenant_id, ast_employment_id	hr.employment_relationships	tenant_id, er_id	RESTRICT	CASCADE
fk_ast_tenant	tenant_id	cloud.tenants	ten_internal_id	CASCADE	CASCADE

Referenced by

No incoming foreign keys found.

Constraints

• Primary key: pk_attendance_status → id
• Unique: c_uk_ast_employment_tenant → tenant_id, ast_employment_id
• Unique: c_uk_ast_id_tenant → tenant_id, ast_id

Indexes

Name	Unique	Method	Columns / expression
idx_ast_absent_lookup	NO	btree	tenant_id, ast_is_absent
idx_ast_present_lookup	NO	btree	tenant_id, ast_is_present

Navigation

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