CurrentUser
Query the current user details in QuickBooks Time.
Table Specific Information
Select
The WHERE clause conditions are not supported on the API side. Only a basic unfiltered SELECT query works on the API side. The filters are executed client-side within the connector.
For example, the following query is processed server-side:
SELECT * FROM CurrentUser
Columns
| Name | Type | Description |
| Id [KEY] | Integer | Id of the current user. |
| FirstName | String | First name of user. |
| LastName | String | Last name of user. |
| DisplayName | String | The display name of user. |
| GroupId | Integer | Id of the group this user belongs to. |
| Active | Boolean | Boolean value which show the active status. |
| EmployeeNumber | Integer | Unique number associated with this user. |
| Salaried | Boolean | Indicates whether or not the user is salaried. |
| Exempt | Boolean | Indicates e.g. whether or not the user is eligible for overtime pay. |
| UserName | String | Username associated with this user. |
| String | Email address associated with this user. | |
| EmailVerified | Boolean | Indicates whether or not the email address has been confirmed by the user. |
| PayrollId | String | Unique company wide string associated with this user. Usually used for linking with external systems. |
| HireDate | Date | Date on which this user was hired. |
| TermDate | Date | Date on which this user was terminated. |
| LastModified | Datetime | Date/time when this user was last modified, in ISO 8601 format. |
| LastActive | Datetime | Date/time when this user last performed any action, in ISO 8601 format. |
| Created | Datetime | Date/time when this user was created, in ISO 8601 format. |
| ClientUrl | String | Client account url identifier associated with this user. |
| CompanyName | String | Client account name identifier associated with the user. |
| ProfileImageUrl | String | Url identifier associated with this user's profile image. |
| MobileNumber | String | Mobile phone number associated with this user. |
| PtoBalances | String | List of jobcode identifiers and their respective PTO balances for this user (in seconds). |
| SubmittedTo | Datetime | The latest date this user has submitted timesheets up to. |
| ApprovedTo | Datetime | The latest date this user has had timesheets approved to. |
| ManagerOfGroupIds | String | The group ids that this user manages. |
| RequirePasswordChange | Boolean | If true, this user will be required to change their password on their next login. |
| PayRate | Float | The rate of pay associated with this user. Only visible to admins. |
| PayInterval | String | The timeframe to which this user's pay rate applies, either 'hour' or 'year'. Only visible to admins. |
| PermissionsAdmin | Boolean | Permissions - Administrator, can perform any changes on the account. |
| PermissionsMobile | Boolean | Permissions - Allowed to use mobile devices to record time. |
| PermissionsStatusBox | Boolean | Permissions - Able to view the list of users currently working for the company. |
| PermissionsReports | Boolean | Permissions - Able to run/view all reports for the company. |
| PermissionsManageTimesheets | Boolean | Permissions - Able to create/edit/delete timesheets for anyone in the company. |
| PermissionsManageAuthorization | Boolean | Permissions - Able to manage computer authorization for the company. |
| PermissionsManageUsers | Boolean | Permissions - Able to create/edit/delete users, groups, and managers for the entire company. |
| PermissionsManageMyTimesheets | Boolean | Permissions - Able to completely manage own timesheets. |
| PermissionsManageJobcodes | Boolean | Permissions - Able to create/edit/delete jobcodes and custom field items for the entire company. |
| PermissionsPinLogin | Boolean | Permissions - Able to login to apps via PIN. |
| PermissionsApproveTimesheets | Boolean | Permissions - Able to run approval reports and approve time for all employees. |
| PermissionsManageSchedules | Boolean | Permissions - Able to create/edit/delete events within the schedule for the groups that the user can manage. |
| PermissionsExternalAccess | Boolean | Permissions - External Access |
| PermissionsManageMySchedule | Boolean | Permissions - Able to create/edit/delete events within the schedule for only themselves. |
| PermissionsManageCompanySchedules | Boolean | Permissions - Able to create/edit/delete events within the schedule for any user in the company. |
| PermissionsViewCompanySchedules | Boolean | Permissions - Able to view published events within the schedule for any user in the company. |
| PermissionsViewGroupSchedules | Boolean | Permissions - Able to view published events within the schedule for the groups that the user is a member of. |
| PermissionsManageNoSchedules | Boolean | Permissions - Not able to create/edit/delete events within the schedule for any user. |
| PermissionsViewMySchedules | Boolean | Permissions - Able to view published events within the schedule for themselves. |
| PermissionsViewProjects | Boolean | Permissions - View Projects |
| PermissionsManageProjects | Boolean | Permissions - Manage Projects |
| PermissionsTimeTracking | Boolean | Permissions - Able to track time and have time tracked on their behalf. |
| CustomFields | String | A key/value map of customfield ids to the customfield items that are associated with the user. |