PublicWorkersassignmentsallReportsLocations

Columns


Name	Type	Description
PublicWorkersPersonId [KEY]	Long	PublicWorkersPersonId of PublicWorkersassignmentsallReportsLocations
AssignmentsAssignmentId [KEY]	Long	AssignmentsAssignmentId of PublicWorkersassignmentsallReportsLocations
LocationId [KEY]	Long	LocationId of PublicWorkersassignmentsallReportsLocations
LocationCode	String	LocationCode of PublicWorkersassignmentsallReportsLocations
LocationName	String	LocationName of PublicWorkersassignmentsallReportsLocations
WorkerCount	Double	WorkerCount of PublicWorkersassignmentsallReportsLocations

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
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