PayrollRelationshipspayrollAssignmentspayrollAssignmentDates
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 |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| AssignmentNumber | String | AssignmentNumber |
| EffectiveEndDate | Date | EffectiveEndDate |
| EffectiveStartDate | Date | EffectiveStartDate |
| PayrollRelationshipId | Long | PayrollRelationshipId |
| PersonNumber | String | PersonNumber |
| SysEffectiveDate | String | SysEffectiveDate |
| Finder | String | finder |