hr._report_functions

Schema: hr
English table: hr._report_functions
Italian original table: hr._report_function
Description: Technical configuration table defining report functions, their parameters, and execution metadata.

Overview

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

Columns

English column	Italian original column	Type	Null	Default / Generated	Description
id	id	integer	NO		Surrogate primary key.
rf_report_function_id	repfn_id	integer	NO		Logical report function identifier (unique per tenant).
rf_name	repfn_name_fn	character varying(50)	NO		Display name of the report function.
rf_description	repfn_description	character varying(200)	NO		Description of the report function purpose.
rf_function_name	repfn_function	character varying(50)	NO		Database function name used to compute the report output.
rf_source_table	repfn_table	character varying(50)	NO		Source table/entity the report function is associated with.
rf_fractionation_code	repfn_fractionation	numeric(1,0)	NO		Fractionation code (stored as numeric(1,0)) controlling how results are split.
rf_arg1	repfn_arg1	character varying(50)	NO		First function argument (stored as text).
rf_arg2	repfn_arg2	character varying(50)	NO		Second function argument (stored as text).
rf_arg3	repfn_arg3	character varying(50)	NO		Third function argument (stored as text).
rf_criteria_code	repfn_criteria	numeric(1,0)	NO		Criteria code (stored as numeric(1,0)) driving report selection logic.
rf_select_function_name	repfn_select_function	character varying(50)	NO		Database function name used to select report rows.
rf_data_area_id	repfn_dta_id	integer	NO		Identifier of the related data area.
rf_type_code	repfn_type	character varying(1)	NO		Type code of the report function (stored as 1-character text).
rf_column_name	repfn_column_name	character varying(25)	NO		Column name involved in the report operation.
rf_operation_code	repfn_operation	character varying(1)	NO		Operation code applied by the report function (stored as 1-character text).
tenant_id	tenant_id	integer	YES		Tenant identifier for row-level security and data partitioning.

Relationships

Outgoing foreign keys

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

Referenced by

From table	Foreign key	Source columns	Target columns
hr.dynamic_lists	fk_dynamic_lists_report_function	report_function_code_id, tenant_id	rf_report_function_id, tenant_id

Constraints

• Primary key: pk_report_functions → id
• Unique: uk_rf_id_tenant → rf_report_function_id, tenant_id

Indexes

Name	Unique	Method	Columns / expression
idx_rf_tenant	NO	btree	tenant_id
idx_rf_tenant_name	NO	btree	tenant_id, rf_name
idx_rf_tenant_rf	NO	btree	tenant_id, rf_report_function_id

Navigation

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