Technische Dokumentation Modul HR

Inhaltsverzeichnis

Informationen

Dokumentationstyp: Vollständig (zur Endanwender Dokumentation)
Erstellt am: 12.04.2024
Modulversion: 19
Modultyp: Basismodul
Beschreibung: Modul für Personaldaten
Benötigt Administrator Rechte: Nein
Ab OCT Version: 5.10.11

Tabellen

integration.tHR_Journal

# Name Datentyp NULL Identity Berechnet
1 RowKey BIGINT highlight_off check_circle highlight_off
Technical primary Key for row identity.
2 DataSourceKey INT highlight_off highlight_off highlight_off
Technical primary Key of datasource. DataSourceKey is used to create a unique identifier when paired with CompanyID.
3 CompanyID NVARCHAR(50) highlight_off highlight_off highlight_off
OCT identifier for the company. Part of AccountKey.
4 Personalnummer NVARCHAR(50) highlight_off highlight_off highlight_off
Personalnummer aus dem HR ERP System
5 Jahr INT highlight_off highlight_off highlight_off
Jahr des Lohnjournals
6 Monat INT highlight_off highlight_off highlight_off
Monat des Lohnjournals
7 LohnartID NVARCHAR(50) check_circle highlight_off highlight_off
LohnartID aus dem Lohnjournals
8 KostenstellenID NVARCHAR(50) check_circle highlight_off highlight_off
KostenstellenID aus dem Lohnjournals
9 Wert BIGINT highlight_off highlight_off highlight_off
Wert centisiert (ohne Nachkommastellen)
10 CustomValuesJSON NVARCHAR(4000) check_circle highlight_off highlight_off
Custom field to store any customer individual informations.

Referenziert von

integration.tHR_Lohnarten

# Name Datentyp NULL Identity Berechnet
1 RowKey BIGINT highlight_off check_circle highlight_off
Technical primary Key for row identity.
2 DataSourceKey INT highlight_off highlight_off highlight_off
Technical primary Key of datasource. DataSourceKey is used to create a unique identifier when paired with CompanyID.
3 CompanyID NVARCHAR(50) highlight_off highlight_off highlight_off
OCT identifier for the company. Part of AccountKey.
4 LohnartID NVARCHAR(50) highlight_off highlight_off highlight_off
Eindeutige ID der Lohnart
5 LohnartName NVARCHAR(255) check_circle highlight_off highlight_off
Name der Lohnart
6 Lohnarttyp NVARCHAR(255) check_circle highlight_off highlight_off
Lohnarttyp: z.B. Euro oder Zeit
7 SachkontenID NVARCHAR(255) check_circle highlight_off highlight_off
8 CustomValuesJSON NVARCHAR(MAX) check_circle highlight_off highlight_off
Custom field to store any customer individual informations.

Referenziert von

integration.tHR_Merkmale

# Name Datentyp NULL Identity Berechnet
1 RowKey BIGINT highlight_off check_circle highlight_off
Technical primary Key for row identity.
2 DataSourceKey INT highlight_off highlight_off highlight_off
Technical primary Key of datasource. DataSourceKey is used to create a unique identifier when paired with CompanyID.
3 CompanyID NVARCHAR(50) highlight_off highlight_off highlight_off
OCT identifier for the company. Part of AccountKey.
4 MerkmalTyp NVARCHAR(50) highlight_off highlight_off highlight_off
5 MerkmalID NVARCHAR(50) highlight_off highlight_off highlight_off
6 MerkmalText NVARCHAR(255) highlight_off highlight_off highlight_off
7 CustomValuesJSON NVARCHAR(MAX) check_circle highlight_off highlight_off

Referenziert von

integration.tHR_Personalstammdaten

