`hr.employment_compensation_costs`

Schema: hr
English table: hr.employment_compensation_costs
Italian original table: hr.retribuzioni_costi
Description: Detailed monthly labor costs per employment relationship. Values from 1 to 40 represent specific cost components mapped via system configuration.

Overview

Columns: 68
Primary key: id
Outgoing foreign keys: 2
Incoming foreign keys: 0
Indexes: 5

Columns

English column	Italian original column	Type	Null	Default / Generated	Description
`id`	`id`	`integer`	NO		Surrogate primary key.
`ecc_id`	`retrco_id`	`integer`	NO		Identifier of the related ecc record.
`ecc_employment_relationship_id`	`retrco_rap_id`	`integer`	NO		Identifier of the related ecc employment relationship record.
`ecc_month`	`retrco_month`	`integer`	NO		The reference month for the cost calculation (1-12).
`ecc_year`	`retrco_year`	`integer`	NO		The reference year for the cost calculation.
`ecc_value_1`	`retrco_v1`	`numeric(10,2)`	NO		Generic cost component value 1, meaning depends on payroll configuration.
`ecc_value_2`	`retrco_v2`	`numeric(10,2)`	NO		Generic cost component value 2, meaning depends on payroll configuration.
`ecc_value_3`	`retrco_v3`	`numeric(10,2)`	NO		Generic cost component value 3, meaning depends on payroll configuration.
`ecc_value_4`	`retrco_v4`	`numeric(10,2)`	NO		Generic cost component value 4, meaning depends on payroll configuration.
`ecc_value_5`	`retrco_v5`	`numeric(10,2)`	NO		Generic cost component value 5, meaning depends on payroll configuration.
`ecc_value_6`	`retrco_v6`	`numeric(10,2)`	NO		Generic cost component value 6, meaning depends on payroll configuration.
`ecc_value_7`	`retrco_v7`	`numeric(10,2)`	NO		Generic cost component value 7, meaning depends on payroll configuration.
`ecc_value_8`	`retrco_v8`	`numeric(10,2)`	NO		Generic cost component value 8, meaning depends on payroll configuration.
`ecc_value_9`	`retrco_v9`	`numeric(10,2)`	NO		Generic cost component value 9, meaning depends on payroll configuration.
`ecc_value_10`	`retrco_v10`	`numeric(10,2)`	NO		Generic cost component value 10, meaning depends on payroll configuration.
`ecc_value_11`	`retrco_v11`	`numeric(10,2)`	NO		Generic cost component value 11, meaning depends on payroll configuration.
`ecc_value_12`	`retrco_v12`	`numeric(10,2)`	NO		Generic cost component value 12, meaning depends on payroll configuration.
`ecc_value_13`	`retrco_v13`	`numeric(10,2)`	NO		Generic cost component value 13, meaning depends on payroll configuration.
`ecc_value_14`	`retrco_v14`	`numeric(10,2)`	NO		Generic cost component value 14, meaning depends on payroll configuration.
`ecc_value_15`	`retrco_v15`	`numeric(10,2)`	NO		Generic cost component value 15, meaning depends on payroll configuration.
`ecc_value_16`	`retrco_v16`	`numeric(10,2)`	NO		Generic cost component value 16, meaning depends on payroll configuration.
`ecc_value_17`	`retrco_v17`	`numeric(10,2)`	NO		Generic cost component value 17, meaning depends on payroll configuration.
`ecc_value_18`	`retrco_v18`	`numeric(10,2)`	NO		Generic cost component value 18, meaning depends on payroll configuration.
`ecc_value_19`	`retrco_v19`	`numeric(10,2)`	NO		Generic cost component value 19, meaning depends on payroll configuration.
`ecc_value_20`	`retrco_v20`	`numeric(10,2)`	NO		Generic cost component value 20, meaning depends on payroll configuration.
`ecc_value_21`	`retrco_v21`	`numeric(10,2)`	NO		Generic cost component value 21, meaning depends on payroll configuration.
`ecc_value_22`	`retrco_v22`	`numeric(10,2)`	NO		Generic cost component value 22, meaning depends on payroll configuration.
`ecc_value_23`	`retrco_v23`	`numeric(10,2)`	NO		Generic cost component value 23, meaning depends on payroll configuration.
`ecc_value_24`	`retrco_v24`	`numeric(10,2)`	NO		Generic cost component value 24, meaning depends on payroll configuration.
`ecc_value_25`	`retrco_v25`	`numeric(10,2)`	NO		Generic cost component value 25, meaning depends on payroll configuration.
`ecc_value_26`	`retrco_v26`	`numeric(10,2)`	NO		Generic cost component value 26, meaning depends on payroll configuration.
`ecc_value_27`	`retrco_v27`	`numeric(10,2)`	NO		Generic cost component value 27, meaning depends on payroll configuration.
`ecc_value_28`	`retrco_v28`	`numeric(10,2)`	NO		Generic cost component value 28, meaning depends on payroll configuration.
`ecc_value_29`	`retrco_v29`	`numeric(10,2)`	NO		Generic cost component value 29, meaning depends on payroll configuration.
`ecc_value_30`	`retrco_v30`	`numeric(10,2)`	NO		Generic cost component value 30, meaning depends on payroll configuration.
`ecc_value_31`	`retrco_v31`	`numeric(10,2)`	NO		Generic cost component value 31, meaning depends on payroll configuration.
`ecc_value_32`	`retrco_v32`	`numeric(10,2)`	NO		Generic cost component value 32, meaning depends on payroll configuration.
`ecc_value_33`	`retrco_v33`	`numeric(10,2)`	NO		Generic cost component value 33, meaning depends on payroll configuration.
`ecc_value_34`	`retrco_v34`	`numeric(10,2)`	NO		Generic cost component value 34, meaning depends on payroll configuration.
`ecc_value_35`	`retrco_v35`	`numeric(10,2)`	NO		Generic cost component value 35, meaning depends on payroll configuration.
`ecc_value_36`	`retrco_v36`	`numeric(10,2)`	NO		Generic cost component value 36, meaning depends on payroll configuration.
`ecc_value_37`	`retrco_v37`	`numeric(10,2)`	NO		Generic cost component value 37, meaning depends on payroll configuration.
`ecc_value_38`	`retrco_v38`	`numeric(10,2)`	NO		Generic cost component value 38, meaning depends on payroll configuration.
`ecc_value_39`	`retrco_v39`	`numeric(10,2)`	NO		Generic cost component value 39, meaning depends on payroll configuration.
`ecc_value_40`	`retrco_v40`	`numeric(10,2)`	NO		Generic cost component value 40, meaning depends on payroll configuration.
`retrco_v41`	`tenant_id`	`numeric(10,2)`	NO		Retrco v41.
`retrco_v42`	`colcustom`	`numeric(10,2)`	NO		Retrco v42.
`retrco_v43`	`_deleted`	`numeric(10,2)`	NO		Retrco v43.
`retrco_v44`	``	`numeric(10,2)`	NO		Retrco v44.
`retrco_v45`	``	`numeric(10,2)`	NO		Retrco v45.
`retrco_v46`	``	`numeric(10,2)`	NO		Retrco v46.
`retrco_v47`	``	`numeric(10,2)`	NO		Retrco v47.
`retrco_v48`	``	`numeric(10,2)`	NO		Retrco v48.
`retrco_v49`	``	`numeric(10,2)`	NO		Retrco v49.
`retrco_v50`	``	`numeric(10,2)`	NO		Retrco v50.
`retrco_v51`	``	`numeric(10,2)`	NO		Retrco v51.
`retrco_v52`	``	`numeric(10,2)`	NO		Retrco v52.
`retrco_v53`	``	`numeric(10,2)`	NO		Retrco v53.
`retrco_v54`	``	`numeric(10,2)`	NO		Retrco v54.
`retrco_v55`	``	`numeric(10,2)`	NO		Retrco v55.
`retrco_v56`	``	`numeric(10,2)`	NO		Retrco v56.
`retrco_v57`	``	`numeric(10,2)`	NO		Retrco v57.
`retrco_v58`	``	`numeric(10,2)`	NO		Retrco v58.
`retrco_v59`	``	`numeric(10,2)`	NO		Retrco v59.
`retrco_v60`	``	`numeric(10,2)`	NO		Retrco v60.
`tenant_id`	``	`integer`	YES		Tenant identifier for data isolation.
`colcustom`	``	`jsonb`	YES	`'{}'::jsonb`	JSON payload containing additional attributes.
`_deleted`	``	`boolean`	YES	`false`	Flag indicating whether the record is soft-deleted.

