Technische Dokumentation Modul ZEIT
Inhaltsverzeichnis
Dokumentationstyp: |
Vollständig (zur Endanwender Dokumentation) |
Erstellt am: |
07.12.2023 |
Modulversion: |
5 |
Modultyp: |
Basismodul |
Beschreibung: |
Modul für Verwaltung von Zeitbuchungen von Personalsystemen |
Benötigt Administrator Rechte: |
Nein |
Ab OCT Version: |
5.10.11 |
Tabellen
integration.tZEIT_Abwesenheitsarten
Speichern der Stammdaten bzw. Bezeichnungen der verschiedenen Abwesenheiten (z.B. Urlaub, Krankheit, Fortbildung).
# |
Name |
Datentyp |
NULL |
Identity |
Berechnet |
1 |
RowKey |
BIGINT |
highlight_off |
check_circle |
highlight_off |
|
Technical primary Key for row identity. |
2 |
DataSourceKey |
INT |
highlight_off |
highlight_off |
highlight_off |
|
Technical primary Key of datasource. DataSourceKey is used to create a unique identifier when paired with CompanyID. |
3 |
CompanyID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
OCT identifier for the company. Part of AccountKey. |
4 |
AbwesenheitsartID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
Idendifikator der Absenheitsart |
5 |
Langname |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
Langname der Absenheitsart |
6 |
Kurzname |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
Kurzname der Absenheitsart |
7 |
CustomValuesJSON |
NVARCHAR(MAX) |
check_circle |
highlight_off |
highlight_off |
|
Custom field to store any customer individual informations |
Referenziert von
integration.tZEIT_Abwesenheitsjournal
Tabelle zum Speichern des Abweseneitsjournals je Mitarbeiter
# |
Name |
Datentyp |
NULL |
Identity |
Berechnet |
1 |
RowKey |
BIGINT |
highlight_off |
check_circle |
highlight_off |
|
Technical primary Key for row identity. |
2 |
DataSourceKey |
INT |
highlight_off |
highlight_off |
highlight_off |
|
Technical primary Key of datasource. DataSourceKey is used to create a unique identifier when paired with CompanyID. |
3 |
CompanyID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
OCT identifier for the company. Part of AccountKey. |
4 |
PersID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
5 |
Jahr |
INT |
highlight_off |
highlight_off |
highlight_off |
|
Jahr |
6 |
Monat |
INT |
highlight_off |
highlight_off |
highlight_off |
|
Monat |
7 |
AbwesenheitsartID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
Idendifikator der Absenheitsart |
8 |
Tage |
BIGINT |
highlight_off |
highlight_off |
highlight_off |
|
Abwesenheitstage (BIGINT - um 100 skaliert) |
9 |
CustomValuesJSON |
NVARCHAR(MAX) |
check_circle |
highlight_off |
highlight_off |
|
Custom field to store any customer individual informations |
Referenziert von
integration.tZEIT_Mehrarbeit
Tabelle zum Speichern des monatlichen Mehrarbeitssaldos je Mitarbeiter
# |
Name |
Datentyp |
NULL |
Identity |
Berechnet |
1 |
RowKey |
BIGINT |
highlight_off |
check_circle |
highlight_off |
|
Technical primary Key for row identity. |
2 |
DataSourceKey |
INT |
highlight_off |
highlight_off |
highlight_off |
|
Technical primary Key of datasource. DataSourceKey is used to create a unique identifier when paired with CompanyID. |
3 |
CompanyID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
OCT identifier for the company. Part of AccountKey. |
4 |
PersID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
5 |
Jahr |
INT |
highlight_off |
highlight_off |
highlight_off |
|
Jahr |
6 |
Monat |
INT |
highlight_off |
highlight_off |
highlight_off |
|
Monat |
7 |
MehrarbeitSaldo |
BIGINT |
highlight_off |
highlight_off |
highlight_off |
|
Über- bzw. Minusstunden am Ende des Monats in Minuten |
8 |
CustomValuesJSON |
NVARCHAR(MAX) |
check_circle |
highlight_off |
highlight_off |
|
Custom field to store any customer individual informations |
Referenziert von
integration.tZEIT_Organisationseinheiten
Speichern von Organisationseinheiten.
# |
Name |
Datentyp |
NULL |
Identity |
Berechnet |
1 |
RowKey |
BIGINT |
highlight_off |
highlight_off |
highlight_off |
|
|
2 |
DataSourceKey |
INT |
highlight_off |
highlight_off |
highlight_off |
|
|
3 |
CompanyID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
4 |
OrgID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
5 |
Langname |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
|
6 |
Kurzname |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
|
7 |
CustomValuesJSON |
NVARCHAR(MAX) |
check_circle |
highlight_off |
highlight_off |
|
|
Referenziert von
integration.tZEIT_Personalstammdaten
Speichern von Personalstammdaten.
# |
Name |
Datentyp |
NULL |
Identity |
Berechnet |
1 |
RowKey |
BIGINT |
highlight_off |
highlight_off |
highlight_off |
|
|
2 |
DataSourceKey |
INT |
highlight_off |
highlight_off |
highlight_off |
|
|
3 |
CompanyID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
4 |
PersID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
5 |
Personalnummer |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
6 |
OrgID |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
7 |
Nachname |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
|
8 |
Vorname |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
|
9 |
CustomValuesJSON |
NVARCHAR(MAX) |
check_circle |
highlight_off |
highlight_off |
|
|
Referenziert von
integration.tZEIT_Resturlaub
Tabelle zum Speichern des Resturlaubs je Mitarbeiter
# |
Name |
Datentyp |
NULL |
Identity |
Berechnet |
1 |
RowKey |
BIGINT |
highlight_off |
check_circle |
highlight_off |
|
Technical primary Key for row identity. |
2 |
DataSourceKey |
INT |
highlight_off |
highlight_off |
highlight_off |
|
Technical primary Key of datasource. DataSourceKey is used to create a unique identifier when paired with CompanyID. |
3 |
CompanyID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
OCT identifier for the company. Part of AccountKey. |
4 |
PersID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
5 |
Jahr |
INT |
highlight_off |
highlight_off |
highlight_off |
|
Jahr |
6 |
Monat |
INT |
highlight_off |
highlight_off |
highlight_off |
|
Monat |
7 |
AbwesenheitsartID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
Idendifikator der Absenheitsart |
8 |
GuthabenAlt |
BIGINT |
highlight_off |
highlight_off |
highlight_off |
|
Resturlaubguthaben aus dem alten Jahr (BIGINT - um 100 skaliert) |
9 |
GuthabenAktuell |
BIGINT |
highlight_off |
highlight_off |
highlight_off |
|
Resturlaubguthaben aus dem aktuellen Jahr (BIGINT - um 100 skaliert) |
10 |
GuthabenUnverplant |
BIGINT |
highlight_off |
highlight_off |
highlight_off |
|
Unverplanter Urlaub im aktuellen Jahr (BIGINT - um 100 skaliert) |
11 |
CustomValuesJSON |
NVARCHAR(MAX) |
check_circle |
highlight_off |
highlight_off |
|
|
Referenziert von
Sichten
result.vZEIT_Abwesenheitsarten
Bereitstellung der Daten aus der Tabelle integration.tZEIT_Abwesenheitsarten.
# |
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 |
AbwesenheitsartID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
4 |
Kurzname |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
|
5 |
Langname |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
|
Referenzierte Objekte
Referenziert von
result.vZEIT_Abwesenheitsjournal
Bereitstellung der Daten aus der Tabelle integration.tZEIT_Abwesenheitsjournal.
# |
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 |
PersID |
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 |
AbwesenheitsartID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
7 |
Tage |
MONEY |
check_circle |
highlight_off |
highlight_off |
|
|
Referenzierte Objekte
Referenziert von
result.vZEIT_Mehrarbeit
Bereitstellung der Daten aus der Tabelle integration.tZEIT_Mehrarbeit.
# |
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 |
PersID |
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 |
MehrarbeitSaldo |
MONEY |
check_circle |
highlight_off |
highlight_off |
|
|
Referenzierte Objekte
Referenziert von
result.vZEIT_Organisationseinheiten
Bereitstellung der Daten aus der Tabelle integration.tZEIT_Organisationseinheiten.
# |
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 |
OrgID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
4 |
Kurzname |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
|
5 |
Langname |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
|
Referenzierte Objekte
Referenziert von
result.vZEIT_Personalstammdaten
Bereitstellung der Daten aus der Tabelle integration.tZEIT_Personalstammdaten.
# |
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 |
PersID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
4 |
Personalnummer |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
5 |
OrgID |
NVARCHAR(50) |
check_circle |
highlight_off |
highlight_off |
|
|
6 |
Nachname |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
|
7 |
Vorname |
NVARCHAR(255) |
check_circle |
highlight_off |
highlight_off |
|
|
Referenzierte Objekte
Referenziert von
result.vZEIT_Resturlaub
Bereitstellung der Daten aus der Tabelle integration.tZEIT_Resturlaub.
# |
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 |
PersID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
4 |
AbwesenheitsartID |
NVARCHAR(50) |
highlight_off |
highlight_off |
highlight_off |
|
|
5 |
Jahr |
INT |
highlight_off |
highlight_off |
highlight_off |
|
|
6 |
Monat |
INT |
highlight_off |
highlight_off |
highlight_off |
|
|
7 |
GuthabenAlt |
MONEY |
check_circle |
highlight_off |
highlight_off |
|
|
8 |
GuthabenAktuell |
MONEY |
check_circle |
highlight_off |
highlight_off |
|
|
9 |
GuthabenUnverplant |
MONEY |
check_circle |
highlight_off |
highlight_off |
|
|
Referenzierte Objekte
Referenziert von
Prozeduren
agent.pDeleteIntegrationValuesZEIT
This stored procedure is used to delete data from all tables of the module "ZEIT".
# |
Parameter |
Datentyp |
1 |
@DataSourceKey |
INT |
|
DataSourceKey |
2 |
@CompanyID |
NVARCHAR(50) |
|
OCT identifier for the company. Part of AccountKey. |
3 |
@PeriodFrom |
INT |
|
PeriodFrom |
4 |
@PeriodTo |
INT |
|
PeriodTo |
5 |
@Username |
NVARCHAR(255) |
|
Username |
6 |
@IsDeltaloadBool |
BIT |
|
IsDeltaloadBool |
7 |
@Module |
NVARCHAR(255) |
|
Module |
Referenzierte Objekte
agent.pPostBulkloadZEIT
This the post bulkload procedure of module "ZEIT". The procedure triggers the sync of master data from integration to global schema including foster parent handling.
# |
Parameter |
Datentyp |
1 |
@Username |
NVARCHAR(255) |
|
Username |
2 |
@CompanyKeys |
NVARCHAR(MAX) |
|
List of CompanyKeys, semicolon separated. |
Referenzierte Objekte
- dbo.sx_pf_pPOST_API_LogEntry
- system.spGET_ParameterString
- system.spGET_TransactUsername
- system.spSEND_Message
agent.pSyncZEIT
Procedure to transfer data of module ZEIT to result schema.
# |
Parameter |
Datentyp |
1 |
@Username |
NVARCHAR(255) |
|
Username |
2 |
@CompanyKeys |
NVARCHAR(MAX) |
|
CompanyKeys |
3 |
@FullRebuild |
BIT |
|
Force full rebuild of fact tables. |
Referenzierte Objekte