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 |