pres.payroll_additional_reasons
Schema: pres
English table: pres.payroll_additional_reasons
Italian original table: pres.causpaghe
Description: Manual or additional payroll reasons (bonuses, expenses, etc.) that are not automatically derived from daily attendance clockings.
Overview
- Columns: 10
- Primary key: id
- Outgoing foreign keys: 3
- Incoming foreign keys: 0
- Indexes: 0
Columns
| English column | Italian original column | Type | Null | Default / Generated | Description |
|---|---|---|---|---|---|
id | id | integer | NO | Identifier of the related record. | |
par_id | caup_id | integer | NO | Unique internal identifier for the payroll record. | |
tenant_id | tenant_id | integer | NO | Identifier of the related tenant. | |
par_employment_id | caup_rap_id | integer | NO | 0 | Identifier of the related par employment. |
par_reference_date | caup_data | date | NO | Reference date for the payroll entry. | |
par_reason_code | caup_cod_giust | character(4) | NO | ''::bpchar | Reference code for the justification/payroll reason. |
par_hours_amount | caup_ore | numeric(11,2) | NO | 0 | Quantity in hours (if applicable). |
par_monetary_value | caup_valore | numeric(11,2) | NO | 0 | Monetary amount or multiplier for the reason. |
par_is_forced | caup_forzato | boolean | NO | false | Flag to indicate if this value was manually forced by an operator. |
par_notes | caup_note | text | NO | Value of par notes. |
Relationships
Outgoing foreign keys
| Constraint | Local columns | References | Referenced columns | On update | On delete |
|---|---|---|---|---|---|
fk_causpaghe_caup_rap_id_to_rapporti | tenant_id, par_employment_id | hr.employment_relationships | tenant_id, er_id | RESTRICT | CASCADE |
fk_par_reason_type | tenant_id, par_reason_code | pres.attendance_reasons | tenant_id, ar_code | CASCADE | RESTRICT |
fk_par_tenant | tenant_id | cloud.tenants | ten_internal_id | CASCADE | CASCADE |
Referenced by
No incoming foreign keys found.
Constraints
- Primary key:
pk_payroll_additional_reasons→id - Unique:
c_uk_par_employment_date_reason_tenant→tenant_id, par_employment_id, par_reference_date, par_reason_code - Unique:
c_uk_par_id_tenant→tenant_id, par_id
Indexes
No indexes detected.
Navigation
- Back to main index
- [Back to
presindex]../)