PayrollRelationshipspayrollRelationshipDates
PayrollRelationshipspayrollRelationshipDates
Columns
Name | Type | Description |
PayrollRelationshipsEffectiveEndDate [KEY] | Date | PayrollRelationshipsEffectiveEndDate of PayrollRelationshipspayrollRelationshipDates |
PayrollRelationshipsEffectiveStartDate [KEY] | Date | PayrollRelationshipsEffectiveStartDate of PayrollRelationshipspayrollRelationshipDates |
PayrollRelationshipsPayrollRelationshipId [KEY] | Long | PayrollRelationshipsPayrollRelationshipId of PayrollRelationshipspayrollRelationshipDates |
PayDateId [KEY] | Long | PayDateId of PayrollRelationshipspayrollRelationshipDates |
DateValue | Date | DateValue of PayrollRelationshipspayrollRelationshipDates |
ShortName | String | ShortName of PayrollRelationshipspayrollRelationshipDates |
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 |