pres.attendance_status_realtime

Schema: pres
English table: pres.attendance_status_realtime
Italian original table: pres.asspre_auto
Description: Real-time automated dashboard for employee presence monitoring, synchronized with live clock-in events.

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.
asrt_id	ass_id	integer	NO		Internal identifier for the real-time status record.
tenant_id	tenant_id	integer	NO		Identifier of the related tenant.
asrt_employment_id	ass_rap_id	integer	NO	0	Identifier of the related asrt employment.
asrt_is_absent	ass_assente	boolean	NO	false	Real-time flag for absence status.
asrt_entrance_time	ass_ora_ingresso	character(10)	YES	''::bpchar	Real-time recorded entrance time.
asrt_reason_code	ass_causale	character(4)	YES	NULL::bpchar	Code of asrt reason code.
asrt_date_from	ass_periodo_dal	date	NO		Date associated with asrt date from.
asrt_date_to	ass_periodo_al	date	NO		Date associated with asrt date to.
asrt_theoretical_schedule_code	ass_teorico	character(4)	NO	''::bpchar	Code of asrt theoretical schedule code.
asrt_full_name	ass_nominativo	character(50)	YES	''::bpchar	Name of asrt full name.
asrt_company_name	ass_ragione_soc	character(60)	YES	''::bpchar	Name of asrt company name.
asrt_late_minutes	ass_ritardo	numeric(4,0)	YES	0	Value of asrt late minutes.
asrt_department_code	ass_reparto	character(4)	NO	''::bpchar	Code of asrt department code.
asrt_department_description	ass_desrep	character(100)	YES	''::bpchar	Description of asrt department description.
asrt_justification_description	ass_desgiust	character(100)	YES	''::bpchar	Description of asrt justification description.
asrt_is_present	ass_presente	boolean	NO	false	Real-time flag for presence status.

Relationships

Outgoing foreign keys

Constraint	Local columns	References	Referenced columns	On update	On delete
fk_asrt_tenant	tenant_id	cloud.tenants	ten_internal_id	CASCADE	CASCADE
fk_asspre_auto_ass_rap_id_to_rapporti	tenant_id, asrt_employment_id	hr.employment_relationships	tenant_id, er_id	RESTRICT	CASCADE

Referenced by

No incoming foreign keys found.

Constraints

• Primary key: pk_attendance_status_realtime → id
• Unique: c_uk_asrt_employment_tenant → tenant_id, asrt_employment_id
• Unique: c_uk_asrt_id_tenant → tenant_id, asrt_id

Indexes

Name	Unique	Method	Columns / expression
idx_asrt_absent_lookup	NO	btree	tenant_id, asrt_is_absent
idx_asrt_present_lookup	NO	btree	tenant_id, asrt_is_present

Navigation

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