# Name Datentyp NULL Identity Berechnet
1 RowKey BIGINT highlight_off check_circle highlight_off
Technical primary Key for row identity.
2 DataSourceKey INT highlight_off highlight_off highlight_off
Technical primary Key of datasource. DataSourceKey is used to create a unique identifier when paired with CompanyID.
3 CompanyID NVARCHAR(50) highlight_off highlight_off highlight_off
OCT identifier for the company. Part of AccountKey.
4 Personalnummer NVARCHAR(50) highlight_off highlight_off highlight_off
Personalnummer aus dem HR ERP System
5 Nachname NVARCHAR(255) check_circle highlight_off highlight_off
Nachname des Mitarbeiters
6 Vorname NVARCHAR(255) check_circle highlight_off highlight_off
Vorname des Mitarbeiters
7 Geschlecht NVARCHAR(255) check_circle highlight_off highlight_off
Geschlecht des Mitarbeiters
8 Geburtsdatum DATETIME check_circle highlight_off highlight_off
Geburtsdatum des Mitarbeiters
9 Eintrittsdatum DATETIME check_circle highlight_off highlight_off
Eintrittsdatum des Mitarbeiters
10 Austrittsdatum DATETIME check_circle highlight_off highlight_off
Austrittsdatum des Mitarbeiters
11 Position NVARCHAR(255) check_circle highlight_off highlight_off
Position des Mitarbeiters. Kann inhaltlich in verschiedenen ERP Systemen unterschiedlich besetzt sein.
12 Stelle NVARCHAR(255) check_circle highlight_off highlight_off
Stelle des Mitarbeiters. Kann inhaltlich in verschiedenen ERP Systemen unterschiedlich besetzt sein.
13 Mitarbeiterstatus NVARCHAR(50) check_circle highlight_off highlight_off
Arbeitsstatus des Mitarbeiter, z.B. Aktiv, Inaktiv, Elternzeit, Mutterschutz
14 Befristung NVARCHAR(50) check_circle highlight_off highlight_off
Zeigt am, ob der Mitarbeiter befristet ist. (Ja/Nein)
15 BefristungDatum DATETIME check_circle highlight_off highlight_off
Datum der Befristung (sofern befristet)
16 SVKennung NVARCHAR(50) check_circle highlight_off highlight_off
Sozialversicherungskennung
17 Taetigkeit1 NVARCHAR(255) check_circle highlight_off highlight_off
Berufsgruppe/Dienstart (DA), häufig auch Taetigkeitsschlüssel. Mehrere Taetigkeiten gleichzeitig möglich.
18 TaetigkeitAnteil1 INT check_circle highlight_off highlight_off
Anteil Taetigkeit 1 in Prozent (centisiert). 10000 wenn nur eine Taetigkeit
19 Taetigkeit2 NVARCHAR(255) check_circle highlight_off highlight_off
Berufsgruppe/Dienstart (DA), häufig auch Taetigkeitsschlüssel. Mehrere Taetigkeiten gleichzeitig möglich.
20 TaetigkeitAnteil2 INT check_circle highlight_off highlight_off
Anteil Taetigkeit 2 in Prozent (centisiert).
21 Taetigkeit3 NVARCHAR(255) check_circle highlight_off highlight_off
Berufsgruppe/Dienstart (DA), häufig auch Taetigkeitsschlüssel. Mehrere Taetigkeiten gleichzeitig möglich.
22 TaetigkeitAnteil3 INT check_circle highlight_off highlight_off
Anteil Taetigkeit 3 in Prozent (centisiert).
23 Taetigkeit4 NVARCHAR(255) check_circle highlight_off highlight_off
Berufsgruppe/Dienstart (DA), häufig auch Taetigkeitsschlüssel. Mehrere Taetigkeiten gleichzeitig möglich.
24 TaetigkeitAnteil4 INT check_circle highlight_off highlight_off
Anteil Taetigkeit 4 in Prozent (centisiert).
25 Taetigkeit5 NVARCHAR(255) check_circle highlight_off highlight_off
Berufsgruppe/Dienstart (DA), häufig auch Taetigkeitsschlüssel. Mehrere Taetigkeiten gleichzeitig möglich.
26 TaetigkeitAnteil5 INT check_circle highlight_off highlight_off
Anteil Taetigkeit 5 in Prozent (centisiert).
27 Stammkostenstelle1 NVARCHAR(255) check_circle highlight_off highlight_off
Stammkostenstelle1 des Mitarbeiters. In der Regel bildet die Stammkostenstelle eine organisatorische Zugehörigkeit ab
28 StammkostenstelleAnteil1 INT check_circle highlight_off highlight_off
Anteil Stammkostenstelle 1 in Prozent (centisiert). 10000 wenn nur eine Stammkostenstelle
29 Stammkostenstelle2 NVARCHAR(255) check_circle highlight_off highlight_off
Stammkostenstelle2 des Mitarbeiters. In der Regel bildet die Stammkostenstelle eine organisatorische Zugehörigkeit ab
30 StammkostenstelleAnteil2 INT check_circle highlight_off highlight_off
Anteil Stammkostenstelle 2 in Prozent (centisiert). 10000 wenn nur eine Stammkostenstelle
31 Stammkostenstelle3 NVARCHAR(255) check_circle highlight_off highlight_off
Stammkostenstelle3 des Mitarbeiters. In der Regel bildet die Stammkostenstelle eine organisatorische Zugehörigkeit ab
32 StammkostenstelleAnteil3 INT check_circle highlight_off highlight_off
Anteil Stammkostenstelle 3 in Prozent (centisiert). 10000 wenn nur eine Stammkostenstelle
33 Stammkostenstelle4 NVARCHAR(255) check_circle highlight_off highlight_off
Stammkostenstelle4 des Mitarbeiters. In der Regel bildet die Stammkostenstelle eine organisatorische Zugehörigkeit ab
34 StammkostenstelleAnteil4 INT check_circle highlight_off highlight_off
Anteil Stammkostenstelle 4 in Prozent (centisiert). 10000 wenn nur eine Stammkostenstelle
35 Stammkostenstelle5 NVARCHAR(255) check_circle highlight_off highlight_off
Stammkostenstelle5 des Mitarbeiters. In der Regel bildet die Stammkostenstelle eine organisatorische Zugehörigkeit ab
36 StammkostenstelleAnteil5 INT check_circle highlight_off highlight_off
Anteil Stammkostenstelle 5 in Prozent (centisiert). 10000 wenn nur eine Stammkostenstelle
37 WochenAZ BIGINT check_circle highlight_off highlight_off
Wochenarbeitszeit in Stunden (centisiert). 4000 = 40 Stunden
38 TageWoche BIGINT check_circle highlight_off highlight_off
Tage pro Woche (centisiert). 450 = 4,5 Tage
39 Stundensatz BIGINT check_circle highlight_off highlight_off
Stundensatz (centisiert). 1000 = 10 €
40 Grundgehalt BIGINT check_circle highlight_off highlight_off
Grundgehalt (centisiert). 100000 = 1000 €
41 Stellenanteil BIGINT check_circle highlight_off highlight_off
Stellenanteil (centisiert). 50 = 0,5
42 GueltigVon DATETIME check_circle highlight_off highlight_off
Gueltigkeitsbeginn für diese Zeile. Das Datum, ab dieser Datensatz gültig ist.
43 CustomValuesJSON NVARCHAR(MAX) check_circle highlight_off highlight_off
Custom field to store any customer individual informations.

Referenziert von

integration.tHR_Tarifbetraege

# Name Datentyp NULL Identity Berechnet
1 RowKey BIGINT highlight_off highlight_off highlight_off
2 DataSourceKey INT highlight_off highlight_off highlight_off
3 CompanyID NVARCHAR(50) highlight_off highlight_off highlight_off
4 TarifID NVARCHAR(50) highlight_off highlight_off highlight_off
5 TarifName NVARCHAR(255) check_circle highlight_off highlight_off
6 TarifGruppeID NVARCHAR(255) check_circle highlight_off highlight_off
7 TarifGruppeName NVARCHAR(255) check_circle highlight_off highlight_off
8 TarifStufe NVARCHAR(255) check_circle highlight_off highlight_off
9 TarifBetrag BIGINT check_circle highlight_off highlight_off
10 GueltigVon DATETIME check_circle highlight_off highlight_off
11 CustomValuesJSON NVARCHAR(MAX) check_circle highlight_off highlight_off

Referenziert von

integration.tHR_Tarifzuordnung

# Name Datentyp NULL Identity Berechnet
1 RowKey BIGINT highlight_off highlight_off highlight_off
2 DataSourceKey INT highlight_off highlight_off highlight_off
3 CompanyID NVARCHAR(50) highlight_off highlight_off highlight_off
4 Personalnummer NVARCHAR(50) highlight_off highlight_off highlight_off
5 TarifID NVARCHAR(50) highlight_off highlight_off highlight_off
6 TarifName NVARCHAR(255) check_circle highlight_off highlight_off
7 TarifGruppeID NVARCHAR(255) check_circle highlight_off highlight_off
8 TarifGruppeName NVARCHAR(255) check_circle highlight_off highlight_off
9 TarifStufe NVARCHAR(255) check_circle highlight_off highlight_off
10 GueltigVon DATETIME check_circle highlight_off highlight_off
11 CustomValuesJSON NVARCHAR(MAX) check_circle highlight_off highlight_off

Referenziert von

integration.tHR_Verteilung

# Name Datentyp NULL Identity Berechnet
1 RowKey BIGINT highlight_off highlight_off highlight_off
2 DataSourceKey INT highlight_off highlight_off highlight_off
3 CompanyID NVARCHAR(50) highlight_off highlight_off highlight_off
4 Personalnummer NVARCHAR(50) highlight_off highlight_off highlight_off
5 VerteilungTypeCODE NVARCHAR(50) highlight_off highlight_off highlight_off
6 ObjektID NVARCHAR(50) highlight_off highlight_off highlight_off
7 GueltigVon DATETIME highlight_off highlight_off highlight_off
8 GueltigBis DATETIME check_circle highlight_off highlight_off
9 Wert INT highlight_off highlight_off highlight_off
10 CustomValuesJSON NVARCHAR(4000) check_circle highlight_off highlight_off

