hr.job_profiles

Schema: hr
English table: hr.job_profiles
Italian original table: hr.profilo_job
Description: Job profiles used for internal job configuration and cost allocation percentages (multi-tenant).

Overview

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

Columns

English column	Italian original column	Type	Null	Default / Generated	Description
id	id	integer	NO		Surrogate primary key.
jp_code	projob_id	integer	NO		Business identifier for the job profile (unique per tenant).
jp_description	projob_descrizione	text	NO		Job profile description.
jp_direct_cost_pct	projob_perc_costo_diretto	numeric(3,0)	NO		Direct cost percentage associated with the job profile.
jp_indirect_cost_pct	projob_perc_costo_indiretto	numeric(3,0)	NO		Indirect cost percentage associated with the job profile.
tenant_id	tenant_id	integer	YES		Tenant identifier.
colcustom	colcustom	jsonb	YES	'{}'::jsonb	Custom fields stored as JSON.
_deleted	_deleted	boolean	YES	false	Soft delete flag (technical).

Relationships

Outgoing foreign keys

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

Referenced by

From table	Foreign key	Source columns	Target columns
hr.job_role_profile_links	fk_jrpl_profile	jrpl_job_profile_code_id, tenant_id	jp_code, tenant_id
hr.organization_units	fk_ou_job_profile	ou_job_profile_id, tenant_id	jp_code, tenant_id

Constraints

• Primary key: pk_job_profiles → id
• Unique: uk_jp_code_tenant → jp_code, tenant_id

Indexes

Name	Unique	Method	Columns / expression
idx_jp_tenant	NO	btree	tenant_id
idx_jp_tenant_code	NO	btree	tenant_id, jp_code) WHERE (_deleted = false

Navigation

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