`hr.employment_pay_components`

Schema: hr
English table: hr.employment_pay_components
Italian original table: hr.retribuzioni_elementi
Description: Specific payroll components (base pay, allowances, etc.) for each employment relationship per period.

Overview

Columns: 29
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.
`epc_id`	`retrele_id`	`integer`	NO		Identifier of the related epc record.
`epc_employment_relationship_id`	`retrele_rap_id`	`integer`	NO		Identifier of the related epc employment relationship record.
`epc_month`	`retrele_month`	`integer`	NO		The reference month for the pay components.
`epc_year`	`retrele_year`	`integer`	NO		The reference year for the pay components.
`epc_value_1`	`retrele_v1`	`numeric(10,2)`	NO		Pay element value 1, meaning depends on payroll engine mapping.
`epc_value_2`	`retrele_v2`	`numeric(10,2)`	NO		Pay element value 2, meaning depends on payroll engine mapping.
`epc_value_3`	`retrele_v3`	`numeric(10,2)`	NO		Pay element value 3, meaning depends on payroll engine mapping.
`epc_value_4`	`retrele_v4`	`numeric(10,2)`	NO		Pay element value 4, meaning depends on payroll engine mapping.
`epc_value_5`	`retrele_v5`	`numeric(10,2)`	NO		Pay element value 5, meaning depends on payroll engine mapping.
`epc_value_6`	`retrele_v6`	`numeric(10,2)`	NO		Pay element value 6, meaning depends on payroll engine mapping.
`epc_value_7`	`retrele_v7`	`numeric(10,2)`	NO		Pay element value 7, meaning depends on payroll engine mapping.
`epc_value_8`	`retrele_v8`	`numeric(10,2)`	NO		Pay element value 8, meaning depends on payroll engine mapping.
`epc_value_9`	`retrele_v9`	`numeric(10,2)`	NO		Pay element value 9, meaning depends on payroll engine mapping.
`epc_value_10`	`retrele_v10`	`numeric(10,2)`	NO		Pay element value 10, meaning depends on payroll engine mapping.
`epc_value_11`	`retrele_v11`	`numeric(10,2)`	NO		Pay element value 11, meaning depends on payroll engine mapping.
`epc_value_12`	`retrele_v12`	`numeric(10,2)`	NO		Pay element value 12, meaning depends on payroll engine mapping.
`epc_value_13`	`retrele_v13`	`numeric(10,2)`	NO		Pay element value 13, meaning depends on payroll engine mapping.
`epc_value_14`	`retrele_v14`	`numeric(10,2)`	NO		Pay element value 14, meaning depends on payroll engine mapping.
`epc_value_15`	`retrele_v15`	`numeric(10,2)`	NO		Pay element value 15, meaning depends on payroll engine mapping.
`epc_value_16`	`retrele_v16`	`numeric(10,2)`	NO		Pay element value 16, meaning depends on payroll engine mapping.
`epc_value_17`	`retrele_v17`	`numeric(10,2)`	NO		Pay element value 17, meaning depends on payroll engine mapping.
`epc_value_18`	`retrele_v18`	`numeric(10,2)`	NO		Pay element value 18, meaning depends on payroll engine mapping.
`epc_value_19`	`retrele_v19`	`numeric(10,2)`	NO		Pay element value 19, meaning depends on payroll engine mapping.
`epc_value_20`	`retrele_v20`	`numeric(10,2)`	NO		Pay element value 20, meaning depends on payroll engine mapping.
`epc_value_99`	`retrele_v99`	`numeric(10,2)`	NO		Special pay element value 99 (e.g., net rounding or specific totals).
`tenant_id`	`tenant_id`	`integer`	YES		Tenant identifier for data isolation.
`colcustom`	`colcustom`	`jsonb`	YES	`'{}'::jsonb`	JSON payload containing additional attributes.
`_deleted`	`_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_epc_employment_relationship`	`epc_employment_relationship_id, tenant_id`	`hr.employment_relationships`	`er_id, tenant_id`	RESTRICT	CASCADE
`fk_epc_tenant`	`tenant_id`	`cloud.tenants`	`ten_internal_id`	RESTRICT	CASCADE

Referenced by

No incoming foreign keys found.

Constraints

Primary key: pk_epc → id
Unique: uk_epc_id_tenant → epc_id, tenant_id

Indexes

Name	Unique	Method	Columns / expression
`idx_epc_emp_rel_period_tenant`	NO	`btree`	`tenant_id, epc_employment_relationship_id, epc_month, epc_year) WHERE (_deleted = false`
`idx_epc_emp_rel_tenant`	NO	`btree`	`tenant_id, epc_employment_relationship_id) WHERE (_deleted = false`
`idx_epc_id_tenant`	NO	`btree`	`tenant_id, epc_id) WHERE (_deleted = false`
`idx_epc_period_tenant`	NO	`btree`	`tenant_id, epc_month, epc_year) WHERE (_deleted = false`
`idx_epc_tenant`	NO	`btree`	`tenant_id`

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

Overview​

Columns​

Relationships​

Outgoing foreign keys​

Referenced by​

Constraints​

Indexes​

Navigation​