Technische Dokumentation Modul ZEIT
Inhaltsverzeichnis
Dokumentationstyp: |
Endanwender (zur vollständigen 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 |
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
- integration.tZEIT_Abwesenheitsarten
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
- integration.tZEIT_Abwesenheitsjournal
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
- integration.tZEIT_Mehrarbeit
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
- integration.tZEIT_Organisationseinheiten
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
- integration.tZEIT_Personalstammdaten
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
- integration.tZEIT_Resturlaub
Referenziert von