`hr.payslips`

Schema: hr
English table: hr.payslips
Italian original table: hr.in_cedolini
Description: Stores employee payslips (PDF and metadata) imported from payroll systems.

Overview

Columns: 27
Primary key: id
Outgoing foreign keys: 1
Incoming foreign keys: 0
Indexes: 6

Columns

English column	Italian original column	Type	Null	Default / Generated	Description
`id`	`id`	`integer`	NO		Internal primary key.
`ps_id`	`ced_id`	`integer`	NO		Unique identifier from the payroll provider.
`employment_relationship_id`	`ced_rap_id`	`integer`	NO		Reference to the employee relationship.
`file_id`	`ced_id_file`	`integer`	NO		Identifier of the document file.
`version`	`ced_versione`	`integer`	NO		Version number of the payslip document.
`employee_external_code`	`ced_coddip`	`character varying(6)`	NO		Legacy payroll code for the employee.
`page_from`	`ced_pag_dal`	`integer`	NO		Starting page number in the source PDF.
`page_to`	`ced_pag_al`	`integer`	NO		Ending page number in the source PDF.
`filename`	`ced_nomefile`	`character varying(200)`	NO		Original name of the payslip file.
`file_content`	`ced_file`	`bytea`	NO		Binary content of the payslip (PDF).
`created_on`	`ced_data_creazione`	`character varying(8)`	NO		Creation date (YYYYMMDD).
`modified_on`	`ced_data_modidfica`	`character varying(8)`	NO		Last modification date (YYYYMMDD).
`acquired_on`	`ced_data_acquisizione`	`character varying(8)`	NO		Import date into the system (YYYYMMDD).
`acquired_at_time`	`ced_ora_acquisizione`	`integer`	NO		Import time into the system (seconds/HHMMSS).
`is_imported`	`ced_import`	`boolean`	NO		Flag indicating if the record was bulk imported.
`payroll_period`	`ced_periodo`	`character varying(7)`	NO		Reference period (e.g., YYYY-MM).
`payment_month_index`	`ced_mensilita`	`integer`	NO		Additional month index (e.g., 13th or 14th salary).
`is_enabled`	`ced_enabled`	`boolean`	NO		Flag for payslip visibility/availability.
`first_opened_at`	`ced_datetime_prima_apertura`	`character varying(14)`	NO		Timestamp of first access by employee (YYYYMMDDHHMMSS).
`error_message`	`ced_errore`	`character varying(100)`	NO		Description of any processing errors.
`external_link`	`ced_link`	`text`	NO		URL or path to an external document storage.
`last_opened_at`	`ced_datetime_ultima_apertura`	`character varying(14)`	NO		Timestamp of last access by employee (YYYYMMDDHHMMSS).
`person_id`	`ced_ana_id`	`integer`	NO		Reference to the person registry.
`payslip_type_id`	`ced_xtipced_id`	`integer`	NO		Reference to the type of payslip (standard, bonus, etc.).
`tenant_id`	`tenant_id`	`integer`	YES		Multi-tenancy identifier.
`colcustom`	`colcustom`	`jsonb`	YES	`'{}'::jsonb`	JSON field for custom metadata.
`_deleted`	`_deleted`	`boolean`	YES	`false`	Soft delete technical flag.

Relationships

Outgoing foreign keys

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

Referenced by

No incoming foreign keys found.

Constraints

Primary key: pk_payslips → id
Unique: uk_payslips_ps_id → ps_id, tenant_id

Indexes

Name	Unique	Method	Columns / expression
`idx_ps_employment`	NO	`btree`	`tenant_id, employment_relationship_id) WHERE (_deleted = false`
`idx_ps_external_id`	NO	`btree`	`tenant_id, ps_id) WHERE (_deleted = false`
`idx_ps_period`	NO	`btree`	`tenant_id, payroll_period) WHERE (_deleted = false`
`idx_ps_person`	NO	`btree`	`tenant_id, person_id) WHERE (_deleted = false`
`idx_ps_tenant`	NO	`btree`	`tenant_id`
`idx_ps_type`	NO	`btree`	`tenant_id, payslip_type_id) WHERE (_deleted = false`

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

Overview​

Columns​

Relationships​

Outgoing foreign keys​

Referenced by​

Constraints​

Indexes​

Navigation​