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 本製品.
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 |