Referenziert von

integration.tHR_Zeitbuchungen

# Name Datentyp NULL Identity Berechnet
1 RowKey BIGINT highlight_off highlight_off highlight_off
2 DataSourceKey INT highlight_off highlight_off highlight_off
3 CompanyID NVARCHAR(50) highlight_off highlight_off highlight_off
4 Personalnummer NVARCHAR(50) highlight_off highlight_off highlight_off
5 ZeitbuchungTypeCODE NVARCHAR(50) highlight_off highlight_off highlight_off
6 GueltigVon DATETIME highlight_off highlight_off highlight_off
7 GueltigBis DATETIME check_circle highlight_off highlight_off
8 ZeitbuchungID NVARCHAR(50) check_circle highlight_off highlight_off
9 ZeitbuchungName NVARCHAR(255) check_circle highlight_off highlight_off
10 BereichID NVARCHAR(50) check_circle highlight_off highlight_off
11 BereichName NVARCHAR(255) check_circle highlight_off highlight_off
12 AufgabenID NVARCHAR(50) check_circle highlight_off highlight_off
13 AufgabenKuerzel NVARCHAR(50) check_circle highlight_off highlight_off
14 AufgabenName NVARCHAR(255) check_circle highlight_off highlight_off
15 KontenID NVARCHAR(50) check_circle highlight_off highlight_off
16 KostenstellenID NVARCHAR(50) check_circle highlight_off highlight_off
17 DienstTyp NVARCHAR(50) check_circle highlight_off highlight_off
18 Betrag BIGINT check_circle highlight_off highlight_off
19 CustomValuesJSON NVARCHAR(4000) check_circle highlight_off highlight_off

Referenziert von

result.tHR_Journal

Tabelle stellt das Lohnjournal bereit. Tabelle wird durch die Datenbereitstellung aus der View result.vHR_Journal materialisiert.

# Name Datentyp NULL Identity Berechnet
1 CompanyKey NVARCHAR(63) highlight_off highlight_off highlight_off
2 MandantenID NVARCHAR(50) highlight_off highlight_off highlight_off
Mandanten ID aus OCT.
3 Personalnummer NVARCHAR(50) highlight_off highlight_off highlight_off
4 Jahr INT highlight_off highlight_off highlight_off
5 Monat INT highlight_off highlight_off highlight_off
6 LohnartID NVARCHAR(50) check_circle highlight_off highlight_off
7 KostenstellenID NVARCHAR(50) check_circle highlight_off highlight_off
8 Wert MONEY highlight_off highlight_off highlight_off
9 RowKey BIGINT check_circle highlight_off highlight_off
RowKey

Referenziert von

result.tHR_Kostenstellen

Tabelle stellt Stammdaten zu Lohnarten bereit. Tabelle wird durch die Datenbereitstellung aus der View result.vHR_Lohnarten materialisiert.

# Name Datentyp NULL Identity Berechnet
1 CompanyKey NVARCHAR(63) highlight_off highlight_off highlight_off
2 MandantenID NVARCHAR(50) highlight_off highlight_off highlight_off
3 KostenstellenID NVARCHAR(50) highlight_off highlight_off highlight_off
4 KostenstellenName NVARCHAR(255) check_circle highlight_off highlight_off

Referenziert von

result.tHR_KostenstellenVerteilung

# Name Datentyp NULL Identity Berechnet
1 CompanyKey NVARCHAR(63) highlight_off highlight_off highlight_off
2 MandantenID NVARCHAR(50) highlight_off highlight_off highlight_off
3 Personalnummer NVARCHAR(50) highlight_off highlight_off highlight_off
4 KostenstellenID NVARCHAR(50) highlight_off highlight_off highlight_off
5 GueltigVon DATETIME highlight_off highlight_off highlight_off
6 GueltigBis DATETIME highlight_off highlight_off highlight_off
7 Wert NUMERIC highlight_off highlight_off highlight_off
8 Rowkey BIGINT check_circle highlight_off highlight_off

result.tHR_Lohnarten

Tabelle stellt Stammdaten zu Lohnarten bereit. Tabelle wird durch die Datenbereitstellung aus der View result.vHR_Lohnarten materialisiert.

# Name Datentyp NULL Identity Berechnet
1 CompanyKey NVARCHAR(63) highlight_off highlight_off highlight_off
2 MandantenID NVARCHAR(50) highlight_off highlight_off highlight_off
Mandanten ID aus OCT.
3 LohnartID NVARCHAR(50) highlight_off highlight_off highlight_off
4 LohnartName NVARCHAR(255) check_circle highlight_off highlight_off
5 Lohnarttyp NVARCHAR(255) check_circle highlight_off highlight_off
6 SachkontenID NVARCHAR(255) check_circle highlight_off highlight_off
7 RowKey BIGINT check_circle highlight_off highlight_off
RowKey

Referenziert von

result.tHR_Merkmale

Tabelle stellt Stammdaten zu Merkmale bereit. Tabelle wird durch die Datenbereitstellung aus der View result.vHR_Merkmale materialisiert.

# Name Datentyp NULL Identity Berechnet
1 CompanyKey NVARCHAR(63) highlight_off highlight_off highlight_off
2 MandantenID NVARCHAR(50) highlight_off highlight_off highlight_off
Mandanten ID aus OCT.
3 MerkmalTyp NVARCHAR(50) highlight_off highlight_off highlight_off
4 MerkmalID NVARCHAR(50) highlight_off highlight_off highlight_off
5 MerkmalText NVARCHAR(255) highlight_off highlight_off highlight_off
6 Rowkey BIGINT check_circle highlight_off highlight_off
RowKey

result.tHR_Personalstammdaten

Tabelle stellt versionierte Personalstammdaten bereit. Tabelle wird durch die Datenbereitstellung aus der View result.vHR_Personalstammdaten materialisiert.

