SSIS Components for TSheets

Build 23.0.8839

UserPermissions

The rights assignable to an individual user.

Table Specific Information

Select

Query the UserPermissions table. All the filters are executed client side within the component.

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839