PublicWorkersassignmentsdirectReports
PublicWorkersassignmentsdirectReports
Columns
Name | Type | Description |
PublicWorkersPersonId [KEY] | Long | PublicWorkersPersonId of PublicWorkersassignmentsdirectReports |
AssignmentsAssignmentId [KEY] | Long | AssignmentsAssignmentId of PublicWorkersassignmentsdirectReports |
AssignmentId [KEY] | Long | AssignmentId of PublicWorkersassignmentsdirectReports |
AssignmentNumber | String | AssignmentNumber of PublicWorkersassignmentsdirectReports |
AssignmentName | String | AssignmentName of PublicWorkersassignmentsdirectReports |
PersonId | Long | PersonId of PublicWorkersassignmentsdirectReports |
PersonNumber | String | PersonNumber of PublicWorkersassignmentsdirectReports |
FirstName | String | FirstName of PublicWorkersassignmentsdirectReports |
LastName | String | LastName of PublicWorkersassignmentsdirectReports |
DisplayName | String | DisplayName of PublicWorkersassignmentsdirectReports |
KnownAs | String | KnownAs of PublicWorkersassignmentsdirectReports |
RelationshipType [KEY] | String | RelationshipType of PublicWorkersassignmentsdirectReports |
RelationshipTypeMeaning | String | RelationshipTypeMeaning of PublicWorkersassignmentsdirectReports |
WorkerType | String | WorkerType of PublicWorkersassignmentsdirectReports |
PhotoId | Long | PhotoId of PublicWorkersassignmentsdirectReports |
PhotoName | String | PhotoName of PublicWorkersassignmentsdirectReports |
Photo | String | Photo of PublicWorkersassignmentsdirectReports |
DirectReportsCount | Double | DirectReportsCount of PublicWorkersassignmentsdirectReports |
AllReportsCount | Double | AllReportsCount of PublicWorkersassignmentsdirectReports |
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 |