Line |
Field Name |
Data Type |
Description |
1 |
str:employeeMasterData |
Table |
Employee master data by employee record. |
2 |
term:departmentCode |
Term (Text/String) |
Code for department rosters. EXAMPLE the department name is IT department, the code is 0018 |
3 |
term:employeeDateOfBirth |
Term (Date) |
Date of Birth of the employee |
4 |
term:employeeFirstName |
Term (Text/String) |
Name of the employee |
5 |
term:employeeId |
Term (Text/String) |
Unique identifier for an employee. Typically auto-generated by the system |
6 |
term:employeeJobTitle |
Term (Text/String) |
Job title of a person in an accounting unit. EXAMPLE Accounting manger |
7 |
term:employeeLastName |
Term (Text/String) |
|
8 |
term:employeeMiddleName |
Term (Text/String) |
|
9 |
term:employeeRefCode |
Term (Text/String) |
Code for employee. Each employee has only one code. If someone has part-time jobs in multiple departments, there will be more than one record with different Employee_ID in this table. The part-time status will be reflected in EmployeeTypeCode |
10 |
term:employmentStartDate |
Term (Date) |
Employment start date of the employee |
11 |
term:employmentTerminationDate |
Term (Date) |
Termination date of the employee from when the labour contract was no longer valid, or from when the employee no longer works in this department |
12 |
term:employmentTypeCode |
Term (Text/String) |
Code for the employee type. EXAMPLE 004 is an on-the-job employee, 005 is a retired employee 006 is a deceased employee. |
13 |
term:employmentTypeName |
Term (Text/String) |
Name of the employee type. Example Employed, retired, probation, part time. |
14 |
term:isActiveFlag |
Term (Text/String) |
Indicates whether one employee is active or inactive. An employee can become inactive due to various reasons (i.e sabbatical leave) |
15 |
term:userId |
Term (Text/String) |
A unique identifier of individuals entering transactions into the ERP system. This field is used to join information in this table to other tables based on the fields Entered_By, Last_Modified_By, and Approved_By. |