PayrollRelationshipspayrollAssignmentsassignedPayrollsassignedPayrollDates
PayrollRelationshipspayrollAssignmentsassignedPayrollsassignedPayrollDates
Columns
| Name | Type | Description |
| PayrollRelationshipsEffectiveEndDate [KEY] | Date | PayrollRelationshipsEffectiveEndDate of PayrollRelationshipspayrollAssignmentsassignedPayrollsassignedPayrollDates |
| PayrollRelationshipsEffectiveStartDate [KEY] | Date | PayrollRelationshipsEffectiveStartDate of PayrollRelationshipspayrollAssignmentsassignedPayrollsassignedPayrollDates |
| PayrollRelationshipsPayrollRelationshipId [KEY] | Long | PayrollRelationshipsPayrollRelationshipId of PayrollRelationshipspayrollAssignmentsassignedPayrollsassignedPayrollDates |
| PayrollassignmentsEffectiveEndDate [KEY] | Date | PayrollassignmentsEffectiveEndDate of PayrollRelationshipspayrollAssignmentsassignedPayrollsassignedPayrollDates |
| PayrollassignmentsEffectiveStartDate [KEY] | Date | PayrollassignmentsEffectiveStartDate of PayrollRelationshipspayrollAssignmentsassignedPayrollsassignedPayrollDates |
| PayrollassignmentsRelationshipGroupId [KEY] | Long | PayrollassignmentsRelationshipGroupId of PayrollRelationshipspayrollAssignmentsassignedPayrollsassignedPayrollDates |
| AssignedpayrollsAssignedPayrollId [KEY] | Long | AssignedpayrollsAssignedPayrollId of PayrollRelationshipspayrollAssignmentsassignedPayrollsassignedPayrollDates |
| AssignedpayrollsEffectiveEndDate [KEY] | Date | AssignedpayrollsEffectiveEndDate of PayrollRelationshipspayrollAssignmentsassignedPayrollsassignedPayrollDates |
| AssignedpayrollsEffectiveStartDate [KEY] | Date | AssignedpayrollsEffectiveStartDate of PayrollRelationshipspayrollAssignmentsassignedPayrollsassignedPayrollDates |
| DateValue | Date | DateValue of PayrollRelationshipspayrollAssignmentsassignedPayrollsassignedPayrollDates |
| PayDateId [KEY] | Long | PayDateId of PayrollRelationshipspayrollAssignmentsassignedPayrollsassignedPayrollDates |
| ShortName | String | ShortName of PayrollRelationshipspayrollAssignmentsassignedPayrollsassignedPayrollDates |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| AssignmentNumber | String | AssignmentNumber |
| EffectiveEndDate | Date | EffectiveEndDate |
| EffectiveStartDate | Date | EffectiveStartDate |
| PayrollRelationshipId | Long | PayrollRelationshipId |
| PersonNumber | String | PersonNumber |
| SysEffectiveDate | String | SysEffectiveDate |
| Finder | String | finder |