hr.person_evaluations

Schema: hr
English table: hr.person_evaluations
Italian original table: hr.ana_valutazione
Description: Person evaluation record containing notes and ratings, linked to a person and compiled within a tenant context.

Overview

• Columns: 22
• Primary key: id
• Outgoing foreign keys: 1
• Incoming foreign keys: 0
• Indexes: 7

Columns

English column	Italian original column	Type	Null	Default / Generated	Description
id	id	integer	NO		Surrogate primary key.
anava_id	anava_id	integer	NO		Legacy evaluation identifier (unique within tenant).
anava_ana_id	anava_ana_id	integer	NO		Referenced person identifier for whom the evaluation is recorded.
anava_date	anava_date	date	NO		Evaluation date.
anava_note1	anava_note1	text	NO		Evaluation note 1 (free text).
anava_note2	anava_note2	text	NO		Evaluation note 2 (free text).
anava_note3	anava_note3	text	NO		Evaluation note 3 (free text).
anava_note4	anava_note4	text	NO		Evaluation note 4 (free text).
anava_compiler_ana_id	anava_compiler_ana_id	integer	NO		Person identifier of the compiler (who filled in the evaluation).
anava_conq_id	anava_conq_id	integer	NO		Contract qualification identifier associated with the evaluation context.
anava_conl_id	anava_conl_id	integer	NO		Contract level identifier associated with the evaluation context.
anava_num_child	anava_num_child	integer	NO		Number of children recorded at the time of evaluation.
anava_resp_ana_id	anava_resp_ana_id	integer	NO		Person identifier of the responsible supervisor/manager.
anava_note5	anava_note5	text	NO		Evaluation note 5 (free text).
anava_note1_rating	anava_note1_rating	numeric(5,2)	NO		Rating associated with evaluation note 1.
anava_note2_rating	anava_note2_rating	numeric(5,2)	NO		Rating associated with evaluation note 2.
anava_note3_rating	anava_note3_rating	numeric(5,2)	NO		Rating associated with evaluation note 3.
anava_note4_rating	anava_note4_rating	numeric(5,2)	NO		Rating associated with evaluation note 4.
anava_note5_rating	anava_note5_rating	numeric(5,2)	NO		Rating associated with evaluation note 5.
tenant_id	tenant_id	integer	YES		Tenant identifier for row ownership and partitioning.
colcustom	colcustom	jsonb	YES	'{}'::jsonb	Custom fields in JSON format.
_deleted	_deleted	boolean	YES	false	Soft delete flag.

Relationships

Outgoing foreign keys

Constraint	Local columns	References	Referenced columns	On update	On delete
fk_person_evaluations_tenant	tenant_id	cloud.tenants	ten_internal_id	RESTRICT	CASCADE

Referenced by

No incoming foreign keys found.

Constraints

• Primary key: pk_person_evaluations → id
• Unique: uk_person_evaluations_anava_id_tenant → anava_id, tenant_id

Indexes

Name	Unique	Method	Columns / expression
idx_pers_eval_tenant	NO	btree	tenant_id
idx_pers_eval_tenant_compiler	NO	btree	tenant_id, anava_compiler_ana_id) WHERE (_deleted = false
idx_pers_eval_tenant_contract_level	NO	btree	tenant_id, anava_conl_id) WHERE (_deleted = false
idx_pers_eval_tenant_contract_qualification	NO	btree	tenant_id, anava_conq_id) WHERE (_deleted = false
idx_pers_eval_tenant_eval_code	NO	btree	tenant_id, anava_id) WHERE (_deleted = false
idx_pers_eval_tenant_person	NO	btree	tenant_id, anava_ana_id) WHERE (_deleted = false
idx_pers_eval_tenant_responsible	NO	btree	tenant_id, anava_resp_ana_id) WHERE (_deleted = false

Navigation

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