# Employees: Gripp CRM Employees - Catalog: `GrippCrm` - Primary Keys: `id` - Label: Employees - Retrieve: True ## Table Columns The columns of the table `Employees` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `active` | `char` | Active | ☐ | | | `adresline2` | `varchar2` | Address Line 2 | ☐ | | | `bankaccount` | `varchar2` | Bank Account | ☐ | | | `bankascription` | `varchar2` | | ☐ | | | `bankcity` | `varchar2` | Bank City | ☐ | | | `city` | `varchar2` | City | ☐ | | | `country` | `varchar2` | Country | ☐ | | | `createdon_date` | `datetime` | Created on Date | ☐ | | | `createdon_timezone_type` | `int32` | Created on Timezone Type | ☐ | | | `createdon_timezone` | `varchar2` | Created on Timezone | ☐ | | | `dateofbirth_date` | `datetime` | Date of Birth (Date) | ☐ | | | `dateofbirth_timezone_type` | `int32` | Date of Birth (Timezone Type) | ☐ | | | `dateofbirth_timezone` | `varchar2` | Date of Birth (Timezone) | ☐ | | | `email` | `varchar2` | Email | ☐ | | | `emailprivate` | `varchar2` | Email Private | ☐ | | | `employeesince_date` | `datetime` | Employee since (Date) | ☐ | | | `employeesince_timezone_type` | `int32` | Employee since (Timezone Type) | ☐ | | | `employeesince_timezone` | `varchar2` | Employee since (Timezone) | ☐ | | | `extendedproperties` | `varchar2` | Extended Properties | ☐ | | | `firstname` | `varchar2` | First Name | ☐ | | | `function` | `varchar2` | Function | ☐ | | | `id` | `int32` | ID | ☐ | | | `infix` | `varchar2` | Infix | ☐ | | | `initials` | `varchar2` | Initials | ☐ | | | `lastname` | `varchar2` | Last Name | ☐ | | | `mobile` | `varchar2` | Mobile | ☐ | | | `notes` | `varchar2` | Notes | ☐ | | | `number` | `int32` | Number | ☐ | | | `password` | `varchar2` | Password | ☑ | | | `phone` | `varchar2` | Phone | ☐ | | | `role_discr` | `varchar2` | | ☐ | | | `role_id` | `int32` | Role ID | ☑ | | | `role_searchname` | `varchar2` | Role Search Name | ☑ | | | `salutation_discr` | `varchar2` | | ☐ | | | `salutation_id` | `int32` | Salutation ID | ☐ | | | `salutation_searchname` | `varchar2` | Salutation Search Name | ☐ | | | `screenname` | `varchar2` | Screen Name | ☐ | | | `searchname` | `varchar2` | Search Name | ☐ | | | `socialsecuritynumber` | `varchar2` | Social Securty Number | ☐ | | | `street` | `varchar2` | Street | ☐ | | | `streetnumber` | `varchar2` | Street Number | ☐ | | | `title` | `varchar2` | Title | ☐ | | | `updatedon_date` | `datetime` | Updated on Date | ☐ | | | `updatedon_timezone_type` | `int32` | Updated on Timezone Type | ☐ | | | `updatedon_timezone` | `varchar2` | Updated on Timezone | ☐ | | | `username` | `varchar2` | User Name | ☑ | | | `userphoto_discr` | `varchar2` | | ☐ | | | `userphoto_id` | `int32` | User Photo ID | ☐ | | | `userphoto_searchname` | `varchar2` | User Photo Search Name | ☐ | | | `zipcode` | `varchar2` | ZIP Code | ☐ | |