pres.leave_transformation_rules
Schema: pres
English table: pres.leave_transformation_rules
Italian original table: pres.cnf_ferie_rule
Description: Rules for automatically transforming generic absence reasons into specific ones based on priority and thresholds.
Overview
- Columns: 15
- Primary key: id
- Outgoing foreign keys: 4
- 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. | |
ltr_id | fer_id | integer | NO | Identifier of the related ltr. | |
tenant_id | tenant_id | integer | NO | Identifier of the related tenant. | |
ltr_company_id | fer_az_id | integer | NO | Identifier of the related ltr company. | |
ltr_start_date | fer_dalla_data | date | NO | Date associated with ltr start date. | |
ltr_end_date | fer_alla_data | date | NO | Date associated with ltr end date. | |
ltr_execution_priority | fer_sequenza | integer | NO | The order in which rules are evaluated (lowest first). | |
ltr_source_reason_code | fer_causale_origine | character(4) | NO | ''::bpchar | The original reason code entered in the system. |
ltr_counter_type | fer_tipo_contatore | character(6) | NO | ''::bpchar | Value of ltr counter type. |
ltr_target_reason_code | fer_codice | character(4) | NO | ''::bpchar | The final reason code after the rule is applied. |
ltr_counter_id | fer_cnt_id | integer | NO | Identifier of the related ltr counter. | |
ltr_absence_type | fer_tipo_assenza | character(2) | NO | ''::bpchar | Value of ltr absence type. |
ltr_max_minutes_threshold | fer_max_minuti | integer | NO | Maximum duration in minutes for this rule to trigger. | |
ltr_min_minutes_threshold | fer_limite_minimo | integer | NO | Value of ltr min minutes threshold. | |
ltr_validity_period | fer_periodo | daterange | YES | GENERATED: daterange(ltr_start_date, ltr_end_date, '[]'::text) | The daterange during which this rule is active. |
Relationships
Outgoing foreign keys
| Constraint | Local columns | References | Referenced columns | On update | On delete |
|---|---|---|---|---|---|
fk_cnf_ferie_rule_fer_az_id_to_aziende | tenant_id, ltr_company_id | hr.companies | tenant_id, cmp_id | CASCADE | RESTRICT |
fk_ltr_source_reason | tenant_id, ltr_source_reason_code | pres.attendance_reasons | tenant_id, ar_code | CASCADE | RESTRICT |
fk_ltr_target_reason | tenant_id, ltr_target_reason_code | pres.attendance_reasons | tenant_id, ar_code | CASCADE | RESTRICT |
fk_ltr_tenant | tenant_id | cloud.tenants | ten_internal_id | CASCADE | CASCADE |
Referenced by
No incoming foreign keys found.
Constraints
- Primary key:
pk_leave_transformation_rules→id - Unique:
c_uk_ltr_id_tenant→tenant_id, ltr_id
Indexes
| Name | Unique | Method | Columns / expression |
|---|---|---|---|
idx_cnf_ferie_rule_fer_az_id | NO | btree | tenant_id, ltr_company_id |
idx_cnf_ferie_rule_fer_causale_origine | NO | btree | tenant_id, ltr_source_reason_code |
idx_cnf_ferie_rule_fer_periodo | NO | gist | ltr_validity_period |
Navigation
- Back to main index
- [Back to
presindex]../)