Table of Contents

Table Employee

ID 5200
Namespace: Microsoft.HumanResources.Employee

Properties

Name Value
Caption Employee
DataCaptionFields 1,2,3,4
DrillDownPageID Page Microsoft.HumanResources.Employee."Employee List"
LookupPageID Page Microsoft.HumanResources.Employee."Employee List"
DataClassification CustomerContent

Fields

Name Type Description
"No." Code[20]

Specifies the number of the involved entry or record, according to the specified number series.
"First Name" Text[30]

Specifies the employee's first name.
"Middle Name" Text[30]

Specifies the employee's middle name.
"Last Name" Text[30]

Specifies the employee's last name.
Initials Text[30]

Specifies the employee's initials.
"Job Title" Text[30]

Specifies the employee's job title.
"Search Name" Code[250]

Specifies an alternate name that you can use to search for the record in question when you cannot remember the value in the Name field.
Address Text[100]

Specifies the employee's address.
"Address 2" Text[50]

Specifies additional address information.
City Text[30]

Specifies the city of the address.
"Post Code" Code[20]

Specifies the postal code.
County Text[30]

Specifies the county of the employee.
"Phone No." Text[30]

Specifies the employee's telephone number.
"Mobile Phone No." Text[30]

Specifies the employee's private telephone number.
"E-Mail" Text[80]

Specifies the employee's private email address.
"Alt. Address Code" Code[10]

Specifies a code for an alternate address.
"Alt. Address Start Date" Date

Specifies the starting date when the alternate address is valid.
"Alt. Address End Date" Date

Specifies the last day when the alternate address is valid.
"Birth Date" Date

Specifies the employee's date of birth.
"Social Security No." Text[30]

Specifies the social security number of the employee.
"Union Code" Code[10]

Specifies the employee's labor union membership code.
"Union Membership No." Text[30]

Specifies the employee's labor union membership number.
Gender Enum Microsoft.HumanResources.Employee."Employee Gender"

Specifies the gender with which the employee identifies.
"Country/Region Code" Code[10]

Specifies the country/region of the address.
"Manager No." Code[20]
"Emplymt. Contract Code" Code[10]

Specifies the employment contract code for the employee.
"Statistics Group Code" Code[10]

Specifies a statistics group code to assign to the employee for statistical purposes.
"Employment Date" Date

Specifies the date when the employee began to work for the company.
Status Enum Microsoft.HumanResources.Employee."Employee Status"

Specifies the employment status of the employee.
"Inactive Date" Date

Specifies the date when the employee became inactive, due to disability or maternity leave, for example.
"Cause of Inactivity Code" Code[10]

Specifies a code for the cause of inactivity by the employee.
"Termination Date" Date

Specifies the date when the employee was terminated, due to retirement or dismissal, for example.
"Grounds for Term. Code" Code[10]

Specifies a termination code for the employee who has been terminated.
"Global Dimension 1 Code" Code[20]
"Global Dimension 2 Code" Code[20]
"Resource No." Code[20]

Specifies a resource number for the employee.
Comment Boolean

Specifies if a comment has been entered for this entry.
"Last Date Modified" Date

Specifies when this record was last modified.
"Date Filter" Date
"Global Dimension 1 Filter" Code[20]
"Global Dimension 2 Filter" Code[20]
"Cause of Absence Filter" Code[10]
"Total Absence (Base)" Decimal
Extension Text[30]

Specifies the employee's telephone extension.
"Employee No. Filter" Code[20]
Pager Text[30]

Specifies the employee's pager number.
"Fax No." Text[30]
"Company E-Mail" Text[80]

Specifies the employee's email address at the company.
Title Text[30]
"Salespers./Purch. Code" Code[20]

Specifies a salesperson or purchaser code for the employee.
"No. Series" Code[20]
"Last Modified Date Time" DateTime
"Employee Posting Group" Code[20]

Specifies the employee's type to link business transactions made for the employee with the appropriate account in the general ledger.
"Bank Branch No." Text[20]

Specifies a number of the bank branch.
"Bank Account No." Text[30]

Specifies the number used by the bank for the bank account.
IBAN Code[50]

