hr._payslip_marker

Schema: hr
English table: hr._payslip_marker
Italian original table: hr._cedolini_marker
Description: Definitions used by the payslip PDF parser: markers/tokens to search and their expected positions (coordinates and offsets) to extract values.

Overview

• Columns: 20
• 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.
psm_id	cedma_id	integer	NO		Logical marker identifier (unique per tenant).
psm_title	cedma_title	character varying(100)	NO		Marker title/label used for configuration and readability.
psm_table	cedma_table	character varying(50)	NO		Target table name (logical) where the extracted value will be written/mapped.
psm_field	cedma_field	character varying(50)	NO		Target field/column name (logical) where the extracted value will be written/mapped.
psm_pos_in_x	cedma_posinx	numeric(16,12)	NO		Expected X coordinate of the first point/anchor (PDF coordinate system).
psm_pos_in_y	cedma_posiny	numeric(16,12)	NO		Expected Y coordinate of the first point/anchor (PDF coordinate system).
psm_offset_x	cedma_offset_x	numeric(16,12)	NO		X offset applied to the detected anchor/area when extracting the value.
psm_offset_y	cedma_offset_y	numeric(16,12)	NO		Y offset applied to the detected anchor/area when extracting the value.
psm_header	cedma_header	character varying(100)	NO		Text header/anchor to locate the marker in the PDF.
psm_fld_id	cedma_fld_id	integer	NO		Internal field identifier used by the extraction/mapping engine.
psm_pos_in_x2	cedma_posinx2	numeric(16,12)	NO		Expected X coordinate of the second point (used to define a bounding box/area).
psm_pos_in_y2	cedma_posiny2	numeric(16,12)	NO		Expected Y coordinate of the second point (used to define a bounding box/area).
psm_payslip_template_id	cedma_cedtempl_id	integer	NO		Reference to the payslip template this marker belongs to.
psm_pdf_extraction_type_id	cedma_xties_id	integer	NO		Extraction type/strategy used by the PDF parser for this marker.
psm_delete_duplicates	cedma_delete_duplicates	boolean	NO		If true, remove duplicated extracted tokens/values.
psm_group	cedma_gruppo	integer	NO		Marker group (used to organize markers and/or apply grouped extraction logic).
psm_ocr	cedma_delete_space	boolean	NO		If true, OCR is enabled/required for this marker extraction.
tenant_id	cedma_ocr	integer	YES		Tenant identifier (multi-tenant isolation).
psm_delete_space	tenant_id	boolean	YES		If true, remove spaces from the extracted value (post-processing).

Relationships

Outgoing foreign keys

Constraint	Local columns	References	Referenced columns	On update	On delete
fk_psm_payslip_template	psm_payslip_template_id, tenant_id	hr._payslip_template	pst_id, tenant_id	RESTRICT	RESTRICT
fk_psm_pdf_extraction_type	psm_pdf_extraction_type_id, tenant_id	hr.x_pdf_extraction_type	pxet_id, tenant_id	RESTRICT	RESTRICT
fk_psm_tenant	tenant_id	cloud.tenants	ten_internal_id	RESTRICT	CASCADE

Referenced by

No incoming foreign keys found.

Constraints

• Primary key: _payslip_marker_pkey → id
• Unique: uk_psm_id_tenant → psm_id, tenant_id

Indexes

Name	Unique	Method	Columns / expression
idx__payslip_marker_tenant	NO	btree	tenant_id
idx_payslip_marker_group_tenant	NO	btree	tenant_id, psm_group
idx_payslip_marker_template_group_tenant	NO	btree	tenant_id, psm_payslip_template_id, psm_group
idx_payslip_marker_template_tenant	NO	btree	tenant_id, psm_payslip_template_id

Navigation

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