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 |