ExpensePerDiemPolicies
Stores the overarching per diem guidelines, including allowable rates and daily caps for travel reimbursements.
Columns
| Name | Type | Description |
| AccomDeductCalcMethCode | String | The method used to calculate accommodation deductions in the ExpensePerDiemPolicies table. |
| AccomDeductCalcMeth | String | Specifies the accommodation deduction calculation method in the ExpensePerDiemPolicies table. |
| AccomDeductionFlag | Bool | Flag indicating whether accommodation deductions are applicable for the given policy in the ExpensePerDiemPolicies table. |
| AccomEligibEndHour | Int | The hour at which accommodation eligibility ends, as defined in the ExpensePerDiemPolicies table. |
| AccomEligibEndMinute | Int | The minute at which accommodation eligibility ends, as defined in the ExpensePerDiemPolicies table. |
| AccomEligibStartHour | Int | The hour at which accommodation eligibility starts, as defined in the ExpensePerDiemPolicies table. |
| AccomEligibStartMinute | Int | The minute at which accommodation eligibility starts, as defined in the ExpensePerDiemPolicies table. |
| AccomFreeOnlyFlag | Bool | Flag indicating whether only free accommodation is eligible under the policy in the ExpensePerDiemPolicies table. |
| AccomMinDurationHours | Int | The minimum number of hours required for accommodation eligibility in the ExpensePerDiemPolicies table. |
| AccomMinDurationMinutes | Int | The minimum number of minutes required for accommodation eligibility in the ExpensePerDiemPolicies table. |
| AccomMinNightHoursStay | Int | The minimum number of hours a person must stay overnight to qualify for accommodation in the ExpensePerDiemPolicies table. |
| AccomMinTripDuratFlag | Bool | Flag indicating whether a minimum trip duration is required for accommodation eligibility in the ExpensePerDiemPolicies table. |
| AccomRateCalcMethodCode | String | Code representing the accommodation rate calculation method in the ExpensePerDiemPolicies table. |
| AccomRateCalcMethod | String | Specifies the accommodation rate calculation method in the ExpensePerDiemPolicies table. |
| AccomReqMealsEligibFlag | Bool | Flag indicating whether meal eligibility is required for accommodation eligibility in the ExpensePerDiemPolicies table. |
| AllowActualExpenseFlag | Bool | Flag indicating whether actual expenses are allowed under the policy in the ExpensePerDiemPolicies table. |
| AllowRateConversionFlag | Bool | Flag indicating whether rate conversion is permitted under the policy in the ExpensePerDiemPolicies table. |
| BreakfastEligEndHour | Int | The hour at which breakfast eligibility ends, as defined in the ExpensePerDiemPolicies table. |
| BreakfastEligEndMinute | Int | The minute at which breakfast eligibility ends, as defined in the ExpensePerDiemPolicies table. |
| BreakfastEligStartHour | Int | The hour at which breakfast eligibility starts, as defined in the ExpensePerDiemPolicies table. |
| BreakfastEligStartMinute | Int | The minute at which breakfast eligibility starts, as defined in the ExpensePerDiemPolicies table. |
| CreatedBy | String | The user who created the record for the accommodation policy in the ExpensePerDiemPolicies table. |
| CreationDate | Datetime | The date and time when the record was created in the ExpensePerDiemPolicies table. |
| CurrencyCode | String | The currency code (for example, USD, EUR) used in the policy for accommodation expenses in the ExpensePerDiemPolicies table. |
| Currency | String | The name of the currency used in the policy for accommodation expenses in the ExpensePerDiemPolicies table. |
| CurrencyOptionCode | String | The code representing the currency option for the accommodation policy in the ExpensePerDiemPolicies table. |
| CurrencyOption | String | The specific currency option for the accommodation policy in the ExpensePerDiemPolicies table. |
| DayTravelEligibHours | Int | The number of hours for day travel eligibility in the ExpensePerDiemPolicies table. |
| Description | String | A brief description of the accommodation policy outlined in the ExpensePerDiemPolicies table. |
| DinnerEligEndHour | Int | The hour at which dinner eligibility ends, as defined in the ExpensePerDiemPolicies table. |
| DinnerEligEndMinute | Int | The minute at which dinner eligibility ends, as defined in the ExpensePerDiemPolicies table. |
| DinnerEligStartHour | Int | The hour at which dinner eligibility starts, as defined in the ExpensePerDiemPolicies table. |
| DinnerEligStartMinute | Int | The minute at which dinner eligibility starts, as defined in the ExpensePerDiemPolicies table. |
| EnabledAccomTypeFlag | Bool | Flag indicating whether a particular accommodation type is enabled under the policy in the ExpensePerDiemPolicies table. |
| EnabledLocationFlag | Bool | Flag indicating whether location-based rules are enabled for accommodation eligibility in the ExpensePerDiemPolicies table. |
| EnabledLongTermFlag | Bool | Flag indicating whether long-term accommodations are allowed in the policy in the ExpensePerDiemPolicies table. |
| EnabledRoleFlag | Bool | Flag indicating whether accommodation rules are based on employee roles in the ExpensePerDiemPolicies table. |
| EnabledSeasonRateFlag | Bool | Flag indicating whether seasonal rate rules are applied to accommodation policies in the ExpensePerDiemPolicies table. |
| EnabledWeekendHolidFlag | Bool | Flag indicating whether weekend and holiday rates are enabled for accommodation policies in the ExpensePerDiemPolicies table. |
| FreeMealDeductionCode | String | Code representing the deduction method for free meals in the policy in the ExpensePerDiemPolicies table. |
| FreeMealDeduction | String | The method used to apply deductions for free meals in the policy in the ExpensePerDiemPolicies table. |
| HolidayCalcMethodCode | String | The code specifying how holiday calculations are performed under the accommodation policy in the ExpensePerDiemPolicies table. |
| HolidayCalcMethod | String | The specific method used to calculate holiday allowances for accommodation expenses in the ExpensePerDiemPolicies table. |
| LastUpdateDate | Datetime | The date and time when the accommodation policy was last updated in the ExpensePerDiemPolicies table. |
| LastUpdateLogin | String | The login ID of the user who last updated the accommodation policy record in the ExpensePerDiemPolicies table. |
| LastUpdatedBy | String | The name of the user who last updated the accommodation policy record in the ExpensePerDiemPolicies table. |
| LocationTypeCode | String | Code specifying the type of location for the accommodation policy in the ExpensePerDiemPolicies table. |
| LocationType | String | Describes the type of location (for example, city, region) for the accommodation policy in the ExpensePerDiemPolicies table. |
| LongTermCalcMethod | String | The method used to calculate long-term accommodation allowances in the ExpensePerDiemPolicies table. |
| LongTermCalcMeth | String | The method used to calculate long-term accommodation expenses in the ExpensePerDiemPolicies table. |
| LunchEligEndHour | Int | The hour at which lunch eligibility ends, as defined in the ExpensePerDiemPolicies table. |
| LunchEligEndMinute | Int | The minute at which lunch eligibility ends, as defined in the ExpensePerDiemPolicies table. |
| LunchEligStartHour | Int | The hour at which lunch eligibility starts, as defined in the ExpensePerDiemPolicies table. |
| LunchEligStartMinute | Int | The minute at which lunch eligibility starts, as defined in the ExpensePerDiemPolicies table. |
| MealDeductionFlag | Bool | Flag indicating whether meal deductions apply in the accommodation policy in the ExpensePerDiemPolicies table. |
| MealInclIncidentalFlag | Bool | Flag indicating whether meals are considered part of incidental expenses in the policy in the ExpensePerDiemPolicies table. |
| MealRateTypeCode | String | Code specifying the type of rate applied to meals in the ExpensePerDiemPolicies table. |
| MealRateType | String | Describes the type of rate used for meals in the accommodation policy in the ExpensePerDiemPolicies table. |
| MealsAmountLimit | Decimal | The maximum allowable amount for meal expenses in the accommodation policy in the ExpensePerDiemPolicies table. |
| MealsCalcMethodCode | String | Code specifying the method used to calculate meal expenses in the accommodation policy in the ExpensePerDiemPolicies table. |
| MealsCalcMethod | String | Describes the method used to calculate meal expenses in the accommodation policy in the ExpensePerDiemPolicies table. |
| MealsDeductCalcMethCode | String | Code specifying the method used for calculating meal deductions in the ExpensePerDiemPolicies table. |
| MealsDeductCalcMeth | String | Describes the method used for calculating meal deductions in the accommodation policy in the ExpensePerDiemPolicies table. |
| MealsDeductionCode | String | Code representing the type of meal deduction in the accommodation policy in the ExpensePerDiemPolicies table. |
| MealsDeduction | String | Describes the type of meal deduction applied in the accommodation policy in the ExpensePerDiemPolicies table. |
| MealsRateSourceCode | String | Code representing the source of the meal rate in the accommodation policy in the ExpensePerDiemPolicies table. |
| MealsRateSource | String | Describes the source of the meal rate for accommodation policy expenses in the ExpensePerDiemPolicies table. |
| MinDistanceFromHome | Decimal | The minimum distance from an employee's home required for accommodation eligibility in the ExpensePerDiemPolicies table. |
| MinDistanceFromOffice | Decimal | The minimum distance from the office required for accommodation eligibility in the ExpensePerDiemPolicies table. |
| MinDurationHours | Int | The minimum number of hours required for the accommodation to be valid in the ExpensePerDiemPolicies table. |
| MinDurationMinutes | Int | The minimum number of minutes required for the accommodation to be valid in the ExpensePerDiemPolicies table. |
| MinTripDuratFlag | Bool | Flag indicating whether a minimum trip duration is required for accommodation eligibility in the ExpensePerDiemPolicies table. |
| MinimumReimbursement | Decimal | The minimum reimbursement amount for accommodation expenses in the policy in the ExpensePerDiemPolicies table. |
| ObjectVersionNumber | Int | The version number of the accommodation policy record in the ExpensePerDiemPolicies table. |
| OthersCalcMethodCode | String | Code representing the method used to calculate other expenses in the accommodation policy in the ExpensePerDiemPolicies table. |
| OthersCalcMethod | String | Describes the method used to calculate other types of expenses in the accommodation policy in the ExpensePerDiemPolicies table. |
| OthersEligibCriteriaCode | String | Code representing the criteria for eligibility for other expenses in the accommodation policy in the ExpensePerDiemPolicies table. |
| OthersEligibCriteria | String | Describes the eligibility criteria for other expenses in the accommodation policy in the ExpensePerDiemPolicies table. |
| PerDiemPolicyId [KEY] | Long | The unique identifier for the per diem policy record in the ExpensePerDiemPolicies table. |
| PerdiemPolicyType | String | The type of per diem policy (for example, international, domestic) defined in the ExpensePerDiemPolicies table. |
| PolicyName | String | The name of the per diem policy defined in the ExpensePerDiemPolicies table. |
| PolicyRoleCode | String | The code specifying the role for which the policy applies in the ExpensePerDiemPolicies table. |
| PolicyRole | String | The specific role or category for which the accommodation policy applies in the ExpensePerDiemPolicies table. |
| RateFormulaMethodCode | String | Code representing the formula method used to calculate rates for accommodation expenses in the ExpensePerDiemPolicies table. |
| RateFormulaMethod | String | Describes the formula used to calculate accommodation rates in the accommodation policy in the ExpensePerDiemPolicies table. |
| RateIncludeAccomFlag | Bool | Flag indicating whether accommodation is included in the rate calculation for the policy in the ExpensePerDiemPolicies table. |
| RateIncludeMealsFlag | Bool | Flag indicating whether meals are included in the rate calculation for the policy in the ExpensePerDiemPolicies table. |
| RateIncludeOtherFlag | Bool | Flag indicating whether other expenses are included in the rate calculation for the policy in the ExpensePerDiemPolicies table. |
| RateMultiplierCode | String | Code representing the rate multiplier applied in the accommodation policy in the ExpensePerDiemPolicies table. |
| RateMultiplier | String | Describes the rate multiplier used in the accommodation policy for calculating expenses in the ExpensePerDiemPolicies table. |
| RatesSourceCode | String | Code specifying the source of the rate in the accommodation policy in the ExpensePerDiemPolicies table. |
| RatesSource | String | Describes the source from which rates are derived in the accommodation policy in the ExpensePerDiemPolicies table. |
| RoleCalcMethod | String | The method used to calculate rates based on the employee's role in the accommodation policy in the ExpensePerDiemPolicies table. |
| SpecificFirstLastDayFlag | Bool | Flag indicating whether special first and last day rules apply to the accommodation policy in the ExpensePerDiemPolicies table. |
| Status | String | The current status of the accommodation policy, such as 'Active' or 'Inactive', in the ExpensePerDiemPolicies table. |
| StatusMeaning | String | The description of the status of the accommodation policy, such as 'Active' or 'Inactive', in the ExpensePerDiemPolicies table. |
| TimeAllowSameDayFlag | Bool | Flag indicating whether same-day accommodation is allowed under the policy in the ExpensePerDiemPolicies table. |
| TimeBasedRateModelFlag | Bool | Flag indicating whether the accommodation policy uses a time-based rate model in the ExpensePerDiemPolicies table. |
| TimeCalcMethodCode | String | Code representing the method used to calculate time-based accommodation expenses in the policy in the ExpensePerDiemPolicies table. |
| TimeCalcMethod | String | Describes the method used to calculate time-based accommodation expenses in the policy in the ExpensePerDiemPolicies table. |
| TimePeriodCode | String | Code representing the time period during which accommodation expenses are applicable in the ExpensePerDiemPolicies table. |
| TimePeriod | String | Describes the time period applicable for accommodation expenses in the ExpensePerDiemPolicies table. |
| TimeSameDayCalcMethod | String | The method used to calculate accommodation expenses for the same day in the ExpensePerDiemPolicies table. |
| TimeSameDayCalcMeth | String | An alternative description for the calculation method for same-day accommodation expenses in the ExpensePerDiemPolicies table. |
| TimeSameDayRuleCode | String | Code representing the rule for calculating same-day accommodation expenses in the ExpensePerDiemPolicies table. |
| TimeSameDayRule | String | Describes the rule used to calculate same-day accommodation expenses in the policy in the ExpensePerDiemPolicies table. |
| WeekendDay1Code | String | Code representing the first weekend day rate in the accommodation policy in the ExpensePerDiemPolicies table. |
| WeekendDay2Code | String | Code representing the second weekend day rate in the accommodation policy in the ExpensePerDiemPolicies table. |
| WithinEmployeeCityFlag | Bool | Flag indicating whether the accommodation policy applies to employees within the same city in the ExpensePerDiemPolicies table. |
| ZoneTypeCode | String | Code specifying the zone type for accommodation expenses in the policy in the ExpensePerDiemPolicies table. |
| ZoneType | String | Describes the type of zone (for example, city, regional) in the accommodation policy in the ExpensePerDiemPolicies table. |
| Finder | String | The name of the person who located or identified the accommodation policy in the ExpensePerDiemPolicies table. |