Technische Dokumentation Modul HR

Inhaltsverzeichnis

Informationen

Dokumentationstyp: Endanwender (zur vollständigen 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

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_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