_ Calculations

Dataset online 43 fields 3 partitions

Setupsource
Sources: ows_tabella

Workspace
001 · Payroll Planning (EU)
Type
Dataset
Status
online
Partitions
INPUT Input    ENGINE Engine    OUTPUT Output

Fields 43source
Sources: ows_tabella_campo

# Code Description Type Length Default Time rollup Conversion Key Req Dimension
0 ENT Entity Text Entity;fr=Entité
1 EMPL Employee Text Employees;fr=Employés
2 HIRE Date of Hire Date
3 POS Position Text Employees;fr=Employés 100
4 DEPT Department Text Cost Centers;fr=Centre cout
5 FTE FTE Number 27,9 Sum None
6 BASE Base Salary Number 27,9 Sum None
7 SALINC Salary Increase (%) Number 27,9 Sum None
8 INCDATE Salary Increase Date Date
9 FTECHNG FTE Change Number 27,9 Sum None
10 CHNGDATE FTE Change Date Date
11 MED Medical Plan Text 255
12 LIFE Life Plan Text 255
13 SAL_01 Base Salary 1 Number 27,9 Sum None
14 SAL_02 Base Salary 2 Number 27,9 Sum None
15 SAL_03 Base Salary 3 Number 27,9 Sum None
16 SAL_04 Base Salary 4 Number 27,9 Sum None
17 SAL_05 Base Salary 5 Number 27,9 Sum None
18 SAL_06 Base Salary 6 Number 27,9 Sum None
19 SAL_07 Base Salary 7 Number 27,9 Sum None
20 SAL_08 Base Salary 8 Number 27,9 Sum None
21 SAL_09 Base Salary 9 Number 27,9 Sum None
22 SAL_10 Base Salary 10 Number 27,9 Sum None
23 SAL_11 Base Salary 11 Number 27,9 Sum None
24 SAL_12 Base Salary 12 Number 27,9 Sum None
25 FTE_01 FTE_01 Number 27,9 Sum None
26 FTE_02 FTE_01 Number 27,9 Sum None
27 FTE_03 FTE_03 Number 27,9 Sum None
28 FTE_04 FTE_04 Number 27,9 Sum None
29 FTE_05 FTE_05 Number 27,9 Sum None
30 FTE_06 FTE_06 Number 27,9 Sum None
31 FTE_07 FTE_07 Number 27,9 Sum None
32 FTE_08 FTE_08 Number 27,9 Sum None
33 FTE_09 FTE_09 Number 27,9 Sum None
34 FTE_10 FTE_10 Number 27,9 Sum None
35 FTE_11 FTE_11 Number 27,9 Sum None
36 FTE_12 FTE_12 Number 27,9 Sum None
37 MP_AMOUNT Medical Plan Amount Number 27,9 Sum None
38 LP_AMOUNT Life Plan Amount Number 27,9 Sum None
39 RANGE_TYPE Range Type Text 255
40 RETFUND Retirement Fund Amount Number 27,9 Sum None
41 LABOR Labour Insurance Amount Number 27,9 Sum None
42 HEALTH Health Insurance Amount Number 27,9 Sum None

Lineage

Read by 3

000001 Payroll act 002
000001 Payroll act 004
000001 Payroll act 005

Written by 2

000001 Payroll act 001 Input
000001 Payroll act 002 Engine