employeeMasterData

11/20/2020 12:37:10 PM

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.