Skip to content

Data Mapping

Lineage

flowchart LR
    HiAnt.InvoiceLines-->FactInvoiceLine;
    Platform.Client-->DimClient;
    Platform.Sector-->DimClient;
    Platform.Office-->DimOffice;
    Prato.Branch-->DimOffice;
    Platform.Student-->DimStudent;
    Platform.Vacancy-->DimShift;
    Platform.Project-->DimShift;
    Prato.Dagcodes-->DimDayCode;
    Prato.Looncode-->DimSalaryCode;
    Prato.Sekties-->DimSektie;
    Excel.KostenWG-->DimSektie;

Data Mapping

Shifts

We take the time worked from Prato.

We map the SalaryLines to shifts by student and day.

Companies / Clients

Platform.prato_client_id

Students

Platform.prato_person_id