PayrollRelationshipspayrollAssignmentspayrollAssignmentDates

Columns


Name	Type	Description
PayrollRelationshipsEffectiveEndDate [KEY]	Date	PayrollRelationshipsEffectiveEndDate of PayrollRelationshipspayrollAssignmentspayrollAssignmentDates
PayrollRelationshipsEffectiveStartDate [KEY]	Date	PayrollRelationshipsEffectiveStartDate of PayrollRelationshipspayrollAssignmentspayrollAssignmentDates
PayrollRelationshipsPayrollRelationshipId [KEY]	Long	PayrollRelationshipsPayrollRelationshipId of PayrollRelationshipspayrollAssignmentspayrollAssignmentDates
PayrollassignmentsEffectiveEndDate [KEY]	Date	PayrollassignmentsEffectiveEndDate of PayrollRelationshipspayrollAssignmentspayrollAssignmentDates
PayrollassignmentsEffectiveStartDate [KEY]	Date	PayrollassignmentsEffectiveStartDate of PayrollRelationshipspayrollAssignmentspayrollAssignmentDates
PayrollassignmentsRelationshipGroupId [KEY]	Long	PayrollassignmentsRelationshipGroupId of PayrollRelationshipspayrollAssignmentspayrollAssignmentDates
ShortName	String	ShortName of PayrollRelationshipspayrollAssignmentspayrollAssignmentDates
DateValue	Date	DateValue of PayrollRelationshipspayrollAssignmentspayrollAssignmentDates
PayDateId [KEY]	Long	PayDateId of PayrollRelationshipspayrollAssignmentspayrollAssignmentDates

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