CurrentUser
Query the current user details in TSheets.
Table Specific Information
Select
Query the CurrentUser table. Here, the WHERE clause conditions are not supported on the API side, only a simple SELECT query works on the API side. The filters are executed client side within the add-in.
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 |
| LastName | String | Last name |
| DisplayName | String | Display name |
| GroupId | Integer | Group Id. |
| Active | Boolean | Boolean value which show the active status. |
| EmployeeNumber | Integer | The employee number. |
| Salaried | Boolean | Salaried |
| Exempt | Boolean | Exempt |
| UserName | String | Username |
| String | ||
| EmailVerified | String | Email verified |
| PayrollId | String | Payroll id |
| HireDate | String | Hire date |
| TermDate | String | Term date |
| LastModified | Datetime | Last modified |
| LastActive | Datetime | Last active |
| Created | Datetime | Created |
| ClientUrl | String | Client URL |
| CompanyName | String | Company Name |
| ProfileImageUrl | String | Profile Image URL |
| MobileNumber | String | Mobile Number |
| PtoBalances | String | PTO Balances |
| SubmittedTo | Datetime | Submitted To |
| ApprovedTo | Datetime | Approved To |
| ManagerOfGroupIds | String | Manager of Group IDs |
| RequirePasswordChange | Boolean | Require Password Change |
| PayRate | Integer | Pay Rate |
| PayInterval | String | Pay Interval |
| PermissionsAdmin | Boolean | Permissions - Admin |
| PermissionsMobile | Boolean | Permissions - Mobile |
| PermissionsStatusBox | Boolean | Permissions - Status Box |
| PermissionsReports | Boolean | Permissions - Reports |
| PermissionsManageTimesheets | Boolean | Permissions - Manage Timesheets |
| PermissionsManageAuthorization | Boolean | Permissions - Manage Authorization |
| PermissionsManageUsers | Boolean | Permissions - Manage Users |
| PermissionsManageMyTimesheets | Boolean | Permissions - Manage My Timesheets |
| PermissionsManageJobcodes | Boolean | Permissions - Manage Jobcodes |
| PermissionsPinLogin | Boolean | Permissions - PIN Login |
| PermissionsApproveTimesheets | Boolean | Permissions - Approve Timesheets |
| PermissionsManageSchedules | Boolean | Permissions - Manage Schedules |
| PermissionsExternalAccess | Boolean | Permissions - External Access |
| PermissionsManageMySchedule | Boolean | Permissions - Manage My Schedule |
| PermissionsManageCompanySchedules | Boolean | Permissions - Manage Company Schedules |
| PermissionsViewCompanySchedules | Boolean | Permissions - View Company Schedules |
| PermissionsViewGroupSchedules | Boolean | Permissions - View Group Schedules |
| PermissionsManageNoSchedules | Boolean | Permissions - Manage No Schedules |
| PermissionsViewMySchedules | Boolean | Permissions - View My Schedules |
| PermissionsViewProjects | Boolean | Permissions - View Projects |
| PermissionsManageProjects | Boolean | Permissions - Manage Projects |
| PermissionsTimeTracking | Boolean | Permissions - Time Tracking |