Description
|
See
|
Table
|
Absence areas
|
Edit absence
|
BEAS_ABWZEIT
|
For detailed information on how to import see Data Integration Hub and Source-Target-Link.
Imports absence areas, like holiday, sick leave, etc.
The primary keys are "Personnel ID" and "from date". It is also possible to update this data.
The following details are required:
•Personnel ID
•From Date
•To Date
•Absence ID
Field
|
Name
|
M
|
Type
|
Description
|
PERS_ID
|
Personnel Id
|
X
|
nchar(20)
|
|
ABWGRND_ID
|
Reason Id
|
X
|
nchar(20)
|
|
VON
|
From Date
|
X
|
datetime(8)
|
best date format: yyyy/mm/dd hh:mm in 24 hour format
Time format with am/pm not working.
|
BIS
|
To Date
|
X
|
datetime(8)
|
best date format: yyyy/mm/dd hh:mm in 24 hour format
Time format with am/pm not working.
|
BEZ
|
Description
|
|
nvarchar(30)
|
|
ADDSOLLSTD
|
Add the time to Plan-/Actual Time
|
|
nchar(1)
|
Valid values: Yes=J
No=N
|
ANWBEACHTUNG
|
Consider attendance hours
|
|
smallint(2)
|
Valid values: Yes=1
No=0
|
FREE_OF_WORK
|
Day off
|
|
smallint(2)
|
Valid values: Yes=1
No=0
|
IfAvailable
|
Available
|
|
int(4)
|
Valid values: Yes=1
No=0
|
UDF1
|
User Field f1
|
|
nvarchar(50)
|
|
UDF2
|
User Field f2
|
|
nvarchar(50)
|
|
UDF3
|
User Field f3
|
|
nvarchar(50)
|
|
UDF4
|
User Field f4
|
|
nvarchar(50)
|
|
WAGETYPE1
|
Wage type 1
|
|
nvarchar(20)
|
|
WAGETYPE1PC
|
Wage type 1 %
|
|
decimal(9)
|
|
WAGETYPE2
|
Wage type 2
|
|
nvarchar(20)
|
|
WAGETYPE2PC
|
Wage type 2 %
|
|
decimal(9)
|
|
ABWSTD
|
Absence hour
|
|
numeric(4)
|
|
ZEITBEACHTUNG
|
Check time
|
|
nchar(1)
|
Valid values: Yes=1
No=0
|
Help URL: https://help.beascloud.com/beas202206/index.html?dih_absence.htm
|