`pres.monthly_payroll_print_layouts`

Schema: pres
English table: pres.monthly_payroll_print_layouts
Italian original table: pres.descri_mese
Description: Stores pre-formatted strings for monthly LUL (Libro Unico del Lavoro) and attendance reports generation.

Overview

Columns: 18
Primary key: id
Outgoing foreign keys: 2
Incoming foreign keys: 0
Indexes: 1

Columns

English column	Italian original column	Type	Null	Default / Generated	Description
`id`	`id`	`integer`	NO		Identifier of the related record.
`mppl_id`	`desc_id`	`integer`	NO		Identifier of the related mppl.
`tenant_id`	`tenant_id`	`integer`	NO		Identifier of the related tenant.
`mppl_employment_id`	`desc_rap_id`	`integer`	NO	`0`	Identifier of the related mppl employment.
`mppl_reference_date`	`desc_data`	`date`	NO		Date associated with mppl reference date.
`mppl_calendar_days_str`	`desc_calen`	`character(250)`	NO	`''::bpchar`	String representation of calendar days (e.g., weekdays, holidays).
`mppl_regular_hours_str`	`desc_ordin`	`character(250)`	NO	`''::bpchar`	Positional string of daily regular hours for the entire month.
`mppl_overtime_hours_str`	`desc_strao`	`character(250)`	NO	`''::bpchar`	Time associated with mppl overtime hours str.
`mppl_shifts_str`	`desc_turno`	`character(250)`	NO	`''::bpchar`	Value of mppl shifts str.
`mppl_justifications_tier1_str`	`desc_giu1`	`character(250)`	NO	`''::bpchar`	String representation of primary justifications/leave codes.
`mppl_justifications_tier2_str`	`desc_giu2`	`character(250)`	NO	`''::bpchar`	Value of mppl justifications tier2 str.
`mppl_justifications_tier3_str`	`desc_giu3`	`character(250)`	NO	`''::bpchar`	Value of mppl justifications tier3 str.
`mppl_justifications_tier4_str`	`desc_giu4`	`character(250)`	NO	`''::bpchar`	Value of mppl justifications tier4 str.
`mppl_justifications_tier5_str`	`desc_giu5`	`character(250)`	NO	`''::bpchar`	Value of mppl justifications tier5 str.
`mppl_custom_area_1`	`desc_area1`	`text`	YES		Value of mppl custom area 1.
`mppl_custom_area_2`	`desc_area2`	`text`	YES		Value of mppl custom area 2.
`mppl_custom_area_3`	`desc_area3`	`text`	YES		Value of mppl custom area 3.
`mppl_custom_area_4`	`desc_area4`	`text`	YES		Value of mppl custom area 4.

Relationships

Outgoing foreign keys

Constraint	Local columns	References	Referenced columns	On update	On delete
`fk_descri_mese_desc_rap_id_to_rapporti`	`tenant_id, mppl_employment_id`	`hr.employment_relationships`	`tenant_id, er_id`	RESTRICT	CASCADE
`fk_mppl_tenant`	`tenant_id`	`cloud.tenants`	`ten_internal_id`	CASCADE	CASCADE

Referenced by

No incoming foreign keys found.

Constraints

Primary key: pk_monthly_payroll_print_layouts → id
Unique: c_uk_mppl_employment_date_tenant → tenant_id, mppl_employment_id, mppl_reference_date
Unique: c_uk_mppl_id_tenant → tenant_id, mppl_id

Indexes

Name	Unique	Method	Columns / expression
`idx_mppl_date_lookup`	NO	`btree`	`tenant_id, mppl_reference_date`

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

Overview​

Columns​

Relationships​

Outgoing foreign keys​

Referenced by​

Constraints​

Indexes​

Navigation​