Specifies the bank account's international bank account number.
Balance Decimal

Specifies the amount the employee owes the company, or the company owes them. For example, for an overpayment, or for expenses, respectively. The word "balance" indicates the amount can be positive (employee owes the company) or negative (the company owes the employee).
"SWIFT Code" Code[20]

Specifies the SWIFT code (international bank identifier code) of the bank where the employee has the account.
"Balance (LCY)" Decimal

Specifies the amount the employee owes the company, or the company owes them in local currency. For example, for an overpayment, or for expenses, respectively. The word "balance" indicates the amount can be positive (employee owes the company) or negative (the company owes the employee).
"Currency Code" Code[10]

Specifies the currency code that is inserted by default when you create entries for the employee.
"Application Method" Enum Microsoft.Finance.ReceivablesPayables."Application Method"

Specifies how to apply payments to entries for this employee.
"Currency Filter" Code[10]
"Engagement Type" Enum Microsoft.HumanResources.Employee."Employee Engagement Type"

Specifies the value of the Engagement Type field.
"Collective Bargain. Agmt. Info" Boolean

Specifies the value of the Collective Bargaining Agreement Info field.
"Board Member" Boolean

Specifies the value of the Board Member field.
"Manager Role" Boolean

Specifies the value of the Manager Role field.
Payroll Decimal

Specifies the value of the Payroll field.
"Payroll Currency Code" Code[10]

Specifies the value of the Payroll Currency Code field.
"Payroll (LCY)" Decimal
"Payroll Currency Factor" Decimal
Nationality Code[20]

Specifies the value of the Nationality field.
"Working Type" Enum Microsoft.HumanResources.Employee."Employee Working Type"

Specifies the value of the Working Type field.
"Working Hours" Decimal

Specifies the value of the Working Hours field.
Image Media

Specifies the picture of the employee.
"Privacy Blocked" Boolean

Specifies whether to limit access to data for the data subject during daily operations. This is useful, for example, when protecting data from changes while it is under privacy review.
"Allow Multiple Posting Groups" Boolean

Specifies if multiple posting groups can be used for posting business transactions for this customer.
"Cost Center Code" Code[20]
"Cost Object Code" Code[20]
SystemId Guid
SystemCreatedAt DateTime
SystemCreatedBy Guid
SystemModifiedAt DateTime
SystemModifiedBy Guid
SystemCreatedByUserName Text[50]
SystemCreatedByFullName Text[80]
SystemModifiedByUserName Text[50]
SystemModifiedByFullName Text[80]
SystemRowVersion BigInteger

Methods

AssistEdit

procedure AssistEdit(): Boolean

Returns

Type Description
Boolean

FullName

procedure FullName(): Text[100]

Returns

Type Description
Text[100]

ValidateShortcutDimCode

procedure ValidateShortcutDimCode(FieldNumber: Integer; var ShortcutDimCode: Code[20])

Parameters

Name Type Description
FieldNumber Integer
ShortcutDimCode Code[20]

DisplayMap

procedure DisplayMap()

GetBankAccountNo

procedure GetBankAccountNo(): Text

Returns

Type Description
Text

CheckBlockedEmployeeOnJnls

procedure CheckBlockedEmployeeOnJnls(IsPosting: Boolean)

Parameters

Name Type Description
IsPosting Boolean

CheckAllowMultiplePostingGroups

procedure CheckAllowMultiplePostingGroups()

Events

OnBeforeGetFullName

[IntegrationEvent(False,False)]
local procedure OnBeforeGetFullName(Employee: Record Employee; var NewFullName: Text[100]; var Handled: Boolean)

Parameters

Name Type Description
Employee Table Microsoft.HumanResources.Employee.Employee
NewFullName Text[100]
Handled Boolean

OnAfterValidateShortcutDimCode

[IntegrationEvent(False,False)]
local procedure OnAfterValidateShortcutDimCode(var Employee: Record Employee; var xEmployee: Record Employee; FieldNumber: Integer; var ShortcutDimCode: Code[20])

Parameters

