PublicWorkersassignmentsallReports
PublicWorkersassignmentsallReports
Columns
Name | Type | Description |
PublicWorkersPersonId [KEY] | Long | PublicWorkersPersonId of PublicWorkersassignmentsallReports |
AssignmentsAssignmentId [KEY] | Long | AssignmentsAssignmentId of PublicWorkersassignmentsallReports |
AssignmentId [KEY] | Long | AssignmentId of PublicWorkersassignmentsallReports |
PersonId | Long | PersonId of PublicWorkersassignmentsallReports |
PersonNumber | String | PersonNumber of PublicWorkersassignmentsallReports |
AssignmentNumber | String | AssignmentNumber of PublicWorkersassignmentsallReports |
AssignmentName | String | AssignmentName of PublicWorkersassignmentsallReports |
LocationId | Long | LocationId of PublicWorkersassignmentsallReports |
DepartmentId | Long | DepartmentId of PublicWorkersassignmentsallReports |
WorkerType | String | WorkerType of PublicWorkersassignmentsallReports |
FirstName | String | FirstName of PublicWorkersassignmentsallReports |
LastName | String | LastName of PublicWorkersassignmentsallReports |
DisplayName | String | DisplayName of PublicWorkersassignmentsallReports |
KnownAs | String | KnownAs of PublicWorkersassignmentsallReports |
RelationshipType [KEY] | String | RelationshipType of PublicWorkersassignmentsallReports |
RelationshipTypeMeaning | String | RelationshipTypeMeaning of PublicWorkersassignmentsallReports |
Level | Int | Level of PublicWorkersassignmentsallReports |
ManagerPersonNumber | String | ManagerPersonNumber of PublicWorkersassignmentsallReports |
ManagerAssignmentNumber | String | ManagerAssignmentNumber of PublicWorkersassignmentsallReports |
PhotoId [KEY] | Long | PhotoId of PublicWorkersassignmentsallReports |
PhotoName | String | PhotoName of PublicWorkersassignmentsallReports |
Photo | String | Photo of PublicWorkersassignmentsallReports |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
Name | Type | Description |
DepartmentName | String | DepartmentName |
DirectReportsFlag | Bool | DirectReportsFlag |
JobName | String | JobName |
LineManagerFlag | Bool | LineManagerFlag |
LocationCountry | String | LocationCountry |
LocationName | String | LocationName |
LocationTownOrCity | String | LocationTownOrCity |
OnlyPrimaryAssignmentFlag | Bool | OnlyPrimaryAssignmentFlag |
PositionName | String | PositionName |
PrimaryAssignmentFlag | Bool | PrimaryAssignmentFlag |
WorkEmail | String | WorkEmail |
Finder | String | finder |