Technische Dokumentation Modul HR-STP

Inhaltsverzeichnis

Informationen

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

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