# Name Datentyp NULL Identity Berechnet
1 CompanyKey NVARCHAR(63) highlight_off highlight_off highlight_off
2 DataSourceKey INT highlight_off highlight_off highlight_off
3 MandantenID NVARCHAR(50) highlight_off highlight_off highlight_off
Mandanten ID aus OCT.
4 Personalnummer NVARCHAR(50) highlight_off highlight_off highlight_off
5 Nachname NVARCHAR(255) check_circle highlight_off highlight_off
6 Vorname NVARCHAR(255) check_circle highlight_off highlight_off
7 Geschlecht NVARCHAR(255) check_circle highlight_off highlight_off
8 Geburtsdatum DATETIME check_circle highlight_off highlight_off
9 Eintrittsdatum DATETIME check_circle highlight_off highlight_off
10 Austrittsdatum DATETIME check_circle highlight_off highlight_off
11 Position NVARCHAR(255) check_circle highlight_off highlight_off
12 Stelle NVARCHAR(255) check_circle highlight_off highlight_off
13 Mitarbeiterstatus NVARCHAR(50) check_circle highlight_off highlight_off
14 Befristung NVARCHAR(50) check_circle highlight_off highlight_off
15 BefristungDatum DATETIME check_circle highlight_off highlight_off
16 SVKennung NVARCHAR(50) check_circle highlight_off highlight_off
17 Taetigkeit1 NVARCHAR(255) check_circle highlight_off highlight_off
18 TaetigkeitAnteil1 INT check_circle highlight_off highlight_off
19 Taetigkeit2 NVARCHAR(255) check_circle highlight_off highlight_off
20 TaetigkeitAnteil2 INT check_circle highlight_off highlight_off
21 Taetigkeit3 NVARCHAR(255) check_circle highlight_off highlight_off
22 TaetigkeitAnteil3 INT check_circle highlight_off highlight_off
23 Taetigkeit4 NVARCHAR(255) check_circle highlight_off highlight_off
24 TaetigkeitAnteil4 INT check_circle highlight_off highlight_off
25 Taetigkeit5 NVARCHAR(255) check_circle highlight_off highlight_off
26 TaetigkeitAnteil5 INT check_circle highlight_off highlight_off
27 Stammkostenstelle1 NVARCHAR(255) check_circle highlight_off highlight_off
28 StammkostenstelleAnteil1 INT check_circle highlight_off highlight_off
29 Stammkostenstelle2 NVARCHAR(255) check_circle highlight_off highlight_off
30 StammkostenstelleAnteil2 INT check_circle highlight_off highlight_off
31 Stammkostenstelle3 NVARCHAR(255) check_circle highlight_off highlight_off
32 StammkostenstelleAnteil3 INT check_circle highlight_off highlight_off
33 Stammkostenstelle4 NVARCHAR(255) check_circle highlight_off highlight_off
34 StammkostenstelleAnteil4 INT check_circle highlight_off highlight_off
35 Stammkostenstelle5 NVARCHAR(255) check_circle highlight_off highlight_off
36 StammkostenstelleAnteil5 INT check_circle highlight_off highlight_off
37 WochenAZ NUMERIC check_circle highlight_off highlight_off
38 TageWoche NUMERIC check_circle highlight_off highlight_off
39 Stundensatz NUMERIC check_circle highlight_off highlight_off
40 Grundgehalt NUMERIC check_circle highlight_off highlight_off
41 Stellenanteil NUMERIC check_circle highlight_off highlight_off
42 GueltigVon DATETIME check_circle highlight_off highlight_off
43 GueltigVonDate DATETIME check_circle highlight_off highlight_off
44 GueltigBisDate DATETIME check_circle highlight_off highlight_off
45 RowKey BIGINT check_circle highlight_off highlight_off
RowKey

Referenziert von

result.tHR_PersonalstammdatenAktuell

Tabelle stellt Personalstammdaten zum gültig zum aktuellen Zeitpunkt bereit. Tabelle wird durch die Datenbereitstellung aus der View result.vHR_PersonalstammdatenAktuell materialisiert.

# Name Datentyp NULL Identity Berechnet
1 CompanyKey NVARCHAR(63) highlight_off highlight_off highlight_off
2 DataSourceKey INT highlight_off highlight_off highlight_off
3 MandantenID NVARCHAR(50) highlight_off highlight_off highlight_off
Mandanten ID aus OCT.
4 Personalnummer NVARCHAR(50) highlight_off highlight_off highlight_off
5 Nachname NVARCHAR(255) check_circle highlight_off highlight_off
6 Vorname NVARCHAR(255) check_circle highlight_off highlight_off
7 Geschlecht NVARCHAR(255) check_circle highlight_off highlight_off
8 Geburtsdatum DATETIME check_circle highlight_off highlight_off
9 Eintrittsdatum DATETIME check_circle highlight_off highlight_off
10 Austrittsdatum DATETIME check_circle highlight_off highlight_off
11 Position NVARCHAR(255) check_circle highlight_off highlight_off
12 Stelle NVARCHAR(255) check_circle highlight_off highlight_off
13 Mitarbeiterstatus NVARCHAR(50) check_circle highlight_off highlight_off
14 Befristung NVARCHAR(50) check_circle highlight_off highlight_off
15 BefristungDatum DATETIME check_circle highlight_off highlight_off
16 SVKennung NVARCHAR(50) check_circle highlight_off highlight_off
17 Taetigkeit1 NVARCHAR(255) check_circle highlight_off highlight_off
18 TaetigkeitAnteil1 INT check_circle highlight_off highlight_off
19 Taetigkeit2 NVARCHAR(255) check_circle highlight_off highlight_off
20 TaetigkeitAnteil2 INT check_circle highlight_off highlight_off
21 Taetigkeit3 NVARCHAR(255) check_circle highlight_off highlight_off
22 TaetigkeitAnteil3 INT check_circle highlight_off highlight_off
23 Taetigkeit4 NVARCHAR(255) check_circle highlight_off highlight_off
24 TaetigkeitAnteil4 INT check_circle highlight_off highlight_off
25 Taetigkeit5 NVARCHAR(255) check_circle highlight_off highlight_off
26 TaetigkeitAnteil5 INT check_circle highlight_off highlight_off
27 Stammkostenstelle1 NVARCHAR(255) check_circle highlight_off highlight_off
28 StammkostenstelleAnteil1 INT check_circle highlight_off highlight_off
29 Stammkostenstelle2 NVARCHAR(255) check_circle highlight_off highlight_off
30 StammkostenstelleAnteil2 INT check_circle highlight_off highlight_off
31 Stammkostenstelle3 NVARCHAR(255) check_circle highlight_off highlight_off
32 StammkostenstelleAnteil3 INT check_circle highlight_off highlight_off
33 Stammkostenstelle4 NVARCHAR(255) check_circle highlight_off highlight_off
34 StammkostenstelleAnteil4 INT check_circle highlight_off highlight_off
35 Stammkostenstelle5 NVARCHAR(255) check_circle highlight_off highlight_off
36 StammkostenstelleAnteil5 INT check_circle highlight_off highlight_off
37 WochenAZ NUMERIC check_circle highlight_off highlight_off
38 TageWoche NUMERIC check_circle highlight_off highlight_off
39 Stundensatz NUMERIC check_circle highlight_off highlight_off
40 Grundgehalt NUMERIC check_circle highlight_off highlight_off
41 Stellenanteil NUMERIC check_circle highlight_off highlight_off
42 GueltigVon DATETIME check_circle highlight_off highlight_off
43 GueltigVonDate DATETIME check_circle highlight_off highlight_off
44 GueltigBisDate DATETIME check_circle highlight_off highlight_off
45 RowKey BIGINT check_circle highlight_off highlight_off
RowKey

