WorkersworkRelationshipscontractscontractsDDF

Columns


Name	Type	Description
WorkersPersonId [KEY]	Long	WorkersPersonId of WorkersworkRelationshipscontractscontractsDDF
WorkrelationshipsPeriodOfServiceId [KEY]	Long	WorkrelationshipsPeriodOfServiceId of WorkersworkRelationshipscontractscontractsDDF
ContractsContractId [KEY]	Long	ContractsContractId of WorkersworkRelationshipscontractscontractsDDF
ContractsEffectiveEndDate [KEY]	Date	ContractsEffectiveEndDate of WorkersworkRelationshipscontractscontractsDDF
ContractsEffectiveStartDate [KEY]	Date	ContractsEffectiveStartDate of WorkersworkRelationshipscontractscontractsDDF
ContractId [KEY]	Long	ContractId of WorkersworkRelationshipscontractscontractsDDF
EffectiveStartDate [KEY]	Date	EffectiveStartDate of WorkersworkRelationshipscontractscontractsDDF
EffectiveEndDate [KEY]	Date	EffectiveEndDate of WorkersworkRelationshipscontractscontractsDDF
_FLEX_Context	String	__FLEX_Context of WorkersworkRelationshipscontractscontractsDDF
_FLEX_Context_DisplayValue	String	__FLEX_Context_DisplayValue of WorkersworkRelationshipscontractscontractsDDF

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


Name	Type	Description
AssignmentId	Long	AssignmentId
AssignmentName	String	AssignmentName
AssignmentNumber	String	AssignmentNumber
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.