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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| 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 |