result.tHR_Tarifbetraege

Tabelle stellt Tarifbetraege bereit. Tabelle wird durch die Datenbereitstellung aus der View result.vHR_Tarifbetraege materialisiert.

# Name Datentyp NULL Identity Berechnet
1 CompanyKey NVARCHAR(63) highlight_off highlight_off highlight_off
2 MandantenID NVARCHAR(50) highlight_off highlight_off highlight_off
Mandanten ID aus OCT.
3 TarifID NVARCHAR(50) highlight_off highlight_off highlight_off
4 TarifName NVARCHAR(255) check_circle highlight_off highlight_off
5 TarifGruppeID NVARCHAR(255) check_circle highlight_off highlight_off
6 TarifGruppeName NVARCHAR(255) check_circle highlight_off highlight_off
7 TarifStufe NVARCHAR(255) check_circle highlight_off highlight_off
8 TarifBetrag MONEY check_circle highlight_off highlight_off
9 GueltigVon DATETIME check_circle highlight_off highlight_off
10 GueltigVonDate DATETIME check_circle highlight_off highlight_off
11 GueltigBisDate DATETIME check_circle highlight_off highlight_off
12 Rowkey BIGINT check_circle highlight_off highlight_off
RowKey

result.tHR_Tarifzuordnung

Tabelle stellt Stammdaten zu Tarifzuordnung bereit. Tabelle wird durch die Datenbereitstellung aus der View result.vHR_Tarifzuordnung materialisiert.

# Name Datentyp NULL Identity Berechnet
1 CompanyKey NVARCHAR(63) highlight_off highlight_off highlight_off
2 MandantenID NVARCHAR(50) highlight_off highlight_off highlight_off
Mandanten ID aus OCT.
3 Personalnummer NVARCHAR(50) highlight_off highlight_off highlight_off
4 TarifID NVARCHAR(50) highlight_off highlight_off highlight_off
5 TarifName NVARCHAR(255) check_circle highlight_off highlight_off
6 TarifGruppeID NVARCHAR(255) check_circle highlight_off highlight_off
7 TarifGruppeName NVARCHAR(255) check_circle highlight_off highlight_off
8 TarifStufe NVARCHAR(255) check_circle highlight_off highlight_off
9 GueltigVon DATETIME check_circle highlight_off highlight_off
10 GueltigVonDate DATE check_circle highlight_off highlight_off
11 GueltigBisDate DATE check_circle highlight_off highlight_off
12 Rowkey BIGINT check_circle highlight_off highlight_off
RowKey

result.tHR_Zeitbuchungen

Tabelle stellt das Lohnjournal bereit. Tabelle wird durch die Datenbereitstellung aus der View result.vHR_Journal materialisiert.

# Name Datentyp NULL Identity Berechnet
1 CompanyKey NVARCHAR(63) highlight_off highlight_off highlight_off
2 MandantenID NVARCHAR(50) highlight_off highlight_off highlight_off
Mandanten ID aus OCT.
3 Personalnummer NVARCHAR(50) highlight_off highlight_off highlight_off
4 ZeitbuchungTypeCODE NVARCHAR(50) highlight_off highlight_off highlight_off
5 GueltigVon DATETIME highlight_off highlight_off highlight_off
6 GueltigBis DATETIME check_circle highlight_off highlight_off
7 ZeitbuchungID NVARCHAR(50) check_circle highlight_off highlight_off
8 ZeitbuchungName NVARCHAR(255) check_circle highlight_off highlight_off
9 BereichID NVARCHAR(50) check_circle highlight_off highlight_off
10 BereichName NVARCHAR(255) check_circle highlight_off highlight_off
11 AufgabenID NVARCHAR(50) check_circle highlight_off highlight_off
12 AufgabenKuerzel NVARCHAR(50) check_circle highlight_off highlight_off
13 AufgabenName NVARCHAR(255) check_circle highlight_off highlight_off
14 KontenID NVARCHAR(50) check_circle highlight_off highlight_off
15 KostenstellenID NVARCHAR(50) check_circle highlight_off highlight_off
16 DienstTyp NVARCHAR(50) check_circle highlight_off highlight_off
17 Betrag NUMERIC check_circle highlight_off highlight_off
18 Rowkey BIGINT check_circle highlight_off highlight_off
RowKey

Sichten

agent.vJSON_integration_tHR_Journal

This view resolves the CustomValuesJSON column in table integration.tHR_Journal to actual columns.

# Name Datentyp NULL Identity Berechnet
1 Rowkey BIGINT highlight_off highlight_off highlight_off

Referenzierte Objekte

Referenziert von

agent.vJSON_integration_tHR_Lohnarten

This view resolves the CustomValuesJSON column in table integration.tHR_Lohnarten to actual columns.

# Name Datentyp NULL Identity Berechnet
1 Rowkey BIGINT highlight_off highlight_off highlight_off

Referenzierte Objekte

Referenziert von

agent.vJSON_integration_tHR_Merkmale

This view resolves the CustomValuesJSON column in table integration.tHR_Merkmale to actual columns.

# Name Datentyp NULL Identity Berechnet
1 Rowkey BIGINT highlight_off highlight_off highlight_off

Referenzierte Objekte

Referenziert von

agent.vJSON_integration_tHR_Personalstammdaten

This view resolves the CustomValuesJSON column in table integration.tHR_Personalstammdaten to actual columns.

# Name Datentyp NULL Identity Berechnet
1 Rowkey BIGINT highlight_off highlight_off highlight_off

Referenzierte Objekte

Referenziert von

agent.vJSON_integration_tHR_Tarifbetraege

This view resolves the CustomValuesJSON column in table integration.tHR_Tarifbetraege to actual columns.

# Name Datentyp NULL Identity Berechnet
1 Rowkey BIGINT highlight_off highlight_off highlight_off

Referenzierte Objekte

Referenziert von

agent.vJSON_integration_tHR_Tarifzuordnung

This view resolves the CustomValuesJSON column in table integration.tHR_Tarifzuordnung to actual columns.

# Name Datentyp NULL Identity Berechnet
1 Rowkey BIGINT highlight_off highlight_off highlight_off

Referenzierte Objekte

Referenziert von

agent.vJSON_integration_tHR_Verteilung

This view resolves the CustomValuesJSON column in table integration.tHR_Verteilung to actual columns.

# Name Datentyp NULL Identity Berechnet
1 Rowkey BIGINT highlight_off highlight_off highlight_off

Referenzierte Objekte

Referenziert von

agent.vJSON_integration_tHR_Zeitbuchungen

This view resolves the CustomValuesJSON column in table integration.tHR_Zeitbuchungen to actual columns.

# Name Datentyp NULL Identity Berechnet
1 Rowkey BIGINT highlight_off highlight_off highlight_off

Referenzierte Objekte

Referenziert von

integration.vHR_JournalStats

Statistiken der Tabelle integration.tHR_Journal