Name Type Description
Employee Table Microsoft.HumanResources.Employee.Employee
xEmployee Table Microsoft.HumanResources.Employee.Employee
FieldNumber Integer
ShortcutDimCode Code[20]

OnBeforeAssistEdit

[IntegrationEvent(False,False)]
local procedure OnBeforeAssistEdit(var Employee: Record Employee; xEmployee: Record Employee; var Result: Boolean; var IsHandled: Boolean)

Parameters

Name Type Description
Employee Table Microsoft.HumanResources.Employee.Employee
xEmployee Table Microsoft.HumanResources.Employee.Employee
Result Boolean
IsHandled Boolean

OnBeforeOnInsert

[IntegrationEvent(False,False)]
local procedure OnBeforeOnInsert(var Employee: Record Employee; var xEmployee: Record Employee; var IsHandled: Boolean)

Parameters

Name Type Description
Employee Table Microsoft.HumanResources.Employee.Employee
xEmployee Table Microsoft.HumanResources.Employee.Employee
IsHandled Boolean

OnBeforeValidateShortcutDimCode

[IntegrationEvent(False,False)]
local procedure OnBeforeValidateShortcutDimCode(var Employee: Record Employee; var xEmployee: Record Employee; FieldNumber: Integer; var ShortcutDimCode: Code[20])

Parameters

Name Type Description
Employee Table Microsoft.HumanResources.Employee.Employee
xEmployee Table Microsoft.HumanResources.Employee.Employee
FieldNumber Integer
ShortcutDimCode Code[20]

OnBeforeCheckBlockedEmployee

[IntegrationEvent(False,False)]
local procedure OnBeforeCheckBlockedEmployee(Employee: Record Employee; IsPosting: Boolean; var IsHandled: Boolean)

Parameters

Name Type Description
Employee Table Microsoft.HumanResources.Employee.Employee
IsPosting Boolean
IsHandled Boolean

OnBeforeValidateCity

[IntegrationEvent(False,False)]
local procedure OnBeforeValidateCity(var Employee: Record Employee; var PostCode: Record "Post Code"; CurrentFieldNo: Integer; var IsHandled: Boolean)

Parameters

Name Type Description
Employee Table Microsoft.HumanResources.Employee.Employee
PostCode Table Microsoft.Foundation.Address."Post Code"
CurrentFieldNo Integer
IsHandled Boolean

OnBeforeValidatePostCode

[IntegrationEvent(False,False)]
local procedure OnBeforeValidatePostCode(var Employee: Record Employee; var PostCode: Record "Post Code"; CurrentFieldNo: Integer; var IsHandled: Boolean)

Parameters

Name Type Description
Employee Table Microsoft.HumanResources.Employee.Employee
PostCode Table Microsoft.Foundation.Address."Post Code"
CurrentFieldNo Integer
IsHandled Boolean

OnModifyOnBeforeEmployeeSalespersonUpdate

[IntegrationEvent(False,False)]
local procedure OnModifyOnBeforeEmployeeSalespersonUpdate(var Employee: Record Employee; xEmployee: Record Employee; var IsHandled: Boolean)

Parameters

Name Type Description
Employee Table Microsoft.HumanResources.Employee.Employee
xEmployee Table Microsoft.HumanResources.Employee.Employee
IsHandled Boolean

OnModifyOnBeforeEmployeeResourceUpdate

[IntegrationEvent(False,False)]
local procedure OnModifyOnBeforeEmployeeResourceUpdate(var Employee: Record Employee; xEmployee: Record Employee; var IsHandled: Boolean)

Parameters

Name Type Description
Employee Table Microsoft.HumanResources.Employee.Employee
xEmployee Table Microsoft.HumanResources.Employee.Employee
IsHandled Boolean

OnBeforeSetEmployeeLedgEntryFilterByAccPeriod

[IntegrationEvent(False,False)]
local procedure OnBeforeSetEmployeeLedgEntryFilterByAccPeriod(var EmployeeLedgerEntry: Record "Employee Ledger Entry"; var IsHandled: Boolean)

Parameters

Name Type Description
EmployeeLedgerEntry Table Microsoft.HumanResources.Payables."Employee Ledger Entry"
IsHandled Boolean

See also