WorkersexternalIdentifiers

Columns


Name	Type	Description
WorkersPersonId [KEY]	Long	WorkersPersonId of WorkersexternalIdentifiers
ExternalIdentifierId [KEY]	Long	ExternalIdentifierId of WorkersexternalIdentifiers
ExternalIdentifierSequence	Int	Sequence of the external identifier.
ExternalIdentifierNumber	String	External identifier number.
ExternalIdentifierType	String	Type of external identifier, such as Third-Party Payroll ID. Valid values are defined in the commonLookupsLOV.
ExternalIdentifierTypeMeaning	String	ExternalIdentifierTypeMeaning of WorkersexternalIdentifiers
AssignmentId	Long	Unique identifier of the assignment to which this external identifier relates.
FromDate	Datetime	Date and time from when the external identifier is valid.
ToDate	Datetime	Date and time until when the external identifier is valid.
Comments	String	Comments for the external identifier.
CreatedBy	String	CreatedBy of WorkersexternalIdentifiers
CreationDate	Datetime	CreationDate of WorkersexternalIdentifiers
LastUpdatedBy	String	LastUpdatedBy of WorkersexternalIdentifiers
LastUpdateDate	Datetime	LastUpdateDate of WorkersexternalIdentifiers
AssignmentNumber	String	Assignment number to which the external identifier belongs.
AssignmentName	String	AssignmentName of WorkersexternalIdentifiers

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


Name	Type	Description
DirectReportsFlag	String	DirectReportsFlag
LineManagerFlag	String	LineManagerFlag
PersonId	Long	PersonId
PersonNumber	String	PersonNumber
PrimaryAssignmentFlag	String	PrimaryAssignmentFlag
RelationshipType	String	RelationshipType
SysEffectiveDate	String	SysEffectiveDate
WorkerType	String	WorkerType
Finder	String	finder
EffectiveDate	Date	This query parameter is used to fetch resources which are effective dated as of the specified start date. The value of this query parameter is a string having a date in yyyy-MM-dd format.