# Name Datentyp NULL Identity Berechnet
1 DataSourceKey INT highlight_off highlight_off highlight_off
2 CompanyID NVARCHAR(50) highlight_off highlight_off highlight_off
3 CompanyName NVARCHAR(255) highlight_off highlight_off highlight_off
4 min_JahrMonat NVARCHAR(7) check_circle highlight_off highlight_off
5 max_JahrMonat NVARCHAR(7) check_circle highlight_off highlight_off
6 RowsCount INT check_circle highlight_off highlight_off

Referenzierte Objekte

Referenziert von

integration.vHR_LohnartenStats

Statistiken der Tabelle integration.tHR_Lohnarten

# Name Datentyp NULL Identity Berechnet
1 DataSourceKey INT highlight_off highlight_off highlight_off
2 CompanyID NVARCHAR(50) highlight_off highlight_off highlight_off
3 CompanyName NVARCHAR(255) highlight_off highlight_off highlight_off
4 Lohnarttyp NVARCHAR(255) check_circle highlight_off highlight_off
5 RowsCount INT check_circle highlight_off highlight_off

Referenzierte Objekte

Referenziert von

integration.vHR_MerkmaleStats

Statistiken der Tabelle integration.tHR_Merkmale

# Name Datentyp NULL Identity Berechnet
1 DataSourceKey INT highlight_off highlight_off highlight_off
2 CompanyID NVARCHAR(50) highlight_off highlight_off highlight_off
3 CompanyName NVARCHAR(255) highlight_off highlight_off highlight_off
4 MerkmalTyp NVARCHAR(50) highlight_off highlight_off highlight_off
5 RowsCount INT check_circle highlight_off highlight_off

Referenzierte Objekte

Referenziert von

integration.vHR_PersonalstammdatenStats

Statistiken der Tabelle integration.tHR_Personalstammdaten

# Name Datentyp NULL Identity Berechnet
1 DataSourceKey INT highlight_off highlight_off highlight_off
2 CompanyID NVARCHAR(50) highlight_off highlight_off highlight_off
3 CompanyName NVARCHAR(255) highlight_off highlight_off highlight_off
4 RowsCount INT check_circle highlight_off highlight_off

Referenzierte Objekte

Referenziert von

integration.vHR_TarifzuordnungStats

Statistiken der Tabelle integration.tHR_Tarifzuordnung

# Name Datentyp NULL Identity Berechnet
1 DataSourceKey INT highlight_off highlight_off highlight_off
2 CompanyID NVARCHAR(50) highlight_off highlight_off highlight_off
3 CompanyName NVARCHAR(255) highlight_off highlight_off highlight_off
4 RowsCount INT check_circle highlight_off highlight_off

Referenzierte Objekte

integration.vHR_VerteilungStats

Statistiken der Tabelle integration.tHR_Verteilung

# Name Datentyp NULL Identity Berechnet
1 DataSourceKey INT highlight_off highlight_off highlight_off
2 CompanyID NVARCHAR(50) highlight_off highlight_off highlight_off
3 CompanyName NVARCHAR(255) highlight_off highlight_off highlight_off
4 MerkmalTyp NVARCHAR(50) highlight_off highlight_off highlight_off
5 RowsCount INT check_circle highlight_off highlight_off

Referenzierte Objekte

result.vHR_Journal

View stellt die Bewegungsdaten der Mitarbeiter aus der Integration bereit

# Name Datentyp NULL Identity Berechnet
1 CompanyKey NVARCHAR(63) highlight_off highlight_off highlight_off
2 MandantenID NVARCHAR(50) highlight_off highlight_off highlight_off
3 Personalnummer NVARCHAR(50) highlight_off highlight_off highlight_off
4 Jahr INT highlight_off highlight_off highlight_off
5 Monat INT highlight_off highlight_off highlight_off
6 LohnartID NVARCHAR(50) check_circle highlight_off highlight_off
7 KostenstellenID NVARCHAR(50) check_circle highlight_off highlight_off
8 Wert MONEY check_circle highlight_off highlight_off
9 Rowkey BIGINT check_circle highlight_off highlight_off

Referenzierte Objekte

Referenziert von

result.vHR_Kostenstellen

View stellt die Kostenstellen aus der Integration bereit

# Name Datentyp NULL Identity Berechnet
1 CompanyKey NVARCHAR(63) highlight_off highlight_off highlight_off
2 MandantenID NVARCHAR(50) highlight_off highlight_off highlight_off
3 KostenstellenID NVARCHAR(50) highlight_off highlight_off highlight_off
4 KostenstellenName NVARCHAR(255) highlight_off highlight_off highlight_off

Referenzierte Objekte

Referenziert von

result.vHR_KostenstellenVerteilung

# Name Datentyp NULL Identity Berechnet
1 CompanyKey NVARCHAR(63) highlight_off highlight_off highlight_off
2 MandantenID NVARCHAR(50) highlight_off highlight_off highlight_off
3 Personalnummer NVARCHAR(50) highlight_off highlight_off highlight_off
4 KostenstellenID NVARCHAR(50) highlight_off highlight_off highlight_off
5 GueltigVon DATETIME check_circle highlight_off highlight_off
6 GueltigBis DATETIME check_circle highlight_off highlight_off
7 Wert NUMERIC check_circle highlight_off highlight_off
8 Rowkey BIGINT check_circle highlight_off highlight_off

Referenzierte Objekte

Referenziert von

result.vHR_Lohnarten

View stellt die Lohnarten aus der Integration bereit

# Name Datentyp NULL Identity Berechnet
1 CompanyKey NVARCHAR(63) highlight_off highlight_off highlight_off
2 MandantenID NVARCHAR(50) highlight_off highlight_off highlight_off
3 LohnartID NVARCHAR(50) highlight_off highlight_off highlight_off
4 LohnartName NVARCHAR(255) check_circle highlight_off highlight_off
5 Lohnarttyp NVARCHAR(255) check_circle highlight_off highlight_off
6 SachkontenID NVARCHAR(255) check_circle highlight_off highlight_off
7 Rowkey BIGINT check_circle highlight_off highlight_off

Referenzierte Objekte

Referenziert von

result.vHR_Merkmale

View stellt die Merkmale aus der Integration bereit

# Name Datentyp NULL Identity Berechnet
1 CompanyKey NVARCHAR(63) highlight_off highlight_off highlight_off
2 MandantenID NVARCHAR(50) highlight_off highlight_off highlight_off
3 MerkmalTyp NVARCHAR(50) highlight_off highlight_off highlight_off
4 MerkmalID NVARCHAR(50) highlight_off highlight_off highlight_off
5 MerkmalText NVARCHAR(255) highlight_off highlight_off highlight_off
6 Rowkey BIGINT check_circle highlight_off highlight_off

Referenzierte Objekte

Referenziert von

result.vHR_Personalstammdaten

