Definition
Table describing the details of the employee.
Temporal and Spatial Information
Data source details
Datasets
| Path name | Data Element | Definition | Data Type | Format |
|---|---|---|---|---|
| employee_id | Employee: Identifier, Text X(32) |
He waehere ahurei kua whakawhiwhia ki tetahi kaimahi mo nga kaupapa tautuhi i roto i tetahi whakahaere, e tohuhia ana e tetahi tuhinga. |
CHARACTERSTRING | X(32) |
| last_name | Employee: Last Name, Text X() | The part of a name an employee usually has in common with some other members of their family, as distinguished from their given names, represented by a text. | String | - |
| first_name | Employee: First Name, Text X() | The first name of an employee that is not their family name, represented by a text. | String | - |
| title | Employee: Title, Text X(32) | The specific job or position that an employee holds within an organisation, indicating their role, responsibilities, and level within the company's hierarchy, represented by a text | CHARACTERSTRING | X(32) |
| title_of_courtesy | Employee: Title of Courtesy, Text X(6) | The respectful or honorific title used when addressing an employee formally, represented by a text. | CHARACTERSTRING | X(6) |
| birth_date | Employee: Birth Date, Date YYYYMMDD | The specific date on which an employee was born, represented by a Date in year first format. | DATE | YYYYMMDD |
| hire_date | Employee: Hire Date, Date YYYYMMDD | The specific date on which an employee was hired for a Job, represented by a Date in year first format. | DATE | YYYYMMDD |
| address | Employee: Address, Text X(120) | The text which defines an employee's full address. | CHARACTERSTRING | X(120) |
| city | Employee: City, Text X(32) | The text that defines the city of an employer's address. | CHARACTERSTRING | X(32) |
| region | Employee: Region, Text X(32) | A name for a defined geographic or administrative area where an employee resides, represented by a text. | CHARACTERSTRING | X(32) |
| postal_code | Employee: Postal Code, Text X(32) | A series of letters or numbers used to identify specific geographic areas, particularly an employee's postal code, for mail delivery purposes, represented by a text. | CHARACTERSTRING | X(32) |
| country | Employee: Country, Text X() | The country in which an employee usually resides, represented as a text. | String | - |
| home_phone | Employee: Home Phone, Text X(32) | The employee's residential landline, represented by text. | CHARACTERSTRING | X(32) |
| extension | Employee: Extension, Text X(32) | A specific internal number for an employee's phone within an organisation's phone system, represented by text. | CHARACTERSTRING | X(32) |
| photo | Employee: Photo, Label | A visual image of an employee captured with a camera or imaging device, represented by a photo label. | - | - |
| notes | Employee: Notes, Text X+ | Personal records or memos created by the employee for their own reference, represented as text. | CHARACTERSTRING | - |
| reports_to | Employee: Reports To, Text X() | It signifies who the employee directly answers to within the organisation's hierarchy, represented by text. | String | - |
| photo_path | Employee: Photo path, Text X+ | The file location where a digital image of an employee is stored on a computer or within a system, represented as text. | CHARACTERSTRING | - |