PublicWorkers
PublicWorkers
Columns
| Name | Type | Description |
| PersonId [KEY] | Long | PersonId of PublicWorkers |
| PersonNumber | String | PersonNumber of PublicWorkers |
| LastName | String | LastName of PublicWorkers |
| FirstName | String | FirstName of PublicWorkers |
| Title | String | Title of PublicWorkers |
| PreNameAdjunct | String | PreNameAdjunct of PublicWorkers |
| Suffix | String | Suffix of PublicWorkers |
| MiddleNames | String | MiddleNames of PublicWorkers |
| Honors | String | Honors of PublicWorkers |
| KnownAs | String | KnownAs of PublicWorkers |
| DisplayName | String | DisplayName of PublicWorkers |
| ListName | String | ListName of PublicWorkers |
| OrderName | String | OrderName of PublicWorkers |
| WorkEmail | String | WorkEmail of PublicWorkers |
| Username | String | Username of PublicWorkers |
| PreviousLastName | String | PreviousLastName of PublicWorkers |
| MilitaryRank | String | MilitaryRank of PublicWorkers |
| FullName | String | FullName of PublicWorkers |
| NameInformation1 | String | NameInformation1 of PublicWorkers |
| NameInformation2 | String | NameInformation2 of PublicWorkers |
| NameInformation3 | String | NameInformation3 of PublicWorkers |
| NameInformation4 | String | NameInformation4 of PublicWorkers |
| NameInformation5 | String | NameInformation5 of PublicWorkers |
| NameInformation6 | String | NameInformation6 of PublicWorkers |
| NameInformation7 | String | NameInformation7 of PublicWorkers |
| NameInformation8 | String | NameInformation8 of PublicWorkers |
| NameInformation9 | String | NameInformation9 of PublicWorkers |
| NameInformation10 | String | NameInformation10 of PublicWorkers |
| NameInformation11 | String | NameInformation11 of PublicWorkers |
| NameInformation12 | String | NameInformation12 of PublicWorkers |
| NameInformation13 | String | NameInformation13 of PublicWorkers |
| NameInformation14 | String | NameInformation14 of PublicWorkers |
| NameInformation15 | String | NameInformation15 of PublicWorkers |
| NameInformation16 | String | NameInformation16 of PublicWorkers |
| NameInformation17 | String | NameInformation17 of PublicWorkers |
| NameInformation18 | String | NameInformation18 of PublicWorkers |
| NameInformation19 | String | NameInformation19 of PublicWorkers |
| NameInformation20 | String | NameInformation20 of PublicWorkers |
| NameInformation21 | String | NameInformation21 of PublicWorkers |
| NameInformation22 | String | NameInformation22 of PublicWorkers |
| NameInformation23 | String | NameInformation23 of PublicWorkers |
| NameInformation24 | String | NameInformation24 of PublicWorkers |
| NameInformation25 | String | NameInformation25 of PublicWorkers |
| NameInformation26 | String | NameInformation26 of PublicWorkers |
| NameInformation27 | String | NameInformation27 of PublicWorkers |
| NameInformation28 | String | NameInformation28 of PublicWorkers |
| NameInformation29 | String | NameInformation29 of PublicWorkers |
| NameInformation30 | String | NameInformation30 of PublicWorkers |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| AssignmentId | Long | AssignmentId |
| AssignmentName | String | AssignmentName |
| AssignmentNumber | String | AssignmentNumber |
| 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 |