UserPermissions
The rights assignable to an individual user.
Table Specific Information
Select
Query the UserPermissions table. The connector will use the QuickBooks Time API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the connector.
- UserId field supports the =, !=, IN, NOT IN operators.
For example, the following queries are processed server side:
SELECT * FROM UserPermissions WHERE UserID = 3600098 SELECT * FROM UserPermissions WHERE UserID != 3600098 SELECT * FROM UserPermissions WHERE UserID NOT IN (3600098, 66025, 66021) SELECT * FROM UserPermissions WHERE UserID IN (3600098, 66025, 66021)
Columns
| Name | Type | Description |
| UserId [KEY] | String | The Id of the user these permissions apply to. |
| Admin | Boolean | Administrator, can perform any changes on the account. |
| Mobile | Boolean | Whether this user is allowed to use mobile devices to record time. |
| StatusBox | Boolean | Whether this user is able to view the list of users currently working for the company. |
| Reports | Boolean | Whether this user is able to run/view all reports for the company. |
| ManageTimesheets | Boolean | Whether this user is able to create/edit/delete timesheets for anyone in the company. |
| ManageAuthorization | Boolean | Whether this user is able to manage computer authorization for the company. |
| ManageUsers | Boolean | Whether this user is able to create/edit/delete users, groups, and managers for the entire company. |
| ManageMyTimesheets | Boolean | Whether this user is able to completely manage own timesheets. |
| ManageJobcodes | Boolean | Whether this user is able to create/edit/delete jobcodes and custom field items for the entire company. |
| PinLogin | Boolean | Whether this user is able to login to apps via PIN. |
| ApproveTimesheets | Boolean | Whether this user is able to run approval reports and approve time for all employees. |
| ManageSchedules | Boolean | Whether this user is able to create/edit/delete events within the schedule for the groups that the user can manage. |
| ManageMySchedule | Boolean | Whether this user is able to create/edit/delete events within the schedule for only themselves. |
| ManageCompanySchedules | Boolean | Whether this user is able to create/edit/delete events within the schedule for any user in the company. |
| ManageNoSchedule | Boolean | Whether this user is not able to create/edit/delete events within the schedule for any user. |
| ViewCompanySchedules | Boolean | Whether this user is able to view published events within the schedule for any user in the company. |
| ViewGroupSchedules | Boolean | Whether this user is able to view published events within the schedule for the groups that the user is a member of. |
| ViewMySchedules | Boolean | Whether this user is able to view published events within the schedule for themselves. |
| TimeTracking | Boolean | Whether this user is able to track time and have time tracked on their behalf. |