Technische Dokumentation Modul HR

Inhaltsverzeichnis

Informationen

Dokumentationstyp: Vollständig (zur Endanwender Dokumentation)
Erstellt am: 03.12.2025
Modulversion: 29
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(255) 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 KontenID NVARCHAR(50) check_circle highlight_off highlight_off
KontenID aus dem Lohnjournals
10 Wert BIGINT highlight_off highlight_off highlight_off
Wert centisiert (ohne Nachkommastellen)
11 CustomValuesJSON NVARCHAR(4000) check_circle highlight_off highlight_off
Custom field to store any customer individual informations.

Referenziert von

integration.tHR_Konten

# 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 KontenID NVARCHAR(50) highlight_off highlight_off highlight_off
Eindeutige ID des Kontos
5 KontenName NVARCHAR(255) check_circle highlight_off highlight_off
Name des Kontos
6 CustomValuesJSON NVARCHAR(MAX) check_circle highlight_off highlight_off
Custom field to store any customer individual informations.

Referenziert von

integration.tHR_Kostenstellen

# 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 KostenstellenID NVARCHAR(50) highlight_off highlight_off highlight_off
Eindeutige ID der Kostenstelle
5 KostenstellenName NVARCHAR(255) check_circle highlight_off highlight_off
Name der Kostenstelle
6 CustomValuesJSON NVARCHAR(MAX) 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(255) highlight_off highlight_off highlight_off
Eindeutige ID der Lohnart
5 LohnartName NVARCHAR(255) check_circle highlight_off highlight_off
Name der Lohnart
6 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 MerkmalName 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 BefristungGrund NVARCHAR(50) check_circle highlight_off highlight_off
Grund der Befristung (sofern befristet).
12 BefristungDatum DATETIME check_circle highlight_off highlight_off
Datum der Befristung (sofern befristet).
13 Funktion NVARCHAR(255) check_circle highlight_off highlight_off
unktion des Mitarbeiters. Kann inhaltlich in verschiedenen ERP Systemen unterschiedlich besetzt sein.
14 Taetigkeit NVARCHAR(255) check_circle highlight_off highlight_off
Berufsgruppe/Dienstart (DA), häufig auch Taetigkeitsschlüssel. Bei mehreren Taetigkeiten nur die Wichtigste.
15 StammKostenstellenID NVARCHAR(255) check_circle highlight_off highlight_off
Stammkostenstelle des Mitarbeiters. In der Regel bildet die Stammkostenstelle eine organisatorische Zugehörigkeit ab
16 WochenAZ BIGINT check_circle highlight_off highlight_off
Wochenarbeitszeit in Stunden (centisiert). 4000 = 40 Stunden
17 WochenAZFirma BIGINT check_circle highlight_off highlight_off
Wochenarbeitszeit Vollzeit der Firma in Stunden (centisiert). 4000 = 40 Stunden.
18 GueltigVon DATETIME check_circle highlight_off highlight_off
Gueltigkeitsbeginn für diese Zeile. Das Datum, ab dieser Datensatz gültig ist.
19 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(255) check_circle highlight_off highlight_off
7 KostenstellenID NVARCHAR(50) check_circle highlight_off highlight_off
8 KontenID NVARCHAR(50) check_circle highlight_off highlight_off
9 Wert MONEY highlight_off highlight_off highlight_off
10 RowKey BIGINT check_circle highlight_off highlight_off
RowKey

Referenziert von

result.tHR_Konten

