AbsencesabsenceEntitlements
AbsencesabsenceEntitlements
Columns
| Name | Type | Description |
| AbsencespersonAbsenceEntryId [KEY] | Long | AbsencespersonAbsenceEntryId of AbsencesabsenceEntitlements |
| EntitlementId [KEY] | Long | EntitlementId of AbsencesabsenceEntitlements |
| PersonAbsenceEntryId | Long | PersonAbsenceEntryId of AbsencesabsenceEntitlements |
| AbsencePlanId | Long | AbsencePlanId of AbsencesabsenceEntitlements |
| AbsencePlanName | String | AbsencePlanName of AbsencesabsenceEntitlements |
| Units | Double | Units of AbsencesabsenceEntitlements |
| UnitOfMeasure | String | UnitOfMeasure of AbsencesabsenceEntitlements |
| AbsencePlanUOMMeaning | String | AbsencePlanUOMMeaning of AbsencesabsenceEntitlements |
| PayFactor | Double | PayFactor of AbsencesabsenceEntitlements |
| PersonId | Long | PersonId of AbsencesabsenceEntitlements |
| ActivityStartDate | Datetime | ActivityStartDate of AbsencesabsenceEntitlements |
| ActivityEndDate | Datetime | ActivityEndDate of AbsencesabsenceEntitlements |
| ActivityCd | String | ActivityCd of AbsencesabsenceEntitlements |
| ActivityCdMeaning | String | ActivityCdMeaning of AbsencesabsenceEntitlements |
| Source | String | Source of AbsencesabsenceEntitlements |
| SourceCdMeaning | String | SourceCdMeaning of AbsencesabsenceEntitlements |
| CalculationDate | Datetime | CalculationDate of AbsencesabsenceEntitlements |
| PlanPeriodStartDate | Datetime | PlanPeriodStartDate of AbsencesabsenceEntitlements |
| EntitlementMethodCd | String | EntitlementMethodCd of AbsencesabsenceEntitlements |
| EntitlementMethodCdMeaning | String | EntitlementMethodCdMeaning of AbsencesabsenceEntitlements |
| ChangeReasonCd | String | ChangeReasonCd of AbsencesabsenceEntitlements |
| ChangeReasonCdMeaning | String | ChangeReasonCdMeaning of AbsencesabsenceEntitlements |
| PersonAbsenceTypeEntryId | Long | PersonAbsenceTypeEntryId of AbsencesabsenceEntitlements |
| AssignmentId | Long | AssignmentId of AbsencesabsenceEntitlements |
| AssignmentNumber | String | AssignmentNumber of AbsencesabsenceEntitlements |
| AssignmentName | String | AssignmentName of AbsencesabsenceEntitlements |
| Used | Double | Used of AbsencesabsenceEntitlements |
| Remaining | Double | Remaining of AbsencesabsenceEntitlements |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| AbsenceTypeId | Long | absenceTypeId |
| EndDate | Date | endDate |
| Finder | String | finder |
| StartDate | Date | startDate |