PublicWorkersassignmentsallReportsDepartments
PublicWorkersassignmentsallReportsDepartments
Columns
Name | Type | Description |
PublicWorkersPersonId [KEY] | Long | PublicWorkersPersonId of PublicWorkersassignmentsallReportsDepartments |
AssignmentsAssignmentId [KEY] | Long | AssignmentsAssignmentId of PublicWorkersassignmentsallReportsDepartments |
DepartmentId [KEY] | Long | DepartmentId of PublicWorkersassignmentsallReportsDepartments |
Name | String | Name of PublicWorkersassignmentsallReportsDepartments |
ManagerPersonId | String | ManagerPersonId of PublicWorkersassignmentsallReportsDepartments |
ManagerPersonNumber | String | ManagerPersonNumber of PublicWorkersassignmentsallReportsDepartments |
ManagerLastName | String | ManagerLastName of PublicWorkersassignmentsallReportsDepartments |
ManagerFirstName | String | ManagerFirstName of PublicWorkersassignmentsallReportsDepartments |
ManagerDisplayName | String | ManagerDisplayName of PublicWorkersassignmentsallReportsDepartments |
ManagerKnownAs | String | ManagerKnownAs of PublicWorkersassignmentsallReportsDepartments |
PhotoId | Long | PhotoId of PublicWorkersassignmentsallReportsDepartments |
PhotoName | String | PhotoName of PublicWorkersassignmentsallReportsDepartments |
WorkerCount | Double | WorkerCount of PublicWorkersassignmentsallReportsDepartments |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
AssignmentId | Long | AssignmentId |
AssignmentName | String | AssignmentName |
AssignmentNumber | String | AssignmentNumber |
DepartmentName | String | DepartmentName |
DirectReportsFlag | Bool | DirectReportsFlag |
DisplayName | String | DisplayName |
JobName | String | JobName |
LineManagerFlag | Bool | LineManagerFlag |
LocationCountry | String | LocationCountry |
LocationName | String | LocationName |
LocationTownOrCity | String | LocationTownOrCity |
OnlyPrimaryAssignmentFlag | Bool | OnlyPrimaryAssignmentFlag |
PersonId | Long | PersonId |
PersonNumber | String | PersonNumber |
PositionName | String | PositionName |
PrimaryAssignmentFlag | Bool | PrimaryAssignmentFlag |
RelationshipType | String | RelationshipType |
WorkEmail | String | WorkEmail |
Finder | String | finder |