View stellt die Stammdaten der Mitarbeiter aus der Integration bereit und ermittelt die Gültigkeit der Datensätze

# Name Datentyp NULL Identity Berechnet
1 CompanyKey NVARCHAR(63) highlight_off highlight_off highlight_off
2 DataSourceKey INT highlight_off highlight_off highlight_off
3 MandantenID NVARCHAR(50) highlight_off highlight_off highlight_off
4 Personalnummer NVARCHAR(50) highlight_off highlight_off highlight_off
5 Nachname NVARCHAR(255) check_circle highlight_off highlight_off
6 Vorname NVARCHAR(255) check_circle highlight_off highlight_off
7 Geschlecht NVARCHAR(255) check_circle highlight_off highlight_off
8 Geburtsdatum DATETIME check_circle highlight_off highlight_off
9 Eintrittsdatum DATETIME check_circle highlight_off highlight_off
10 Austrittsdatum DATETIME check_circle highlight_off highlight_off
11 Position NVARCHAR(255) check_circle highlight_off highlight_off
12 Stelle NVARCHAR(255) check_circle highlight_off highlight_off
13 Mitarbeiterstatus NVARCHAR(50) check_circle highlight_off highlight_off
14 Befristung NVARCHAR(50) check_circle highlight_off highlight_off
15 BefristungDatum DATETIME check_circle highlight_off highlight_off
16 SVKennung NVARCHAR(50) check_circle highlight_off highlight_off
17 Taetigkeit1 NVARCHAR(255) check_circle highlight_off highlight_off
18 TaetigkeitAnteil1 INT check_circle highlight_off highlight_off
19 Taetigkeit2 NVARCHAR(255) check_circle highlight_off highlight_off
20 TaetigkeitAnteil2 INT check_circle highlight_off highlight_off
21 Taetigkeit3 NVARCHAR(255) check_circle highlight_off highlight_off
22 TaetigkeitAnteil3 INT check_circle highlight_off highlight_off
23 Taetigkeit4 NVARCHAR(255) check_circle highlight_off highlight_off
24 TaetigkeitAnteil4 INT check_circle highlight_off highlight_off
25 Taetigkeit5 NVARCHAR(255) check_circle highlight_off highlight_off
26 TaetigkeitAnteil5 INT check_circle highlight_off highlight_off
27 Stammkostenstelle1 NVARCHAR(255) check_circle highlight_off highlight_off
28 StammkostenstelleAnteil1 INT check_circle highlight_off highlight_off
29 Stammkostenstelle2 NVARCHAR(255) check_circle highlight_off highlight_off
30 StammkostenstelleAnteil2 INT check_circle highlight_off highlight_off
31 Stammkostenstelle3 NVARCHAR(255) check_circle highlight_off highlight_off
32 StammkostenstelleAnteil3 INT check_circle highlight_off highlight_off
33 Stammkostenstelle4 NVARCHAR(255) check_circle highlight_off highlight_off
34 StammkostenstelleAnteil4 INT check_circle highlight_off highlight_off
35 Stammkostenstelle5 NVARCHAR(255) check_circle highlight_off highlight_off
36 StammkostenstelleAnteil5 INT check_circle highlight_off highlight_off
37 WochenAZ NUMERIC check_circle highlight_off highlight_off
38 TageWoche NUMERIC check_circle highlight_off highlight_off
39 Stundensatz NUMERIC check_circle highlight_off highlight_off
40 Grundgehalt NUMERIC check_circle highlight_off highlight_off
41 Stellenanteil NUMERIC check_circle highlight_off highlight_off
42 GueltigVon DATETIME check_circle highlight_off highlight_off
43 GueltigVonDate DATETIME check_circle highlight_off highlight_off
44 GueltigBisDate DATETIME check_circle highlight_off highlight_off
45 Rowkey BIGINT check_circle highlight_off highlight_off

Referenzierte Objekte

Referenziert von

result.vHR_PersonalstammdatenAktuell

View stellt die aktuellen Stammdaten der Mitarbeiter aus der Integration bereit (basierend auf dem aktuellen Datum)

# Name Datentyp NULL Identity Berechnet
1 CompanyKey NVARCHAR(63) highlight_off highlight_off highlight_off
2 DataSourceKey INT highlight_off highlight_off highlight_off
3 MandantenID NVARCHAR(50) highlight_off highlight_off highlight_off
4 Personalnummer NVARCHAR(50) highlight_off highlight_off highlight_off
5 Nachname NVARCHAR(255) check_circle highlight_off highlight_off
6 Vorname NVARCHAR(255) check_circle highlight_off highlight_off
7 Geschlecht NVARCHAR(255) check_circle highlight_off highlight_off
8 Geburtsdatum DATETIME check_circle highlight_off highlight_off
9 Eintrittsdatum DATETIME check_circle highlight_off highlight_off
10 Austrittsdatum DATETIME check_circle highlight_off highlight_off
11 Position NVARCHAR(255) check_circle highlight_off highlight_off
12 Stelle NVARCHAR(255) check_circle highlight_off highlight_off
13 Mitarbeiterstatus NVARCHAR(50) check_circle highlight_off highlight_off
14 Befristung NVARCHAR(50) check_circle highlight_off highlight_off
15 BefristungDatum DATETIME check_circle highlight_off highlight_off
16 SVKennung NVARCHAR(50) check_circle highlight_off highlight_off
17 Taetigkeit1 NVARCHAR(255) check_circle highlight_off highlight_off
18 TaetigkeitAnteil1 INT check_circle highlight_off highlight_off
19 Taetigkeit2 NVARCHAR(255) check_circle highlight_off highlight_off
20 TaetigkeitAnteil2 INT check_circle highlight_off highlight_off
21 Taetigkeit3 NVARCHAR(255) check_circle highlight_off highlight_off
22 TaetigkeitAnteil3 INT check_circle highlight_off highlight_off
23 Taetigkeit4 NVARCHAR(255) check_circle highlight_off highlight_off
24 TaetigkeitAnteil4 INT check_circle highlight_off highlight_off
25 Taetigkeit5 NVARCHAR(255) check_circle highlight_off highlight_off
26 TaetigkeitAnteil5 INT check_circle highlight_off highlight_off
27 Stammkostenstelle1 NVARCHAR(255) check_circle highlight_off highlight_off
28 StammkostenstelleAnteil1 INT check_circle highlight_off highlight_off
29 Stammkostenstelle2 NVARCHAR(255) check_circle highlight_off highlight_off
30 StammkostenstelleAnteil2 INT check_circle highlight_off highlight_off
31 Stammkostenstelle3 NVARCHAR(255) check_circle highlight_off highlight_off
32 StammkostenstelleAnteil3 INT check_circle highlight_off highlight_off
33 Stammkostenstelle4 NVARCHAR(255) check_circle highlight_off highlight_off
34 StammkostenstelleAnteil4 INT check_circle highlight_off highlight_off
35 Stammkostenstelle5 NVARCHAR(255) check_circle highlight_off highlight_off
36 StammkostenstelleAnteil5 INT check_circle highlight_off highlight_off
37 WochenAZ NUMERIC check_circle highlight_off highlight_off
38 TageWoche NUMERIC check_circle highlight_off highlight_off
39 Stundensatz NUMERIC check_circle highlight_off highlight_off
40 Grundgehalt NUMERIC check_circle highlight_off highlight_off
41 Stellenanteil NUMERIC check_circle highlight_off highlight_off
42 GueltigVon DATETIME check_circle highlight_off highlight_off
43 GueltigVonDate DATETIME check_circle highlight_off highlight_off
44 GueltigBisDate DATETIME check_circle highlight_off highlight_off
45 RowKey BIGINT check_circle highlight_off highlight_off

