AbsencesabsenceEntitlementsabsenceEntitlementDetails
AbsencesabsenceEntitlementsabsenceEntitlementDetails
Columns
Name | Type | Description |
AbsencespersonAbsenceEntryId [KEY] | Long | AbsencespersonAbsenceEntryId of AbsencesabsenceEntitlementsabsenceEntitlementDetails |
AbsenceentitlementsentitlementId [KEY] | Long | AbsenceentitlementsentitlementId of AbsencesabsenceEntitlementsabsenceEntitlementDetails |
EntitlementDetailId [KEY] | Long | EntitlementDetailId of AbsencesabsenceEntitlementsabsenceEntitlementDetails |
StartDate | Datetime | StartDate of AbsencesabsenceEntitlementsabsenceEntitlementDetails |
EndDate | Datetime | EndDate of AbsencesabsenceEntitlementsabsenceEntitlementDetails |
Units | Double | Units of AbsencesabsenceEntitlementsabsenceEntitlementDetails |
UnitOfMeasure | String | UnitOfMeasure of AbsencesabsenceEntitlementsabsenceEntitlementDetails |
AbsencePlanUOMMeaning | String | AbsencePlanUOMMeaning of AbsencesabsenceEntitlementsabsenceEntitlementDetails |
PayFactor | Double | PayFactor of AbsencesabsenceEntitlementsabsenceEntitlementDetails |
EntitlementId | Long | EntitlementId of AbsencesabsenceEntitlementsabsenceEntitlementDetails |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
AbsenceTypeId | Long | absenceTypeId |
Finder | String | finder |
PersonAbsenceEntryId | Long | personAbsenceEntryId |
PersonId | Long | personId |