hr.position_competency_requirements
Schema: hr
English table: hr.position_competency_requirements
Italian original table: hr.ruoli_competenze
Description: Defines the minimum competency levels required for a specific organizational position (hr.positions).
Overview
- Columns: 10
- Primary key: id
- Outgoing foreign keys: 3
- Incoming foreign keys: 0
- Indexes: 4
Columns
| English column | Italian original column | Type | Null | Default / Generated | Description |
|---|
id | id | integer | NO | | Surrogate primary key. |
pcr_id | ruc_id | integer | NO | | Business identifier of the competency-role requirement (unique per tenant). |
pcr_position_code_id | ruc_ru_id | integer | NO | | Reference to the organizational position (hr.positions). |
pcr_competency_id | ruc_comp_id | integer | NO | | Reference to the required competency (hr.competencies). |
pcr_min_fval | ruc_comp_fval_min | numeric(5,0) | NO | | Minimum required fval value for the competency within the role requirement. |
pcr_min_eval | ruc_comp_eval_min | numeric(5,0) | NO | | Minimum required evaluation value for the competency within the role requirement. |
pcr_min_vval | ruc_comp_vval_min | numeric(5,0) | NO | | Minimum required vval value for the competency within the role requirement. |
tenant_id | tenant_id | integer | YES | | Tenant identifier. |
colcustom | colcustom | jsonb | YES | '{}'::jsonb | Custom fields (JSON). |
_deleted | _deleted | boolean | YES | false | Soft-delete flag. |
Relationships
Outgoing foreign keys
| Constraint | Local columns | References | Referenced columns | On update | On delete |
|---|
fk_pcr_competency | pcr_competency_id, tenant_id | hr.competencies | cpt_id, tenant_id | RESTRICT | RESTRICT |
fk_pcr_position | pcr_position_code_id, tenant_id | hr.positions | pos_code_id, tenant_id | RESTRICT | RESTRICT |
fk_pcr_tenant | tenant_id | cloud.tenants | ten_internal_id | RESTRICT | CASCADE |
Referenced by
No incoming foreign keys found.
Constraints
- Primary key:
pk_pcr → id
- Unique:
uk_pcr_id_tenant → pcr_id, tenant_id
Indexes
| Name | Unique | Method | Columns / expression |
|---|
idx_pcr_competency_tenant | NO | btree | tenant_id, pcr_competency_id) WHERE (_deleted = false |
idx_pcr_id_tenant | NO | btree | tenant_id, pcr_id) WHERE (_deleted = false |
idx_pcr_position_tenant | NO | btree | tenant_id, pcr_position_code_id) WHERE (_deleted = false |
idx_pcr_tenant | NO | btree | tenant_id |
Navigation