PublicWorkersassignments
PublicWorkersassignments
Columns
| Name | Type | Description |
| PublicWorkersPersonId [KEY] | Long | PublicWorkersPersonId of PublicWorkersassignments |
| AssignmentId [KEY] | Long | AssignmentId of PublicWorkersassignments |
| AssignmentNumber | String | AssignmentNumber of PublicWorkersassignments |
| AssignmentName | String | AssignmentName of PublicWorkersassignments |
| LegalEmployerName | String | LegalEmployerName of PublicWorkersassignments |
| StartDate | Date | StartDate of PublicWorkersassignments |
| PrimaryFlag | Bool | PrimaryFlag of PublicWorkersassignments |
| PrimaryAssignmentFlag | Bool | PrimaryAssignmentFlag of PublicWorkersassignments |
| WorkerType | String | WorkerType of PublicWorkersassignments |
| WorkerNumber | String | WorkerNumber of PublicWorkersassignments |
| WorkAtHomeFlag | Bool | WorkAtHomeFlag of PublicWorkersassignments |
| FullPartTime | String | FullPartTime of PublicWorkersassignments |
| ManagerName | String | ManagerName of PublicWorkersassignments |
| BusinessUnitName | String | BusinessUnitName of PublicWorkersassignments |
| DepartmentName | String | DepartmentName of PublicWorkersassignments |
| JobCode | String | JobCode of PublicWorkersassignments |
| JobName | String | JobName of PublicWorkersassignments |
| PositionCode | String | PositionCode of PublicWorkersassignments |
| PositionName | String | PositionName of PublicWorkersassignments |
| LocationCode | String | LocationCode of PublicWorkersassignments |
| LocationName | String | LocationName of PublicWorkersassignments |
| GradeCode | String | GradeCode of PublicWorkersassignments |
| GradeName | String | GradeName of PublicWorkersassignments |
| InternalBuilding | String | InternalBuilding of PublicWorkersassignments |
| InternalFloor | String | InternalFloor of PublicWorkersassignments |
| InternalOfficeNumber | String | InternalOfficeNumber of PublicWorkersassignments |
| InternalMailstop | String | InternalMailstop of PublicWorkersassignments |
| LocationAddressLine1 | String | LocationAddressLine1 of PublicWorkersassignments |
| LocationAddressLine2 | String | LocationAddressLine2 of PublicWorkersassignments |
| LocationAddressLine3 | String | LocationAddressLine3 of PublicWorkersassignments |
| LocationAddressLine4 | String | LocationAddressLine4 of PublicWorkersassignments |
| LocationRegion1 | String | LocationRegion1 of PublicWorkersassignments |
| LocationRegion2 | String | LocationRegion2 of PublicWorkersassignments |
| LocationRegion3 | String | LocationRegion3 of PublicWorkersassignments |
| LocationTownOrCity | String | LocationTownOrCity of PublicWorkersassignments |
| LocationPostalCode | String | LocationPostalCode of PublicWorkersassignments |
| LocationCountry | String | LocationCountry of PublicWorkersassignments |
| LocationLongPostalCode | String | LocationLongPostalCode of PublicWorkersassignments |
| LocationTimezoneCode | String | LocationTimezoneCode of PublicWorkersassignments |
| LocationSingleLineAddress | String | LocationSingleLineAddress of PublicWorkersassignments |
| LocationMultiLineAddress | String | LocationMultiLineAddress of PublicWorkersassignments |
| LengthOfServiceYears | Int | LengthOfServiceYears of PublicWorkersassignments |
| LengthOfServiceMonths | Int | LengthOfServiceMonths of PublicWorkersassignments |
| LengthOfServiceDays | Int | LengthOfServiceDays of PublicWorkersassignments |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| DirectReportsFlag | Bool | DirectReportsFlag |
| DisplayName | String | DisplayName |
| LineManagerFlag | Bool | LineManagerFlag |
| OnlyPrimaryAssignmentFlag | Bool | OnlyPrimaryAssignmentFlag |
| PersonId | Long | PersonId |
| PersonNumber | String | PersonNumber |
| RelationshipType | String | RelationshipType |
| WorkEmail | String | WorkEmail |
| Finder | String | finder |