`hr.agreement_levels`

Schema: hr
English table: hr.agreement_levels
Italian original table: hr.con_livelli
Description: Graduated steps (Levels/Grades) within an agreement qualification, defining the pay grid and seniority progression.

Overview

Columns: 29
Primary key: id
Outgoing foreign keys: 2
Incoming foreign keys: 4
Indexes: 3

Columns

English column	Italian original column	Type	Null	Default / Generated	Description
`id`	`id`	`integer`	NO		Surrogate primary key.
`al_code`	`conl_id`	`integer`	NO		Business identifier of the contract level, unique per tenant.
`al_agreement_qualification_code`	`conl_conq_id`	`integer`	NO		Reference to the related contract qualification (business code), unique per tenant.
`al_description`	`conl_descrizione`	`character varying(50)`	NO		Description/label of the contract level.
`al_sort_order`	`conl_order`	`numeric(3,0)`	NO		Ordering value used to sort levels within the same qualification.
`al_sync_code`	`conl_code_syncro`	`character varying(10)`	NO		External synchronization code for integrations.
`al_value_01`	`conl_v1`	`numeric(10,2)`	NO		Configurable numeric value 1 associated with this contract level.
`al_value_02`	`conl_v2`	`numeric(10,2)`	NO		Configurable numeric value 2 associated with this contract level.
`al_value_03`	`conl_v3`	`numeric(10,2)`	NO		Configurable numeric value 3 associated with this contract level.
`al_value_04`	`conl_v4`	`numeric(10,2)`	NO		Configurable numeric value 4 associated with this contract level.
`al_value_05`	`conl_v5`	`numeric(10,2)`	NO		Configurable numeric value 5 associated with this contract level.
`al_value_06`	`conl_v6`	`numeric(10,2)`	NO		Configurable numeric value 6 associated with this contract level.
`al_value_07`	`conl_v7`	`numeric(10,2)`	NO		Configurable numeric value 7 associated with this contract level.
`al_value_08`	`conl_v8`	`numeric(10,2)`	NO		Configurable numeric value 8 associated with this contract level.
`al_value_09`	`conl_v9`	`numeric(10,2)`	NO		Configurable numeric value 9 associated with this contract level.
`al_value_10`	`conl_v10`	`numeric(10,2)`	NO		Configurable numeric value 10 associated with this contract level.
`al_value_11`	`conl_v11`	`numeric(10,2)`	NO		Configurable numeric value 11 associated with this contract level.
`al_value_12`	`conl_v12`	`numeric(10,2)`	NO		Configurable numeric value 12 associated with this contract level.
`al_value_13`	`conl_v13`	`numeric(10,2)`	NO		Configurable numeric value 13 associated with this contract level.
`al_value_14`	`conl_v14`	`numeric(10,2)`	NO		Configurable numeric value 14 associated with this contract level.
`al_value_15`	`conl_v15`	`numeric(10,2)`	NO		Configurable numeric value 15 associated with this contract level.
`al_value_16`	`conl_v16`	`numeric(10,2)`	NO		Configurable numeric value 16 associated with this contract level.
`al_value_17`	`conl_v17`	`numeric(10,2)`	NO		Configurable numeric value 17 associated with this contract level.
`al_value_18`	`conl_v18`	`numeric(10,2)`	NO		Configurable numeric value 18 associated with this contract level.
`al_value_19`	`conl_v19`	`numeric(10,2)`	NO		Configurable numeric value 19 associated with this contract level.
`al_value_20`	`conl_v20`	`numeric(10,2)`	NO		Configurable numeric value 20 associated with this contract level.
`tenant_id`	`tenant_id`	`integer`	YES		Tenant identifier for row ownership and RLS filtering.
`colcustom`	`colcustom`	`jsonb`	YES	`'{}'::jsonb`	Custom fields in JSON format.
`_deleted`	`_deleted`	`boolean`	YES	`false`	Soft-delete flag (technical).

Relationships

Outgoing foreign keys

Constraint	Local columns	References	Referenced columns	On update	On delete
`fk_al_agreement_qualification`	`al_agreement_qualification_code, tenant_id`	`hr.agreement_qualifications`	`aq_code, tenant_id`	RESTRICT	RESTRICT
`fk_al_tenant`	`tenant_id`	`cloud.tenants`	`ten_internal_id`	RESTRICT	CASCADE

Referenced by

From table	Foreign key	Source columns	Target columns
`hr.contract_level_job_links`	`fk_cljl_contract_level`	`contract_level_code, tenant_id`	`al_code, tenant_id`
`hr.contract_level_job_links`	`fk_conl_id`	`contract_level_code, tenant_id`	`al_code, tenant_id`
`hr.employment_relationship_details`	`fk_erd_job_level_id`	`erd_job_level_id, tenant_id`	`al_code, tenant_id`
`hr.medical_exam_type_parameters`	`fk_metp_job_level_id`	`metp_job_level_id, tenant_id`	`al_code, tenant_id`

Constraints

Primary key: pk_al → id
Unique: uk_al_code_tenant → al_code, tenant_id

Indexes

Name	Unique	Method	Columns / expression
`idx_al_code_tenant`	NO	`btree`	`tenant_id, al_code) WHERE (_deleted = false`
`idx_al_qualification_tenant`	NO	`btree`	`tenant_id, al_agreement_qualification_code) WHERE (_deleted = false`
`idx_al_tenant`	NO	`btree`	`tenant_id`

Back to main index
[Back to hr index]../)

Overview​

Columns​

Relationships​

Outgoing foreign keys​

Referenced by​

Constraints​

Indexes​

Navigation​