Tabelle stellt Stammdaten zu Konten bereit. Tabelle wird durch die Datenbereitstellung aus der View result.vHR_Konten 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 KontenID NVARCHAR(50) highlight_off highlight_off highlight_off
4 KontenName NVARCHAR(255) check_circle highlight_off highlight_off

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(255) highlight_off highlight_off highlight_off
4 LohnartName NVARCHAR(255) check_circle highlight_off highlight_off
5 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 MerkmalName 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 BefristungGrund NVARCHAR(50) check_circle highlight_off highlight_off
12 BefristungDatum DATETIME check_circle highlight_off highlight_off
13 Funktion NVARCHAR(255) check_circle highlight_off highlight_off
14 Taetigkeit NVARCHAR(255) check_circle highlight_off highlight_off
15 StammKostenstellenID NVARCHAR(255) check_circle highlight_off highlight_off
16 WochenAZ MONEY check_circle highlight_off highlight_off
17 WochenAZFirma MONEY check_circle highlight_off highlight_off
18 GueltigVon DATETIME check_circle highlight_off highlight_off
19 GueltigVonDate DATETIME check_circle highlight_off highlight_off
20 GueltigBisDate DATETIME check_circle highlight_off highlight_off
21 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 BefristungGrund NVARCHAR(50) check_circle highlight_off highlight_off
12 BefristungDatum DATETIME check_circle highlight_off highlight_off
13 Funktion NVARCHAR(255) check_circle highlight_off highlight_off
14 Taetigkeit NVARCHAR(255) check_circle highlight_off highlight_off
15 StammKostenstellenID NVARCHAR(255) check_circle highlight_off highlight_off
16 WochenAZ MONEY check_circle highlight_off highlight_off
17 WochenAZFirma MONEY check_circle highlight_off highlight_off
18 GueltigVon DATETIME check_circle highlight_off highlight_off
19 GueltigVonDate DATETIME check_circle highlight_off highlight_off
20 GueltigBisDate DATETIME check_circle highlight_off highlight_off
21 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_Konten

This view resolves the CustomValuesJSON column in table integration.tHR_Konten 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_Kostenstellen

This view resolves the CustomValuesJSON column in table integration.tHR_Kostenstellen 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 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(255) check_circle highlight_off highlight_off
7 KostenstellenID NVARCHAR(50) check_circle highlight_off highlight_off
8 KontenID NVARCHAR(50) check_circle highlight_off highlight_off
9 Wert MONEY check_circle highlight_off highlight_off
10 Rowkey BIGINT check_circle highlight_off highlight_off

Referenzierte Objekte

Referenziert von

result.vHR_Konten

View stellt die Konten 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 KontenID NVARCHAR(50) highlight_off highlight_off highlight_off
4 KontenName NVARCHAR(255) check_circle highlight_off highlight_off
5 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) check_circle highlight_off highlight_off
5 Rowkey BIGINT check_circle 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(255) highlight_off highlight_off highlight_off
4 LohnartName NVARCHAR(255) check_circle highlight_off highlight_off
5 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 MerkmalName 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 BefristungGrund NVARCHAR(50) check_circle highlight_off highlight_off
12 BefristungDatum DATETIME check_circle highlight_off highlight_off
13 Funktion NVARCHAR(255) check_circle highlight_off highlight_off
14 Taetigkeit NVARCHAR(255) check_circle highlight_off highlight_off
15 StammKostenstellenID NVARCHAR(255) check_circle highlight_off highlight_off
16 WochenAZ MONEY check_circle highlight_off highlight_off
17 WochenAZFirma MONEY check_circle highlight_off highlight_off
18 GueltigVon DATETIME check_circle highlight_off highlight_off
19 GueltigVonDate DATETIME check_circle highlight_off highlight_off
20 GueltigBisDate DATETIME check_circle highlight_off highlight_off
21 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 BefristungGrund NVARCHAR(50) check_circle highlight_off highlight_off
12 BefristungDatum DATETIME check_circle highlight_off highlight_off
13 Funktion NVARCHAR(255) check_circle highlight_off highlight_off
14 Taetigkeit NVARCHAR(255) check_circle highlight_off highlight_off
15 StammKostenstellenID NVARCHAR(255) check_circle highlight_off highlight_off
16 WochenAZ MONEY check_circle highlight_off highlight_off
17 WochenAZFirma MONEY check_circle highlight_off highlight_off
18 GueltigVon DATETIME check_circle highlight_off highlight_off
19 GueltigVonDate DATETIME check_circle highlight_off highlight_off
20 GueltigBisDate DATETIME check_circle highlight_off highlight_off
21 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.pMaintenanceRecreateViewsHR

This stored procedure is used to refresh all views of the HR module.

# Parameter Datentyp
1 @Username NVARCHAR(255)
Username

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