Relationships

Outgoing foreign keys

Constraint	Local columns	References	Referenced columns	On update	On delete
`fk_ecc_employment_relationship`	`ecc_employment_relationship_id, tenant_id`	`hr.employment_relationships`	`er_id, tenant_id`	RESTRICT	CASCADE
`fk_ecc_tenant`	`tenant_id`	`cloud.tenants`	`ten_internal_id`	RESTRICT	CASCADE

Referenced by

No incoming foreign keys found.

Constraints

Primary key: pk_ecc → id
Unique: uk_ecc_id_tenant → ecc_id, tenant_id

Indexes

Name	Unique	Method	Columns / expression
`idx_ecc_emp_rel_period_tenant`	NO	`btree`	`tenant_id, ecc_employment_relationship_id, ecc_month, ecc_year) WHERE (_deleted = false`
`idx_ecc_emp_rel_tenant`	NO	`btree`	`tenant_id, ecc_employment_relationship_id) WHERE (_deleted = false`
`idx_ecc_id_tenant`	NO	`btree`	`tenant_id, ecc_id) WHERE (_deleted = false`
`idx_ecc_period_tenant`	NO	`btree`	`tenant_id, ecc_month, ecc_year) WHERE (_deleted = false`
`idx_ecc_tenant`	NO	`btree`	`tenant_id`

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

Overview​

Columns​

Relationships​

Outgoing foreign keys​

Referenced by​

Constraints​

Indexes​

Navigation​