Technische Dokumentation Modul HR-CP
Inhaltsverzeichnis
Dokumentationstyp: |
Vollständig (zur Endanwender Dokumentation) |
Erstellt am: |
08.03.2024 |
Modulversion: |
13 |
Modultyp: |
Erweiterung für das Modul HR |
Beschreibung: |
Modul für den Import von Personaldaten in CP-Suite |
Benötigt Administrator Rechte: |
Nein |
Ab OCT Version: |
5.10.11 |
Sichten
result.vHR_CP_KostenstellenVerteilungPerioden
View stellt Stammdaten zum Personal bereit. Dabei wird die Gültigkeit der Merkmale auf Perioden gemappt, sowie die Anwesenheit anhand von Eintritts- und Austrittsdatum ermittelt.
# |
Name |
Datentyp |
NULL |
Identity |
Berechnet |
1 |
MandantenID |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
MandantenID |
2 |
KalenderJahr |
VARCHAR(30) |
check_circle |
highlight_off |
highlight_off |
|
|
3 |
KalenderMonat |
VARCHAR(30) |
check_circle |
highlight_off |
highlight_off |
|
|
4 |
Periode |
NVARCHAR(4000) |
check_circle |
highlight_off |
highlight_off |
|
|
5 |
Personalnummer |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
6 |
Personalname |
NVARCHAR(512) |
check_circle |
highlight_off |
highlight_off |
|
|
7 |
PersonalNummerName |
NVARCHAR(565) |
check_circle |
highlight_off |
highlight_off |
|
|
8 |
KostenstellenID |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
9 |
KostenstellenBez |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
|
10 |
KostenstellenIDBez |
NVARCHAR(308) |
check_circle |
highlight_off |
highlight_off |
|
|
11 |
Verteilung |
NUMERIC |
check_circle |
highlight_off |
highlight_off |
|
|
Referenzierte Objekte
- global.tPeriods
- result.tHR_Journal
- result.tHR_Kostenstellen
- result.tHR_KostenstellenVerteilung
- result.tHR_Personalstammdaten
Referenziert von
result.vHR_CP_Lohnjournal
View stellt Stammdaten zum Personal bereit. Dabei wird die Gültigkeit der Merkmale auf Perioden gemappt, sowie die Anwesenheit anhand von Eintritts- und Austrittsdatum ermittelt.
# |
Name |
Datentyp |
NULL |
Identity |
Berechnet |
1 |
MandantenID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
MandantenID |
2 |
MandantenName |
NVARCHAR(255) |
highlight_off |
highlight_off |
highlight_off |
|
MandantenName |
3 |
MandantenIDName |
NVARCHAR(308) |
highlight_off |
highlight_off |
highlight_off |
|
MandantenIDName |
4 |
Personalnummer |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
Personalnummer |
5 |
Personalname |
NVARCHAR(512) |
check_circle |
highlight_off |
highlight_off |
|
Personalname |
6 |
PersonalNummerName |
NVARCHAR(565) |
check_circle |
highlight_off |
highlight_off |
|
PersonalNummerName |
7 |
LohnartID |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
LohnartID |
8 |
LohnartBez |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
LohnartBez |
9 |
LohnartIDBez |
NVARCHAR(308) |
check_circle |
highlight_off |
highlight_off |
|
LohnartIDBez |
10 |
KostenstellenID |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
KostenstellenID |
11 |
KostenstellenBez |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
KostenstellenBez |
12 |
KostenstellenIDBez |
NVARCHAR(308) |
check_circle |
highlight_off |
highlight_off |
|
KostenstellenIDBez |
13 |
Jahr |
INT |
highlight_off |
highlight_off |
highlight_off |
|
Jahr |
14 |
Monat |
INT |
highlight_off |
highlight_off |
highlight_off |
|
Monat |
15 |
Periode |
NVARCHAR(7) |
check_circle |
highlight_off |
highlight_off |
|
Periode |
16 |
Wert |
MONEY |
highlight_off |
highlight_off |
highlight_off |
|
Wert |
Referenzierte Objekte
- global.tCompanies
- result.tHR_Journal
- result.tHR_Kostenstellen
- result.tHR_Lohnarten
- result.tHR_Personalstammdaten
Referenziert von
result.vHR_CP_PersonalPerioden
View stellt Stammdaten zum Personal bereit. Dabei wird die Gültigkeit der Merkmale auf Perioden gemappt, sowie die Anwesenheit anhand von Eintritts- und Austrittsdatum ermittelt.
# |
Name |
Datentyp |
NULL |
Identity |
Berechnet |
1 |
MandantenID |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
MandantenID |
2 |
KalenderJahr |
VARCHAR(30) |
check_circle |
highlight_off |
highlight_off |
|
|
3 |
KalenderMonat |
VARCHAR(30) |
check_circle |
highlight_off |
highlight_off |
|
|
4 |
Periode |
NVARCHAR(4000) |
check_circle |
highlight_off |
highlight_off |
|
|
5 |
Personalnummer |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
6 |
Personalname |
NVARCHAR(512) |
check_circle |
highlight_off |
highlight_off |
|
|
7 |
PersonalNummerName |
NVARCHAR(565) |
check_circle |
highlight_off |
highlight_off |
|
|
8 |
Eintrittsdatum |
DATETIME |
check_circle |
highlight_off |
highlight_off |
|
|
9 |
Austrittsdatum |
DATETIME |
check_circle |
highlight_off |
highlight_off |
|
|
10 |
KostenstellenID |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
|
11 |
KostenstellenBez |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
|
12 |
KostenstellenIDBez |
NVARCHAR(513) |
check_circle |
highlight_off |
highlight_off |
|
|
13 |
Anwesend |
INT |
highlight_off |
highlight_off |
highlight_off |
|
|
14 |
Geschlecht |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
|
15 |
Geburtsdatum |
DATETIME |
check_circle |
highlight_off |
highlight_off |
|
|
16 |
Jahrgang |
INT |
check_circle |
highlight_off |
highlight_off |
|
|
17 |
Alter |
INT |
check_circle |
highlight_off |
highlight_off |
|
|
18 |
WochenAZ |
NUMERIC |
check_circle |
highlight_off |
highlight_off |
|
|
19 |
BetriebszugehoerigkeitMonate |
INT |
check_circle |
highlight_off |
highlight_off |
|
|
Referenzierte Objekte
- global.tPeriods
- result.tHR_Journal
- result.tHR_Kostenstellen
- result.tHR_Personalstammdaten
result.vHR_CP_TarifbetraegePerioden
View stellt Tarifbetraege bereit. Dabei wird die Gültigkeit der Tarifbetraege auf Perioden gemappt.
# |
Name |
Datentyp |
NULL |
Identity |
Berechnet |
1 |
MandantenID |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
MandantenID |
2 |
KalenderJahr |
VARCHAR(30) |
check_circle |
highlight_off |
highlight_off |
|
|
3 |
KalenderMonat |
VARCHAR(30) |
check_circle |
highlight_off |
highlight_off |
|
|
4 |
Periode |
NVARCHAR(4000) |
check_circle |
highlight_off |
highlight_off |
|
|
5 |
TarifID |
NVARCHAR(50) |
check_circle |
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 |
TarifBetrag |
MONEY |
check_circle |
highlight_off |
highlight_off |
|
|
Referenzierte Objekte
- global.tPeriods
- result.tHR_Journal
- result.tHR_Tarifbetraege
result.vHR_CP_TarifzuordnungPerioden
View stellt zeitliche Tarifzuordnungen bereit. Dabei wird die Gültigkeit der Zuordnungen auf Perioden gemappt.
# |
Name |
Datentyp |
NULL |
Identity |
Berechnet |
1 |
MandantenID |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
MandantenID |
2 |
KalenderJahr |
VARCHAR(30) |
check_circle |
highlight_off |
highlight_off |
|
|
3 |
KalenderMonat |
VARCHAR(30) |
check_circle |
highlight_off |
highlight_off |
|
|
4 |
Periode |
NVARCHAR(4000) |
check_circle |
highlight_off |
highlight_off |
|
|
5 |
Personalnummer |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
6 |
Personalname |
NVARCHAR(512) |
check_circle |
highlight_off |
highlight_off |
|
|
7 |
PersonalNummerName |
NVARCHAR(565) |
check_circle |
highlight_off |
highlight_off |
|
|
8 |
TarifID |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
9 |
TarifName |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
|
10 |
TarifGruppeID |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
|
11 |
TarifGruppeName |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
|
12 |
TarifStufe |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
|
Referenzierte Objekte
- global.tPeriods
- result.tHR_Journal
- result.tHR_Personalstammdaten
- result.tHR_Tarifzuordnung
result.vHR_CP_ZeitbuchungenBetrag
View stellt die Zeitbuchungen pro Periode und Mitarbeiter bereit.
# |
Name |
Datentyp |
NULL |
Identity |
Berechnet |
1 |
MandantenID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
MandantenID |
2 |
Personalnummer |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
3 |
Personalname |
NVARCHAR(512) |
check_circle |
highlight_off |
highlight_off |
|
|
4 |
PersonalNummerName |
NVARCHAR(565) |
check_circle |
highlight_off |
highlight_off |
|
|
5 |
ZeitbuchungTypeCODE |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
6 |
ZeitbuchungID |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
7 |
ZeitbuchungName |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
|
8 |
BereichID |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
9 |
BereichName |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
|
10 |
AufgabenID |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
11 |
AufgabenKuerzel |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
12 |
AufgabenName |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
|
13 |
KontenID |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
14 |
KostenstellenID |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
15 |
DienstTyp |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
16 |
KalenderJahr |
INT |
check_circle |
highlight_off |
highlight_off |
|
|
17 |
KalenderMonat |
INT |
check_circle |
highlight_off |
highlight_off |
|
|
18 |
Periode |
NVARCHAR(4000) |
check_circle |
highlight_off |
highlight_off |
|
|
19 |
Datum |
DATE |
check_circle |
highlight_off |
highlight_off |
|
|
20 |
Betrag |
NUMERIC |
check_circle |
highlight_off |
highlight_off |
|
|
Referenzierte Objekte
- result.tHR_Personalstammdaten
- result.tHR_Zeitbuchungen
Referenziert von
result.vHR_CP_ZeitbuchungenTage
View stellt die Tage pro Periode und Mitarbeiter bereit.
# |
Name |
Datentyp |
NULL |
Identity |
Berechnet |
1 |
MandantenID |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
MandantenID |
2 |
Personalnummer |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
3 |
Personalname |
NVARCHAR(512) |
check_circle |
highlight_off |
highlight_off |
|
|
4 |
PersonalNummerName |
NVARCHAR(565) |
check_circle |
highlight_off |
highlight_off |
|
|
5 |
ZeitbuchungTypeCODE |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
6 |
ZeitbuchungID |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
7 |
ZeitbuchungName |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
|
8 |
BereichID |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
9 |
BereichName |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
|
10 |
AufgabenID |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
11 |
AufgabenKuerzel |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
12 |
AufgabenName |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
|
13 |
KontenID |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
14 |
KostenstellenID |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
15 |
DienstTyp |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
16 |
KalenderJahr |
INT |
check_circle |
highlight_off |
highlight_off |
|
|
17 |
KalenderMonat |
INT |
check_circle |
highlight_off |
highlight_off |
|
|
18 |
Periode |
NVARCHAR(4000) |
check_circle |
highlight_off |
highlight_off |
|
|
19 |
AnzahlTage |
INT |
check_circle |
highlight_off |
highlight_off |
|
|
Referenzierte Objekte
- result.tHR_PersonalstammdatenAktuell
- result.tHR_Zeitbuchungen
Referenziert von
Prozeduren
result.pVAL_HR_CP_KstVerteilungPerioden
# |
Parameter |
Datentyp |
1 |
@Username |
NVARCHAR(255) |
|
Username |
2 |
@FactoryID |
NVARCHAR(255) |
|
FactoryID |
3 |
@ProductlineID |
NVARCHAR(255) |
|
ProductlineID |
Referenzierte Objekte
result.pVAL_HR_CP_Lohnjournal
# |
Parameter |
Datentyp |
1 |
@Username |
NVARCHAR(255) |
|
Username |
2 |
@FactoryID |
NVARCHAR(255) |
|
FactoryID |
3 |
@ProductlineID |
NVARCHAR(255) |
|
ProductlineID |
Referenzierte Objekte
result.pVAL_HR_CP_PersonalKstPerioden
# |
Parameter |
Datentyp |
1 |
@Username |
NVARCHAR(255) |
|
Username |
2 |
@FactoryID |
NVARCHAR(255) |
|
FactoryID |
3 |
@ProductlineID |
NVARCHAR(255) |
|
ProductlineID |
Referenzierte Objekte
- dbo.sx_pf_Determine_TransactionUsername
- dbo.sx_pf_pPOST_API_LogEntry
- planning.tfValues
result.pVAL_HR_CP_ZeitbuchungenBetrag
# |
Parameter |
Datentyp |
1 |
@Username |
NVARCHAR(255) |
|
Username |
2 |
@FactoryID |
NVARCHAR(255) |
|
FactoryID |
3 |
@ProductlineID |
NVARCHAR(255) |
|
ProductlineID |
Referenzierte Objekte
result.pVAL_HR_CP_ZeitbuchungenTage
# |
Parameter |
Datentyp |
1 |
@Username |
NVARCHAR(255) |
|
Username |
2 |
@FactoryID |
NVARCHAR(255) |
|
FactoryID |
3 |
@ProductlineID |
NVARCHAR(255) |
|
ProductlineID |
Referenzierte Objekte