hr.dynamic_lists
Schema: hr
English table: hr.dynamic_lists
Italian original table: hr.lista_dinamic
Description: Definitions for dynamic employee filtering and listing criteria.
Overview
- Columns: 15
- 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 | Internal unique identifier (surrogate key). | |
list_code_id | ld_id | integer | NO | Functional list identifier, unique within the tenant. | |
description | ld_descrizione | character varying(50) | NO | Descriptive name of the dynamic list. | |
active_employees_only | ld_dipendenti_in_forza | boolean | NO | Flag to filter only currently employed personnel. | |
start_date | ld_data | date | NO | Reference start date for the list logic. | |
notes | ld_note | text | NO | General notes or usage instructions for the list. | |
use_variable | ld_usa_variabile | boolean | NO | Boolean flag to enable variable-based logic. | |
variable_name | ld_variabile | character varying(50) | NO | Name of the variable used in the list filtering. | |
end_date | ld_data_al | date | NO | Reference end date for the list logic. | |
use_functions | ld_usa_funzioni | boolean | NO | Boolean flag to enable report function-based logic. | |
report_function_code_id | ld_repfn_id | integer | NO | Reference to the report function code id. | |
tenant_id | tenant_id | integer | YES | Tenant identifier for data isolation. | |
colcustom | colcustom | jsonb | YES | '{}'::jsonb | Custom metadata fields in JSON format. |
_deleted | _deleted | boolean | YES | false | Technical flag for soft delete. |
validity_period | ld_periodo | daterange | YES | GENERATED: daterange(start_date, end_date, '[]'::text) | Daterange representing the window of validity for the list. |
Relationships
Outgoing foreign keys
| Constraint | Local columns | References | Referenced columns | On update | On delete |
|---|---|---|---|---|---|
fk_dynamic_lists_report_function | report_function_code_id, tenant_id | hr._report_functions | rf_report_function_id, tenant_id | RESTRICT | RESTRICT |
fk_dynamic_lists_tenant | tenant_id | cloud.tenants | ten_internal_id | RESTRICT | CASCADE |
Referenced by
| From table | Foreign key | Source columns | Target columns |
|---|---|---|---|
hr.dynamic_list_details | fk_dynamic_list_details_list | list_code_id, tenant_id | list_code_id, tenant_id |
Constraints
- Primary key:
pk_dynamic_lists→id - Unique:
uk_dynamic_lists_code_tenant→list_code_id, tenant_id
Indexes
| Name | Unique | Method | Columns / expression |
|---|---|---|---|
idx_dl_code_tenant | NO | btree | tenant_id, list_code_id) WHERE (_deleted = false |
idx_dl_report_function_tenant | NO | btree | tenant_id, report_function_code_id) WHERE (_deleted = false |
idx_dl_validity_period_gist | NO | gist | tenant_id, validity_period) WHERE (_deleted = false |
idx_dynamic_lists_tenant | NO | btree | tenant_id |
Navigation
- Back to main index
- [Back to
hrindex]../)