PayrollRelationshipspayrollAssignments
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 |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
PayrollRelationshipId | Long | PayrollRelationshipId |
PersonNumber | String | PersonNumber |
SysEffectiveDate | String | SysEffectiveDate |
Finder | String | finder |