Payroll Planning (EU)
001 · Analytical WorkspaceLineage overview
Dataset
Virtual Dataset
Datasource
DTP
External / cross-workspace
data flow direction
flowchart LR
classDef dsStyle fill:#eff6ff,stroke:#1d4ed8,color:#1e3a6e
classDef dtpStyle fill:#fef3c7,stroke:#d97706,color:#92400e
classDef srcStyle fill:#f5f3ff,stroke:#6d28d9,color:#4c1d95
classDef vdsStyle fill:#ecfdf5,stroke:#059669,color:#064e3b
classDef extStyle fill:#f1f5f9,stroke:#94a3b8,color:#475569,stroke-dasharray:4 3
DS_001_000001["000001
Roster Planning"]:::dsStyle DS_001_000008["000008
Health and Labor ins., Retirement Fund assumptions"]:::dsStyle DS_001_000009["000009
Base Salary Ranges"]:::dsStyle DS_001_000010["000010
Other assumptions"]:::dsStyle DS_001_000013["000013
Salaries and Wages"]:::dsStyle DS_001_000016["000016
_ Calculations"]:::dsStyle DTP_001_000001["000001
Payroll"]:::dtpStyle click DTP_001_000001 href "dtp_001_000001.html" "Open DTP: Payroll" click DS_001_000001 href "dataset_001_000001.html" "Open Dataset: 000001" click DS_001_000008 href "dataset_001_000008.html" "Open Dataset: 000008" click DS_001_000009 href "dataset_001_000009.html" "Open Dataset: 000009" click DS_001_000010 href "dataset_001_000010.html" "Open Dataset: 000010" click DS_001_000013 href "dataset_001_000013.html" "Open Dataset: 000013" click DS_001_000016 href "dataset_001_000016.html" "Open Dataset: 000016" DS_001_000001 --> DTP_001_000001 DTP_001_000001 --> DS_001_000016 DS_001_000016 --> DTP_001_000001 DTP_001_000001 --> DS_001_000013
Roster Planning"]:::dsStyle DS_001_000008["000008
Health and Labor ins., Retirement Fund assumptions"]:::dsStyle DS_001_000009["000009
Base Salary Ranges"]:::dsStyle DS_001_000010["000010
Other assumptions"]:::dsStyle DS_001_000013["000013
Salaries and Wages"]:::dsStyle DS_001_000016["000016
_ Calculations"]:::dsStyle DTP_001_000001["000001
Payroll"]:::dtpStyle click DTP_001_000001 href "dtp_001_000001.html" "Open DTP: Payroll" click DS_001_000001 href "dataset_001_000001.html" "Open Dataset: 000001" click DS_001_000008 href "dataset_001_000008.html" "Open Dataset: 000008" click DS_001_000009 href "dataset_001_000009.html" "Open Dataset: 000009" click DS_001_000010 href "dataset_001_000010.html" "Open Dataset: 000010" click DS_001_000013 href "dataset_001_000013.html" "Open Dataset: 000013" click DS_001_000016 href "dataset_001_000016.html" "Open Dataset: 000016" DS_001_000001 --> DTP_001_000001 DTP_001_000001 --> DS_001_000016 DS_001_000016 --> DTP_001_000001 DTP_001_000001 --> DS_001_000013
Datasets 6Sources: ows_tabella
| Code | Description | Type | Status | Fields | Written by |
|---|---|---|---|---|---|
000001 |
Roster Planning | Dataset | active | 13 | — |
000008 |
Health and Labor ins., Retirement Fund assumptions | Dataset | active | 7 | — |
000009 |
Base Salary Ranges | Dataset | active | 6 | — |
000010 |
Other assumptions | Dataset | active | 4 | — |
000013 |
Salaries and Wages | Dataset | active | 9 | 2 DTPs |
000016 |
_ Calculations | Dataset | active | 43 | 2 DTPs |
DTPs 1Sources: ows_dtp
| Code | Description | Activities | Writes to FW | Triggered by |
|---|---|---|---|---|
000001 |
Payroll | 4 | — | no process data |
Special Methods 2Sources: ows_metodo_speciale
Custom PostgreSQL scripts used as DTP operations.
| Code | Description | Params | Reads from | Writes to |
|---|---|---|---|---|
Input Validation |
INCDATE / SALINC coherence | 0 | — | — |
Input Validation 2 |
FTE greater than 0 | 0 | — | — |