| 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. |