PayrollRelationshipspayrollAssignmentsassignedPayrolls
PayrollRelationshipspayrollAssignmentsassignedPayrolls
Columns
| Name | Type | Description |
| PayrollRelationshipsEffectiveEndDate [KEY] | Date | PayrollRelationshipsEffectiveEndDate of PayrollRelationshipspayrollAssignmentsassignedPayrolls |
| PayrollRelationshipsEffectiveStartDate [KEY] | Date | PayrollRelationshipsEffectiveStartDate of PayrollRelationshipspayrollAssignmentsassignedPayrolls |
| PayrollRelationshipsPayrollRelationshipId [KEY] | Long | PayrollRelationshipsPayrollRelationshipId of PayrollRelationshipspayrollAssignmentsassignedPayrolls |
| PayrollassignmentsEffectiveEndDate [KEY] | Date | PayrollassignmentsEffectiveEndDate of PayrollRelationshipspayrollAssignmentsassignedPayrolls |
| PayrollassignmentsEffectiveStartDate [KEY] | Date | PayrollassignmentsEffectiveStartDate of PayrollRelationshipspayrollAssignmentsassignedPayrolls |
| PayrollassignmentsRelationshipGroupId [KEY] | Long | PayrollassignmentsRelationshipGroupId of PayrollRelationshipspayrollAssignmentsassignedPayrolls |
| AssignedPayrollId [KEY] | Long | Unique identifier used to retrieve the assigned payroll record for an assignment. |
| PayrollId | Long | Unique identifier for the payroll, such as the weekly payroll. |
| StartDate | Date | Start date of the payroll assigned to the assignment. |
| EndDate | Date | End date of the payroll assigned to the assignment. |
| TimeCardRequired | String | Associated with all assignments for a given payroll. Indicates whether the assignment must submit time cards for payroll purposes. |
| OverridingPeriodId | Long | Overtime period for all assignments associated to the payroll, such as the FLSA period for US employees. |
| EffectiveStartDate [KEY] | Date | Date at the beginning of the date range within which the payroll is effective. |
| EffectiveEndDate [KEY] | Date | Date at the end of the date range within which the payroll is effective. |
| Lsed | Date | Last standard earning date of the payroll assigned to the assignment. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| AssignmentNumber | String | AssignmentNumber |
| PayrollRelationshipId | Long | PayrollRelationshipId |
| PersonNumber | String | PersonNumber |
| SysEffectiveDate | String | SysEffectiveDate |
| Finder | String | finder |