PublicWorkersassignmentsemploymentHistory

Columns


Name	Type	Description
PublicWorkersPersonId [KEY]	Long	PublicWorkersPersonId of PublicWorkersassignmentsemploymentHistory
AssignmentsAssignmentId [KEY]	Long	AssignmentsAssignmentId of PublicWorkersassignmentsemploymentHistory
AssignmentId [KEY]	Long	AssignmentId of PublicWorkersassignmentsemploymentHistory
Name	String	Name of PublicWorkersassignmentsemploymentHistory

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


Name	Type	Description
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