hr.person_competency_assessments
Schema: hr
English table: hr.person_competency_assessments
Italian original table: hr.competenze_score
Description: Competency assessment scores assigned to a person within an organizational context and validity period.
Overview
- Columns: 12
- Primary key: id
- Outgoing foreign keys: 3
- Incoming foreign keys: 0
- Indexes: 6
Columns
| English column | Italian original column | Type | Null | Default / Generated | Description |
|---|---|---|---|---|---|
id | id | integer | NO | Surrogate primary key. | |
pca_id | comps_id | integer | NO | Person competency assessment internal identifier, unique per tenant. | |
pca_person_id | comps_ana_id | integer | NO | Reference to the person. | |
pca_org_unit_id | comps_org_id | integer | NO | Reference to the organizational unit or position context used for the assessment. | |
pca_score | comps_score | numeric(6,2) | NO | Assessment score value. | |
pca_status_id | comps_stato | integer | NO | Assessment status identifier. | |
pca_valid_from | comps_dal | date | NO | Start date of validity for the assessment. | |
tenant_id | tenant_id | integer | YES | Tenant identifier. | |
colcustom | colcustom | jsonb | YES | '{}'::jsonb | Custom fields in JSON format. |
_deleted | _deleted | boolean | YES | false | Soft delete flag. |
pca_valid_to | comps_al | date | YES | End date of validity for the assessment. | |
pca_valid_period | comps_periodo | daterange | YES | GENERATED: daterange(pca_valid_from, pca_valid_to, '[]'::text) | Validity period derived from valid_from and valid_to (inclusive). |
Relationships
Outgoing foreign keys
| Constraint | Local columns | References | Referenced columns | On update | On delete |
|---|---|---|---|---|---|
fk_prcpca_org_unit_id | pca_org_unit_id, tenant_id | hr.organization_units | ou_id, tenant_id | RESTRICT | RESTRICT |
fk_prcpca_person_id | pca_person_id, tenant_id | hr.person_registry | pr_id, tenant_id | RESTRICT | CASCADE |
fk_prcpca_tenant_id | tenant_id | cloud.tenants | ten_internal_id | RESTRICT | CASCADE |
Referenced by
No incoming foreign keys found.
Constraints
- Primary key:
pk_person_competency_assessments→id - Unique:
uk_prcpca_pca_id_tenant→pca_id, tenant_id
Indexes
| Name | Unique | Method | Columns / expression |
|---|---|---|---|
idx_prcpca_tenant | NO | btree | tenant_id |
idx_prcpca_tenant_orgunit | NO | btree | tenant_id, pca_org_unit_id) WHERE (_deleted = false |
idx_prcpca_tenant_pca | NO | btree | tenant_id, pca_id) WHERE (_deleted = false |
idx_prcpca_tenant_period_gist | NO | gist | tenant_id, pca_valid_period) WHERE (_deleted = false |
idx_prcpca_tenant_person | NO | btree | tenant_id, pca_person_id) WHERE (_deleted = false |
idx_prcpca_tenant_person_period_gist | NO | gist | tenant_id, pca_person_id, pca_valid_period) WHERE (_deleted = false |
Navigation
- Back to main index
- [Back to
hrindex]../)