Name 
 | 
Type 
 | 
Description 
 | 
PersonnelId 
 | 
Edm.String(20) 
 | 
 Database:  rtrim("BEAS_PERS"."PERS_ID") 
 | 
 
 
 
 | 
empId 
 | 
Edm.Int32 
 | 
 Linked table: OHEM 
Linked column: empID 
Integration hub: Importable 
Database:  "BEAS_PERS"."empID" 
 | 
 
 
 
 | 
FirstName 
 | 
Edm.String(50) 
 | 
 Integration hub: Importable 
Mandatory field 
Database:  "BEAS_PERS"."NAME1" 
 | 
 
 
 
 | 
MiddleName 
 | 
Edm.String(50) 
 | 
 Integration hub: Importable 
Database:  "BEAS_PERS"."NAME3" 
 | 
 
 
 
 | 
LastName 
 | 
Edm.String(50) 
 | 
 Integration hub: Importable 
Mandatory field 
Database:  "BEAS_PERS"."NAME2" 
 | 
 
 
 
 | 
DisplayName 
 | 
Edm.String(50) 
 | 
 | 
Active 
 | 
Edm.Boolean 
 | 
 Default Value: 1 
Constraints:  
Yes=1 
No=0 
Integration hub: Importable 
Database:  "BEAS_PERS"."AKTIV" 
 | 
 
 
 
 | 
Language 
 | 
Edm.String(20) 
 | 
 Database:  rtrim("BEAS_PERS"."SPR_ID") 
 | 
 
 
 
 | 
CardNumber 
 | 
Edm.String(50) 
 | 
 Integration hub: Importable 
Database:  "BEAS_PERS"."CARDNUMBER" 
 | 
 
 
 
 | 
Present 
 | 
Edm.Int32 
 | 
 Database:  case when (select count(*) from "BEAS_ANWSTMP" where "BEAS_ANWSTMP"."PERS_ID"="BEAS_PERS"."PERS_ID") > 0 then 1 else 0 end 
 | 
 
 
 
 | 
MachineGrouping 
 | 
Edm.Boolean 
 | 
 If active, the employee can work on multiple machines in parallel (beas_pers.machine grouping) 
Default Value: 0 
Constraints:  
Yes=1 
No=0 
Integration hub: Importable 
Database:  "BEAS_PERS"."MEHRMASCHINENBEDIENUNG" 
 | 
 
 
 
 | 
WorkorderGrouping 
 | 
Edm.Boolean 
 | 
 If active, the employee can log on to multiple orders at once 
Default Value: 0 
Constraints:  
Yes=1 
No=0 
Integration hub: Importable 
Database:  "BEAS_PERS"."MEHRAUFTRAGSBEDIENUNG" 
 | 
 
 
 
 | 
AllowLogonAllPools 
 | 
Edm.Boolean 
 | 
 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. 
Default Value: 0 
Constraints:  
Yes=1 
No=0 
Integration hub: Importable 
Database:  "BEAS_PERS"."ALLESANMELDBAR" 
 | 
 
 
 
 | 
ResourceSelectable 
 | 
Edm.Int32 
 | 
 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 
Default Value: 0 
Constraints:  
No=0 
Yes=1 
Alternativ Resource=2 
  
Integration hub: Importable 
Database:  "BEAS_PERS"."RESSOURCENWECHSEL" 
 | 
 
 
 
 | 
CostCenterSelectable 
 | 
Edm.Boolean 
 | 
 Determines whether the "Charge to Cost Center" field is displayed and can be changed for Close Work Order (and only there) 
Default Value: 1 
Constraints:  
Yes=1 
No=0 
Integration hub: Importable 
Database:  coalesce("BEAS_PERS"."KOSTENSTELLENWECHSEL",1) 
 | 
 
 
 
 | 
CostElementSelectable 
 | 
Edm.Boolean 
 | 
 Determines whether the "Time Type" field is displayed and can be changed for Work order logoff 
Default Value: 1 
Constraints:  
yes=1 
No=0 
Integration hub: Importable 
Database:  coalesce("BEAS_PERS"."ZEITARTWECHSEL",1) 
 | 
 
 
 
 | 
QCRelease 
 | 
Edm.Boolean 
 | 
 Database:  "BEAS_PERS"."QCMeasurementRelease" 
 | 
 
 
 
 | 
BranchId 
 | 
Edm.Int32 
 | 
 Linked table: OBPL 
Linked column: BPLId 
Integration hub: Importable 
Database:  "BEAS_PERS"."BPLId" 
 | 
 
 
 
 | 
CostRateTimeReceipt 
 | 
Edm.Decimal 
 | 
 Integration hub: Importable 
Database:  coalesce("BEAS_PERS"."KOSTENFAKTOR",0) 
 | 
 
 
 
 | 
UseOwnCostRate 
 | 
Edm.Boolean 
 | 
 Integration hub: Importable 
Database:  coalesce("BEAS_PERS"."KOSTENSATZ_VERWENDEN",0) 
 | 
 
 
 
 | 
CostRate 
 | 
Edm.Decimal 
 | 
 Integration hub: Importable 
Database:  "BEAS_PERS"."KOSTENSATZ" 
 | 
 
 
 
 | 
UDF1 
 | 
Edm.String(50) 
 | 
 Integration hub: Importable 
Database:  "BEAS_PERS"."UDF1" 
 | 
 
 
 
 | 
UDF2 
 | 
Edm.String(50) 
 | 
 Integration hub: Importable 
Database:  "BEAS_PERS"."UDF2" 
 | 
 
 
 
 | 
UDF3 
 | 
Edm.String(50) 
 | 
 Integration hub: Importable 
Database:  "BEAS_PERS"."UDF3" 
 | 
 
 
 
 | 
UDF4 
 | 
Edm.String(50) 
 | 
 Integration hub: Importable 
Database:  "BEAS_PERS"."UDF4" 
 | 
 
 
 
 |