PublicWorkersassignmentsmanagers
PublicWorkersassignmentsmanagers
Columns
| Name | Type | Description |
| PublicWorkersPersonId [KEY] | Long | PublicWorkersPersonId of PublicWorkersassignmentsmanagers |
| AssignmentsAssignmentId [KEY] | Long | AssignmentsAssignmentId of PublicWorkersassignmentsmanagers |
| AssignmentSupervisorId [KEY] | Long | AssignmentSupervisorId of PublicWorkersassignmentsmanagers |
| ManagerPersonId | Long | ManagerPersonId of PublicWorkersassignmentsmanagers |
| ManagerPersonNumber | String | ManagerPersonNumber of PublicWorkersassignmentsmanagers |
| FirstName | String | FirstName of PublicWorkersassignmentsmanagers |
| LastName | String | LastName of PublicWorkersassignmentsmanagers |
| DisplayName | String | DisplayName of PublicWorkersassignmentsmanagers |
| KnownAs | String | KnownAs of PublicWorkersassignmentsmanagers |
| ManagerAssignmentId | Long | ManagerAssignmentId of PublicWorkersassignmentsmanagers |
| ManagerAssignmentNumber | String | ManagerAssignmentNumber of PublicWorkersassignmentsmanagers |
| ManagerAssignmentName | String | ManagerAssignmentName of PublicWorkersassignmentsmanagers |
| ManagerType | String | ManagerType of PublicWorkersassignmentsmanagers |
| ManagerTypeMeaning | String | ManagerTypeMeaning of PublicWorkersassignmentsmanagers |
| JobCode | String | JobCode of PublicWorkersassignmentsmanagers |
| JobName | String | JobName of PublicWorkersassignmentsmanagers |
| PositionCode | String | PositionCode of PublicWorkersassignmentsmanagers |
| PositionName | String | PositionName of PublicWorkersassignmentsmanagers |
| PhotoId [KEY] | Long | PhotoId of PublicWorkersassignmentsmanagers |
| PhotoName | String | PhotoName of PublicWorkersassignmentsmanagers |
| Photo | String | Photo of PublicWorkersassignmentsmanagers |
| WorkEmail | String | WorkEmail of PublicWorkersassignmentsmanagers |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| AssignmentId | Long | AssignmentId |
| AssignmentName | String | AssignmentName |
| AssignmentNumber | String | AssignmentNumber |
| DepartmentName | String | DepartmentName |
| DirectReportsFlag | Bool | DirectReportsFlag |
| LineManagerFlag | Bool | LineManagerFlag |
| LocationCountry | String | LocationCountry |
| LocationName | String | LocationName |
| LocationTownOrCity | String | LocationTownOrCity |
| OnlyPrimaryAssignmentFlag | Bool | OnlyPrimaryAssignmentFlag |
| PersonId | Long | PersonId |
| PersonNumber | String | PersonNumber |
| PrimaryAssignmentFlag | Bool | PrimaryAssignmentFlag |
| RelationshipType | String | RelationshipType |
| Finder | String | finder |