Table 5200 Employee

Base Application, Microsoft.HumanResources.Employee

80 fields

IdNameTypeVersions
1No.Code[20]17-29
2First NameText[30]17-29
3Middle NameText[30]17-29
4Last NameText[30]17-29
5InitialsText[30]17-29
6Job TitleText[30]17-29
7Search NameCode[250]17-29
8AddressText[100]17-29
9Address 2Text[50]17-29
10CityText[30]17-29
11Post CodeCode[20]17-29
12CountyText[30]17-29
13Phone No.Text[30]17-29
14Mobile Phone No.Text[30]17-29
15E-MailText[80]17-29
16Alt. Address CodeCode[10]17-29
17Alt. Address Start DateDate17-29
18Alt. Address End DateDate17-29
19PictureBlobgone after 25
Removed, tag 18.0, obsolete since 17: Replaced by Image field
20Birth DateDate17-29
21Social Security No.Text[30]17-29
22Union CodeCode[10]17-29
23Union Membership No.Text[30]17-29
24GenderEnum "Employee Gender"17-29
25Country/Region CodeCode[10]17-29
26Manager No.Code[20]17-29
27Emplymt. Contract CodeCode[10]17-29
28Statistics Group CodeCode[10]17-29
29Employment DateDate17-29
31StatusEnum "Employee Status"17-29
32Inactive DateDate17-29
33Cause of Inactivity CodeCode[10]17-29
34Termination DateDate17-29
35Grounds for Term. CodeCode[10]17-29
36Global Dimension 1 CodeCode[20]17-29
37Global Dimension 2 CodeCode[20]17-29
38Resource No.Code[20]17-29
39CommentBoolean17-29
40Last Date ModifiedDate17-29
41Date FilterDate17-29
42Global Dimension 1 FilterCode[20]17-29
43Global Dimension 2 FilterCode[20]17-29
44Cause of Absence FilterCode[10]17-29
45Total Absence (Base)Decimal17-29
46ExtensionText[30]17-29
47Employee No. FilterCode[20]17-29
48PagerText[30]17-29
49Fax No.Text[30]17-29
50Company E-MailText[80]17-29
51TitleText[30]17-29
52Salespers./Purch. CodeCode[20]17-29
53No. SeriesCode[20]17-29
54Last Modified Date TimeDateTime17-29
55Employee Posting GroupCode[20]17-29
56Bank Branch No.Text[20]17-29
57Bank Account No.Text[30]17-29
58IBANCode[50]17-29
59BalanceDecimal17-29
60SWIFT CodeCode[20]17-29
70Balance (LCY)Decimalnew in 24
75Currency CodeCode[10]new in 24
80Application MethodEnum "Application Method"17-29changed in 18
90Currency FilterCode[10]new in 24
100Engagement TypeEnum "Employee Engagement Type"new in 27
101Collective Bargain. Agmt. InfoBooleannew in 27
102Board MemberBooleannew in 27
103Manager RoleBooleannew in 27
104PayrollDecimalnew in 27
105Payroll Currency CodeCode[10]new in 27
106Payroll (LCY)Decimalnew in 27
107Payroll Currency FactorDecimalnew in 27
108NationalityCode[20]new in 27changed in 29
109Working TypeEnum "Employee Working Type"new in 27
110Working HoursDecimalnew in 27
140ImageMedia17-29
150Privacy BlockedBoolean17-29
175Allow Multiple Posting GroupsBooleannew in 27
1100Cost Center CodeCode[20]17-29
1101Cost Object CodeCode[20]17-29
8000IdGuidgone after 25
Removed, tag 22.0, obsolete since 17: This functionality will be replaced by the systemID field