employee
Tracks employee records, storing personal and professional details for HR, payroll, and management purposes.
Columns
| Name | Type | References | Description |
| id [KEY] | Integer | The unique internal identifier for the employee record, used to track and reference it within the system. | |
| accountnumber | String | The account number associated with the employee, typically used for payroll or accounting purposes. | |
| aliennumber | String | The alien registration number associated with an employee, typically used for immigration or work authorization tracking. | |
| approvallimit | Decimal | The maximum amount that the employee is authorized to approve for expenses, typically used for budgeting and expense management. | |
| approver | String | The individual responsible for approving the employee's expenses or transactions, typically a manager or supervisor. | |
| authworkdate | Date | The date until the employee is authorized to work, typically used for managing work authorization or visa status. | |
| billpay | Boolean | Indicates whether the employee is eligible for online bill payments, typically used for payroll or reimbursement systems. | |
| birthdate | Date | The employee's date of birth, typically used for identity verification or benefits management. | |
| class | String | The class associated with the employee, used for categorization and classification within organizational or payroll systems. | |
| comments | String | Notes or additional comments about the employee, typically used for internal communication or record-keeping. | |
| currency | String | The currency associated with the employee's pay or expenses, used for reporting and processing payments in the correct currency. | |
| datecreated | Date | The date when the employee record was created, important for tracking the employee's tenure within the system. | |
| defaultacctcorpcardexp | String | The default account to which corporate card expenses will be charged, typically used for tracking and allocating corporate card spending. | |
| defaultexpensereportcurrency | String | The default currency for the employee's expense reports, ensuring consistency in financial reporting. | |
| defaultjobresourcerole | String | The default job resource role for the employee, used for categorizing their responsibilities or function in job-related tasks. | |
| department | String | The department in which the employee works, used for organizational classification and reporting. | |
| eligibleforcommission | Boolean | Indicates whether the employee is eligible for commission-based compensation, typically used for sales roles. | |
| String | The employee's email address, used for communication within the organization. | ||
| employeestatus | String | The current status of the employee, such as 'Active', 'On Leave', or 'Terminated', used for HR and reporting purposes. | |
| employeetype | String | The type of employment the individual holds, such as 'Full-Time', 'Part-Time', 'Contractor', or 'Intern'. | |
| entityid | String | A unique identifier for the employee entity, typically used in systems with multiple entities or business units. | |
| ethnicity | String | The employee's ethnicity, used for diversity reporting and compliance purposes. | |
| expenselimit | Decimal | The maximum amount the employee can expense for a particular period, typically used to control spending within corporate policies. | |
| externalid | String | An external identifier used to link the employee record with external systems or third-party services. | |
| firstname | String | The employee's first name, used for personal identification and records. | |
| gender | String | The employee's gender, used for personal identification and diversity reporting. | |
| giveaccess | Boolean | Indicates whether the employee is granted access to the system or specific resources, often used for security management. | |
| globalsubscriptionstatus | String | The global status of the employee's subscription to benefits, training, or other global programs. | |
| hiredate | Date | The date the employee was hired, marking the start of their employment with the organization. | |
| i9verified | Boolean | Indicates whether the employee's I-9 form has been verified, ensuring compliance with employment eligibility verification laws. | |
| initials | String | The employee's initials, often used for identification in systems where full names are not required. | |
| isinactive | Boolean | Indicates whether the employee record is marked as inactive, meaning they are no longer active within the organization. | |
| isjobmanager | Boolean | Indicates whether the employee holds a managerial role, responsible for overseeing job functions or teams. | |
| isjobresource | Boolean | Indicates whether the employee is considered a job resource, responsible for performing key tasks or functions within the organization. | |
| issalesrep | Boolean | Indicates whether the employee is in a sales representative role, responsible for generating revenue through sales. | |
| issupportrep | Boolean | Indicates whether the employee is in a support representative role, responsible for assisting customers or clients. | |
| jobdescription | String | A detailed description of the employee's job role, outlining their responsibilities and tasks within the organization. | |
| laborcost | Decimal | The employee's labor cost, often used in accounting for tracking expenses related to labor and compensation. | |
| lastname | String | The employee's last name, used for personal identification and records. | |
| lastreviewdate | Date | The date of the employee's last performance review, used for tracking performance evaluation history. | |
| location | String | The physical or organizational location of the employee, typically used for office or remote work classification. | |
| maritalstatus | String | The employee's marital status, often used for benefits or tax purposes. | |
| middlename | String | The employee's middle name, used for formal identification. | |
| nextreviewdate | Date | The scheduled date for the employee's next performance review, used for tracking ongoing performance assessments. | |
| purchaseorderapprovallimit | Decimal | The maximum amount the employee can approve for purchase orders, used for managing spending limits in procurement. | |
| purchaseorderapprover | String | The individual responsible for approving the employee's purchase orders, typically a manager or supervisor. | |
| purchaseorderlimit | Decimal | The maximum value of purchase orders the employee can submit, helping control purchasing within the organization. | |
| releasedate | Date | The employee's termination or release date, typically used for tracking employee exit from the organization. | |
| residentstatus | String | The employee's residency status, such as 'Citizen', 'Permanent Resident', or 'Work Visa', used for legal and tax compliance. | |
| salesrole | String | The role of the employee in the sales process, used to categorize sales responsibilities, such as 'Sales Manager' or 'Account Executive'. | |
| salutation | String | A formal salutation used for the employee, such as 'Mr.', 'Ms.', or 'Dr.', often used in official communications. | |
| subsidiary | String | The subsidiary or business unit within the organization to which the employee belongs. | |
| supervisor | String | The name of the employee's supervisor or manager, typically used for organizational hierarchy and reporting purposes. | |
| targetutilization | Double | The target utilization rate for the employee, often used in resource management to measure the efficiency of time spent on billable tasks. | |
| timeapprover | String | The individual responsible for approving the employee's time entries, such as a manager or team lead. | |
| title | String | The job title of the employee, used for classification and role identification within the organization. | |
| visaexpdate | Date | The expiration date of the employee's visa, used for compliance with immigration and work authorization regulations. | |
| visatype | String | The type of visa the employee holds, relevant for work authorization and compliance purposes. | |
| workcalendar | String | The work calendar associated with the employee, used for scheduling, time off management, and holiday tracking. |