PublicWorkersassignmentsrepresentatives
PublicWorkersassignmentsrepresentatives
Columns
| Name | Type | Description |
| PublicWorkersPersonId [KEY] | Long | PublicWorkersPersonId of PublicWorkersassignmentsrepresentatives |
| AssignmentsAssignmentId [KEY] | Long | AssignmentsAssignmentId of PublicWorkersassignmentsrepresentatives |
| AsgResponsibilityId [KEY] | Long | AsgResponsibilityId of PublicWorkersassignmentsrepresentatives |
| ResponsibilityType | String | ResponsibilityType of PublicWorkersassignmentsrepresentatives |
| ResponsibilityName | String | ResponsibilityName of PublicWorkersassignmentsrepresentatives |
| FirstName | String | FirstName of PublicWorkersassignmentsrepresentatives |
| LastName | String | LastName of PublicWorkersassignmentsrepresentatives |
| DisplayName | String | DisplayName of PublicWorkersassignmentsrepresentatives |
| KnownAs | String | KnownAs of PublicWorkersassignmentsrepresentatives |
| PersonId | Long | PersonId of PublicWorkersassignmentsrepresentatives |
| PersonNumber | String | PersonNumber of PublicWorkersassignmentsrepresentatives |
| AssignmentNumber | String | AssignmentNumber of PublicWorkersassignmentsrepresentatives |
| WorkContactsFlag | Bool | WorkContactsFlag of PublicWorkersassignmentsrepresentatives |
| FromDate | Date | FromDate of PublicWorkersassignmentsrepresentatives |
| ToDate | Date | ToDate of PublicWorkersassignmentsrepresentatives |
| PhotoId [KEY] | Long | PhotoId of PublicWorkersassignmentsrepresentatives |
| PhotoName | String | PhotoName of PublicWorkersassignmentsrepresentatives |
| Photo | String | Photo of PublicWorkersassignmentsrepresentatives |
| WorkEmail | String | WorkEmail of PublicWorkersassignmentsrepresentatives |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| AssignmentId | Long | AssignmentId |
| AssignmentName | String | AssignmentName |
| 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 |
| RelationshipType | String | RelationshipType |
| Finder | String | finder |