PayrollRelationshipspayrollAssignments

Columns


Name	Type	Description
PayrollRelationshipsEffectiveEndDate [KEY]	Date	PayrollRelationshipsEffectiveEndDate of PayrollRelationshipspayrollAssignments
PayrollRelationshipsEffectiveStartDate [KEY]	Date	PayrollRelationshipsEffectiveStartDate of PayrollRelationshipspayrollAssignments
PayrollRelationshipsPayrollRelationshipId [KEY]	Long	PayrollRelationshipsPayrollRelationshipId of PayrollRelationshipspayrollAssignments
RelationshipGroupId [KEY]	Long	RelationshipGroupId of PayrollRelationshipspayrollAssignments
AssignmentNumber	String	AssignmentNumber of PayrollRelationshipspayrollAssignments
EffectiveStartDate [KEY]	Date	EffectiveStartDate of PayrollRelationshipspayrollAssignments
EffectiveEndDate [KEY]	Date	EffectiveEndDate of PayrollRelationshipspayrollAssignments
TimeCardRequired	String	TimeCardRequired of PayrollRelationshipspayrollAssignments
OverridingPeriodId	Long	OverridingPeriodId of PayrollRelationshipspayrollAssignments

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