Technische Dokumentation Modul HR-STP
Inhaltsverzeichnis
Dokumentationstyp: |
Vollständig (zur Endanwender Dokumentation) |
Erstellt am: |
07.06.2023 |
Modulversion: |
5 |
Modultyp: |
Erweiterung für das Modul HR |
Beschreibung: |
Modul für HR Stellenpläne |
Benötigt Administrator Rechte: |
Nein |
Ab OCT Version: |
5.10.11 |
Tabellen
global.tDays
Tabelle für die Views des Moduls CARE_VIVENDI, die mit Tagen arbeiten.
# |
Name |
Datentyp |
NULL |
Identity |
Berechnet |
1 |
Tages_Key |
INT |
highlight_off |
highlight_off |
highlight_off |
|
Tages_Key |
2 |
Datum |
DATETIME2 |
highlight_off |
highlight_off |
highlight_off |
|
|
3 |
JJ |
NVARCHAR(255) |
highlight_off |
highlight_off |
highlight_off |
|
|
4 |
JJJJ |
INT |
highlight_off |
highlight_off |
highlight_off |
|
|
5 |
Q |
INT |
highlight_off |
highlight_off |
highlight_off |
|
|
6 |
QQ |
NVARCHAR(255) |
highlight_off |
highlight_off |
highlight_off |
|
|
7 |
M |
INT |
highlight_off |
highlight_off |
highlight_off |
|
|
8 |
MM |
NVARCHAR(255) |
highlight_off |
highlight_off |
highlight_off |
|
|
9 |
MM_JJ |
NVARCHAR(255) |
highlight_off |
highlight_off |
highlight_off |
|
|
10 |
MM_JJJJ |
NVARCHAR(255) |
highlight_off |
highlight_off |
highlight_off |
|
|
11 |
Woche |
INT |
highlight_off |
highlight_off |
highlight_off |
|
|
12 |
TagDesJahres |
NVARCHAR(255) |
highlight_off |
highlight_off |
highlight_off |
|
|
13 |
TTT |
NVARCHAR(255) |
highlight_off |
highlight_off |
highlight_off |
|
|
14 |
TTTT |
NVARCHAR(255) |
highlight_off |
highlight_off |
highlight_off |
|
|
15 |
MMM |
NVARCHAR(255) |
highlight_off |
highlight_off |
highlight_off |
|
|
16 |
MMMM |
NVARCHAR(255) |
highlight_off |
highlight_off |
highlight_off |
|
|
17 |
QQQ |
NVARCHAR(255) |
highlight_off |
highlight_off |
highlight_off |
|
|
18 |
QQQQ |
NVARCHAR(255) |
highlight_off |
highlight_off |
highlight_off |
|
|
19 |
TT_MM_JJJJ |
NVARCHAR(255) |
highlight_off |
highlight_off |
highlight_off |
|
|
20 |
TT_MMMM_JJJJ |
NVARCHAR(255) |
highlight_off |
highlight_off |
highlight_off |
|
|
21 |
AnzahlTageMonat |
INT |
highlight_off |
highlight_off |
highlight_off |
|
|
22 |
IstErsterTagDesJahres |
INT |
highlight_off |
highlight_off |
highlight_off |
|
|
23 |
IstLetzterTagDesJahres |
INT |
highlight_off |
highlight_off |
highlight_off |
|
|
24 |
IstErsterTagDesMonats |
INT |
highlight_off |
highlight_off |
highlight_off |
|
|
25 |
IstLetzterTagDesMonats |
INT |
highlight_off |
highlight_off |
highlight_off |
|
|
26 |
IstErsterTagDerWoche |
INT |
highlight_off |
highlight_off |
highlight_off |
|
|
27 |
IstLetzterTagDerWoche |
INT |
highlight_off |
highlight_off |
highlight_off |
|
|
28 |
IstErsterTagDesQuartals |
INT |
highlight_off |
highlight_off |
highlight_off |
|
|
29 |
IstLetzterTagDesQuartals |
INT |
highlight_off |
highlight_off |
highlight_off |
|
|
Referenziert von
integration.tSTP_StBewertung_KOArbeitszeit_DV
###Beschreibung###
# |
Name |
Datentyp |
NULL |
Identity |
Berechnet |
1 |
RowKey |
BIGINT |
highlight_off |
highlight_off |
highlight_off |
|
|
2 |
DataSourceKey |
NVARCHAR(255) |
highlight_off |
highlight_off |
highlight_off |
|
|
3 |
Mandanten_ID |
NVARCHAR(255) |
highlight_off |
highlight_off |
highlight_off |
|
|
4 |
Stellen_ID |
NVARCHAR(255) |
highlight_off |
highlight_off |
highlight_off |
|
|
5 |
Datum_ST |
DATETIME |
highlight_off |
highlight_off |
highlight_off |
|
|
6 |
AZTab |
NVARCHAR(255) |
highlight_off |
highlight_off |
highlight_off |
|
|
7 |
KOAT_Abper |
NVARCHAR(255) |
highlight_off |
highlight_off |
highlight_off |
|
|
8 |
Arbeitszeit_Monat |
NVARCHAR(255) |
highlight_off |
highlight_off |
highlight_off |
|
|
9 |
Arbeitszeit_Tag |
NVARCHAR(255) |
highlight_off |
highlight_off |
highlight_off |
|
|
10 |
Zeitmodell |
NVARCHAR(255) |
highlight_off |
highlight_off |
highlight_off |
|
|
Referenziert von
integration.tSTP_Stellen
###Beschreibung###
# |
Name |
Datentyp |
NULL |
Identity |
Berechnet |
1 |
RowKey |
BIGINT |
highlight_off |
highlight_off |
highlight_off |
|
|
2 |
DataSourceKey |
NVARCHAR(255) |
highlight_off |
highlight_off |
highlight_off |
|
|
3 |
Mandanten_ID |
NVARCHAR(255) |
highlight_off |
highlight_off |
highlight_off |
|
|
4 |
Stellen_ID |
NVARCHAR(255) |
highlight_off |
highlight_off |
highlight_off |
|
|
5 |
Datum_ST |
DATETIME |
highlight_off |
highlight_off |
highlight_off |
|
|
6 |
StellenCode |
NVARCHAR(255) |
highlight_off |
highlight_off |
highlight_off |
|
|
7 |
Status |
NVARCHAR(255) |
highlight_off |
highlight_off |
highlight_off |
|
|
8 |
bis |
DATETIME |
check_circle |
highlight_off |
highlight_off |
|
|
9 |
befristet |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
|
10 |
StellenName |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
|
11 |
Amtsbezeichnung |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
|
12 |
Rufbereitschaft |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
|
13 |
Bereitschaftsdienst |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
|
14 |
Aktenzeichen |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
|
15 |
Schichtdienst |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
|
16 |
Stellenkategorie |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
|
17 |
Zielsetzung |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
|
18 |
Laufbahngruppe |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
|
19 |
Standort |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
|
20 |
Dienstart |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
|
21 |
AutoBez |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
|
Referenziert von
integration.tSTP_Stellen_KST_Zuordnung
###Beschreibung###
# |
Name |
Datentyp |
NULL |
Identity |
Berechnet |
1 |
RowKey |
BIGINT |
highlight_off |
highlight_off |
highlight_off |
|
|
2 |
DataSourceKey |
NVARCHAR(255) |
highlight_off |
highlight_off |
highlight_off |
|
|
3 |
Mandanten_ID |
NVARCHAR(255) |
highlight_off |
highlight_off |
highlight_off |
|
|
4 |
Stellen_ID |
NVARCHAR(255) |
highlight_off |
highlight_off |
highlight_off |
|
|
5 |
Datum_ST |
DATETIME |
highlight_off |
highlight_off |
highlight_off |
|
|
6 |
Kostenstellen_ID |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
|
7 |
von |
DATETIME |
check_circle |
highlight_off |
highlight_off |
|
|
8 |
bis |
DATETIME |
check_circle |
highlight_off |
highlight_off |
|
|
9 |
Anteil |
NUMERIC |
check_circle |
highlight_off |
highlight_off |
|
|
10 |
Kostenstellen_Key |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
|
11 |
KostenstellenName |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
|
Referenziert von
integration.tSTP_Stellenbesetzung
###Beschreibung###
# |
Name |
Datentyp |
NULL |
Identity |
Berechnet |
1 |
RowKey |
BIGINT |
highlight_off |
highlight_off |
highlight_off |
|
|
2 |
DataSourceKey |
NVARCHAR(255) |
highlight_off |
highlight_off |
highlight_off |
|
|
3 |
Mandanten_ID |
NVARCHAR(255) |
highlight_off |
highlight_off |
highlight_off |
|
|
4 |
PersonalNummer |
NVARCHAR(255) |
highlight_off |
highlight_off |
highlight_off |
|
|
5 |
Stellen_ID |
NVARCHAR(255) |
highlight_off |
highlight_off |
highlight_off |
|
|
6 |
Beginn |
DATETIME |
highlight_off |
highlight_off |
highlight_off |
|
|
7 |
MDNr_ST |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
|
8 |
Ende |
DATETIME |
check_circle |
highlight_off |
highlight_off |
|
|
9 |
Anteil |
NUMERIC |
check_circle |
highlight_off |
highlight_off |
|
|
10 |
Status |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
|
11 |
Bemerkung |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
|
12 |
Hist_status |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
|
13 |
ANAustritt |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
|
14 |
Austritt_uebern |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
|
15 |
Stellenanteil |
NUMERIC |
check_circle |
highlight_off |
highlight_off |
|
|
Referenziert von
Sichten
result.vSTP_Lohnabrechnung_Stammkostenstelle_Mitarbeiter
###Beschreibung###
# |
Name |
Datentyp |
NULL |
Identity |
Berechnet |
1 |
Mandanten_ID |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
2 |
MandantenName |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
|
3 |
Abrechnungsmonat |
INT |
check_circle |
highlight_off |
highlight_off |
|
|
4 |
Monat |
INT |
highlight_off |
highlight_off |
highlight_off |
|
|
5 |
Jahr |
INT |
highlight_off |
highlight_off |
highlight_off |
|
|
6 |
PersonalNummer |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
7 |
PersonalName |
NVARCHAR(512) |
check_circle |
highlight_off |
highlight_off |
|
|
8 |
PersonalVorname |
VARCHAR(1) |
highlight_off |
highlight_off |
highlight_off |
|
|
9 |
Stammkostenstellen_ID |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
|
10 |
StammkostenstellenBezeichnung |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
|
11 |
Buchungsschluessel |
VARCHAR(1) |
highlight_off |
highlight_off |
highlight_off |
|
|
12 |
Lohnbestandteil |
VARCHAR(1) |
highlight_off |
highlight_off |
highlight_off |
|
|
13 |
Betrag |
MONEY |
check_circle |
highlight_off |
highlight_off |
|
|
Referenzierte Objekte
- global.tCompanies
- global.tPeriods
- result.tHR_Journal
- result.tHR_Kostenstellen
- result.tHR_Personalstammdaten
result.vSTP_Stellenbesetzung_Monat
###Beschreibung###
# |
Name |
Datentyp |
NULL |
Identity |
Berechnet |
1 |
Mandanten_ID |
NVARCHAR(255) |
highlight_off |
highlight_off |
highlight_off |
|
|
2 |
PersonalNummer |
NVARCHAR(255) |
highlight_off |
highlight_off |
highlight_off |
|
|
3 |
Stellen_ID |
NVARCHAR(255) |
highlight_off |
highlight_off |
highlight_off |
|
|
4 |
Beginn |
DATETIME |
highlight_off |
highlight_off |
highlight_off |
|
|
5 |
MDNr_ST |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
|
6 |
Ende |
DATETIME |
check_circle |
highlight_off |
highlight_off |
|
|
7 |
Anteil |
NUMERIC |
check_circle |
highlight_off |
highlight_off |
|
|
8 |
Status |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
|
9 |
Bemerkung |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
|
10 |
Hist_status |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
|
11 |
ANAustritt |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
|
12 |
Austritt_uebern |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
|
13 |
Stellenanteil |
NUMERIC |
check_circle |
highlight_off |
highlight_off |
|
|
14 |
M |
INT |
highlight_off |
highlight_off |
highlight_off |
|
|
15 |
JJJJ |
INT |
highlight_off |
highlight_off |
highlight_off |
|
|
16 |
MM_JJJJ |
NVARCHAR(255) |
highlight_off |
highlight_off |
highlight_off |
|
|
Referenzierte Objekte
Prozeduren
agent.pDeleteIntegrationValuesSTP
This stored procedure is used to delete data from all tables of the module "STP".
# |
Parameter |
Datentyp |
1 |
@DataSourceKey |
INT |
|
|
2 |
@CompanyID |
NVARCHAR(50) |
|
|
3 |
@PeriodFrom |
INT |
|
|
4 |
@PeriodTo |
INT |
|
|
5 |
@MasterDataOnly |
BIT |
|
|
6 |
@Username |
NVARCHAR(255) |
|
|
7 |
@ProcessID |
NVARCHAR(50) |
|
|
8 |
@SubProcessID |
NVARCHAR(50) |
|
|
9 |
@IsDeltaloadBool |
BIT |
|
|
10 |
@Solution |
NVARCHAR(50) |
|
|
Referenzierte Objekte