pres.custom_calculations
Schema: pres
English table: pres.custom_calculations
Italian original table: pres.calcoli
Description: Configuration for end-of-month calculation rules, scripts, and filters for payroll variables.
Overview
- Columns: 18
- Primary key: id
- Outgoing foreign keys: 2
- 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. | |
cca_id | calc_id | integer | NO | Identifier of the related cca. | |
tenant_id | tenant_id | integer | NO | Identifier of the related tenant. | |
cca_description | calc_descrizione | character(40) | NO | ''::bpchar | Description of cca description. |
cca_from_department | calc_da_rep | character(4) | NO | ''::bpchar | Value of cca from department. |
cca_to_department | calc_a_rep | character(4) | NO | ''::bpchar | Value of cca to department. |
cca_from_job_title | calc_da_qual | character(4) | NO | ''::bpchar | Value of cca from job title. |
cca_to_job_title | calc_a_qual | character(4) | NO | ''::bpchar | Value of cca to job title. |
cca_from_employee_code | calc_da_matri | character(6) | NO | ''::bpchar | Code of cca from employee code. |
cca_to_employee_code | calc_a_matri | character(6) | NO | ''::bpchar | Code of cca to employee code. |
cca_from_company | calc_da_ditta | character(4) | NO | ''::bpchar | Value of cca from company. |
cca_to_company | calc_a_ditta | character(4) | NO | ''::bpchar | Value of cca to company. |
cca_from_branch | calc_da_filiale | character(2) | NO | ''::bpchar | Value of cca from branch. |
cca_to_branch | calc_a_filiale | character(2) | NO | ''::bpchar | Value of cca to branch. |
cca_reason_code | calc_cod_cau | character(4) | NO | ''::bpchar | Code of cca reason code. |
cca_include_zero_values | calc_sizero | boolean | NO | false | Flag to determine if results equal to zero should be processed. |
cca_calculation_script | calc_istruz | text | NO | ''::text | Text field containing the custom logic or script to be executed. |
cca_target_variable_name | calc_var_name | character(30) | NO | ''::bpchar | The name of the resulting variable where the calculation result is stored. |
Relationships
Outgoing foreign keys
| Constraint | Local columns | References | Referenced columns | On update | On delete |
|---|---|---|---|---|---|
fk_cca_reason_type | tenant_id, cca_reason_code | pres.attendance_reasons | tenant_id, ar_code | CASCADE | RESTRICT |
fk_cca_tenant | tenant_id | cloud.tenants | ten_internal_id | CASCADE | CASCADE |
Referenced by
No incoming foreign keys found.
Constraints
- Primary key:
pk_custom_calculations→id - Unique:
c_uk_cca_id_tenant→tenant_id, cca_id
Indexes
No indexes detected.
Navigation
- Back to main index
- [Back to
presindex]../)