Technische Dokumentation Modul HR
Inhaltsverzeichnis
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
- dbo.sx_pf_pPOST_API_LogEntry
- system.spGET_ParameterString
- system.spGET_TransactUsername
- system.spSEND_Message
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