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 |