DIH Attendance - Personnel

- if existing, the system updates the following fields: First Name, Last Name, Middle Name, Date of Birth, Start Date, Termination Date.

Field	Name	M	Type	Description
PERS_ID	Employee number	X	nchar(20)
empID	Employer ID		int(4)
NAME1	First Name	X	nvarchar(50)
NAME3	Middle name		nvarchar(50)
NAME2	Last Name	X	nvarchar(50)
DisplayName	DisplayName		char(0)
GEBDAT	Date of birth		datetime(8)	best date format: yyyy/mm/dd hh:mm in 24 hour format Time format with am/pm not working.
SPR_ID	Language		nchar(4)
PERSGRP_ID	Personnel group		nchar(20)
KSTST_ID	Cost Center	X	nchar(20)
MAART	Job Category		smallint(2)
STANDORT	Location		nvarchar(20)
AKTIV	Active		smallint(2)	Valid values: Yes=1 No=0
EINTRDAT	Date of Hire		datetime(8)	best date format: yyyy/mm/dd hh:mm in 24 hour format Time format with am/pm not working.
AUSTRDAT	Exit Date		datetime(8)	best date format: yyyy/mm/dd hh:mm in 24 hour format Time format with am/pm not working.
URLAUB	Standard annual holiday		numeric(4)
SCHICHT1_ID	Default Shift	X	nchar(20)
STDRGL_ID	Period rule	X	nchar(20)
ReportName	Evaluation by report		nvarchar(20)
CARDNUMBER	Card Number		nvarchar(100)
MENUGROUP	Access group		nvarchar(20)
MENUGROUPWEB	Web terminal group		nvarchar(20)
BPLId	BPLId		int(4)
BPLName	BPLName		nvarchar(100)
BPLIds	BPLIds		nvarchar(100)
KOSTENFAKTOR	Cost Rate on time receipt		decimal(9)
KOSTENSATZ_VERWENDEN	use own Cost rate		int(4)
APLATZ_ID	Resource 1	X	nchar(20)	Define, on which resource the user can work. Special characters not allowed. The defined resource must exist.
APLATZ_ID2	Resource 2		nvarchar(20)	Define, on which resource the user can work. Special characters as % and _ are allowed.
APLATZ_ID3	Resource 3		nvarchar(20)	Define, on which resource the user can work. Special characters as % and _ are allowed.
APLATZ_ID4	Resource 4		nvarchar(20)	Define, on which resource the user can work. Special characters as % and _ are allowed.
APLATZ_ID5	Resource 5		nvarchar(20)	Define, on which resource the user can work. Special characters as % and _ are allowed.
APLATZ_ID6	Resource 6		nvarchar(20)	Define, on which resource the user can work. Special characters as % and _ are allowed.
MEHRMASCHINENBEDIENUNG	Machine Grouping		int(4)	If active, the employee can work on multiple machines in parallel (beas_pers.machine grouping) Valid values: Yes=1 No=0
MEHRAUFTRAGSBEDIENUNG	Work Order Grouping		int(4)	If active, the employee can log on to multiple orders at once Valid values: Yes=1 No=0
ALLESANMELDBAR	Allow logon to op. sequ. of all pools		int(4)	if active, the employee can also log on to positions by barcode which are not in the active pool. Only affects Terminal > work order logon. Valid values: Yes=1 No=0
RESSOURCENWECHSEL	Resource selectable		int(4)	Time receipt define, if the emplyee can change the default resource - if current resource is a resource group, then it's always allowed to change - if yes, only resource, which allowed for current user Valid values: No=0 Yes=1 Alternativ Resource=2
KOSTENSTELLENWECHSEL	Cost center selectable		int(4)	Determines whether the "Charge to Cost Center" field is displayed and can be changed for Close Work Order (and only there) Valid values: Yes=1 No=0
ZEITARTWECHSEL	Cost element selectable		int(4)	Determines whether the "Time Type" field is displayed and can be changed for Work order logoff Valid values: yes=1 No=0
ZEITTYP_TR	setting up		int(4)
ZEITTYP_TE	processing		int(4)
ZEITTYP_TN	Rework		int(4)
ZEITTYP_TH	quality control		int(4)
INFO	Remarks		nvarchar(0)
KARTENNR	Card Number		int(4)
UDF1	Userfield 1		nvarchar(100)
UDF2	Userfield 2		nvarchar(100)
UDF3	Userfield 3		nvarchar(100)
UDF4	Userfield 4		nvarchar(100)
KOSTENSATZ	Cost rate		decimal(9)
WEBUSER	Weblogin Name		nvarchar(50)
WEBPWD	Weblogin Password		nvarchar(50)
WEBPWD_DateTo	Weblogin Valid to		datetime(8)	best date format: yyyy/mm/dd hh:mm in 24 hour format Time format with am/pm not working.
ANGESTELLTENSTATUS	Status		smallint(2)
ZEITART_ID	Time Type		nvarchar(20)