employee
The employee table.
Columns
Name | Type | References | Description |
id [KEY] | Integer | Internal ID | |
accountnumber | String | Account | |
aliennumber | String | Alien Number | |
approvallimit | Decimal | Expense Approval Limit | |
approver | String | Expense Approver | |
authworkdate | Date | Authorized to Work Until | |
billpay | Boolean | Enable Online Bill Pay | |
birthdate | Date | Birth Date | |
class | String | Class | |
comments | String | Notes | |
currency | String | Currency | |
datecreated | Date | Date Created | |
defaultacctcorpcardexp | String | Default Account for Corporate Card Expenses | |
defaultexpensereportcurrency | String | Default Currency For Expense Reports | |
defaultjobresourcerole | String | Default Job Resource Role | |
department | String | Department | |
eligibleforcommission | Boolean | Eligible for Commission | |
String | |||
employeestatus | String | Employee Status | |
employeetype | String | Type | |
entityid | String | Entity ID | |
ethnicity | String | Ethnicity | |
expenselimit | Decimal | Expense Limit | |
externalid | String | External ID | |
firstname | String | First Name | |
gender | String | Gender | |
giveaccess | Boolean | Login Access | |
globalsubscriptionstatus | String | Global Subscription Status | |
hiredate | Date | Hire Date | |
i9verified | Boolean | I-9 Verified | |
initials | String | Initials | |
isinactive | Boolean | Is Inactive | |
isjobmanager | Boolean | Job Manager | |
isjobresource | Boolean | Job Resource | |
issalesrep | Boolean | Sales Rep | |
issupportrep | Boolean | Support Rep | |
jobdescription | String | Job Description | |
laborcost | Decimal | Labor Cost | |
lastname | String | Last Name | |
lastreviewdate | Date | Last Review Date | |
location | String | Location | |
maritalstatus | String | Marital Status | |
middlename | String | Middle Name | |
nextreviewdate | Date | Next Review Date | |
purchaseorderapprovallimit | Decimal | Purchase Approval Limit | |
purchaseorderapprover | String | Purchase Approver | |
purchaseorderlimit | Decimal | Purchase Limit | |
releasedate | Date | Termination/Release Date | |
residentstatus | String | Resident Status | |
salesrole | String | Sales Role | |
salutation | String | Mr./Ms... | |
subsidiary | String | Subsidiary | |
supervisor | String | Supervisor | |
targetutilization | Double | Target Utilization | |
timeapprover | String | Time Approver | |
title | String | Job Title | |
visaexpdate | Date | Visa Expiration Date | |
visatype | String | Visa Type | |
workcalendar | String | Work Calendar |