Employee Table

Administering employee information in Microsoft Dynamics NAV enables you to register and update personnel information effectively, and it gives you easy access to all employee information. This can be beneficial in providing department managers with useful information; for example, the names of employees with a certain qualification or the name of an employee's closest relative in case of emergency.

Keeping track of your employees also helps the company manage hiring and training needs. You can use the Employee table to register all employee information. The table can help you organize this information, which is then in easy reach for later use.

The Human Resources application area is linked to the Resources application area. So when you update certain basic information about the employee (such as name, address, social security number, employment date and so on) in the Employee table, the program automatically updates the resource card for the employee.

The Employee table contains a card for each employee, on which you enter basic information. Each employee must also have an employee number, which can consist of numbers and/or letters. The program uses the employee's number in other windows to link information specific to the individual employee with his employee number.

The program can display employee information in two different windows:

• The Employee Card window has a card for each employee, containing all the fields you have selected. You can therefore see many fields for each employee.

• The Employee List window displays all the employees, with a line for each - fewer fields are therefore displayed for each employee.

In the Absences window you can see an individual employee's absences that you registered for the employee in the Absence Registration window. You can see all the employee's qualifications by clicking Related Information, pointing to Employee, and choosing Qualifications. In this window, you can enter additional qualifications as the employee acquires them.

There are also various windows that provide you with an overview of, for example, the employee's absences categorized by type or the various company articles that the employee is in possession of.

All employees must be set up in this table.

List of Fields in the Table

The following table lists the fields in this table.

Field	Location
Alt. Address Code Field, Employee Table	Human Resources
Initials Field, Employee Table	Human Resources
Termination Date Field, Employee Table	Human Resources
Comment Field, Employee Table	Human Resources
Alt. Address Start Date Field, Employee Table	Human Resources
Global Dimension 1 Code Field, Employee Table	Human Resources
Search Name Field, Employee Table	Human Resources
Manager No. Field, Employee Table	Human Resources
Mobile Phone No. Field, Employee Table	Human Resources
Middle Name Field, Employee Table	Human Resources
Address Field, Employee Table	Human Resources
Date Filter Field, Employee Table	Human Resources
Cause of Absence Filter Field, Employee Table	Human Resources
Inactive Date Field, Employee Table	Human Resources
Alt. Address End Date Field, Employee Table	Human Resources
Pager Field, Employee Table	Human Resources
Picture Field, Employee Table	Human Resources
Fax No. Field, Employee Table	Human Resources
Union Code Field, Employee Table	Human Resources
E-Mail Field, Employee Table	Human Resources
Emplymt. Contract Code Field, Employee Table	Human Resources
Social Security No. Field, Employee Table	Human Resources
Employment Date Field, Employee Table	Human Resources
Address 2 Field, Employee Table	Human Resources
Global Dimension 1 Filter Field, Employee Table	Human Resources
Last Name Field, Employee Table	Human Resources
Employee No. Filter Field, Employee Table	Human Resources
Job Title Field, Employee Table	Human Resources
Status Field, Employee Table	Human Resources
No. Series Field, Employee Table	Human Resources
Extension Field, Employee Table	Human Resources
Birth Date Field, Employee Table	Human Resources
Global Dimension 2 Code Field, Employee Table	Human Resources
Resource No. Field, Employee Table	Human Resources
First Name Field, Employee Table	Human Resources
Company E-Mail Field, Employee Table	Human Resources
Union Membership No. Field, Employee Table	Human Resources
Salespers./Purch. Code Field, Employee Table	Human Resources
No. Field, Employee Table	Human Resources
City Field, Employee Table	Human Resources
Grounds for Term. Code Field, Employee Table	Human Resources
Total Absence (Base) Field, Employee Table	Human Resources
Country/Region Code Field, Employee Table	Human Resources
Gender Field, Employee Table	Human Resources
Title Field, Employee Table	Human Resources
County Field, Employee Table	Human Resources
Last Date Modified Field, Employee Table	Human Resources
Global Dimension 2 Filter Field, Employee Table	Human Resources
Post Code Field, Employee Table	Human Resources
Statistics Group Code Field, Employee Table	Human Resources
Cause of Inactivity Code Field, Employee Table	Human Resources
Phone No. Field, Employee Table	Human Resources
Birth Place Code Field, Employee Table	Italy Local Functionality
Marital Status Field, Employee Table	France Local Functionality
Birth Place Field, Employee Table	Italy Local Functionality
Cost Object Code Field, Employee Table	General Ledger
Cost Center Code Field, Employee Table	General Ledger
Alt. Address Code Field, Employee Table	Human Resources
Initials Field, Employee Table	Human Resources
Termination Date Field, Employee Table	Human Resources
Comment Field, Employee Table	Human Resources
Alt. Address Start Date Field, Employee Table	Human Resources
Global Dimension 1 Code Field, Employee Table	Human Resources
Search Name Field, Employee Table	Human Resources
Manager No. Field, Employee Table	Human Resources
Mobile Phone No. Field, Employee Table	Human Resources
Middle Name Field, Employee Table	Human Resources
Address Field, Employee Table	Human Resources
Date Filter Field, Employee Table	Human Resources
Cause of Absence Filter Field, Employee Table	Human Resources
Inactive Date Field, Employee Table	Human Resources
Alt. Address End Date Field, Employee Table	Human Resources
Pager Field, Employee Table	Human Resources
Picture Field, Employee Table	Human Resources
Fax No. Field, Employee Table	Human Resources
Union Code Field, Employee Table	Human Resources
E-Mail Field, Employee Table	Human Resources
Emplymt. Contract Code Field, Employee Table	Human Resources
Social Security No. Field, Employee Table	Human Resources
Employment Date Field, Employee Table	Human Resources
Address 2 Field, Employee Table	Human Resources
Global Dimension 1 Filter Field, Employee Table	Human Resources
Last Name Field, Employee Table	Human Resources
Employee No. Filter Field, Employee Table	Human Resources
Job Title Field, Employee Table	Human Resources
Cost Object Code Field, Employee Table	Human Resources
Status Field, Employee Table	Human Resources
No. Series Field, Employee Table	Human Resources
Extension Field, Employee Table	Human Resources
Cost Center Code Field, Employee Table	Human Resources
Birth Date Field, Employee Table	Human Resources
Global Dimension 2 Code Field, Employee Table	Human Resources
Resource No. Field, Employee Table	Human Resources
First Name Field, Employee Table	Human Resources
Company E-Mail Field, Employee Table	Human Resources
Union Membership No. Field, Employee Table	Human Resources
Salespers./Purch. Code Field, Employee Table	Human Resources
No. Field, Employee Table	Human Resources
City Field, Employee Table	Human Resources
Grounds for Term. Code Field, Employee Table	Human Resources
Total Absence (Base) Field, Employee Table	Human Resources
Country/Region Code Field, Employee Table	Human Resources
Gender Field, Employee Table	Human Resources
Title Field, Employee Table	Human Resources
County Field, Employee Table	Human Resources
Last Date Modified Field, Employee Table	Human Resources
Global Dimension 2 Filter Field, Employee Table	Human Resources
Post Code Field, Employee Table	Human Resources
Statistics Group Code Field, Employee Table	Human Resources
Cause of Inactivity Code Field, Employee Table	Human Resources
Phone No. Field, Employee Table	Human Resources
Marital Status Field, Employee Table	France Local Functionality
Birth Place Code Field, Employee Table	Italy Local Functionality
Birth Place Field, Employee Table	Italy Local Functionality

See Also

Reference

Employee Card