hr.performance_evaluation_forms

Schema: hr
English table: hr.performance_evaluation_forms
Italian original table: hr.scheda_valutazione
Description: Templates for performance evaluations, typically linked to specific job positions.

Overview

• Columns: 8
• Primary key: id
• Outgoing foreign keys: 2
• Incoming foreign keys: 1
• Indexes: 3

Columns

English column	Italian original column	Type	Null	Default / Generated	Description
id	id	integer	NO		Surrogate primary key.
pef_id	scva_id	integer	NO		Business identifier for the evaluation form.
pef_title	scva_title	character varying(100)	NO		The name of the evaluation template (e.g., Annual Sales Review).
pef_description	scva_description	text	NO		Detailed instructions or description of the evaluation process.
pef_position_id	scva_ru_id	integer	NO		Reference to the job position this form is designed for.
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_scva_role_id	pef_position_id, tenant_id	hr.positions	pos_code_id, tenant_id	RESTRICT	RESTRICT
fk_tenant_id	tenant_id	cloud.tenants	ten_internal_id	RESTRICT	CASCADE

Referenced by

From table	Foreign key	Source columns	Target columns
hr.performance_evaluation_form_items	fk_scval_scava_id	pefi_form_id, tenant_id	pef_id, tenant_id

Constraints

• Primary key: pk_performance_evaluation_forms → id
• Unique: uk_pef_id_tenant → pef_id, tenant_id

Indexes

Name	Unique	Method	Columns / expression
idx_pef_id_tenant	NO	btree	tenant_id, pef_id) WHERE (_deleted = false
idx_pef_position_tenant	NO	btree	tenant_id, pef_position_id) WHERE (_deleted = false
idx_pef_tenant	NO	btree	tenant_id

Navigation

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