pres.daily_attendance_justifications
Schema: pres
English table: pres.daily_attendance_justifications
Italian original table: pres.giust_giorno
Description: Daily breakdown of justifications (leave, sickness, permits) linked to the attendance sheet.
Overview
- Columns: 14
- Primary key: id
- Outgoing foreign keys: 3
- Incoming foreign keys: 0
- Indexes: 3
Columns
| English column | Italian original column | Type | Null | Default / Generated | Description |
|---|---|---|---|---|---|
id | id | integer | NO | Identifier of the related record. | |
daj_id | gig_id | integer | NO | Identifier of the related daj. | |
tenant_id | tenant_id | integer | NO | Identifier of the related tenant. | |
daj_employment_id | gig_rap_id | integer | NO | 0 | Identifier of the related daj employment. |
daj_date | gig_data | date | NO | Date associated with daj date. | |
daj_reason_code | gig_cod_giust | character(4) | NO | ''::bpchar | Code of daj reason code. |
daj_hours_amount | gig_ore_giust | numeric(10,2) | YES | 0 | Value of daj hours amount. |
daj_source_type | gig_provenienza | character(2) | NO | ''::bpchar | Code indicating the origin of the entry (e.g., UI, Import, System). |
daj_is_automatic | gig_automatico | boolean | NO | false | Boolean flag for daj is automatic. |
daj_is_cancelled | gig_annullato | boolean | NO | false | Boolean flag for daj is cancelled. |
daj_is_manually_forced | gig_forzato | boolean | NO | false | Boolean flag for daj is manually forced. |
daj_start_time_int | gig_dalle_ore | numeric(4,0) | NO | 0 | Start time of the justification in HHMM format (as integer). |
daj_end_time_int | gig_alle_ore | numeric(4,0) | NO | 0 | Time associated with daj end time int. |
daj_document_id | gig_doc_id | integer | NO | 0 | Reference to an external document or attachment (e.g., medical certificate ID). |
Relationships
Outgoing foreign keys
| Constraint | Local columns | References | Referenced columns | On update | On delete |
|---|---|---|---|---|---|
fk_daj_reason_definition | tenant_id, daj_reason_code | pres.attendance_reasons | tenant_id, ar_code | CASCADE | RESTRICT |
fk_daj_tenant | tenant_id | cloud.tenants | ten_internal_id | CASCADE | CASCADE |
fk_giust_giorno_gig_rap_id_to_rapporti | tenant_id, daj_employment_id | hr.employment_relationships | tenant_id, er_id | RESTRICT | CASCADE |
Referenced by
No incoming foreign keys found.
Constraints
- Primary key:
pk_daily_attendance_justifications→id - Unique:
c_uk_daj_id_tenant→tenant_id, daj_id
Indexes
| Name | Unique | Method | Columns / expression |
|---|---|---|---|
idx_daj_date_lookup | NO | btree | tenant_id, daj_date |
idx_daj_date_reason_lookup | NO | btree | tenant_id, daj_date, daj_reason_code |
idx_daj_employment_date_lookup | NO | btree | tenant_id, daj_employment_id, daj_date |
Navigation
- Back to main index
- [Back to
presindex]../)