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
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 |