hr.agreement_seniority_steps
Schema: hr
English table: hr.agreement_seniority_steps
Italian original table: hr.con_scatti
Description: Definitions for automatic seniority-based salary increases (scatti di anzianità) within a Collective Labor Agreement.
Overview
- Columns: 12
- Primary key: id
- Outgoing foreign keys: 1
- Incoming foreign keys: 0
- Indexes: 4
Columns
| English column | Italian original column | Type | Null | Default / Generated | Description |
|---|---|---|---|---|---|
id | id | integer | NO | Internal surrogate primary key. | |
ass_code | cons_id | integer | NO | Business identifier of the seniority step definition, unique per tenant. | |
ass_agreement_code | con_id | integer | NO | Contract business code this seniority step refers to (per tenant). | |
ass_type | cons_tipo | character varying(1) | NO | Step type code (single-character domain value). | |
ass_level_code | cons_conl_id | integer | NO | Contract level business code this seniority step refers to (per tenant). | |
ass_continues_previous_step | cons_continua_prec | numeric(1,0) | NO | Numeric flag indicating continuity with the previous step (as stored in source data). | |
ass_sequence | cons_sequenza | numeric(2,0) | NO | Sequence number of the step within the contract/level progression. | |
ass_period_type | cons_tipo_periodo | character varying(1) | NO | Period type code (single-character domain value) used to interpret period_value. | |
ass_period_value | cons_periodo | numeric(3,0) | NO | Period value (e.g., number of units defined by period_type). | |
tenant_id | tenant_id | integer | YES | Tenant identifier for multi-tenant partitioning. | |
colcustom | colcustom | jsonb | YES | '{}'::jsonb | Custom fields in JSON format. |
_deleted | _deleted | boolean | YES | false | Soft-delete flag. True means the record is logically deleted. |
Relationships
Outgoing foreign keys
| Constraint | Local columns | References | Referenced columns | On update | On delete |
|---|---|---|---|---|---|
fk_ass_tenant | tenant_id | cloud.tenants | ten_internal_id | RESTRICT | CASCADE |
Referenced by
No incoming foreign keys found.
Constraints
- Primary key:
pk_ass→id - Unique:
uk_ass_code_tenant→ass_code, tenant_id
Indexes
| Name | Unique | Method | Columns / expression |
|---|---|---|---|
idx_ass_agreement_tenant | NO | btree | tenant_id, ass_agreement_code) WHERE (_deleted = false |
idx_ass_code_tenant | NO | btree | tenant_id, ass_code) WHERE (_deleted = false |
idx_ass_level_tenant | NO | btree | tenant_id, ass_level_code) WHERE (_deleted = false |
idx_ass_tenant | NO | btree | tenant_id |
Navigation
- Back to main index
- [Back to
hrindex]../)