PublicWorkersassignmentsallReportsDepartments
PublicWorkersassignmentsallReportsDepartments
Columns
| Name | Type | Description |
| PublicWorkersPersonId [KEY] | Long | PublicWorkersPersonId of PublicWorkersassignmentsallReportsDepartments |
| AssignmentsAssignmentId [KEY] | Long | AssignmentsAssignmentId of PublicWorkersassignmentsallReportsDepartments |
| DepartmentId [KEY] | Long | DepartmentId of PublicWorkersassignmentsallReportsDepartments |
| Name | String | Name of PublicWorkersassignmentsallReportsDepartments |
| ManagerPersonId | String | ManagerPersonId of PublicWorkersassignmentsallReportsDepartments |
| ManagerPersonNumber | String | ManagerPersonNumber of PublicWorkersassignmentsallReportsDepartments |
| ManagerLastName | String | ManagerLastName of PublicWorkersassignmentsallReportsDepartments |
| ManagerFirstName | String | ManagerFirstName of PublicWorkersassignmentsallReportsDepartments |
| ManagerDisplayName | String | ManagerDisplayName of PublicWorkersassignmentsallReportsDepartments |
| ManagerKnownAs | String | ManagerKnownAs of PublicWorkersassignmentsallReportsDepartments |
| PhotoId | Long | PhotoId of PublicWorkersassignmentsallReportsDepartments |
| PhotoName | String | PhotoName of PublicWorkersassignmentsallReportsDepartments |
| WorkerCount | Double | WorkerCount of PublicWorkersassignmentsallReportsDepartments |
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 |
| AssignmentId | Long | AssignmentId |
| AssignmentName | String | AssignmentName |
| AssignmentNumber | String | AssignmentNumber |
| DepartmentName | String | DepartmentName |
| DirectReportsFlag | Bool | DirectReportsFlag |
| DisplayName | String | DisplayName |
| JobName | String | JobName |
| LineManagerFlag | Bool | LineManagerFlag |
| LocationCountry | String | LocationCountry |
| LocationName | String | LocationName |
| LocationTownOrCity | String | LocationTownOrCity |
| OnlyPrimaryAssignmentFlag | Bool | OnlyPrimaryAssignmentFlag |
| PersonId | Long | PersonId |
| PersonNumber | String | PersonNumber |
| PositionName | String | PositionName |
| PrimaryAssignmentFlag | Bool | PrimaryAssignmentFlag |
| RelationshipType | String | RelationshipType |
| WorkEmail | String | WorkEmail |
| Finder | String | finder |