Employee

Employee

beas Employee Master Data

 

Property

Description

Table

BEAS_PERS

Primary key

PersonnelId/c

$transaction

no

$branch

no

$mask

For dropdown you can use follow mask definition:
1: PersonnelId,DisplayName
You can define follow filter:
&$filter=PersonnelId eq
 

 

Fields

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)

abwesenheiten.htm

Integration hub: Importable

Database: "BEAS_PERS"."DisplayName"

Active

Edm.Boolean

Default Value: 1

Constraints:

Yes=1

No=0

Integration hub: Importable

Database: "BEAS_PERS"."AKTIV"

Language

Edm.String(50)

Integration hub: Importable

Database: "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"

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"

 

Relations

Join to Entiy Object

Relation

EmployeePresent

PERS_ID