Technische Dokumentation Modul HR
Inhaltsverzeichnis
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.pVAL_HR_Pivot_Lohnjournal
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.pVAL_HR_Pivot_Lohnjournal
- result.pVAL_HR_Pivot_Personalstamm
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.pVAL_HR_Pivot_Lohnjournal
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.pVAL_HR_Pivot_Lohnjournal
- result.pVAL_HR_Pivot_Personalstamm
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 |