# CurrentUser_DepartmentBranches Returns the user that is currently authenticated. Returns the user that is currently authenticated. - Catalog: `Bouw7` - Schema: `Organization` This is a read-only table. The Bouw7 API may not support changing the data or the Invantive UniversalSQL driver for Bouw7 does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Bouw7 API. ## Table Columns The columns of the table `CurrentUser_DepartmentBranches` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `avatarFileHash` | `varchar2` | Avatar File Hash | ☐ | A file hash associated with the user avatar. | | `branch_code` | `varchar2` | Branch Code | ☐ | The code for this branch | | `branch_id` | `int64` | Branch ID | ☐ | The ID of the branch. | | `branch_name` | `varchar2` | Branch Name | ☐ | The name of this branch | | `code` | `varchar2` | Code | ☐ | The code for this branch | | `color` | `varchar2` | Colour | ☐ | Display color of the department | | `createdAt` | `datetime` | Created at | ☐ | The creation time of the entity. | | `createdBy` | `varchar2` | Created by | ☐ | The user that created the entity. | | `employee_address` | `varchar2` | Employee Address | ☐ | The address of the employee. | | `employee_birthDate` | `datetime` | Employee Birth Date | ☐ | The birth date of the employee. | | `employee_bsn` | `varchar2` | Employee BSN | ☐ | The BSN of the employee. | | `employee_city` | `varchar2` | Employee City | ☐ | The city of the employee. | | `employee_createdAt` | `datetime` | Employee Created at | ☐ | The creation time of the entity. | | `employee_createdBy` | `varchar2` | Employee Created by | ☐ | The user that created the entity. | | `employee_department_id` | `int64` | Employee Department ID | ☐ | ID of the department. | | `employee_department_name` | `varchar2` | Employee Department Name | ☐ | Name of the department. | | `employee_employeeMail` | `varchar2` | Employee Employee Mail | ☐ | The email of the employee. | | `employee_firstName` | `varchar2` | Employee First Name | ☐ | The first name of the employee. | | `employee_function` | `varchar2` | Employee Function | ☐ | The function of the employee. | | `employee_hourlyRate` | `varchar2` | Employee Hourly Rate | ☐ | The hourly rate | | `employee_id` | `int64` | Employee ID | ☐ | The ID of the employee. | | `employee_lastName` | `varchar2` | Employee Last Name | ☐ | The last name of the employee. | | `employee_phoneNumber` | `varchar2` | Employee Phone Number | ☐ | The phone number of the employee. | | `employee_sellingHourlyRate` | `varchar2` | Employee Selling Hourly Rate | ☐ | The selling hourly rate | | `employee_updatedAt` | `datetime` | Employee Updated at | ☐ | The last updated time of the entity. | | `employee_updatedBy` | `varchar2` | Employee Updated by | ☐ | The user that last updated the entity. | | `employee_workload` | `varchar2` | Employee Workload | ☐ | The workload of the employee | | `employee_zipCode` | `varchar2` | Employee ZIP Code | ☐ | ZIP code of the address. | | `eulaAcceptedAt` | `varchar2` | | ☐ | The date and time in ATOM/ISO-8601 format when this user accepted the latest EULA, or NULL if the user never accepted it. | | `eulaFirstAcceptedAt` | `varchar2` | | ☐ | The date and time in ATOM/ISO-8601 format when this user first accepted the EULA, or NULL if the user never accepted it. | | `familyName` | `varchar2` | | ☐ | The family (last) name of the user. | | `givenName` | `varchar2` | | ☐ | The given (first) name of the user. | | `hasBranchSpecificAccess` | `char` | | ☐ | Whether users within the department can only access items associated with one of the specified branches. | | `id_2` | `int64` | ID | ☐ | ID of the department. | | `id_3` | `int64` | | ☐ | The ID of the User. | | `id` | `int64` | ID | ☐ | The ID of the branch. | | `isActive` | `char` | Is Active | ☐ | Whether or not the department is active. | | `isAdmin` | `char` | Is Admin | ☐ | Whether the user is an admin. | | `isDataWithoutBranchAccessible` | `char` | | ☐ | Whether this branch can access data without a branch, this option is only used in combination with the hasBranchSpecificAccess=true. | | `linkId` | `int64` | Link ID | ☐ | The ID of the relation between the user and organization. | | `name_2` | `varchar2` | | ☐ | Name of the department. | | `name` | `varchar2` | Name | ☐ | The name of this branch | | `organization_alternativeAddressPosition` | `char` | Organisation Alternative Address Position | ☐ | Whether to show the alternative address position. | | `organization_city` | `varchar2` | Organisation City | ☐ | The organization's city. | | `organization_cocNumber` | `varchar2` | Organisation CoC Number | ☐ | The organization's coc number. | | `organization_contactFirstName` | `varchar2` | Organisation Contact First Name | ☐ | The contact first name. | | `organization_contactLastName` | `varchar2` | Organisation Contact Last Name | ☐ | The contact last name. | | `organization_country` | `varchar2` | Organisation Country | ☐ | The organization's country. | | `organization_currency` | `varchar2` | Organisation Currency | ☐ | The currency used by this organization, e.g.: EUR. | | `organization_emailAddress` | `varchar2` | Organisation Email Address | ☐ | The organization's email address. | | `organization_expirationReminder` | `int64` | Organisation Expiration Reminder | ☐ | The expiration reminder days for this organization. | | `organization_glnNumber` | `varchar2` | Organisation GL Number | ☐ | The Global Location Number. | | `organization_hasExactHostingAssociation` | `char` | | ☐ | Whether the organization has an exact hosting association. | | `organization_hourlyRate` | `varchar2` | Organisation Hourly Rate | ☐ | The hourly rate for this organization. | | `organization_houseNumber` | `varchar2` | Organisation House Number | ☐ | The organization's house number (incl. additions). | | `organization_iban` | `varchar2` | Organisation IBAN | ☐ | The organization's IBAN. | | `organization_id` | `int64` | Organisation ID | ☐ | The organization ID. | | `organization_invoiceMail` | `varchar2` | Organisation Invoice Mail | ☐ | The invoice email address. | | `organization_isAutomaticInvoiceNumbering` | `char` | | ☐ | Whether automatic invoice numbering is enabled for this organization. | | `organization_isEnableAlternativeEmail` | `char` | | ☐ | Whether an alternative email is enabled for this organization. | | `organization_language` | `varchar2` | Organisation Language | ☐ | The locale used by this organization, e.g.: nl-NL. | | `organization_logo_createdAt` | `datetime` | Organisation Logo Created at | ☐ | The creation time of the entity. | | `organization_logo_createdBy` | `varchar2` | Organisation Logo Created by | ☐ | The user that created the entity. | | `organization_logo_extension` | `varchar2` | Organisation Logo Extension | ☐ | The extension of the file. | | `organization_logo_id` | `int64` | Organisation Logo ID | ☐ | The ID of this file | | `organization_logo_modelId` | `int64` | Organisation Logo Model ID | ☐ | The ID of the associated type. | | `organization_logo_modelType` | `varchar2` | Organisation Logo Model Type | ☐ | The category of the file. | | `organization_logo_name` | `varchar2` | Organisation Logo Name | ☐ | The public name of the file. | | `organization_logo_secureHash` | `varchar2` | | ☐ | A secure random hash for the file, that can be used for retrieving thumbnails without additional authentication. | | `organization_logo_size` | `int64` | Organisation Logo Size | ☐ | The size of the file in bytes. | | `organization_logo_updatedAt` | `datetime` | Organisation Logo Updated at | ☐ | The last updated time of the entity. | | `organization_logo_updatedBy` | `varchar2` | Organisation Logo Updated by | ☐ | The user that last updated the entity. | | `organization_logo_uri` | `varchar2` | Organisation Logo URI | ☐ | The URI of the file, used to fetch the contents. | | `organization_name` | `varchar2` | Organisation Name | ☐ | The organization name. | | `organization_note` | `varchar2` | Organisation Note | ☐ | Note field for organization. | | `organization_phoneNumber` | `varchar2` | Organisation Phone Number | ☐ | The organization's phone number. | | `organization_prognosisHourlyRate` | `varchar2` | Organisation Prognosis Hourly Rate | ☐ | The prognosis hourly rate for this organization. | | `organization_requireHourLogTimes` | `char` | Organisation Require Hour Log Times | ☐ | Whether hour log times are enabled and therefore required for this organization. | | `organization_sellingHourlyRate` | `varchar2` | Organisation Selling Hourly Rate | ☐ | The selling hourly rate for this organization. | | `organization_shouldCopyProjectDescription` | `char` | Organisation Should Copy Project Description | ☐ | True if the project description should be copied to an invoice. | | `organization_status` | `int64` | Organisation Status | ☐ | The status of the organization. | | `organization_streetName` | `varchar2` | Organisation Street Name | ☐ | The organization's street name. | | `organization_vatNumber` | `varchar2` | Organisation VAT Number | ☐ | The organization's vat number. | | `organization_website` | `varchar2` | Organisation Website | ☐ | The organization's website. | | `organization_zipCode` | `varchar2` | Organisation ZIP Code | ☐ | The organization's zip-code. | | `updatedAt` | `datetime` | Updated At | ☐ | The last updated time of the entity. | | `updatedBy` | `varchar2` | Updated by | ☐ | The user that last updated the entity. | | `username` | `varchar2` | User Name | ☐ | The username of the user. |