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 |