Referenzierte Objekte

Referenziert von

result.vHR_Tarifbetraege

View stellt die Tarifbetraege aus der Integration bereit

# Name Datentyp NULL Identity Berechnet
1 CompanyKey NVARCHAR(63) highlight_off highlight_off highlight_off
2 MandantenID NVARCHAR(50) highlight_off highlight_off highlight_off
3 TarifID NVARCHAR(50) highlight_off highlight_off highlight_off
4 TarifName NVARCHAR(255) check_circle highlight_off highlight_off
5 TarifGruppeID NVARCHAR(255) check_circle highlight_off highlight_off
6 TarifGruppeName NVARCHAR(255) check_circle highlight_off highlight_off
7 TarifStufe NVARCHAR(255) check_circle highlight_off highlight_off
8 TarifBetrag MONEY check_circle highlight_off highlight_off
9 GueltigVon DATETIME check_circle highlight_off highlight_off
10 GueltigVonDate DATETIME check_circle highlight_off highlight_off
11 GueltigBisDate DATETIME check_circle highlight_off highlight_off
12 Rowkey BIGINT check_circle highlight_off highlight_off

Referenzierte Objekte

Referenziert von

result.vHR_Tarifzuordnung

View stellt die Tarifzuordnung aus der Integration bereit

# Name Datentyp NULL Identity Berechnet
1 CompanyKey NVARCHAR(63) highlight_off highlight_off highlight_off
2 MandantenID NVARCHAR(50) highlight_off highlight_off highlight_off
3 Personalnummer NVARCHAR(50) highlight_off highlight_off highlight_off
4 TarifID NVARCHAR(50) highlight_off highlight_off highlight_off
5 TarifName NVARCHAR(255) check_circle highlight_off highlight_off
6 TarifGruppeID NVARCHAR(255) check_circle highlight_off highlight_off
7 TarifGruppeName NVARCHAR(255) check_circle highlight_off highlight_off
8 TarifStufe NVARCHAR(255) check_circle highlight_off highlight_off
9 GueltigVon DATETIME check_circle highlight_off highlight_off
10 GueltigVonDate DATETIME check_circle highlight_off highlight_off
11 GueltigBisDate DATETIME check_circle highlight_off highlight_off
12 Rowkey BIGINT check_circle highlight_off highlight_off

Referenzierte Objekte

Referenziert von

result.vHR_Zeitbuchungen

View stellt die Zeitbuchungen aus der Integration bereit

# Name Datentyp NULL Identity Berechnet
1 CompanyKey NVARCHAR(63) highlight_off highlight_off highlight_off
2 MandantenID NVARCHAR(50) highlight_off highlight_off highlight_off
3 Personalnummer NVARCHAR(50) highlight_off highlight_off highlight_off
4 ZeitbuchungTypeCODE NVARCHAR(50) highlight_off highlight_off highlight_off
5 GueltigVon DATETIME highlight_off highlight_off highlight_off
6 GueltigBis DATETIME check_circle highlight_off highlight_off
7 ZeitbuchungID NVARCHAR(50) check_circle highlight_off highlight_off
8 ZeitbuchungName NVARCHAR(255) check_circle highlight_off highlight_off
9 BereichID NVARCHAR(50) check_circle highlight_off highlight_off
10 BereichName NVARCHAR(255) check_circle highlight_off highlight_off
11 AufgabenID NVARCHAR(50) check_circle highlight_off highlight_off
12 AufgabenKuerzel NVARCHAR(50) check_circle highlight_off highlight_off
13 AufgabenName NVARCHAR(255) check_circle highlight_off highlight_off
14 KontenID NVARCHAR(50) check_circle highlight_off highlight_off
15 KostenstellenID NVARCHAR(50) check_circle highlight_off highlight_off
16 DienstTyp NVARCHAR(50) check_circle highlight_off highlight_off
17 Betrag NUMERIC check_circle highlight_off highlight_off
18 Rowkey BIGINT check_circle highlight_off highlight_off

Referenzierte Objekte

Referenziert von

Prozeduren

agent.pDeleteIntegrationValuesHR

This stored procedure is used to delete data from all tables of the module "HR".

# Parameter Datentyp
1 @DataSourceKey INT
DataSourceKey
2 @CompanyID NVARCHAR(50)
OCT identifier for the company.
3 @PeriodFrom INT
PeriodFrom
4 @PeriodTo INT
PeriodTo
5 @Username NVARCHAR(255)
Username
6 @IsDeltaloadBool BIT
IsDeltaloadBool
7 @Module NVARCHAR(255)
Module

Referenzierte Objekte

agent.pPostBulkloadHR

This the post bulkload procedure of module "HR". The procedure triggers the sync of master data from integration to global schema including foster parent handling.

# Parameter Datentyp
1 @Username NVARCHAR(255)
Username
2 @CompanyKeys NVARCHAR(MAX)
List of CompanyKeys, semicolon separated.

Referenzierte Objekte

agent.pSyncHR

Procedure to transfer integration data of module HR to result schema.

# Parameter Datentyp
1 @Username NVARCHAR(255)
Username
2 @CompanyKeys NVARCHAR(MAX)
CompanyKeys
3 @FullRebuild BIT
Force full rebuild of fact tables.

Referenzierte Objekte

result.pVAL_HR_HTML_ZV_HR_Start

# Parameter Datentyp
1 @Username NVARCHAR(255)
2 @FactoryID NVARCHAR(255)
3 @ProductlineID NVARCHAR(255)

Referenzierte Objekte

result.pVAL_HR_Pivot_Lohnjournal

Default Balance Sheet

# Parameter Datentyp
1 @Username NVARCHAR(255)
Username
2 @FactoryID NVARCHAR(255)
FactoryID
3 @ProductlineID NVARCHAR(255)
ProductlineID

Referenzierte Objekte

result.pVAL_HR_Pivot_Personalstamm

Default Balance Sheet

# Parameter Datentyp
1 @Username NVARCHAR(255)
Username
2 @FactoryID NVARCHAR(255)
FactoryID
3 @ProductlineID NVARCHAR(255)
ProductlineID

Referenzierte Objekte