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 |