DIH Attendance - Absence

Administration > Data Integration Hub > Data integration hub > Import Definition > Definition Data Target > DIH Attendance - Absence

Top  Previous  Next

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/beas202402/index.html?dih_absence.htm